Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

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

SPPS .dat file: Column Offset

  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 2 months ago #215180 by blocka
SPPS .dat file: Column Offset was created by blocka
I'm running LS 3.25.22+210413
When I export my response data to SPPS (both version options), the columns are mismatched (data gets pushed out in some rows).
From what I can tell, it is occurring where I have Other type questions, and the participant included a comma in their text:



Where Other text has a commas, the SPSS data gets split between two columns:

 

This looks like a bug to me... Has anyone else encountered this?
The topic has been locked.
More
4 years 2 months ago #215183 by jelo
Replied by jelo on topic SPPS .dat file: Column Offset
I recommend to report that as a bug.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 2 months ago #215184 by blocka
Replied by blocka on topic SPPS .dat file: Column Offset
Done:
bugs.limesurvey.org/view.php?id=17265
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 2 months ago #215191 by Joffm
Replied by Joffm on topic SPPS .dat file: Column Offset
Hi, blocka,
Seeing your EXCEL file there are still the single quotes around the text.
Seems to me that the qualifier is wrong.
What is set as DELIMITER and QUALIFIER in the sps-file?

If we compare with the settings in "application/helpers/export_helper.php"
maybe we can see where there is the bug.
 
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • blocka
  • blocka's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
4 years 2 months ago #215204 by blocka
Replied by blocka on topic SPPS .dat file: Column Offset
In my .SPS file, this is what I have for delimiters:
Code:
GET DATA
/TYPE=TXT
/FILE='survey_167811_SPSS_data_file.dat'
/DELCASE=LINE
/DELIMITERS=","
/QUALIFIER="'"
/ARRANGEMENT=DELIMITED
/FIRSTCASE=1
/IMPORTCASE=ALL
/VARIABLES=
 
The topic has been locked.
Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source