Check out the LimeSurvey source code on GitHub!

Exporting Syntax to SPSS 20 - Error 100

More
4 years 2 months ago #89921 by liamh121
Hi there,
We are trying to export our survey syntax into SPSS 20 - followed all the instructions and continuously receiving constant repetitions of the following errors for each variable - alas, no output is achieved. Any ideas



>Error # 100. Command name: RENAME VARIABLE
>This command is not permitted before the beginning of file definition
>commands.
>Execution of this command stops.
RENAME VARIABLE ( V67 = C7_other ).

Please Log in to join the conversation.

More
4 years 2 months ago #89923 by mdekker
Did you modify the line that does the actual import so it can find the file? Line 4 i think it is. There should be a different error before this one as the renames are on the end of the file.

---
Menno Dekker

Please Log in to join the conversation.

More
4 years 2 months ago #89925 by liamh121
Nope! Here's the full text output

pastebin.com/m4jtv446

Please Log in to join the conversation.

More
4 years 2 months ago #89926 by mdekker
The real error: >(2269) Failure opening file: /Users/HackettandTiger/survey_61547_SPSS_data_file.dat

Line 5 should be modified to read the full path to the file. When it can find the file it will run normal.

---
Menno Dekker

Please Log in to join the conversation.

More
1 year 10 months ago #119440 by Anneke
Hi there,

I have the same problem as liamh121. But by ready the reaction, I still don't understand what I can do to export data to spss.

Has somebody any ideas?

Looking forward for a reaction

Please Log in to join the conversation.

More
1 year 10 months ago #119446 by holch
Well, do you actually have problems with exporting or with importing? I assume it is with importing, right?

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
1 year 10 months ago #119449 by Anneke
Yes with importing. To make from the syntax file a sav file, to use the data in SPSS.

Please Log in to join the conversation.

More
1 year 10 months ago #119456 by tpartner
What error(s) do you see? Please provide more information.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
1 year 10 months ago - 1 year 10 months ago #119464 by Anneke
In the attachments I put the output which I get afther changing what is standing behind File to this: /FILE='c:\data\survey_56224_SPSS_data_file.dat' and clicking on Run --> All

I see that the attachment of the output is not working so I made a picture of it.

I als tried File with this name: C:\spss\Data\limesurvey\SPSS\survey_56224_SPSS_data_file.dat

But by both I get the same result. In the picture you see what I see in the syntax file.

Hopefully this give enough information to come to a solution
Attachments:
Last Edit: 1 year 10 months ago by Anneke.

Please Log in to join the conversation.

More
1 year 10 months ago #119466 by tpartner
It looks like you have an incorrect path to the "survey_56224_SPSS_data_file.dat" file.

Open the folder it was downloaded into, right-click in the address bar and copy the address as text. Then paste that address into line 8 of the SPSS syntax file. So that line may look something like:
/FILE='C:\Users\YourUsername\Downloads\survey_56224_SPSS_data_file.dat'

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
1 year 10 months ago #119472 by Anneke
Hi Tony,

I tried it, but it is still not working. The first picture is the address bar which I see when I open it and the second picture is the adress bar when I copy the adress as text. I tried both ways to put in after file. But I am working on the system of the hospital Erasmus MC.

I also tried to download it in document, but also here it was not working.

And to be sure, you mean Line 5 after the word file instead of line 8 or?
Attachments:

Please Log in to join the conversation.

More
1 year 10 months ago #119473 by tpartner
Remove "c:\" from the beginning.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
1 year 10 months ago #119557 by Anneke
Yess, it is working :D

Thanks a lot for your advise!

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form