View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04923 | Bug reports | Import/Export | public | 2011-02-03 01:02 | 2011-04-11 11:31 |
| Reporter | Assigned To | Mazi | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 1.90+ | ||||
| Summary | 04923: 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?) | ||||
| Tags | No 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 | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 9089 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Mozilla Firefox but I think bug persists across all browsers | ||||
| Database type & version | MySQL 5.1.36 | ||||
| Server OS (if known) | Windows 7 | ||||
| Webserver software & version (if known) | Apache 2.2.11 | ||||
| PHP Version | 5.3.0 | ||||
| Git branch / Pull Request URL | |||||
|
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. |
|
|
Hi, The actual problem lies in rendering it with microsoft excel. The solution to this can be found on the export page itself. so save the file with .tab extension and open it with microsoft excel... i have attached the file with both extensions , so you can also check it out. 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. |
|
|
Thanks for your detailed feedback. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-02-03 01:02 |
|
New Issue | |
| 2011-02-03 15:26 |
|
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 |
|
Issue Monitored: user12700 | |
| 2011-03-11 14:48 |
|
Issue End Monitor: user12700 | |
| 2011-03-11 16:00 |
|
File Added: vvexport_72555.csv | |
| 2011-03-11 16:01 |
|
File Added: vvexport_72555.tab | |
| 2011-03-11 16:13 |
|
Note Added: 14409 | |
| 2011-03-11 16:17 |
|
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 |