Using your project website to view and download data
All data gathered from multiple mobile devices (and/or via the web) can be viewed (in tabular format or with Google maps and charts) at your project homepage. Furthermore, all data gathered can be downloaded in a number of formats for further analysis.
Demonstration Project - Schools - http://plus.epicollect.net/schools
As a reminder, within the form builder tutorial we developed a single form for gathering data about any number of schools.
The questions we defined were as follows:
1) What is the Schools name? - unique for each school (Key Field).
2) What is the headteachers name? - a text field
2) How many pupils attend the school? -aA numerical field
3) What date does the school year start? - a date field
4) What time does the school day start? - a time field
5) What kind of school is this? - a drop-down list - the user can choose only one.
6) Does the school have any of the following sports facilities? - A set of check-boxes.
7) Take a GPS point of the school - a 'location' field allowing capture of GPS co-ordiantes for the school
8) Take a photo of the school - a 'photo' field allowing the capture of a photo of the school
Viewing a project website
For our schools project, the URL for viewing data is : http://plus.epicollect.net/schools
When loading the URL, you are first presented with a frontpage containing a brief description of the project and a list of the forms within the project - As this is a single form project you will see a view similar to that in the following screenshot:
You are offered the choice to view all data or the option to show records based on the answer to a particular question.
When clicking the 'View all' option, a table is presented detailing the entries synched within the particular project. For our schools demo this will look like the following screenshot:
All entries gathered are displayed in tabular format. The column headings contain the question presented to the user and for each entry the values entered are displayed.
Sorting data: You can sort data by clicking on the column headings - this will order by values, descending or ascending
Column widths: You can change the column widths, as you would in an application such as Excel, by clicking and dragging the column boundaries within the column headings.
Above the table a number of options are available:
Filter List by: This allows you to choose a question and enter a value to search entries for. As you type, available values are automatically presented allowing you to choose. Clicking the magnigfying glass icon will apply your search term and only display those entries containing your chosen term.
Clear Filter: This will remove the filter applied and display all entries
Show/Hide Fields: Clicking this option will present you with a list of column headings displayed in the table and also columns that are not displayed allowing you to view different sets of data.
Downloading data: The final three icons contain links to download data from the form you are viewing. You can download as comma separated values (CSV), tab separated values (TSV) or XML (formatted as ecml). This allows all entries to be imported easily into 3rd party applications for further analysis (For more details see 'downloading data').
Below the table are two other control options as follows:
The first simply allows you to navigate through multiple pages of entries and by default, 25 entries are displayed per page.
The second control lets you define the number of default entries displayed per page.
A number of options are available when you have specified media fields within your project as follows:
We will now move on to detailing the Map View