Pushing, Pulling, and Logs in ODKBriefcase
Pushing forms to ODK Aggregate
- Open the Push tab.
- Select Aggregate server in the Push to drop-down.
- Click the Configure button.
- Enter the URL and login credentials for your Aggregate server in the dialog that pops up and click the Connect button.
- If you have anonymous login enabled on Aggregate, no login credentials are needed here.
- Select the forms you want to upload and click Push. The selected forms will be pushed from your Briefcase Storage to the Aggregate server.
- For each selected form, Briefcase will upload:
- The form definition file (that is, the blank XForm).
- All media associated with the form.
- Completed form instances, including all their attached media files.
Pulling from ODK Collect (in relation to ODK Aggregate online)
ODK Collect is an open source Android app that replaces paper forms used in survey-based data gathering. It supports a wide range of question and answer types, and is designed to work well without network connectivity. Please refer the the Handbook section on ODK Collect installation before proceeding with these steps, if it is the tool you want to use.
Please use ODK Collect if you are are using KoBo Toolbox, instead of ODK Collect.
- Ensure all filled-in forms are finalized.
- If you have incomplete forms that you cannot finalize before pulling into Briefcase, delete them.
- Create a zip archive of the entire odk directory
- You’ll need to use an app to do this, we would recommend OI File Manager as an option.
- Connect your Android device to your computer using a USB cable and choose to mount it as a Media device.
- Copy the zip file you created from the Android device to your local hard drive.
- Once it is copied onto your local hard drive, unzip the file.
- In Briefcase, open the Pull tab.
- Select Collect directory in the Pull from drop-down.
- Click the Configure button and select the unzipped odk folder.
- Select the forms you want to download and click Pull. The selected forms will be pulled to your Briefcase Storage location.
- On the Android device, open Collect and delete the filled-in forms
Briefcase cannot discriminate between duplicate form instances. After you pull completed forms into Briefcase, it is important that you delete them from Collect. Otherwise, the next time you pull in forms, you will create duplicates.
Pulling form definitions
- Open the Pull tab.
- Select Form definition in the Pull from drop-down.
- Click the Configure button and select the .xml form definition file.
- Select the form and click Pull. The form will be pulled to your Briefcase Storage location.
Exporting forms to CSV/Excel
- Open the Export tab.
- Click on the Set Default Configuration button.
- Set an Export directory.
- If exporting Encrypted Forms, set the corresponding PEM file location. See the Encrypted forms section for more information.
- If you wish, select a Start date and an End date to specify a limited date range to export.
- Toggle export parameters as needed:
- Export media files enables exporting media files into the chosen export directory
- Overwrite existing files enables overwriting form instance data in the output files. The default behavior is to append data.
- Split select multiples enables splitting select multiple fields. Enabling this setting will create an extra output column per select choice, with a 1 if the choice was selected, or 0 otherwise. This only affects select fields without a choice filter and that are not from an external file (including widgets with search appearance).
- Include GeoJSON enables generating a GeoJSON file with spatial data from all exported submissions.
- Remove group names enables removing non-repeat group names from column names in the CSV.
- Pull before export enables trying to pull the selected forms in case there are new form instances to be exported.
- Click Export
- Briefcase will generate a different number of files and directories depending on the form’s contents and the export configuration selected by the user. This can include, per form:
- One main CSV file.
- For example: Form Name.csv
- If the form includes any repeat group, one CSV file for each one of them.
- For example: Form Name-repeat group name.csv
- If any submission includes binary attachments, they are copied to a media directory, relative to the export directory.
- For example: media/1538040007350.jpg
- If the user enables the Include GeoJSON export configuration option, one GeoJSON file with spatial data.
- For example: Form Name.geojson
- If the form includes audit metadata:
- One CSV file with audit data from all submissions.
- For example: Form Name – audit.csv
- One CSV audit file for each exported submission in the media directory, relative to the export directory.
- For example: media/audit-uuid56880d5e-ee8a-4832-b69d-6dfdd526e2dc.csv
Briefcase log files
Briefcase creates a log file with warnings and errors that might be useful for troubleshooting.
Default log file location
- If something goes wrong while using Briefcase and you look for help, it’s possible that you’re asked to provide your log file.
- The default location for the log file is the directory where you are when launching Briefcase, and the default filename is “briefcase.log”
- Briefcase will create the log file on launch if it doesn’t previously exist. Otherwise, it will append lines at the end of a pre-existing log file.–