View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05032 | Bug reports | Import/Export | public | 2011-03-14 19:31 | 2011-04-11 11:34 |
| Reporter | HIV7 | Assigned To | mdekker | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 1.91RC4 | ||||
| Fixed in Version | 1.91RC6 | ||||
| Summary | 05032: Problems with Export to SPSS (Question Code get's lost) | ||||
| Description | Hello Experts, I got a problem with the export from LimeSurvey to SPSS 19, because the Question Code gets lost and is substituted by V01, V02 ,,, by SPSS. That is in the view of my doctoral adviser a scientific gap, because when doing some analysis and getting back from what question is behind V123 is not that easy. The additional Export fields from LimeSurvey like the ID of the participant and the timestamp as well as the language do not make that easier. Anyway, too much information as these three fields can be deleted, but how to get the question Code out of LimeSurvey? In my view that has to be within the exported syntax file, because there SPSS creates the V01-Vxx Variables. In Excel the Export of the Answers and even the Question-Codes works perfect. So can please anybody tell me what I'm doing wrong, or what I have to do to get the question codes out of LimeSurvey and into SPSS? I found out, that the SPSS syntax afforts that the Variables/Question Codes start with a non numeric character like "q" for question. Unfortunately even that change in LimeSurvey did not guide the LS question codes through to SPSS... So there must be another mistake or missing functionality... | ||||
| Steps To Reproduce | Make a New Survey, create a Question Code (like F10000), collect some data and export eo SPSS (2 files), then import into SPSS, | ||||
| Additional Information | I already made a forum post, where I attached some files. Maybe that helps: | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 9797 | ||||
| I will donate to the project if issue is resolved | Yes | ||||
| Browser | firefox 3.6.13/IE 8 | ||||
| Database type & version | My SQL 5.0.91-community | ||||
| Server OS (if known) | CentOS 2.6.18-194.17.1.el5 | ||||
| Webserver software & version (if known) | apache version 2.2.15 | ||||
| PHP Version | 5.2.13 | ||||
| Git branch / Pull Request URL | |||||
|
Rename fixes incorrect variable names for you, and add comment to the script telling you from what to what it was changed. I also replied in the forum. If you keep having problems, please attach your output file so i can see if there are any errors. |
|
|
Solved, THX a Lot! |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-03-14 19:31 | HIV7 | New Issue | |
| 2011-03-15 11:35 | mdekker | Note Added: 14438 | |
| 2011-03-15 11:35 | mdekker | Assigned To | => mdekker |
| 2011-03-15 11:35 | mdekker | Status | new => assigned |
| 2011-03-15 12:24 | HIV7 | Note Added: 14439 | |
| 2011-03-15 12:44 | mdekker | Status | assigned => resolved |
| 2011-03-15 12:44 | mdekker | Resolution | open => no change required |
| 2011-04-11 11:34 | c_schmitz | Fixed in Version | => 1.91RC6 |
| 2011-04-11 11:34 | c_schmitz | Status | resolved => closed |