View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
12804Bug reportsImport/Exportpublic2017-10-18 12:462017-10-20 16:00
Reporterpnadam Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionduplicate 
Product Version2.7x.x 
Summary12804: Exporting responses using 'Answer Codes (replace Yes with 1 and No with 2)', causes false 2 values for resps affected by 12803
Description

When a response has been affected by bug 12803, which causes NULL data to be replaced with empty values when a response is edited, exporting that response with the answers settings set to 'Answer Codes', with Yes values to be replaced with 1 and No values to be replaced with 2, for Yes/No questions, causes those questions to be exported with value 2, when the question was not asked.

Said another way, Yes/No questions that should have NULL answers, because they were not asked, are changed to empty data by bug 12803. This empty data is then exported as the value 2, when the export settings are configured to export answer codes and to replace Yes values with 1 and to replace No values with 2.

Steps To Reproduce

Reproduce the steps in bug 12803, namely:

  1. Create a survey
  2. Add a multiple choice question 'Q1'
  3. Add another multiple choice question 'Q2' and make the relevance equation such that it is only asked if Q2 was answered with a specific response.
  4. Activate the survey and fill in some surveys: some where Q2 is asked and answered, and some where Q2 is not asked because Q1 was answered such that Q2's relevance equation was not matched.
  5. Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
  6. Inspect the database table of responses for this survey and not that Q2 is NULL for the responses in which it was not asked.
  7. Edit a response in which Q2 was not asked and is thus blank. Do not change Q2 in any way.
  8. Inspect the responses and note that Q2 is blank, correctly so, for the responses in which it was not asked.
  9. Inspect the database table of responses for this survey and note that Q2 is now an empty value instead of NULL, for the responses in which it was not asked.

Now:

  1. Export the responses and configure the export so:
    Responses: Answer codes
    [X] Convert Y to: 1
    [X] Convert N to: 2

  2. Inspect the results and see that the blank Q2s have been exported with the value 2 instead of empty answers.

Additional Information

Attached is the same file I attached for bug 12803, containing the summary of findings for both bugs as one end-user issue.

TagsNo tags attached.
Attached Files
Blank Data Export Issue Reproduction.pdf (248,823 bytes)
Bug heat0
Complete LimeSurvey version number (& build)2.72.1+171012
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 14.14, LS DB v263
Server OS (if known)Debian 7
Webserver software & version (if known)Apache 2.22.22 Debian
PHP Version5.6.25

Relationships

Relationship GraphDependency Graph
duplicate of 12803 closed Editing a response turns NULL data into no-value data, which exposes a separate bug 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2017-10-18 12:46 pnadam New Issue
2017-10-18 12:46 pnadam File Added: Blank Data Export Issue Reproduction.pdf
2017-10-20 15:59 c_schmitz Relationship added duplicate of 12803
2017-10-20 16:00 c_schmitz Assigned To => c_schmitz
2017-10-20 16:00 c_schmitz Status new => closed
2017-10-20 16:00 c_schmitz Resolution open => duplicate