View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05032Bug reportsImport/Exportpublic2011-04-11 11:34
ReporterHIV7 Assigned Tomdekker  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version1.91RC4 
Fixed in Version1.91RC6 
Summary05032: 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:

http://www.limesurvey.org/de/forum/design-issues/58163-problem-export-to-spss-question-code-gets-lost

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)9797
I will donate to the project if issue is resolvedYes
Browserfirefox 3.6.13/IE 8
Database type & versionMy 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 Version5.2.13
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2011-03-15 11:35

reporter   ~14438

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.

HIV7

HIV7

2011-03-15 12:24

reporter   ~14439

Solved, THX a Lot!

Issue History

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