View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06189Bug reportsImport/Exportpublic2012-09-20 14:12
Reporteruser9189Assigned Touser9189 
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version2.00RC9 
Summary06189: Export to R: csv file uses incorrect quote character
Description

The csv export file is quoted with single quotes, rather than double quotes. This leads to problems when trying to import the csv file into Excel, for example (although R deals with this correctly.)

Note. This issue report originally incorrectly identified handling of line breaks (\n or \r) as the problem.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)999999
I will donate to the project if issue is resolvedNo
Browser
Database type & versionAny
Server OS (if known)Any
Webserver software & version (if known)Any
PHP VersionAny

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-07-27 13:23

administrator   ~20026

In general linebreak are fine in a CSV format because the end of a field is determined by the field delimiter. If R is not capable of parsing the linebreaks then an additional step (converting(removing linebreaks in fields) needs to be taken just for R export.
Andrie, can you do this?

user9189

2012-08-16 23:30

  ~20492

The problem isn't with R, which easily deals with line breaks. The issue was that in one of my surveys, the csv file had some fields that weren't quoted properly, thus being separated between columns, where the answer should have been in a single cell.

I am now trying to replicate the issue, but no success yet.

user9189

2012-08-21 09:48

  ~20554

The issue was not with line breaks being incorrectly handled, but text fields being delimited with 'single quotes' rather than "double quotes", making it difficult to read the csv export file into Excel.

user9189

2012-08-21 11:16

  ~20557

Fixed in Yii branch

user9189

2012-08-21 11:17

  ~20559

Added column headers, and changed quote character to "double quotes"

Issue History

Date Modified Username Field Change
2012-06-10 09:50 user9189 New Issue
2012-06-10 09:50 user9189 Status new => assigned
2012-06-10 09:50 user9189 Assigned To => user9189
2012-07-27 13:23 c_schmitz Note Added: 20026
2012-07-27 13:23 c_schmitz Status assigned => feedback
2012-08-16 23:30 user9189 Note Added: 20492
2012-08-16 23:30 user9189 Status feedback => assigned
2012-08-21 09:47 user9189 Summary Export to R: csv file is improperly formatted when answers to text questions contain line breaks => Export to R: csv file uses incorrect quote character
2012-08-21 09:47 user9189 Description Updated
2012-08-21 09:48 user9189 Note Added: 20554
2012-08-21 11:16 user9189 Note Added: 20557
2012-08-21 11:17 user9189 Note Added: 20559
2012-08-21 11:17 user9189 Status assigned => resolved
2012-08-21 11:17 user9189 Fixed in Version => 2.00RC9
2012-08-21 11:17 user9189 Resolution open => fixed
2012-09-20 14:12 c_schmitz Status resolved => closed