View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17626Bug reportsImport/Exportpublic2021-11-17 14:14
Reportercandrea Assigned Toadamzammit  
PrioritynoneSeverityblock 
Status closedResolutionunable to reproduce 
Product Version5.x 
Summary17626: Unable to open .sav file exportet in the .sav export format.
Description

I am using the new feature in v5.1 that allows to export data in the .sav format. But after exporting I can not open the .sav file. I get this error message (SPSS version 27):

(See also https://www.ibm.com/support/pages/error-1405-unable-open-sav-file)

GET
FILE='/Users/user/Downloads/survey_377467_spss.sav'.

Fehler. Befehlsname: GET FILE
Ungültige SPSS Statistics-Datendatei: /Users/user/Downloads/survey_377467_spss.sav (DATA1204)
Die Ausführung dieses Befehls wurde unterbrochen.

Fehlernummer 1405 in Spalte 8. Text: /Users/user/Downloads/survey_377467_spss.sav
Fehler bei dem Versuch, eine Datendatei abzurufen.
DATASET NAME DataSet1 WINDOW=FRONT.

Steps To Reproduce

Steps to reproduce

Export data in the *.sav format.

Expected result

*.sav file than can be openend.

Actual result

Can not open *.sav file with SPSS version 27.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)5.1.12
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMariaDB (latest)
Server OS (if known)
Webserver software & version (if known)
PHP Version7.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

adamzammit

adamzammit

2021-09-27 06:23

developer   ~66617

Hi,

It looks like this error doesn't show up when using PSPP (or at least not the same error, and the file still opens).

Can you please test each of the 3 attachments here with SPSS and let me know how you go with opening each of them in SPSS 27 (I do not have access to this).

"orig" is a SAV file with a long string included exported same code that exists in LimeSurvey now
"psppfixed" is a SAV file with a long string included exported same code that exists in LimeSurvey now, but then opened in PSPP and saved again.
"withpatch" is a SAV file with a long string included and outputted after the following patch applied to the LimeSurvey code: https://github.com/tiamo/spss/pull/62/

Adam

candrea

candrea

2021-10-08 10:39

reporter   ~66809

Hi,

Thank you for sending the testfiles.

I can open all of these with SPSS v27.

There seems to be another reason, why some files are corrupt.

Andrea

adamzammit

adamzammit

2021-10-18 06:56

developer   ~66861

Thanks Andrea,

Can you please send one of the files that is causing the problem? Also ideally if you could send the "LSA" file (survey structure and data) then I can debug the issue further.

Adam

c_schmitz

c_schmitz

2021-11-17 14:14

administrator   ~67404

Hello candrea,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exampl data as requested s on how to reproduce it.

Thank you and best regards,

c_schmitz

Issue History

Date Modified Username Field Change
2021-09-26 20:55 candrea New Issue
2021-09-27 05:27 adamzammit Assigned To => adamzammit
2021-09-27 05:27 adamzammit Status new => assigned
2021-09-27 06:23 adamzammit Note Added: 66617
2021-09-27 06:23 adamzammit File Added: survey_243299_spss-withpatch.sav
2021-09-27 06:23 adamzammit File Added: survey_243299_spss-psppfixed.sav
2021-09-27 06:23 adamzammit File Added: survey_243299_spss-orig.sav
2021-09-27 06:23 adamzammit Bug heat 0 => 2
2021-09-27 11:20 ollehar Status assigned => feedback
2021-10-08 10:39 candrea Note Added: 66809
2021-10-08 10:39 candrea Bug heat 2 => 4
2021-10-08 10:39 candrea Status feedback => assigned
2021-10-18 06:56 adamzammit Note Added: 66861
2021-11-17 13:00 ollehar Status assigned => feedback
2021-11-17 14:14 c_schmitz Status feedback => closed
2021-11-17 14:14 c_schmitz Resolution open => unable to reproduce
2021-11-17 14:14 c_schmitz Note Added: 67404
2021-11-17 14:14 c_schmitz Bug heat 4 => 6