View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
07010Bug reportsOtherpublic2013-03-11 15:04
Reporterfernandodbc Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Fixed in Version2.00+ 
Summary07010: Export response on csv : \n or \r\n doesn't escaped
Description

When you want to make an csv export with questions who have \n or \r\n, the export file doesnt look good.

I've made a bugfix on the uploaded file ...

Steps To Reproduce

1* Write some questions with \n or \r\n (if you are in windows or linux)

2* Go to export page : admin/export/exportresults/surveyid/<my_id>

3* Make a csv export

4* open with notepad or excel ...

TagsNo tags attached.
Attached Files
common_helper.php (289,711 bytes)
Bug heat4
Complete LimeSurvey version number (& build)121117
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-03-05 13:56

developer   ~24554

Last edited: 2013-03-05 13:57

CSV can have /n and /r/n in the "cell".

But " must be "" in each "cell". Maybe the problem is here.

(and using function with good option in exportresult is better)

And again,

Please test with last version.

c_schmitz

c_schmitz

2013-03-05 22:16

administrator   ~24559

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=11777

c_schmitz

c_schmitz

2013-03-05 22:16

administrator   ~24560

Line breaks are now properly unified and written to the CSV file

c_schmitz

c_schmitz

2013-03-07 22:39

administrator   ~24575

Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=11794

c_schmitz

c_schmitz

2013-03-11 15:04

administrator   ~24629

2.00+ build 130311 released

Related Changesets

LimeSurvey: master 7bb00d23

2013-03-05 21:15:52

c_schmitz

Details Diff
Fixed issue 07010: Line breaks not properly handled in response export to CSV Affected Issues
07010
mod - application/helpers/common_helper.php Diff File

LimeSurvey: 2.05 81df4c55

2013-03-05 21:15:52

c_schmitz

Details Diff
Fixed issue 07010: Line breaks not properly handled in response export to CSV Affected Issues
07010
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-12-04 15:15 fernandodbc New Issue
2012-12-04 15:15 fernandodbc File Added: common_helper.php
2013-03-05 12:51 c_schmitz Project @2@ => Bug reports
2013-03-05 12:51 c_schmitz Category Admin Tools => Other issues
2013-03-05 13:56 DenisChenu Note Added: 24554
2013-03-05 13:57 DenisChenu Note Edited: 24554
2013-03-05 13:57 DenisChenu Note Edited: 24554
2013-03-05 22:15 c_schmitz Assigned To => c_schmitz
2013-03-05 22:15 c_schmitz Status new => assigned
2013-03-05 22:16 c_schmitz Changeset attached => LimeSurvey master 7bb00d23
2013-03-05 22:16 c_schmitz Note Added: 24559
2013-03-05 22:16 c_schmitz Resolution open => fixed
2013-03-05 22:16 c_schmitz Note Added: 24560
2013-03-05 22:16 c_schmitz Status assigned => resolved
2013-03-05 22:16 c_schmitz Fixed in Version => 2.00+
2013-03-07 22:39 c_schmitz Changeset attached => LimeSurvey 2.05 81df4c55
2013-03-07 22:39 c_schmitz Note Added: 24575
2013-03-11 15:04 c_schmitz Note Added: 24629
2013-03-11 15:04 c_schmitz Status resolved => closed