User Tools

Site Tools


help:data_entry

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

help:data_entry [2012/08/12 17:52] (current)
Line 1: Line 1:
 +
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
 +
 +====== Entering Fresh Data ======
 +
 +SOFA Statistics lets you enter your data directly. ​ Or you can import it from a spreadsheet or csv file.  Or you can connect directly to a database. ​ This demonstration shows how to enter fresh data.
 +
 +Start by clicking on the "​Enter/​Edit Data" button on the main SOFA form.
 +
 +{{:​help:​create_new_table.jpg|}}
 +
 +In the "​Configure Data Table" dialog:
 +
 +  - Give your table a name.  NB spaces are not allowed in the table name.
 +  - Add fields - each with a name and a data type ("​Numeric"​ (numbers), "​String"​ (which means text), or "​Date"​.
 +  - Click on the "​Update"​ button to save your changes and open the table ready for data entry.
 +
 +{{:​help:​config_new_table.jpg|}}
 +
 +Any tables you make yourself are added to the default SOFA database "​sofa_db"​.
 +
 +To open your new table, click on "​Enter/​Edit Data", select your table and click on the "​Open"​ button.
 +
 +{{:​help:​initial_data_entry.jpg|}}
 +
 +The Sofa_Id is an autonumber to enable SOFA to keep track of everything. It can't be edited. You can edit the other fields. ​ NB to hit the "​Enter"​ key on your keyboard to save a row and open and empty one ready for more data entry. ​ Note how the Sofa_Id is autfilled in.
 +
 +{{:​help:​sofa_id_autofilled.jpg|}}
 +
 +[[https://​www.youtube.com/​watch?​v=YJqWxex2VfE&​feature=plcp |{{:​help:​play_button.gif|}}]] A video is available showing how to enter data by hand into SOFA Statistics:​[[https://​www.youtube.com/​watch?​v=YJqWxex2VfE&​feature=plcp]]
 +
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
 +
 +[[:home | Wiki]]
 +
  
help/data_entry.txt ยท Last modified: 2012/08/12 17:52 (external edit)