Back to the Data Export Overview
This export functionality provides the ability to download data from the forms submitted to CommCareHQCommCare HQ. You should use this feature when you are interested in measuring an outcome across beneficiaries across time. Applications that track a beneficiary over time will usually collect data in different forms at different points in time. This Form export will capture all of the changes in the data at these different time points.
Location: CommcareHQ CommCare HQ -> Data -> Export Data -> Export Forms
...
- Next to the form name in the "Export Full Forms" section, click on the "+ Create New Export" button.
- You can select which form you would like to export by selecting from the following options:
- App type (in general you leave this as All Applications)
- Application
- Module
- Form
...
- Once you have selected your form, you will see the number of submissions that are associated with that form:
...
- Click "Create Export" to navigate to that export's edit page, where you can manipulate more settings:
...
- The Form Export Edit page is broken down into three parts:
- Export Settings
- Form Settings
- Privacy Settings
Export Settings
- Change the name of your export in the "Export Name:" field. The will be the name displayed in the list of exports and should use keywords to identify the type of information in the report.
- Select the desired default file type using the drop-down option. There are four types available: Excel 2007, Excel (older versions), CSV (Zip file), Web Page (Excel Dashboards).
...
Additionally there are four five options that can be selected by checking the boxboxes:
- Automatically convert dates for excel: Leaving this checked will ensure dates appear in excel format. Otherwise they will appear as a normal text format.
- Automatically format cells for Excel 2007+: If this setting is not selected, your export will be in Excel’s general format. If you enable this setting, Excel will format dates, integers, decimals, Boolean values (True/False) and currencies.
- Create a Daily Saved Export: By checking this box, the saved export will be pre-processed once every 24 hours and available for immediate download on the main Form Exports page. After 35 days without downloading the export will stop updating, but you can press the "Update Data" button to resume daily updates.
- Include duplicates and other unprocessed forms: If every variable collected by the mobile user is the same, CommCare flags these submissions as a "duplicate." This can happen when there is more connectivity, so CommCare mobile submits a form multiple times before it receives confirmation that a form has reached the server. By checking this box, there will be duplicate form submissions in the export download.
- Expand Multiple Choice Questions: if you have checkbox questions in your app this setting will create one column for every possible answer.
...
- In the first column, the field (data point) can be re-ordered by dragging the box up or down. The order that is selected on this page will correspond with the order the variables are displayed in the export file. Select You can also select the fields you want to include in your report by using the check boxes. The
- In the second column, the fields shown represent the data collected by the mobile user, the application, the phone, and the server where the data is stored.
- In the fourth column, change field names which will update the title row of the data export. By default the display column will repeat the field name from the third column.
...
- Show Deleted Questions and Advanced
...
- Questions: If selected, the export will allow you to see advanced
...
- questions and/or questions that have been deleted from the current version of your application. Advanced
...
- questions include metadata like case updates and server information
...
- .
- In the third column, change field names which will update the title row of the data export. By default the display column will repeat the field name from the second column which are referred to as question ids.
Privacy Settings
This allows the user to select form data to be de-identified. This means that when the data is exported to an excel sheet, the columns will still be in the data export but the data values will not contain personal information that can be tracked to a single beneficiary.
- Click “Allow me to mark sensitive data” and another column called “Sensitivity” will be added to the Form table.
- A drop down box will appear next to each field name. A field can be marked as “Sensitive ID” which can be used for all text or numeric fields such as name or age. Alternatively, a field can be marked as “Sensitive Date” which would be used for date of birth. Finally, a field can be left blank and the data will export directly as it was input into the application.
...
- Once you have marked the sensitive fields, scroll all the way down to Privacy Settings and check the box "Publish in De-identified Export"
- Create: Click "Create" to finish the export creation process. You're done!
- The export will now be available on the Export Forms page
...
Any form with associated multimedia files will have a Download button accessible. When you download the multimedia, it will appear as a zip file onto your computer, each photo will be a unique JPEG. These media files will be named in the format question ID-username-form id
Example: [question_id]-[username]-[form_id].jpg
Example: head_of_household-supervisor5-e9b4cdfa-c6a2-8607-b4e8-9839493ca2de.jpg
To identify which form submission a multimedia file came from, use the form_id (in green above). Each form submission has a unique form_id.
E. Common Questions Regarding Data Exports
What is the difference between "---" and blank values in form exports?
...
If you see "---" in a form, this means that a question was never presented to the end user. For example, if you have a question that had a display condition that was not met and therefore the question was hidden completely from the mobile worker, including that field in a form export will show "---" as the value, i.e. questions skipped logically/automatically by the app show up in exports as "---"
This also happens when the mobile user is not using the latest version of an application in which question ids or the application structure have been changed, hence the user never sees the latest questions and the data appears as "—". For more information, see Making Changes to a Deployed Application.
...