View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
18102Bug reportsImport/Exportpublic2022-05-25 02:36
Reporterahhsung Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status assignedResolutionopen 
Product Version5.3.x 
Summary18102: Export Duplicate entries in the Excel Form
Description

I am currently using LimeSurvey 5.1.10 and it is found that the there are duplicated entries in the Survey Result if there are more than 200 rows.

Steps To Reproduce

Steps to reproduce

Survey with more than 200 responses

Expected result

Export completed responses in Excel Format

Actual result

A few rows in the survey is duplicated

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)5.1.10
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL Server 2016
Server OS (if known)Windows Server 2016
Webserver software & version (if known)
PHP Version8.0.10

Users monitoring this issue

User List Mazi

Activities

ahhsung

ahhsung

2022-05-13 04:57

reporter  

bug.png (40,409 bytes)   
bug.png (40,409 bytes)   
gabrieljenik

gabrieljenik

2022-05-13 15:11

manager   ~69624

Has this happened more than once?
Can you please provide more precise instructions on how to reproduce? Preferably in a step-by-step manner, like 1) Go to question x; 2) Click button y; 3) Expected z but saw v. Thank you very much.

ahhsung

ahhsung

2022-05-16 02:52

reporter   ~69643

Yes. This happened when the survey is more than 200 responses.
Also, it is found that there are no duplication in the submission table.

Step-by-Step manner:

  1. Select an survey with more than 200 responses
  2. Select Responses and Statistic under Responses
  3. Select Export responses under Export
  4. Select "Export Format" as Microsoft Excel and Completed Responses only
  5. Export

After that, the downloaded excel contains duplicated entries in the file.

Thank you.

gabrieljenik

gabrieljenik

2022-05-16 17:22

manager   ~69671

Does this happen on many surveys or just one?

DenisChenu

DenisChenu

2022-05-16 18:10

developer   ~69676

But here : it's not duplicate for sure. Order of id can be different when export thand ASC

Can you export the LSA (private upload is possible)

ahhsung

ahhsung

2022-05-17 03:07

reporter   ~69693

The problem happened in all the Surveys

DenisChenu

DenisChenu

2022-05-17 08:57

developer   ~69695

Can you export the 453141 data here ? Want to check something.
(i can not reproduce with the lsa)

Issue History

Date Modified Username Field Change
2022-05-13 04:57 ahhsung New Issue
2022-05-13 04:57 ahhsung File Added: bug.png
2022-05-13 15:11 gabrieljenik Assigned To => gabrieljenik
2022-05-13 15:11 gabrieljenik Status new => feedback
2022-05-13 15:11 gabrieljenik Note Added: 69624
2022-05-13 15:11 gabrieljenik Bug heat 0 => 2
2022-05-16 02:52 ahhsung Note Added: 69643
2022-05-16 02:52 ahhsung Bug heat 2 => 4
2022-05-16 02:52 ahhsung Status feedback => assigned
2022-05-16 17:22 gabrieljenik Note Added: 69671
2022-05-16 18:10 DenisChenu Note Added: 69676
2022-05-16 18:10 DenisChenu Bug heat 4 => 6
2022-05-17 03:07 ahhsung Note Added: 69693
2022-05-17 08:57 DenisChenu Note Added: 69695
2022-05-17 08:57 DenisChenu File Added: Capture d’écran du 2022-05-17 08-56-44.png
2022-05-17 12:11 Mazi Issue Monitored: Mazi
2022-05-17 12:11 Mazi Bug heat 6 => 8
2022-05-25 02:36 hinghang Bug heat 8 => 10