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

ODK Briefcase can:

  1. pull blank forms and finalized forms (submissions) from ODK Collect or ODK Aggregate into a local ODK Briefcase Storage location.
  2.  export the finalized forms (submissions) to a CSV file for processing by other applications.

Download “ODK Briefcase vN.N.N. Production.jar”


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.

ODK brief case in folder

Click on “ODK Briefcase Production.jar”, if Java 7 has been installed then the screen below will open.

ODK briefcase location

Browse to your location, preferable the “Fisheries statistics” folder.

select ODK briefcase location 2Click 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.

ODK briefcase form

Enter the Web address of your server, The username of the Administrator and the password and click “Connect”.

PullSelect the forms and click “Pull”.

The importation was successful. Click “Export” to continue.


Choose export directoryClick “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”.

Select files for export

After a few seconds you will see the message “SUCCEEDED”.

Export succeeded

If you go to the export directory, you will see two files;

  1. LandingSurvey.csv containing the data of the fishing units sampled.
  2. 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.