View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
16676Bug reportsImport/Exportpublic2021-03-09 13:55
ReporterChristianJeske Assigned Toollehar  
PrioritynoneSeverityblock 
Status closedResolutionunable to reproduce 
Product Version4.3.15 
Summary16676: LimeSurvey PDF (QueXML/PDF) and html export totally screws with Array ordering
Description

Hello,

I made and remade the same array (6 Questions, 10 values from 1-10) in multiple (also new) survey and with import, with creating it new, multiple times.

In LimeSurvey I see it ordered Minute 0-5. In the Database I see the QID to be sequencial (say 2013, 2014 and so on, the question ordering in the DB is also 1-6.

So from Limesurvey side everything looks great.

As soon as I go to export and either select html or (what I would want) quexf pdf the array gets more or less random. 2,0,3,4,5,1

So I have no idea how and why the export treats the sorting without looking at either the sorting order (which again is there in the database and in LS as it shows correctly in the online survey).

Steps To Reproduce

Do Array X 5 or 6, Y 1-10. Export to html or quexf pdf/xml

TagsNo tags attached.
Attached Files
borked_export.png (99,309 bytes)   
borked_export.png (99,309 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)Version 4.3.15+200907
I will donate to the project if issue is resolvedNo
BrowserFirefox 80
Database type & versionMySQL 5.6.19 version 427
Server OS (if known)
Webserver software & version (if known)
PHP Version7.3.10

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2020-09-19 18:50

developer   ~59886

A sample lss file with only one question can be great …

ChristianJeske

ChristianJeske

2020-09-21 09:01

reporter   ~59890

Ah sure, there is 2 groups, second question group is the array. This version I tried the 10-Point array but with array (F) same result.

I have 0 idea what the Problem could be. Database / Limesurvey Looks good. As soon as I Export it does a random roll on the sorting of the Array.

ChristianJeske

ChristianJeske

2020-09-21 10:50

reporter   ~59893

just created another survey. Only one question, limesurvey looks good. As soon as I export to HTML or QueXML (Pdf or XML) it will sort the Array in a random sorting.

random minutes.png (83,014 bytes)   
random minutes.png (83,014 bytes)   
html.png (39,146 bytes)   
html.png (39,146 bytes)   
ChristianJeske

ChristianJeske

2020-10-01 08:27

reporter   ~59997

Can anybody replicate my error? Or just my install borked?

ollehar

ollehar

2021-03-03 15:46

administrator   ~62678

Please check if this bug still exists in the latest patch release. Thank you.

ChristianJeske

ChristianJeske

2021-03-03 15:53

reporter   ~62681

I'll install the latest Version tomorrow and will try again and let you know. Thanks!

ChristianJeske

ChristianJeske

2021-03-04 10:14

reporter   ~62705

LimeSurvey
Version 4.4.11+210301

I upgraded PHP vom 7.3 to 7.4.0

And changed the DB to a MariaDB 10.4

As you can see, the pdf / xml export still does the same, I have a simple array with 1-10 and Minutes 0-6 and it will totally scramble the minutes by random. And every export it will scramble them again. For whatever reason.

ChristianJeske

ChristianJeske

2021-03-04 10:27

reporter   ~62706

Can you replicate my problem with the Survey? Or if it works, can you send me a 0-5 Grid with 1-10 answers?

ollehar

ollehar

2021-03-09 11:59

administrator   ~62916

Will check

ollehar

ollehar

2021-03-09 12:41

administrator   ~62919

Last edited: 2021-03-09 12:41

HTML export works fine for me. Can you import your own lss file and try again?

(Tested on latest master branch.)

LimeSurvey - Intervention.html (6,017 bytes)   
<!DOCTYPE html>
<html dir="ltr" class="de dir-ltr  no-js " lang="de"><head>
        <meta http-equiv="content-type" content="text/html; charset=UTF-8">
        <title>LimeSurvey - Intervention</title>
    </head>
    <body>

        <x-test id="action::printableSurvey"></x-test>

    <div id="limesurvey">
            <h1>Intervention</h1>

            <div class="survey-description"></div>

            <div class="survey-welcome"></div>

            <p class="x-questions">In dieser Umfrage sind 1 Fragen enthalten.</p>

                                            <div class="survey-group ">
    <h2>Meine erste Fragengruppe</h2>
    <div class="group-desc">
        
    </div>
                    <div id="question" class="array-flexible-row mandatory question-wrapper">
    <div class="q-text">
        <h3> <p>Temperaturwahrnehmung
            <span class="mandatory">*</span>
        </p></h3>
        <p class="q-scenaria"></p>
        <p class="q-type-help"></p><div class="tip-help">Bitte wählen Sie die zutreffende Antwort für jeden Punkt aus:</div><p></p>
        <p class="q-man-message"></p>
        <p class="q-validation"></p>
        <p class="q-fvalidation"></p>
    </div>
    <div class="q-answer">
        
<table class="table-print-answers table table-bordered">
	<thead>
		<tr>
			<td style="width:33%"><span></span></td>
			<th style="width:8%;">1 (Kühl)</th>
			<th style="width:8%;">2</th>
			<th style="width:8%;">3</th>
			<th style="width:8%;">4</th>
			<th style="width:8%;">5</th>
			<th style="width:8%;">6</th>
			<th style="width:8%;">7</th>
			<th style="width:8%;">8</th>
			<th style="width:8%;">9</th>
			<th style="width:8%;">10 (sehr heiss)</th>
		</tr>
	</thead>

	<tbody>
		<tr class="ls-odd">
			<th class="answertext">Minute 0</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
		<tr class="ls-even">
			<th class="answertext">Minute 1</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
		<tr class="ls-odd">
			<th class="answertext">Minute 2</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
		<tr class="ls-even">
			<th class="answertext">Minute 3</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
		<tr class="ls-odd">
			<th class="answertext">Minute 4</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
		<tr class="ls-even">
			<th class="answertext">Minute 5</th>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
			<td><div class="input-radio"><span></span></div></td>
		</tr>
	</tbody>
</table>

    </div>
    <div class="q-help">
        <p>1 ist Kalt, 10 ist heiß</p>
    </div>
</div>

    </div>

            
            
            
            <p class="submit-by">
                <br>
                <br>
                <br>
                Übermittlung Ihres ausgefüllten Fragebogens:<br>
                Vielen Dank für die Beantwortung des Fragebogens.<br>
            </p>

        </div>
    

</body></html>
LimeSurvey - Intervention.html (6,017 bytes)   
ChristianJeske

ChristianJeske

2021-03-09 13:53

reporter   ~62925

Ok, I first just exported it again and had the same mistake.

Then I thought, ok you said import it again first, so I made a new one, imported it and it worked.

Both in HTML and in QXML which is what I want.

I still have no clue what or how. Do I have to export/import now? Or just make a new one and it should work?

ollehar

ollehar

2021-03-09 13:54

administrator   ~62926

Yeah, good question....

ollehar

ollehar

2021-03-09 13:55

administrator   ~62927

Closing this for now. Please tell us if a similar issue appears again.

Issue History

Date Modified Username Field Change
2020-09-18 13:34 ChristianJeske New Issue
2020-09-18 13:34 ChristianJeske File Added: borked_export.png
2020-09-19 18:50 DenisChenu Note Added: 59886
2020-09-21 09:01 ChristianJeske Note Added: 59890
2020-09-21 09:01 ChristianJeske File Added: limesurvey_survey_626625.lss
2020-09-21 10:50 ChristianJeske Note Added: 59893
2020-09-21 10:50 ChristianJeske File Added: limesurvey_survey_484217.lss
2020-09-21 10:50 ChristianJeske File Added: random minutes.png
2020-09-21 10:50 ChristianJeske File Added: html.png
2020-10-01 08:27 ChristianJeske Note Added: 59997
2021-03-03 15:46 ollehar Assigned To => ollehar
2021-03-03 15:46 ollehar Status new => feedback
2021-03-03 15:46 ollehar Note Added: 62678
2021-03-03 15:53 ChristianJeske Note Added: 62681
2021-03-03 15:53 ChristianJeske Status feedback => assigned
2021-03-04 10:14 ChristianJeske Note Added: 62705
2021-03-04 10:14 ChristianJeske File Added: 2021-03-04 10_09_07-quexmlpdf_626625_de.pdf - Foxit Reader.png
2021-03-04 10:27 ChristianJeske Note Added: 62706
2021-03-09 11:59 ollehar Note Added: 62916
2021-03-09 12:41 ollehar Note Added: 62919
2021-03-09 12:41 ollehar File Added: LimeSurvey - Intervention.html
2021-03-09 12:41 ollehar Note Edited: 62919
2021-03-09 12:42 ollehar Status assigned => feedback
2021-03-09 13:53 ChristianJeske Note Added: 62925
2021-03-09 13:53 ChristianJeske Status feedback => assigned
2021-03-09 13:54 ollehar Note Added: 62926
2021-03-09 13:55 ollehar Status assigned => closed
2021-03-09 13:55 ollehar Resolution open => unable to reproduce
2021-03-09 13:55 ollehar Note Added: 62927