View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|17907||Bug reports||Import/Export||public||2022-02-23 23:47||2023-10-09 23:54|
|Status||resolved||Resolution||no change required|
|Summary||17907: SPSS export participant data variables blank|
When I am running a survey with a participant database with additional attributes, when I do an SPSS export the SPSS data file has variables for the participant data, but it doesn't draw through the data from the participant database (variable data is blank).
This is only an issue since the upgrade to 5.x (previous versions pulled through the participant data into SPSS).
|Steps To Reproduce|
Steps to reproduce
Create a survey with participants database activated
SPSS file has data from participant database in it
Participant database variables are in the SPSS file, but the data hasn't been pulled through (SPSS data file is blank for those variables)
|Tags||No tags attached.|
|Complete LimeSurvey version number (& build)||5.2.13|
|I will donate to the project if issue is resolved||Yes|
|Browser||Firefox and Chrome|
|Database type & version||SPSS|
|Server OS (if known)||Linux Mint and windows 10 (tried on both)|
|Webserver software & version (if known)|
|PHP Version||whatever is used for the Australian hosted server|
survey_archive_425756.lsa (6,208 bytes)
Test SPSS data.sav (9,315 bytes)
What export to SPSS method are you using? Is it Export Responses - > Export to SPSS (.sav) or Export to SPSS then exporting the .sps file and running the syntax in SPSS?
I tested using 5.2.14, the "Export responses" then exported to CSV and Export to SPSS (.sav) and got the same correct output as attached.
survey_425756_spss.sav (3,947 bytes)
Hi, I used the Export Responses > Export to SPSS which exports a syntax and data file, then you run the syntax to generate the .sav. This is the way I have been doing it for years.
Exporting to CSV works fine (the data comes through), but that isn't any good when working in SPSS as you have to set up all of the SPSS variable information manually.
Can you please try visiting the page where you export to CSV
Then instead of choosing CSV as the type, please choose "Export to SPSS (.sav)"
You should get a .sav file that you can open directly in SPSS (no syntax required) and hopefully will have your participant data too.
Oh, OK, sorry, I didn't know there was an SPSS .sav option in the 'export responses' area. This works perfectly. I won't bother using the 'export responses to SPSS' functionality any more. Thank you!
|2022-02-23 23:47||tixeon||New Issue|
|2022-02-23 23:47||tixeon||File Added: survey_archive_425756.lsa|
|2022-02-23 23:47||tixeon||File Added: Test SPSS data.sav|
|2022-02-25 00:05||adamzammit||Assigned To||=> adamzammit|
|2022-02-25 00:05||adamzammit||Status||new => assigned|
|2022-02-25 00:07||adamzammit||Note Added: 68405|
|2022-02-25 00:07||adamzammit||File Added: survey_425756_spss.sav|
|2022-02-25 00:07||adamzammit||Bug heat||0 => 2|
|2022-03-02 23:59||tixeon||Note Added: 68529|
|2022-03-02 23:59||tixeon||Bug heat||2 => 4|
|2022-03-03 14:40||galads||Issue Monitored: galads|
|2022-03-03 14:40||galads||Bug heat||4 => 6|
|2022-03-07 06:11||adamzammit||Note Added: 68544|
|2022-03-09 05:07||tixeon||Note Added: 68605|
|2023-10-09 23:54||adamzammit||Status||assigned => resolved|
|2023-10-09 23:54||adamzammit||Resolution||open => no change required|