Editing Twitter Analysis DB GUI

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
= Overview =
+
= Overview ( early version ) =
 
The GUI or graphical user interface is the key to using the Twitter Analysis DB. The main page for the project is '''[http://www.opencircuits.com/Twitter_Analysis_DB Twitter Analysis DB - OpenCircuits ]'''.  This page is the documentation for the GUI.
 
The GUI or graphical user interface is the key to using the Twitter Analysis DB. The main page for the project is '''[http://www.opencircuits.com/Twitter_Analysis_DB Twitter Analysis DB - OpenCircuits ]'''.  This page is the documentation for the GUI.
 
Before getting into the details a bit of overview:
 
 
* You basically can choose at any one time to have one two kinds of selects ( selections, reports, views ) of the data:
 
** Focus on the full text of the tweet.
 
** Focus on the vocabulary/concordance of the tweets.
 
** This choice are make when you pick a "Select Type"
 
 
* In any case you have a range of other choices you might make:
 
** What sort of output you want: csv files ( viewable automatically in your system editor ), html files ( viewable automatically in your browser ) Message output ( viewable in the message area of the application )....
 
** Selection criteria on type of tweet or type of word ( see information below, and help for each select )  To see the help and selection criteria choose a select type an press <About It>, the information will be displayed in the message area.  Different selection criteria apply to different select types.  To better understand the selections you should refer to the description of the database at: '''[[Twitter Analysis DB Details]]'''.
 
 
  
 
== Screen Shot ==
 
== Screen Shot ==
Line 18: Line 6:
 
This is what it looks like, details on each part below.  Still working on it, current download of code should be related, but may look quite different.
 
This is what it looks like, details on each part below.  Still working on it, current download of code should be related, but may look quite different.
  
[[File:Tadb 15 B gui.png | 1400x3300px]]
+
[[File:Tadb gui.png | 1000x2500px]]
  
 
<!-----------
 
<!-----------
Line 31: Line 19:
 
------------->
 
------------->
  
= What Does What: The Widgets =
+
= What Does What: The Controls =
  
Control is mostly through widgest of various types buttons, text fields, dropdown lists, checkboxes and so on.  Outside of the GUI there is also a parameter file which controls start up and item like database file name.  The large rectangle at the bottom right, a text area, is where information messages are displayed.  It is referred to as the message area.  Buttons on its left help control the display in the message areas.
+
Control is mostly through buttons, sometimes supplemented by text fields.  Outside of the GUI there is also a parameter file which controls start up and item like database file name.  The large rectangle at the bottom right, a text area, is where information messages are displayed.  It is referred to as the message area.  Buttons on its left help control the display in the message areas.
  
 
Working from top to bottom:
 
Working from top to bottom:
Line 42: Line 30:
  
 
== First Row of Buttons ==
 
== First Row of Buttons ==
These buttons are mostly more about the application as an application than they are about tweets.  Still they can be very useful.  The <Edit Parms> button controls a lot about how the application runs, the <Edit Log> button can be useful in debugging and tracking your work.
 
  
 
* <Edit Log> opens an editor on the system ( needs to be configured in parameter file self.ex_editor = <name of executable or link> ) to view the python logging file for the app.
 
* <Edit Log> opens an editor on the system ( needs to be configured in parameter file self.ex_editor = <name of executable or link> ) to view the python logging file for the app.
Line 51: Line 38:
 
* <About> Bit of information on the program, the usual sort of stuff.
 
* <About> Bit of information on the program, the usual sort of stuff.
  
== General Select Widgets ==
+
== Selection Buttons ==
  
Sets basic choices about your selection including which of several different types of selections you want to use.:
+
Sets basic choices about your selection:
 +
 
 +
* Select Type: Dropdown choose between different selection types that focus on different tables in the database.  After a selection is chosen you can get more information about it using the <About It> button.  The information is
 +
displayed in the message area.
  
* Select Type: Dropdown choose between different selection types that focus on different tables in the database.  After a selection is chosen you can get more information about it using the <About It> button.  The information is displayed in the message area. 
 
 
You can select between:
 
You can select between:
 
** Tweets cross referenced to the concordance
 
** Tweets cross referenced to the concordance
 
** Just information on the concordance
 
** Just information on the concordance
** Just information on the words table
 
** Different tables cross referenced to each others in different ways
 
 
You can check out each by selecting it then pressing <About It>
 
  
 
* <About It>: Shows information about the Select Type.  In addition to "static" information it also shows the SQL for the current choices in the GUI.  This is most useful to those of you who know a bit of SQL.  This SQL can also be copied from the message area and used in other SQL tools.
 
* <About It>: Shows information about the Select Type.  In addition to "static" information it also shows the SQL for the current choices in the GUI.  This is most useful to those of you who know a bit of SQL.  This SQL can also be copied from the message area and used in other SQL tools.
Line 81: Line 66:
 
The app attempts to open each output in the program on your system best for that file type.
 
The app attempts to open each output in the program on your system best for that file type.
  
* <Append To Output> A dropdown that lets you append one selection to another.  Selections are generally written to a file, and in the standard case the file is overwritten each time you run a selection.  Using this you can append various selection to each other.  Since different formats use different file names, this only "works" for files of the same format.
+
== Selection Criteria Widgets ==
 
 
* <Turn on Slider Mode> In this mode any change in the date will kick off a selection of data.  The intention here is that will be most useful for data displayed in the message area.  Additionally there is a selection ( currently called Message Area Tweets ) that is optimized for the display there.  So you might want to try out this feature with that report, output to the message area, and turn on the slider mode.  Now slide the date around, on my computer updates are completed in less than a second.  All of the select criteria that normally are in effect are still in effect.  The control is a toggle, so turn off in the same way you turn it on.
 
 
 
== Date Select Widgets ==
 
Date Criteria
 
* Start date and time
 
* End date and time
 
The widgets above are two part one for the date ( including a calendar ) and one for the time of day.  Then there are 4 widgets altogether for a start and end to the selection.
 
The times are on a 24 hr clock.
 
 
 
  
* Some accessory controls let you quickly select for: .........
+
Pairs of labels and widgets for input. Used in selects. Not all values are used for all selects.
** <1 Year Ago Today >.... <4 Years Ago Today > selects dates for a duration of 1 day for a time n years ago.
 
** <Today> like 1 year ago, but 0 years ago.
 
** <This Week>
 
** This Month
 
** <Forever> which is as long as twitter has been up.
 
** Slider to chooses any week in past n weeks.
 
** New controls coming, will work in time ( or go away )
 
  
== Selection Criteria Widgets ==
+
* Date Criteria  
 +
** Start date and time
 +
** End date and time
 +
** Some accessory controls let you quickly select for: .........
  
* Other Criteria ... this list is incomplete more comming... just look at gui
+
* Other Criteria
 
** Word Search:  search for a given word in the concordance
 
** Word Search:  search for a given word in the concordance
 
** Is Covid:  search for tweets tagged as covid19 pandemic related  
 
** Is Covid:  search for tweets tagged as covid19 pandemic related  
Line 111: Line 82:
 
** TweetType: select tweets, retweets or any
 
** TweetType: select tweets, retweets or any
  
== Database Table Load ==
+
== Select Action ==
This area helps you define and load a database, or destroy oneIt can be "turned off" with a parameter and then does not show in the GUI.  This can prevent accidental destruction of the database.
+
Each button runs some selection on the database based on the Select Values in the area above.  Prior to the execution of the selection you will be shown ( in the message area ) the help for the selection and the sql and data for the queryYou can then cancel or continue.  This ( with the cancel ) is a good way to get help on each selection.
  
*<Show Load Parameters>
+
* Output Format:  You can choose the output format of the selection:
*<Define Tweets/Concord> Defines ( and destroys current, if any tables )
+
**html
*<Load Tweets (concord)>
+
**csv
*<Define Words>
+
**txt file
*<Load Words>
+
 
*<Rank Words> Populates the rank column in the words table.
+
* <Tweets>         Selects tweets that fit criteria on the window.  To see the criteria press the button then cancel.
 +
* <Concordance>>  Selects a concordance that fits criteria on the window.  To see the criteria press the button then cancel.
  
 
== Message Area ==
 
== Message Area ==
  
This area is for messages from the system and in some cases output from selects ( delayed while dealing with unicode issues )
 
 
Often display ( after <About It> or <Run It> help text about the select as well as the sql for the query as specified by the GUI )
 
 
You may find that copying out the sql into another tool like sqlstudio light may be useful.
 
 
   
 
   
 
* <Column of Buttons and Text Panel>  The Panel shows program activity and some other info ( like the sql used in a query ) the buttons act on this data in some way.  You might be able type in the text panel, to no particular effect, perhaps could use this to make notes.  Text is partly erased from time to time depending on settings in parameter file(s)   
 
* <Column of Buttons and Text Panel>  The Panel shows program activity and some other info ( like the sql used in a query ) the buttons act on this data in some way.  You might be able type in the text panel, to no particular effect, perhaps could use this to make notes.  Text is partly erased from time to time depending on settings in parameter file(s)   

Please note that all contributions to OpenCircuits may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see OpenCircuits:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)