View Issue Details

IDProjectCategoryView StatusLast Update
13337Bug reports[All Projects] Import/Exportpublic2018-05-16 12:45
ReporterDeusdeorumAssigned ToLouisGac 
PrioritynoneSeverityminor 
Status feedbackResolutionopen 
Product Version3.3.x 
Target VersionFixed in Version 
Summary13337: fail on csv token import
DescriptionUploading a .csv-file generated from excel and specific mac does not work anymore.
Steps To ReproduceCreate a survey, set up it to use a token table and create a small tokens.csv-file containing firstname;lastname;email;token in excel and upload it to the token table, zero participants will be imported.
Additional InformationIncluded the same file generated from mac excel 2011, mac excel 2015, windows excel where only the latter works. All files work on 2.06LTS and 2.50+ Build 160526 (only have those two to test against...)
TagsNo tags attached.
Complete LimeSurvey version number (& build)3.3.0 github
I will donate to the project if issue is resolvedNo
Browser
Database & DB-Version 5.5.5-10.1.26-MariaDB-0+deb9u1
Operating System (Server)Debian GNU/Linux 9.3
Webserver software & version nginx/1.10.3
PHP Version 7.0.27-0+deb9u1

Activities

Deusdeorum

Deusdeorum

2018-02-12 13:43

developer  

tokens_mac_excel_v2011.csv (223 bytes)
tokens_mac_excel_v2015.csv (226 bytes)
tokens_windows_excel.csv (238 bytes)
olle

olle

2018-02-12 14:34

administrator   ~46395

Which options did you choose when you exported the tokens?
olle

olle

2018-02-12 14:36

administrator   ~46396

Did you get this error message?

Selection_391.png (19,064 bytes)
Selection_391.png (19,064 bytes)
Deusdeorum

Deusdeorum

2018-02-12 14:39

developer   ~46397

Just remove all the duplicate stuff. Sorry.

import-csv.png (130,834 bytes)
olle

olle

2018-02-12 15:11

administrator   ~46402

Works for me on latest git pull.

Selection_392.png (57,961 bytes)
Selection_392.png (57,961 bytes)
Deusdeorum

Deusdeorum

2018-02-15 09:29

developer   ~46499

@olle I just tried on demo.limesurvey.org to verify it's not my installation. And it still doesn't work. And it works on 2.06LTS and 2.50+ Build 160526.

* tokens_windows_excel.csv WORKS
* tokens_mac_excel_v2011.csv Does not work
* tokens_mac_excel_v2015.csv Does not work

All of the .csv-files are generated from respective excel versions. My guess is that there's some kind of encoding problem while detecting the character set of the file.
LouisGac

LouisGac

2018-05-16 12:45

developer   ~47624

we need somone one to confirm that he still face that bug.
else we'll close it.

Issue History

Date Modified Username Field Change
2018-02-12 13:43 Deusdeorum New Issue
2018-02-12 13:43 Deusdeorum File Added: tokens_mac_excel_v2011.csv
2018-02-12 13:43 Deusdeorum File Added: tokens_mac_excel_v2015.csv
2018-02-12 13:43 Deusdeorum File Added: tokens_windows_excel.csv
2018-02-12 13:49 Deusdeorum Additional Information Updated View Revisions
2018-02-12 14:21 olle Assigned To => olle
2018-02-12 14:21 olle Status new => assigned
2018-02-12 14:34 olle Note Added: 46395
2018-02-12 14:36 olle File Added: Selection_391.png
2018-02-12 14:36 olle Note Added: 46396
2018-02-12 14:36 olle Assigned To olle =>
2018-02-12 14:36 olle Status assigned => feedback
2018-02-12 14:39 Deusdeorum File Added: import-csv.png
2018-02-12 14:39 Deusdeorum Note Added: 46397
2018-02-12 14:39 Deusdeorum Status feedback => new
2018-02-12 15:11 olle File Added: Selection_392.png
2018-02-12 15:11 olle Note Added: 46402
2018-02-13 17:01 olle Status new => feedback
2018-02-15 09:29 Deusdeorum Note Added: 46499
2018-02-15 09:29 Deusdeorum Status feedback => new
2018-05-16 12:45 LouisGac Assigned To => LouisGac
2018-05-16 12:45 LouisGac Status new => feedback
2018-05-16 12:45 LouisGac Note Added: 47624