Archived forms and the export tool

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:

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.