View Issue Details

IDProjectCategoryView StatusLast Update
15154Bug reportsImport/Exportpublic2021-03-10 22:24
Reporterdavebostockgmail Assigned To 
Status feedbackResolutionopen 
Product Version3.17.x 
Summary15154: Export of data incorrect when an Exclusive is in consistent in a Multiple Choice Question
DescriptionWhen an exclusive option is added to a multiple choice question the data is stored inconsistently when compared to other answer options this affects the export and reporting of the data and is not in line with other research software conventions.

The data in a multiple choice question is either Y or N for selected answer or Not ...and this is exported as a 1 or a 0 in the data set allowing you to get a base to calculate the correct %'s needed, when you apply an Exclusive option then instead of being N the other answers are shown as N/A which leaves the exported data blank.

This is an issue if the questions has logic to display it or not ... as you cannot then tell if the sub question (answer option) was seen and not answered or not seen due to filtering.
Steps To ReproduceCreate a survey with a multiple choice question
Make one of the answers exclusive
Run through the survey several times
Export the data to see the incorrect export when compared to the other answers.
TagsNo tags attached.
Complete LimeSurvey version number (& build)3.17.7+190627
I will donate to the project if issue is resolvedNo
Database & DB-VersionMySQL 5.x
Server OS (if known)Ubuntu 16
Webserver software & version (if known)Apache 2
PHP VersionPHP 5.6




2021-03-10 22:24

administrator   ~63191

Please update to the latest version and check if the bug can still be reproduced. Thank you.

Issue History

Date Modified Username Field Change
2019-08-12 14:26 davebostockgmail New Issue
2019-12-03 15:53 cdorin Assigned To => cdorin
2019-12-03 15:53 cdorin Status new => assigned
2021-02-08 13:02 cdorin Assigned To cdorin =>
2021-02-08 13:02 cdorin Status assigned => acknowledged
2021-03-10 22:24 ollehar Status acknowledged => feedback
2021-03-10 22:24 ollehar Note Added: 63191