View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
18167Bug reportsImport/Exportpublic2022-06-24 17:35
Reporterfranz007 Assigned Togabrieljenik  
PrioritynoneSeverityblock 
Status assignedResolutionopen 
Product Version3.28.x 
Summary18167: Certain answers are neither displayed nor exported
Description

For some, not all, responses, certain answers are not displayed in the "View response details" function.
The same answers are not exported either.
Values are correctly stored in the database.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)Version 3.28.13+220531
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.5.55
Server OS (if known)
Webserver software & version (if known)
PHP Version5.6.30

Users monitoring this issue

User List franz007

Activities

DenisChenu

DenisChenu

2022-05-31 17:38

developer   ~70129

No lss or lsa ?
No way to reproduce …

franz007

franz007

2022-05-31 17:51

reporter   ~70130

lss attached
The problem is for example for questions 2703 and 2740

franz007

franz007

2022-06-14 16:11

reporter   ~70350

Any update about this?
Thanks

gabrieljenik

gabrieljenik

2022-06-14 23:02

manager   ~70363

From what we have been reviewing the behaviour is happening, but it is to highlight that we believe it may only be happening to questions which are not relevant for the given response (which were not shown during the survey taking process).

Can you confirm this only happens to non-relevant questions?
What kind of export are you using? Individual export or mass response export?

franz007

franz007

2022-06-15 09:22

reporter   ~70369

Unfortunately this is not the case.
Some of the answers not included in any report are of mandatory questions.
The problem affects both the Responses -> Survey responses -> View response details function and the export in any format.
I attach the example from one of the submitted answers that are affected by the problem.
The answers stored in the database are shown in the image.
Thanks for the support.

gabrieljenik

gabrieljenik

2022-06-15 15:47

manager   ~70383

Please, can you include an LSA and point us to a specific response where this is happening?

franz007

franz007

2022-06-15 16:13

reporter   ~70385

lsa attached.
I had to import the survey into our testing environment to anonymize tokens so sid and other ids have changed.
Responses affected by the problem are for example 37, 41, 42 but there are many ore.
Not all the answers are "missing" the same values.
Data is correctly stored in the database.

gabrieljenik

gabrieljenik

2022-06-21 21:21

manager   ~70464

Ohh I understand now!
For specific questions, the response is on the DB, but is showing empty on the individual response view, right?

I thought the row for the whole question was not shown (which could happen if question was not asked).

The response is shown on the queXML export.

image.png (24,587 bytes)   
image.png (24,587 bytes)   
franz007

franz007

2022-06-22 08:47

reporter   ~70472

Sorry for not being able to fully explain the problem.
The problem is both in viewing a single response and in the export of the responses in all formats.
I have to provide the export of all responses in csv or Excel format.
Could you please further investigate the problem?
Thanks

gabrieljenik

gabrieljenik

2022-06-22 22:19

manager   ~70495

Last edited: 2022-06-22 22:23

I think the is because of the "<" sign used on the answer option.
Can Iask you to remove it and try again? (Just a sa temporary workaround)
Or use "<" as a replacement for "<" (please, try it on a test env)

franz007

franz007

2022-06-24 08:52

reporter   ~70519

Thanks very much for the hint.
Changing the answers options, display and export of responses is now working.

gabrieljenik

gabrieljenik

2022-06-24 17:35

manager   ~70520

Glad workaround works.
Still an issue!

Issue History

Date Modified Username Field Change
2022-05-31 17:37 franz007 New Issue
2022-05-31 17:37 franz007 Issue Monitored: franz007
2022-05-31 17:37 franz007 Bug heat 0 => 2
2022-05-31 17:38 DenisChenu Note Added: 70129
2022-05-31 17:38 DenisChenu Bug heat 2 => 4
2022-05-31 17:51 franz007 Note Added: 70130
2022-05-31 17:51 franz007 File Added: limesurvey_survey_548912.lss
2022-05-31 17:51 franz007 Bug heat 4 => 6
2022-06-14 16:11 franz007 Note Added: 70350
2022-06-14 23:01 gabrieljenik Status new => acknowledged
2022-06-14 23:02 gabrieljenik Assigned To => gabrieljenik
2022-06-14 23:02 gabrieljenik Status acknowledged => feedback
2022-06-14 23:02 gabrieljenik Note Added: 70363
2022-06-14 23:02 gabrieljenik Bug heat 6 => 8
2022-06-15 09:22 franz007 Note Added: 70369
2022-06-15 09:22 franz007 File Added: results-survey548912.csv
2022-06-15 09:22 franz007 File Added: responseDetails.png
2022-06-15 09:22 franz007 Status feedback => assigned
2022-06-15 15:47 gabrieljenik Note Added: 70383
2022-06-15 16:09 franz007 File Deleted: limesurvey_survey_548912.lss
2022-06-15 16:13 franz007 Note Added: 70385
2022-06-15 16:13 franz007 File Added: survey_archive_245644.lsa
2022-06-21 21:21 gabrieljenik Note Added: 70464
2022-06-21 21:21 gabrieljenik File Added: image.png
2022-06-22 08:47 franz007 Note Added: 70472
2022-06-22 22:19 gabrieljenik Note Added: 70495
2022-06-22 22:22 gabrieljenik Note Edited: 70495
2022-06-22 22:23 gabrieljenik Note Edited: 70495
2022-06-24 08:52 franz007 Note Added: 70519
2022-06-24 08:52 franz007 File Deleted: responseDetails.png
2022-06-24 08:52 franz007 File Deleted: results-survey548912.csv
2022-06-24 08:52 franz007 File Deleted: survey_archive_245644.lsa
2022-06-24 17:35 gabrieljenik Note Added: 70520