View Issue Details

This bug affects 1 person(s).
 24
IDProjectCategoryView StatusLast Update
19383Bug reportsImport/Exportpublic2024-04-19 08:49
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version6.4.x 
Summary19383: 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 .
Loose this part in 6.X

Steps To Reproduce

Steps to reproduce

Import included survey, export with fuill answer on 6.X
Comapore with 5X expport

Expected result

Same result

Actual result

No in place of N/A

TagsNo 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,,,
results-survey932686-5X.csv (778 bytes)   
Bug heat24
Complete LimeSurvey version number (& build)6.4.4
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Relationships

has duplicate 19477 closedDenisChenu 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 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-01-30 12:22

developer   ~79347

For tester : LSA import empty value as NULL value (to be reported too …)
Then need to create some answers before test export

c_schmitz

c_schmitz

2024-01-30 14:58

administrator   ~79355

URL to PR?

DenisChenu

DenisChenu

2024-01-30 15:00

developer   ~79357

https://github.com/LimeSurvey/LimeSurvey/pull/3718

gabrieljenik

gabrieljenik

2024-02-12 13:51

manager   ~79451

Code structure looks good. Haven't tested it.
I would say we create a ticket for creating unit tests for these classes. We can take those unit tests.
@tibor.pacalat look forward for your confirmation

tibor.pacalat

tibor.pacalat

2024-02-12 14:49

administrator   ~79454

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",,,
results-survey932686.csv (913 bytes)   
tibor.pacalat

tibor.pacalat

2024-02-12 14:50

administrator   ~79455

@gabrieljenik, sure I'll create ticket for the unit tests when this one has been approved and merged in.

DenisChenu

DenisChenu

2024-02-12 15:07

developer   ~79456

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.

What do you have in 5.X ?
Warning about extra N/A : related to https://bugs.limesurvey.org/view.php?id=19386
You must create new response to check the difference.

DenisChenu

DenisChenu

2024-02-13 17:06

developer   ~79482

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36055

DenisChenu

DenisChenu

2024-02-13 17:06

developer   ~79483

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36054

rodarape@gmail.com

rodarape@gmail.com

2024-02-13 17:14

reporter   ~79484

Hi, I have de same problem When export multiple choice filtered : loose N/A value in 6.4

DenisChenu

DenisChenu

2024-02-13 18:42

developer   ~79485

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 :)

tibor.pacalat

tibor.pacalat

2024-02-14 09:21

administrator   ~79486

Link for the unit tests https://bugs.limesurvey.org/view.php?id=19416

LimeBot

LimeBot

2024-02-19 16:17

administrator   ~79545

Fixed in Release 6.4.7+240219

Related Changesets

LimeSurvey: master c6b58988

2024-02-13 17:06:13

DenisChenu


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 17:06:13

DenisChenu


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

Issue History

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