07010: Export response on csv : \n or \r\n doesn't escaped - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

07010	Bug reports	Other	public	2012-12-04 15:15	2013-03-11 15:04

Reporter	fernandodbc	Assigned To	c_schmitz
Priority	normal	Severity	minor
Status	closed	Resolution	fixed
Fixed in Version	2.00+

Summary	07010: 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 ...
Tags	No tags attached.
Attached Files	common_helper.php (289,711 bytes)

Bug heat	4
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

User List	There are no users monitoring this issue.

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 2013-03-05 22:16 administrator ~24559	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11777

c_schmitz 2013-03-05 22:16 administrator ~24560	Line breaks are now properly unified and written to the CSV file

c_schmitz 2013-03-07 22:39 administrator ~24575	Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=11794

c_schmitz 2013-03-11 15:04 administrator ~24629	2.00+ build 130311 released

LimeSurvey: master 7bb00d23 2013-03-05 22:15 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 22:15 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

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