I'm trying to create a case export in CommCare HQ of data collected via a CommCare mobile application. I've noticed that when I am doing a form export there is the option to expand the check box questions in the excel export of data. However I do not see the same option when I try to make an export of case data. Is there an option to expand check box questions when doing an export of case data from CommCare HQ?
CommCare – Expanding Checkbox Questions in Case Data Export
commcare
Related Solutions
For this, you can leave the Case Management tab as "does not use cases." This controls the cases of the case type you've selected in your module.
The User Case will automatically be loaded into your form when you choose a form that has User Case setup.
The export tool can't export users, groups or organisations (locations) but you could use a mapping table to lookup the location or supervisor info based on the user_id.
You could do this by adding a Mappings sheet to your export query that contains the lookup table.
Here is an example of what your query sheet might look like:
We've defined two fields, Location and Supervisor which both reference user_id. We've also added a Mappings sheet as follows:
For each user_id value we have mapped them to the Location and the Supervisor.
When the export is run it will do the lookups the final export will contain the mapped values.
To get the data for the Mappings sheet you can use the user export and organisations (locations) export from CommCare HQ.
Related Topic
- Are there any crucial risks to allowing mobile users sign in with the same username and password to collect data in CommCare
- Way to reassign form data that is submitted to the wrong case in CommCare
- CommCare – How to Reference Mobile Worker’s Username in Case List Filter
- Why does ‘Extra’ appear if you select ”Expand Multiple Choice Questions”
- Estimating CommCare Mobile Data Consumption
- In CommCare can the question labels in the data export to be set to a non default-language
- How to get the reference ID of an extension case during a case export
Best Answer
The default settings of your project do not let you split mulitselect questions in case exports. This is because your case does not know which questions correspond with which case properties (because it could be multiple questions).
However, we do have a feature preview that you can enable on your project that will allow you to define how you would like to split your case property in a case export.
You can enable this setting by going to https://www.commcarehq.org/a/your_domain/settings/project/previews/ and checking the "Split multi-selects in case export" option. Then hit Update Previews.
When that is enabled you should see an extra column in your export that will allow you to select the Type. Here you select "multiselect." Then you can add your options. Example below: