Data analysis export does not create separate columns for multiple option questions

[janagombitova]

Via support, we learned that the Data analysis export no longer creates the separate option columns for multiple select option questions. In this issue, we limited the splitting of option questions #2400 to only apply for multiple select option questions. This is no longer happening.

Below is an example of random data: UAT1 > _Lumen tests > Example dataset
In the attached file column AP holds multiple option question data but as you can see there are no option columns. Other splitting (photo geotags and cascades) work as expected.

DATA_ANALYSIS-554339123 (4).xlsx

[stellanl]

Just saw another restriction in the exporter, too: The image filenames are assumed to contain a slash or they will not show up.

[stellanl]

This happened because the allowOther and allowMultiple flags exist both in the QuestionDto and its child, QuestionOptionsDto. The db-fetching code filled in the former; the published-form parser the latter. The cell-splitting code looked at the QuestionDto. Both code paths will now fill in both.

[janagombitova]

Works like a charm 👍