How to download collected data from the server?
If you login to the server and open the “Submissions”, you see that the forms are successfully uploaded to the server.
On the submission page you see various options such as Visualise, Export and Publish.
However, we recommend not to use these options, but to use software “ODK briefcase” to download the submitted data.
ODK Briefcase can:
- pull blank forms and finalized forms (submissions) from ODK Collect or ODK Aggregate into a local ODK Briefcase Storage location.
- export the finalized forms (submissions) to a CSV file for processing by other applications.
Create the subfolder “Download CSV files” in your “Fisheries Statistics” folder and move the downloaded “ODK Briefcase vN.N.N. Production.jar” to this subfolder.
Click on “ODK Briefcase Production.jar”, if Java 7 has been installed then the screen below will open.
Browse to your location, preferable the “Fisheries statistics” folder.
Click on “Choose” and then on “OK.
The “ODK brief case form” will open with the brief case storage location you just selected.
Click on “Connect” to make a connection with your server in the cloud.
Enter the Web address of your server, The username of the Administrator and the password and click “Connect”.
Select the forms and click “Pull”.
The importation was successful. Click “Export” to continue.
Click “Choose” and browse to the export directory where you want to store the files.
Select the file data you want to export and click “OK”.
After a few seconds you will see the message “SUCCEEDED”.
If you go to the export directory, you will see two files;
- LandingSurvey.csv containing the data of the fishing units sampled.
- LandingSurvey_speciescatchgroup.csv containing the data of the species landed.
The two table are linked in a “one to many relatonship” through the “Key” in the LandingSurvey file and “ParentKey” in the LandingSurvey_speciescatchgroup, as they are identical in both files.
The CSV files can be imported into any database system for further analyses.
FAO has developed “OpenARTFISH” which has a module for incorporating the CSV files.