Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Export Syntax

  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago #147341 by etutora
Export Syntax was created by etutora
Dear Community,

For the first time, I'm trying to export the results of my questionnaire to SPSS.

I'm able to Export Data. Trying to Export Syntax I get a message that it is not possible to access the site: ...lime/index.php/admin/export/sa/exportspss/sid/XXXXXX

I checked and I do not have a SPSS plugin.

I'm working with the last stable version of Lime Survey.

I would be thankful for help.

Greetings,
Maria
The topic has been locked.
  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago #147362 by etutora
Replied by etutora on topic SPSS Export Syntax
Hi,
I updated to LimeSurvey to the last version. I'm able to Export Data. I only get the message for the Export Syntax. It happens to the pilot survey also.

I still get the message:
"File not found

Firefox can’t find the file at ......

Check the file name for capitalization or other typing errors.
Check to see if the file was moved, renamed or deleted."

How can I solve the problem? Thanks so much.
Maria
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 2 months ago #147379 by DenisChenu
Replied by DenisChenu on topic SPSS Export Syntax
Set debug to 1 and try again manual.limesurvey.org/Debug_mode

But this is surely a memory issue

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago #147391 by etutora
Replied by etutora on topic SPSS Export Syntax
Thanks for your reply, Denis.

I checked and the memory limite is set to 128M. I changed it to 256M, and the problem remains.

I've a test implementation of LimeSurvey, and when I import the survey to it, I'm able to Export both, Data and Syntax. Is there something went wrong by one of the updates? I don't know. It is strange, as I update both implementations in equal form.
Please, where am I supposed to change the debug (i'm not very techny save, as you already got it.).

Thanks so much for your help.
Maria
The topic has been locked.
More
7 years 2 months ago #147396 by Ben_V
Replied by Ben_V on topic Export Syntax
Hi,

don't forget that it's also very easy to import excel files into SPSS ;)

help.fresnostate.edu/facstaff/software/spss/importdatabase.php

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 2 months ago #147401 by DenisChenu
Replied by DenisChenu on topic Export Syntax
@Ben_V : Or PSPP : www.gnu.org/software/pspp/manual/html_node/IMPORT.html ;)
@etutora : you need access to FTP/SSH/SFTP on your installation : look at the link manual.limesurvey.org/Debug_mode

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago #147402 by etutora
Replied by etutora on topic Export Syntax
Benoît,
Thanks. Yes, the problem is that my phd advisor is a "purist". ;-)
I've to solve the issue as soon I'll have to make the next study and everything should be working.
Greetings,
Maria
The topic has been locked.
  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago #147406 by etutora
Replied by etutora on topic Export Syntax
Denis,
It is not easy: I saw the forest (limesurvey) but not the tree (config.php). But I found it. ;-)
Changed debug to 1 (it was set to 2) and I was able to Explort Syntax.
Thanks so much.
Greetings,
Maria
The topic has been locked.
More
7 years 2 months ago - 7 years 2 months ago #147408 by Ben_V
Replied by Ben_V on topic Export Syntax
Except if your thesis is related with the art of importing data into SPSS or if you have to edit for special needs the syntax file, there are no good reasons to waste too much time with the import process because the result after importation is pretty the same. NO pure or not ways... just working or not process. There are plenty of posts in this forum about SPSS export files related issues.... some past or recent LS versions have issues with SPSS file some other versions no.

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 7 years 2 months ago by Ben_V.
The following user(s) said Thank You: holch, etutora
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 2 months ago #147418 by DenisChenu
Replied by DenisChenu on topic Export Syntax
Just set debug=1 and you are able to export syntax ????

Arg ... didn't understand here .....

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • etutora
  • etutora's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 2 months ago - 7 years 2 months ago #147421 by etutora
Replied by etutora on topic Export Syntax
Denis,
I'm going to try to explain. I was able to Export Data to SPSS. I only got the error message about the site not found when I tried the button "Export Syntax".
Checked the Memory Limit: 128M; Changed it to 256M, but problem was still there.
The next step was to change in Config.php debug=1 (it was set to 2). After that, I was able to make the Export Data, no error message anymore and the file was downloaded.

Why? That I don't know why. I don't understand what I did, only know that it solved the problem.
Up to the experts. ;-)
Last edit: 7 years 2 months ago by etutora.
The following user(s) said Thank You: DenisChenu
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose