kpi is the (frontend) 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.
The problem occurs when you use a very specific syntax for "others", and more specifically when you append "or_other" to the select_one or select_multiple types of questions (instead of creating a dedicated text type line.
Example of problematic syntax:
type name label::English
select_one HR_Cat or_other A_HR_Cat A.07. Are you a Humanitarian Affairs Officer (HAO) or an Information Management Officer (IMO)?
In that case, the export will show the choice "other", but there is no dedicated column for the specified other (see column AI or AJ)
The problem occurs when you use a very specific syntax for "others", and more specifically when you append "or_other" to the select_one or select_multiple types of questions (instead of creating a dedicated text type line.
Example of problematic syntax:
type name label::English select_one HR_Cat or_other A_HR_Cat A.07. Are you a Humanitarian Affairs Officer (HAO) or an Information Management Officer (IMO)?
In that case, the export will show the choice "other", but there is no dedicated column for the specified other (see column AI or AJ)
XLS Form: See row # 22 & 23 CompetencyMapping.xlsx
Link to Form: https://ee.kobotoolbox.org/x/#YT9o
Downloaded data in XL: Competency Survey - labels - 2017-06-20-11-08.xlsx