search

kobotoolbox / kpi

kpi is the server for KoboToolbox. It includes an API for users to access data and manage their forms, question library, sharing settings, create reports, and export data.
https://www.kobotoolbox.org
GNU Affero General Public License v3.0
136 stars 182 forks source link

Select-multiple questions in NLP analysis don't respect export settings #5117

Open esario opened 2 months ago

esario commented 2 months ago

Description

Select-multiple questions in the transcript analysis section always export in one column as comma-separated regardless of export settings ("Export Select Many questions as…" {single column | separate columns | single and separate columns}

Steps to Reproduce

  1. Create a survey with an audio question and submit once
  2. Open the audio transcription/transcription/analysis view from the Data -> Table view
  3. Create a select-multiple question in the Analysis tab
  4. Select at least two options for that question for the submission and save
  5. Export the data with separate columns or single and separate columns selected under the Export Select Many questions as… setting

Expected behavior

Export respects the export settings: when selecting separate columns option, the export contains a separate column for each answer option and codes the answers with ones and zeros. image

Actual behavior

The select-multiple answers show up in one column as comma-separated values image

jnm commented 1 month ago

Note to the investigator: this may require a code change in https://github.com/kobotoolbox/formpack/