pspp-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problems with data import from LimeSurvey


From: Robert Prout
Subject: Re: Problems with data import from LimeSurvey
Date: Thu, 25 Apr 2013 16:31:31 +1000

Hi,

I use LimeSurvey and SPSS everyday at work, and I use PSPP at home. 

I have managed to create a SPSS .sav file from the LimeSurvey syntax and .dat file using PSPP. I am using Win7 64 bit, and PSPP (64bit) 0.7.10-g29c145


Here is what I did:

First delete the first two lines on the SPSS syntax file that was generated by LimeSurvey. The lines of code should look something like this:

*$Rev: 10925 $ 2.
SET UNICODE=ON.



The syntax file should now start with the GET DATA command. The FILE subcommand (under GET DATA) needs to have the directory added to the .dat file name. For example:

/FILE='C:\current\survey_49991_SPSS_data_file.dat'



The other thing that needs updating are the VARIABLE LABELS commands in the syntax file. The syntax file that is generated by LimeSurvey tends to break the VARIABLE LABELS commands over a number of lines. PSPP will not run the command in this format. PSPP will only run the command if the VARIABLE LABEL commands are each on one line. For example:

VARIABLE LABELS Var1 "My first variable".
VARIABLE LABELS Var2 "My second variable". 
VARIABLE LABELS Var3 "My third variable".  
etc...


There will be a VARIABLE LABEL command for each of the items in your survey, so there may be a number to correct. The label in the quotation marks appears pink in colour in the PSPP syntax editor when the command is well formed, and each command is on one line.

Hope that helps,

Cheers,

RP


On 25 April 2013 15:33, Ben Pfaff <address@hidden> wrote:
On Tue, Apr 23, 2013 at 08:36:13PM +0200, Dr. Holger Handstein wrote:
> Also, I've attached the syntax file. Maybe this helps?

The syntax file begins with a UTF-8 "byte order mark".  PSPP didn't
handle that correctly, but I've now pushed a fix to the repository.

_______________________________________________
Pspp-users mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/pspp-users


reply via email to

[Prev in Thread] Current Thread [Next in Thread]