kobotoolbox / kpi / 27381181525 / 9

81%

master: 76%

push

github

fix(qual): export qual questions correctly DEV-2233 (#7124)

### 📣 Summary
Fixes the qualitative manual multiple select data export

### 📖 Description
The one hot data export for manual qualitative multiple select data was
[fixed on formpack](https://github.com/kobotoolbox/formpack/pull/347).
In `import_export_task.py`, the
`SubmissionExportTaskBase.get_export_object` we pass for_output=True
down to `get_submissions` in order to resolve the choice UUIDs into
their corresponding human-readable labels. We have also added `_uuid`
and `meta/rootUuid` to the additional_fields list in
`_get_fields_and_groups()` to retrieve the qualitative payload
correctly.

### 👀 Preview steps
1. Create a project with an active qualSelectMultiple question and
ensure there are submissions with multiple tags/options selected (You
can achieve this by having an audio question, then clicking on "Open",
in the Data view, in the audio cell, and then in the "Analysis" tab you
can add a multiple choice question and select a few options)
3. Go to the project's Data > Downloads
4. Select an export format (e.g., XLS) and check the "Single and
separate columns" advanced option
5. Generate and download the export
6. Open the export file and verify that the Qual multiple-choice field
has successfully expanded into multiple binary columns, and that the
single column version displays the selected labels separated by spaces
instead of commas

4841 of 12343 branches covered (39.22%)

19868 of 37132 relevant lines covered (53.51%)

0.54 hits per line