View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04923Bug reportsImport/Exportpublic2011-04-11 11:31
Reporteruser11886Assigned ToMazi  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version1.90+ 
Summary04923: CSV export of responses doesn't work
Description

There seems to be a bug in CSV exporting when there is a comma and quotations within the question.

Steps To Reproduce

Create question with a quotation and a comma within the question. (Ex: She said "No," but did she mean it?)
Export to CSV and it will be incorrect.

TagsNo tags attached.
Attached Files
vvexport_72555.csv (248 bytes)   
Response ID	Date submitted	Last page	Start language	She said "No," but did she mean it?	
id	submitdate	lastpage	startlanguage	72555X22X146	
1	1980-01-01 00:00:00	2	en	yes she "meant" it.. ?
2	1980-01-01 00:00:00	2	en	
3	1980-01-01 00:00:00	2	en	no
vvexport_72555.csv (248 bytes)   
vvexport_72555.tab (248 bytes)
Bug heat4
Complete LimeSurvey version number (& build)9089
I will donate to the project if issue is resolvedNo
BrowserMozilla Firefox but I think bug persists across all browsers
Database type & versionMySQL 5.1.36
Server OS (if known)Windows 7
Webserver software & version (if known)Apache 2.2.11
PHP Version5.3.0
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2011-02-09 16:01

updater   ~14110

Please test if this is fixed at the latest version by testing our online demo at http://demo.limesurvey.org/admin(external link) which always runs the latest Limesurvey version.
Username: admin
Password: test
If you can reproduce the problem there please report back.

user12700

2011-03-11 16:13

  ~14409

Hi,
I have tested the issue using online demo as suggested by Mazi.
and there seems to be no problem with the exported file.

The actual problem lies in rendering it with microsoft excel.
Excel, tries to render the file as comma seperated values, where the file contains tab delimited values.

The solution to this can be found on the export page itself.
it states -
"* For easy opening in MS Excel, change the extension to 'tab' or 'txt'"

so save the file with .tab extension and open it with microsoft excel...
It will give the option of selecting the delimiter, set it as Tab (in most cases, excel will automatically guess it)
and then the file is rendered properly.

i have attached the file with both extensions , so you can also check it out.
(Files - vvexport_72555.csv, vvexport_72555.tab)

PS: I tried to escape the comma,in the generated csv(for user friendliness), but still excel renders it wrong, so it seems the only proper solution is delimiting the file with tabs,which limesurvey is already doing.

Mazi

Mazi

2011-03-12 12:57

updater   ~14415

Thanks for your detailed feedback.

Issue History

Date Modified Username Field Change
2011-02-03 01:02 user11886 New Issue
2011-02-03 15:26 user11898 Issue Monitored: user11898
2011-02-09 16:01 Mazi Note Added: 14110
2011-02-09 16:01 Mazi Assigned To => Mazi
2011-02-09 16:01 Mazi Status new => feedback
2011-03-11 14:48 user12700 Issue Monitored: user12700
2011-03-11 14:48 user12700 Issue End Monitor: user12700
2011-03-11 16:00 user12700 File Added: vvexport_72555.csv
2011-03-11 16:01 user12700 File Added: vvexport_72555.tab
2011-03-11 16:13 user12700 Note Added: 14409
2011-03-11 16:17 user12700 Issue Monitored: user12700
2011-03-12 12:57 Mazi Note Added: 14415
2011-03-12 12:57 Mazi Status feedback => resolved
2011-03-12 12:57 Mazi Resolution open => no change required
2011-04-11 11:31 c_schmitz Status resolved => closed