| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 13653 | Bug reports | Import/Export | public | 2018-05-04 20:50 | 2018-05-16 11:24 |
| Reporter | BBCMResearch | Assigned To | |||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.7.x | ||||
| Summary | 13653: LimeSurvey fails to properly export responses in CSV or Excel format | ||||
| Description | Since upgrading, LimeSurvey has not been properly formatting response data for CSVs. It will for participant data, but for responses, all values have been combined into one column, in what appears to be a semicolon delimited format. For example, the first row of my data, rather than containing multiple cells with individual variable labels instead has Response ID;"Date submitted";"Last page";"Start language";"Seed";"Token";"Date started";"Date last action";....etc in column A. When I try to export to a regular excel format, I receive the error message: "Internal Server Error Thank you." As far as we can tell, SPSS is exporting correctly. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | Version 3.7.1+180424 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MySQL: Percona-Server-client-56.x86_64 5.6.39 | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | HTTP: Apache 2.4.33 | ||||
| PHP Version | php70.x86_64 7.0.29-1.28.amzn1 | ||||
 |
Tried this too (with some panic ;) but export - csv, xlsx - working fine for me in 3.7.1. May be an installation problem? => The file containing the class is not installed? |
 |
Our IT guy tinkered with the server and install last week and now .xlsx works for responses. However, when I try to export as a .csv it's still creating a semi-colon delimited format. I can read it if I go into windows control panel and change my number settings so that " ; " is chosen as the system's list separator, but then I can no longer read properly-formatted .csv's. |
|
|
it's a server configuration problem |
