View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06189 | Bug reports | Import/Export | public | 2012-06-10 09:50 | 2012-09-20 14:12 |
Reporter | Assigned To | ||||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92+ | ||||
Fixed in Version | 2.00RC9 | ||||
Summary | 06189: 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. | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 999999 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Any | ||||
Server OS (if known) | Any | ||||
Webserver software & version (if known) | Any | ||||
PHP Version | Any | ||||
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. |
|
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. |
|
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. |
|
Fixed in Yii branch |
|
Added column headers, and changed quote character to "double quotes" |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-06-10 09:50 |
|
New Issue | |
2012-06-10 09:50 |
|
Status | new => assigned |
2012-06-10 09:50 |
|
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 |
|
Note Added: 20492 | |
2012-08-16 23:30 |
|
Status | feedback => assigned |
2012-08-21 09:47 |
|
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 |
|
Description Updated | |
2012-08-21 09:48 |
|
Note Added: 20554 | |
2012-08-21 11:16 |
|
Note Added: 20557 | |
2012-08-21 11:17 |
|
Note Added: 20559 | |
2012-08-21 11:17 |
|
Status | assigned => resolved |
2012-08-21 11:17 |
|
Fixed in Version | => 2.00RC9 |
2012-08-21 11:17 |
|
Resolution | open => fixed |
2012-09-20 14:12 | c_schmitz | Status | resolved => closed |