Access to internet may not always be available in the different settings in which you will conduct your data collection campaign. Compiling data from ODK Collect on the various mobile devices you are using for data collection will therefore not be possible through online connection with an ODK Aggregate server or other ODK-compatible servers such as Formhub, SurveyCTO, ONA or Kobo Toolbox. It is in these settings where ODK Briefcase comes in handy.
ODK Briefcase is a Java application developed to easily gather and aggregate data from ODK Collect without need for internet connectivity. ODK Briefcase is also an alternative for those who do not want to setup an ODK Aggregate server or other ODK-compatible servers indicated above. ODK Briefcase can therefore either be a complementary tool to an ODK Aggregate server particularly during periods of poor internet connectivity or as a replacement for ODK Aggregate altogether.
This tutorial describes how to utilise ODK Briefcase as an ODK Aggregate replacement. Specifically, this tutorial describes how to export data into comma-separated value (CSV) format for use in data analysis and reporting. This tutorial assumes that:
- You have installed ODK Briefcase onto your computer. A guide on how to install ODK Briefcase can be found here.
- You have pulled submissions from ODK Collect in your mobile devices to ODK Briefcase on your computer. A guide on how to pull submissions into ODK Briefcase can be found here.
Once you have pulled submissions from the various mobile devices you are using for your data collection campaign, you may want to export the data into a format that would be usable for various purposes such as data analysis, data reporting, etc.
Following are the steps to export data from ODK Briefcase.
1. Open ODK Briefcase
Open ODK Briefcase by double clicking on the ODK Briefcase executable file saved on your computer or by running a command on the command line.
There are three tabs on the top menu portion of the application. These tabs are:
- Pull (1);
- Push (2); and,
- Export (3).
These are the three key functionalities provided by ODK Briefcase. However, it should be remembered that when ODK Briefcase is being used as a replacement for an ODK Aggregate server, the Push functionality is not available.
2. Click on Export tab
Click on the ‘Export’ tab on the ODK Briefcase menu.
3. Select the form to export data from
Click on the arrow indicating the drop down menu for selecting the form to export data from.
From the drop down menu, select the form to export data from. In this example, there is only one form in Arabic. Select this form.
4. Select the type of file to export data to
In the ‘Export Type’ option, click on the arrow indicating the drop down menu to select the type of file to export data to.
By default, comma-separated value or CSV file is the file type to which data can be exported to.
For most cases, this is the file type that woulb be needed. Select this file type.
5. Choose the directory to export the data to
You should now select the directory to export the data to. Click on ‘Choose’ button in the Export Directory option.
A dialog box will come out allowing you to choose the directory on your computer to export data to. For this example, the Desktop was chosen as the export directory. Click on ‘Choose’ button.
6. Click on Export
Confirm the export choices that you have made (1) and then click on ‘Export’ button at the bottom right corner of the application (2).
It will then be indicated that you have been successfull in exporting your data (1). If you go to the export directory you have chosen, you will see the exported data there. In this example, the data is now seen on the Desktop as this was the export directory selected (2).
Congratulations. You have now successfully used ODK Briefcase as an ODK Aggregate server alternative.