Back to the Data Export Overview
...
- Automatically convert dates for Excel: Leaving this checked will ensure dates appear in Excel format. Otherwise, they will appear in 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 poor 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.
Form Settings
- 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 in which the variables are displayed in the export file. You can also select the fields you want to include in your report by using the checkboxes.
- 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.
- 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 is referred to as question ids.
- You are also able to select and sort multiple rows simultaneously for easy management of form data. (Note: this is only on Standard plans and above)
- To drag multiple fields, select by clicking while holding the CTRL key on a PC, or the Command key on a Mac.
- To select a range of fields hold the Shift key and select the first and last field in the range.
- To unselect a field hold the CTRL key on a PC, or the Command key on a Mac, and click.
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.
...
- On this page, you have the option to select filters for your export, consisting of user types, groups, and date range. For more information on filters, please see this help page
- Once you have selected your filters, click "Prepare Export"
- Click "Download" and your export with the filters you have selected will be downloaded!
...
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: [casename]-[question_id]-[username]-[form_id].jpg
Example: johnm-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.
F. Shared Form Exports
| Info |
|---|
Feature available on the Pro Plan or higher. |
...
Step - 2: Access Shared reports by navigating to Data → Export Form Data, you will find a section of "Exports Shared with Me"
G. 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.
2. Seeing blank in a form export
...
Error Messages In Exports
Multimedia Exports
You may notice this error message when trying to export multimedia:
This indicates that the file size is too large, and you should reattempt downloading the multimedia export by changing your filters to reduce the file size. Due to limited system resources, we are able to support multimedia exports only up to 5 GB in size.
...
For more information on images in CommCare, please see this help page.
Form Exports
You may also sometimes encounter an error mentioning:
This export contains 101865 rows. Please change the filters to be less than 100000 rows.
This means that the number of rows exceeds what we're able to successfully support via the export UI. You can try to reduce the date range of the export and download in batches, or you can also add filters to reduce the number of users the export is covering.
Alternatively, you can use other methods we have available to export your Form Data in case you have a large data set. Please see this help page for more information on selecting tools for data exports on CommCare HQ.