Hello,

I want to export my result data to SPSS, but it doesn't work. I'm following the instructions on the website, but I'm constantly getting an 'error'. I'm using SPSS 16.0 en Limesurvey 1.71+.
When I open the syntax, edit the 4th line and complete the filename with a full path to the downloaded data file this is what I get:

>Error. Command name: GET DATA
>(2265) Unrecognized or invalid variable definition.
>This command not executed.
CACHE.
EXECUTE.

>Error # 105. Command name: EXECUTE
>This command is not valid before a working file has been defined.
>This command not executed.
*Define Variable Properties.
VARIABLE LABELS d1 'Record ID'.

>Error # 100. Command name: VARIABLE LABELS
>This command is not permitted before the beginning of file definition
>commands.
>This command not executed.
VARIABLE LABELS d2 'Datum van voltooiing'.

Does anyone know what I'm doing wrong? When I export the data to xls and open it in SPSS then it does work well.

Thanx!

Jantien

Which build of LimeSurvey do you use?

If not the latest one (>5500) please update. A lot of SPSS bugs have been fixed recently.

Hi Mazi,

Thanks for your quick reply.

We use build 5535, so bugs should be fixed, right? Do you have any other ideas why we have these errors?

Thanks!
Jantien

According to the error messages I would think that there is an error within the operations to get the data into SPSS. Doesn't really seem to be a limesurvey error (but I might be wrong). I'm no SPSS expert.
Please check the error messages and try SPSS forums/google.

@ Jantien: plz open a ticket in the bugtracker and attach your data:
# database dump done with phpMyAdmin
# survey structure
# SPSS Syntax and Data-File

I receive these error messages too, but not always.

If I remove the decimals from the variable type in the syntax-file
the error messages are gone and everything works fine.

So

d4 F4.2
d5 F1.2
d6 F1.2
d7 F1.2
....

has to become

d4 F4
d5 F1
d6 F1
d7 F1
....

Dirk

Plz attach your information to this bugreport:
http://bugs.limesurvey.org/view.php?id=2472

I have just updated my limesurvey 1.7 to 1.72 and I had the same problem in exporting my data, described in this topic. I have seen that here is proposed to remove points after variables. Actually in this way I did not resolved my problem. I have also seen that you have open a ticket to the bugtracker, but I did not understand how it has been resolved. Can you help me in fixing my problem?
My version of lime survey is :1.72 (5737)

Many thanks in advance

If the problem still exists and you can easily reproduce it please open a ticket at the bugtracker and give as much information as possible and also attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.

Afterwards please post the link to the bugtracker so we can follow the progress.

Attach the journal part from your last failed import (see your other thread re the journal file), a copy of your SPSS export from LimeSurvey, and give SPSS version details. If I find time, I'll see if I can figure out the problem.

Regards.