Home
LimeSurvey Forums
Welcome, Guest
Please Login or Register.    Lost Password?
LimeSurvey Forums LimeSurvey Support Design Issues
[done] Cannot open SPSS Syntax file as a data file (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: [done] Cannot open SPSS Syntax file as a data file
#14581
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:[done] Cannot run SPSS Syntax file 5 Months, 3 Weeks ago Karma: 28  
Mademoiselle wrote:
Hi,

I use the lastest version of LimeSurvey. Do you know an other solution ?

Thanks.

Which SPSS version are you using? I think there are differences.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#14594
mdekker (User)
Senior Lime
Posts: 40
graphgraph
User Offline Click here to see the profile of this user
Re:[done] Cannot run SPSS Syntax file 5 Months, 3 Weeks ago Karma: 0  
I have the same problem and have upgraded to latest svn a few minutes ago (#5041). I use SPSS 15. This is (part of) my SPSS file:

Code:
NEW FILE.
FILE TYPE NESTED RECORD=1(A).
- RECORD TYPE 'A'.
- DATA LIST LIST / i0(A1) fname(A40) lname(A40) email(A100) attr1(A100) attr2(A100) d6(DATETIME20.0) d7(A19) d8(A2) d9(A15) d10(A19) d11(A19) d12(A4) d13(A2) d14(N1) d15(A27) d16(N1) (44) (38) (1) (27).

- RECORD TYPE 'B'.
- DATA LIST LIST / i1(A1) (1).
END FILE TYPE.


So the last variables get no variable name and data type. When I name them d17, d18 etc and given then A datatype it seems to work so probably somewhere in a loop it stops a little bit too early.... Also noticed something strange near the first date type. I already filed some SPSS bugs but I think they can be closed since a lot has changed since then (01926 and 02028). I am willing to file a new bug report and send in my survey structure, data and spss output but the info is confidential so I think emailing it would be the best option if it is needed??
 
Logged Logged  
 
Last Edit: 2008/06/11 11:09 By mdekker.
 
Menno Dekker
  The administrator has disabled public write access.
#14797
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:[done] Cannot run SPSS Syntax file 5 Months, 2 Weeks ago Karma: 28  
Please fill out another ticket at the bugtrackr and add your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#14897
Gill (User)
Fresh Lemon
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:HowTo open LimeSurvey .sps files in SPSS 5 Months, 2 Weeks ago Karma: 0  
Hi,
I have done as you suggest here with my SPSS export from Limesurvey 1.7 (I have SPSS 16.0 - which does NOT allow the patch for large files to be installed because I have an academic licence - agh!) and I gt this message:
<<Couldn't count fields in tokens<br />SHOW COLUMNS FROM [tokens_49896]<br />[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'FROM'.>>
I'm really not sure what this refers to. I get the same message if I try to open the sps file in WordPad as one of the others in this forum suggested.
 
Logged Logged  
  The administrator has disabled public write access.
#14947
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:HowTo open LimeSurvey .sps files in SPSS 5 Months, 2 Weeks ago Karma: 28  
Hi, please upgrade to the latest release. If the error isn't fixed, please fill out another ticket at the bugtracker and add your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#14948
Gill (User)
Fresh Lemon
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:[done] Cannot open SPSS Syntax file as a data f 5 Months, 2 Weeks ago Karma: 0  
Thanks!
I will upgrade to 1.71 this afternoon and report back as you suggest. G
 
Logged Logged  
  The administrator has disabled public write access.
#15082
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:[done] Cannot open SPSS Syntax file as a data f 5 Months, 1 Week ago Karma: 28  
Any progress?

Have you been able to solve your problem? If so, how did you solve it? Any kind of feedback is always appreciated so we know which solution helps best to solve common problems.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#15092
Gill (User)
Fresh Lemon
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:[done] Cannot open SPSS Syntax file as a data f 5 Months, 1 Week ago Karma: 0  
Hi ,
Sorry - we decided to wait until Tuesday (tomorrow) to install the upgrade as I'd just sent out a reminder to participate and didn't want the site down (the last upgrade took longer than we thought and I got some annoyed responses!). Will definitely report back once we've done it.
 
Logged Logged  
  The administrator has disabled public write access.
#15105
Mazi (Moderator)
Moderator Lime
Posts: 3349
graph
User Offline Click here to see the profile of this user
Re:[done] Cannot open SPSS Syntax file as a data f 5 Months, 1 Week ago Karma: 28  
Thanks for your feedback.
 
Logged Logged  
 
Best regards,
Mazi
______________________
Need help? I can: set up Limesurvey for you / create your survey / implement additional features / design your template / offer premium support -> Contact.
  The administrator has disabled public write access.
#15284
Gill (User)
Fresh Lemon
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Re:[done] Cannot open SPSS Syntax file as a data f 5 Months, 1 Week ago Karma: 0  
OK, so we've installed the upgrades and my large survey file is still NOT exporting SPSS headers. The files are still completely empty. Smaller test files are exporting with content, but not the larger one. We will have another go, but not sure why its a problem.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
Powered by FireBoardget the latest posts directly to your desktop