View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
19383 | Bug reports | Import/Export | public | 2024-01-30 11:00 | 2024-04-19 08:49 |
Reporter | DenisChenu | Assigned To | DenisChenu | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 6.4.x | ||||
Summary | 19383: When export multiple choice filtered : loose N/A value | ||||
Description | In 5.X , for multiple choice : there are a difference between sub question filtered and sub question not answered . | ||||
Steps To Reproduce | Steps to reproduceImport included survey, export with fuill answer on 6.X Expected resultSame result Actual resultNo in place of N/A | ||||
Tags | No tags attached. | ||||
Attached Files | results-survey932686-5X.csv (778 bytes)
Response ID,Date submitted,Last page,Start language,Seed,Date started,Date last action,IP address,A first example question. Please answer this question: [Choice 1],A first example question. Please answer this question: [Choice 2],A first example question. Please answer this question: [Choice 3],Filtered [Choice 1],Filtered [Choice 2],Filtered [Choice 3],Filtered array [Choice 1],Filtered array [Choice 2],Filtered array [Choice 3] 1,2024-01-30 10:53:45,1,en,453245779,2024-01-30 10:53:34,2024-01-30 10:53:45,127.0.0.0,Yes,Yes,No,Yes,No,N/A,Uncertain,, 2,2024-01-30 10:53:53,1,en,554436717,2024-01-30 10:53:50,2024-01-30 10:53:53,127.0.0.0,No,No,No,N/A,N/A,N/A,,, 3,2024-01-30 10:54:01,1,en,2099096180,2024-01-30 10:53:57,2024-01-30 10:54:01,127.0.0.0,Yes,Yes,Yes,No,No,No,,, | ||||
Bug heat | 24 | ||||
Complete LimeSurvey version number (& build) | 6.4.4 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | not relevant | ||||
Database type & version | not relevant | ||||
Server OS (if known) | not relevant | ||||
Webserver software & version (if known) | not relevant | ||||
PHP Version | not relevant | ||||
has duplicate | 19477 | closed | DenisChenu | Error exporting questions of type YES/NO/No Answer to excel. |
related to | 19386 | new | Survey archive didn't respect NULL value | |
related to | 19236 | new | Answers to multiple choice questions with an exclusive option are incorrectly exported |
For tester : LSA import empty value as NULL value (to be reported too …) |
|
URL to PR? |
|
Code structure looks good. Haven't tested it. |
|
Hmm, when I compare csv export from this ticket (5.x) and the export from fix branch (result in attachment) they are not the same. results-survey932686.csv (913 bytes)
"Response ID","Date submitted","Last page","Start language","Seed","Date started","Date last action","IP address","A first example question. Please answer this question: [Choice 1]","A first example question. Please answer this question: [Choice 2]","A first example question. Please answer this question: [Choice 3]","Filtered [Choice 1]","Filtered [Choice 2]","Filtered [Choice 3]","Filtered array [Choice 1]","Filtered array [Choice 2]","Filtered array [Choice 3]" "1","2024-01-30 10:53:45","1","en","453245779","2024-01-30 10:53:34","2024-01-30 10:53:45","127.0.0.0","Yes","Yes","N/A","Yes","N/A","N/A","Uncertain",, "2","2024-01-30 10:53:53","1","en","554436717","2024-01-30 10:53:50","2024-01-30 10:53:53","127.0.0.0","N/A","N/A","N/A","N/A","N/A","N/A",,, "3","2024-01-30 10:54:01","1","en","2099096180","2024-01-30 10:53:57","2024-01-30 10:54:01","127.0.0.0","Yes","Yes","Yes","N/A","N/A","N/A",,, |
|
@gabrieljenik, sure I'll create ticket for the unit tests when this one has been approved and merged in. |
|
What do you have in 5.X ? |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36055 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36054 |
|
Hi, I have de same problem When export multiple choice filtered : loose N/A value in 6.4 |
|
Wait for next update or apply the fix :) |
|
Link for the unit tests https://bugs.limesurvey.org/view.php?id=19416 |
|
Fixed in Release 6.4.7+240219 |
|
LimeSurvey: master c6b58988 2024-02-13 18:06 Committer: GitHub Details Diff |
Fixed issue 19383: When export multiple choice filtered : loose N/A value (03718) |
Affected Issues 19383 |
|
mod - application/helpers/admin/export/SurveyObj.php | Diff File | ||
LimeSurvey: master c6b58988 2024-02-13 18:06 Committer: GitHub Details Diff |
Fixed issue 19383: When export multiple choice filtered : loose N/A value (03718) |
Affected Issues 19383 |
|
mod - application/helpers/admin/export/SurveyObj.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2024-01-30 11:00 | DenisChenu | New Issue | |
2024-01-30 11:00 | DenisChenu | File Added: results-survey932686-5X.csv | |
2024-01-30 11:00 | DenisChenu | File Added: survey_archive_MultipleChoiceFlter.lsa | |
2024-01-30 11:00 | DenisChenu | Assigned To | => DenisChenu |
2024-01-30 11:00 | DenisChenu | Status | new => assigned |
2024-01-30 12:22 | DenisChenu | Note Added: 79347 | |
2024-01-30 12:22 | DenisChenu | Bug heat | 0 => 2 |
2024-01-30 14:49 | DenisChenu | Assigned To | DenisChenu => c_schmitz |
2024-01-30 14:49 | DenisChenu | Status | assigned => ready for code review |
2024-01-30 14:58 | c_schmitz | Note Added: 79355 | |
2024-01-30 14:58 | c_schmitz | Bug heat | 2 => 4 |
2024-01-30 15:00 | DenisChenu | Note Added: 79357 | |
2024-01-31 16:09 | DenisChenu | Relationship added | related to 19386 |
2024-02-12 13:51 | gabrieljenik | Status | ready for code review => ready for testing |
2024-02-12 13:51 | gabrieljenik | Note Added: 79451 | |
2024-02-12 13:51 | gabrieljenik | Bug heat | 4 => 6 |
2024-02-12 14:49 | tibor.pacalat | Note Added: 79454 | |
2024-02-12 14:49 | tibor.pacalat | File Added: results-survey932686.csv | |
2024-02-12 14:49 | tibor.pacalat | Bug heat | 6 => 8 |
2024-02-12 14:50 | tibor.pacalat | Note Added: 79455 | |
2024-02-12 15:07 | DenisChenu | Note Added: 79456 | |
2024-02-13 16:43 | DenisChenu | Bug heat | 8 => 14 |
2024-02-13 17:06 | DenisChenu | Changeset attached | => LimeSurvey master c6b58988 |
2024-02-13 17:06 | DenisChenu | Changeset attached | => LimeSurvey master c6b58988 |
2024-02-13 17:06 | DenisChenu | Note Added: 79482 | |
2024-02-13 17:06 | DenisChenu | Note Added: 79483 | |
2024-02-13 17:06 | DenisChenu | Assigned To | c_schmitz => DenisChenu |
2024-02-13 17:06 | DenisChenu | Resolution | open => fixed |
2024-02-13 17:06 | DenisChenu | Assigned To | c_schmitz => DenisChenu |
2024-02-13 17:06 | DenisChenu | Resolution | open => fixed |
2024-02-13 17:14 | rodarape@gmail.com | Note Added: 79484 | |
2024-02-13 17:14 | rodarape@gmail.com | Bug heat | 14 => 16 |
2024-02-13 18:42 | DenisChenu | Note Added: 79485 | |
2024-02-14 09:21 | tibor.pacalat | Note Added: 79486 | |
2024-02-14 12:29 | DenisChenu | Status | ready for testing => resolved |
2024-02-19 16:17 | LimeBot | Note Added: 79545 | |
2024-02-19 16:17 | LimeBot | Status | resolved => closed |
2024-02-19 16:17 | LimeBot | Bug heat | 16 => 18 |
2024-03-18 17:09 | DenisChenu | Relationship added | has duplicate 19477 |
2024-03-18 17:09 | DenisChenu | Bug heat | 18 => 24 |
2024-04-19 08:49 | DenisChenu | Relationship added | related to 19236 |