Data cleaning export columns and header for Caddisfly question type

[janagombitova]

Currently if the user exports data using the raw data export with the Advanced settings turned on, he gets all questions in the header without the Flow internal question ID. Usually only with the name of the questions, and if the user created unique IDs for questions then with those as well.

However, Caddisfly questions are generated still with the Flow internal question IDs. These IDs should not be shown.

Secondly, if a Caddisfly question has a user created question ID, this is shown properly but also with the question name. In this case, only the user created question ID should be shown.

See example export for more details:

Without user created IDs: Example Advanced Settings Export.xlsx

With user created IDs: With User Question IDs.xlsx

[janagombitova]

Tested this issue on the latest released version of Flow on UAT1 and it is still present. See example below with test data: https://flowdev1.akvoflow.org/report/uat1.akvoflow.org/445eba9b-385d-4dd1-b96b-b60a583d3d52/DATA_ANALYSIS-156909115.xlsx

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.