View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17265 | Bug reports | Statistics | public | 2021-04-20 23:09 | 2021-10-15 11:42 |
Reporter | blocka | Assigned To | gabrieljenik | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.25.20 | ||||
Summary | 17265: Error in SPSS Export | ||||
Description | When I export my response data to SPPS (both version options), the columns are mismatched (data gets pushed out in some rows). Where Other text has a commas, the SPSS data gets split between two columns. See InResponseTable.png and SplitColumn.png attached. | ||||
Steps To Reproduce | Just export data for a survey that has Other answers for a question. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | 3.25.22+210413 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MariaDB 10.3 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | PHP 7.4 | ||||
Is this a regression? Do you know if it worked earlier? |
|
I don't know if it occurred in earlier versions, but this is the first time that I've experienced this issue. |
|
To have the issue before , need
=> This surely not happen a lot. |
|
In case it helps, I've attached two sets of dat and sps files from the survey. "The Bad (as exported from LS)" contains the dat and sps file directly as they exported from LS. Columns are delimited with single quotes and commas. And the data does not import correctly in SPSS and PSPP. "The Successful Import" is the only one I've been able to import into PSPP successfully. To do this, I removed the single quotes around text values in the data file, and removed commas for Other and open-ended questions, and I updated the sps file to indicate there was no QUALIFIER. DELIMITER remained as ",". However, while "Successful Import works" okay in PSPP, when we import into SPSS Version 27 (the Grad Pack), the data columns are offset just like when we use the file "The Bad (as exported from LS) ". |
|
The dat file (CSV) seems to be fine. Can I ask you to provide a dat file that works and has text delimiter and commas? |
|
I've attached the "bad" .dat file. Also I have prepared this short video overview: https://www.dropbox.com/s/v3aqw950jo5ln8g/LS%203%20SPPS%202021-04-23_10-20-10.MP4?dl=0 |
|
The app that you are using for viewing the CSV is not SPSS. I believe that viewer is not considering the apotrophe as text qualifier. Same happens in excel when you open the CSV with default settings. Thanks! |
|
I don't find a lot of documentation about SPSS format : https://www.ibm.com/docs/en/spss-statistics/23.0.0?topic=formats-comma-dot-dollar-pct Fort PSPP : https://www.gnu.org/software/pspp/manual/pspp.pdf#GET%20DATA%20/TYPE%3DTXT%20/ARRANGEMENT%3DDELIMITED Maybe QUALIFIER is not set in the definition file ? |
|
Since this is not an issue, I am closing the ticket. Feel free to re-open if you think otherwise. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-04-20 23:09 | blocka | New Issue | |
2021-04-20 23:09 | blocka | File Added: InResponseTable.png | |
2021-04-20 23:09 | blocka | File Added: SplitColumn.png | |
2021-04-21 13:43 | ollehar | Note Added: 64079 | |
2021-04-21 13:43 | ollehar | Assigned To | => gabrieljenik |
2021-04-21 13:43 | ollehar | Status | new => assigned |
2021-04-21 15:49 | blocka | Note Added: 64089 | |
2021-04-22 17:08 | DenisChenu | Note Added: 64117 | |
2021-04-22 18:49 | blocka | Note Added: 64124 | |
2021-04-22 18:49 | blocka | File Added: Bad (as exported from LS).zip | |
2021-04-22 18:49 | blocka | File Added: Successful Import.zip | |
2021-04-23 14:55 | gabrieljenik | Note Added: 64127 | |
2021-04-23 14:55 | gabrieljenik | Description Updated | |
2021-04-23 14:55 | gabrieljenik | Sync to Zoho Project | => |Yes| |
2021-04-23 14:55 | gabrieljenik | Status | assigned => feedback |
2021-04-23 16:22 | blocka | Note Added: 64135 | |
2021-04-23 16:22 | blocka | File Added: survey_167811_SPSS_data_file.dat | |
2021-04-23 16:22 | blocka | Status | feedback => assigned |
2021-04-24 02:21 | gabrieljenik | Note Added: 64144 | |
2021-04-24 02:21 | gabrieljenik | File Added: image.png | |
2021-04-24 02:21 | gabrieljenik | File Added: image-2.png | |
2021-04-24 02:22 | gabrieljenik | Status | assigned => feedback |
2021-04-24 10:27 | DenisChenu | Note Added: 64145 | |
2021-10-15 11:42 | galads | Note Added: 66854 | |
2021-10-15 11:42 | galads | Bug heat | 8 => 10 |
2021-10-15 11:42 | galads | Status | feedback => closed |
2021-10-15 11:42 | galads | Resolution | open => fixed |