Content Comparison

Back to the Data Export Overview

...

• You can select which form you would like to export by selecting from the following options:
  
  • App typetype (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:

...

• Change the name of your custom report in the "Export Name:" field. The name will correspond to the name under the “Saved Custom 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).

Image RemovedImage Added

Additionally there are four options that can be selected by checking the box:

• 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 downloadAutomatically convert dates for excel: Leaving this checked will ensure dates appear in excel format. Otherwise they will appear as a normal text format.
• Create a Daily Saved Export: By checking this box, the saved custom report 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. 
  
• Automatically convert dates for excel: Leaving this checked will ensure dates appear in excel format. Otherwise they will appear as a normal text format.
• Show Deleted Questions and Advanced Properties: If checked, the export will allow you to see advanced properties and questions that have been deleted from the current version of your application. Advanced properties include metadata like case updates and server information.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. 

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 the variables are displayed in the export file.
• Select the fields you want to include in your report by using the check boxes. 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.

Image ModifiedShow Deleted Questions and Advanced Properties: If selected, the export will allow you to see advanced properties and questions that have been deleted from the current version of your application. Advanced properties include metadata like case updates and server information.

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.      

...

These media files will be named in the format formName-questionID-username-formid.extension

Example: [form name]-[question_id]-[username]-[form_id].jpg

Example: registration-head_of_household-supervisor5-e9b4cdfa-c6a2-8607-b4e8-9839493ca2de

Use the alpha-numeric string at the end of the picture title, this is form_id and can be used to link the picture to your form export. 

When you download the multimedia, it will appear as a zip file onto your computer, each photo will be a unique JPEG.

...