View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
02950Bug reportsOtherpublic2009-03-11 05:422009-10-01 09:13
Reporteruser1286Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.80 
Summary02950: ERROR # 5226 in SPSS
Description

I have a rather large survey that I am exporting to SPSS. When importing to SPSS, I get a LOT of errors, but they begin with #5226. They read:

Error # 5226 in column 48. Text: )

The RENAME old and new variable lists are of different lengths.
This command not executed.

The old list names 1 variables, and the new list names 2.

RENAME VARIABLE ( d20 = Secondary Contact_EMAIL ).

Error # 5226 in column 49. Text: )
The RENAME old and new variable lists are of different lengths.
This command not executed.

The old list names 1 variables, and the new list names 2.

RENAME VARIABLE ( d21 = Secondary Contact_PHONE ).

Error # 5226 in column 49. Text: )
The RENAME old and new variable lists are of different lengths.
This command not executed.

The old list names 1 variables, and the new list names 2.

TRUNCATED>>>>>>>>>>>>

Additional Information

I just upgraded to 1.80

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
BrowserIE, Opera
Database type & versionMySQL 4.1.22-standard
Server OS (if known)Linux
Webserver software & version (if known)RS HOSTING
PHP Version5.2.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2009-03-11 07:56

  ~07313

@ jeygifford: please attach your survey structure as .csv-file and your spss data and spss-syntax file.

@ Menno Dekker: what do you think about this issue?
mdekker

mdekker

2009-03-11 09:37

reporter   ~07314

There is basic variable name validation in the SPSS export. I missed a few invalid characters in the variable name items like a space and a slash that give problems in this export. While there are errors, the data should be right, only with variables names like d123, d124 etc.

I created a patch to fix this, but I noticed in the survey the same question code is used for more than one question. This is an error that should be fixed in the survey design.

I attached a patch and updated export_data_spss.php. Please try this and let me know it it fixes the errors. Only errors that stay are duplicate variable names.

user1286

2009-10-01 06:26

  ~09684

Hi Guys. It has come to my attention that the data submitted is publicly viewable and contains information that should not be in general circulation. Could you please remove the attached files from this submission?

Issue History

Date Modified Username Field Change
2009-03-11 05:42 user1286 New Issue
2009-03-11 05:42 user1286 Status new => assigned
2009-03-11 05:42 user1286 Assigned To => user372
2009-03-11 05:42 user1286 Browser => IE, Opera
2009-03-11 05:42 user1286 Database & DB-Version => MySQL 4.1.22-standard
2009-03-11 05:42 user1286 Operating System (Server) => Linux
2009-03-11 05:42 user1286 Webserver => RS HOSTING
2009-03-11 05:42 user1286 PHP Version => 5.2.6
2009-03-11 07:56 user372 Note Added: 07313
2009-03-11 07:58 user372 Assigned To user372 => mdekker
2009-03-11 08:03 user1286 File Added: limesurvey_survey_14156.csv
2009-03-11 08:03 user1286 File Added: survey_14156_SPSS_data_file.dat
2009-03-11 08:03 user1286 File Added: survey_14156_SPSS_syntax_file.sps
2009-03-11 08:09 user1286 Issue Monitored: user1286
2009-03-11 09:37 mdekker Note Added: 07314
2009-03-11 09:38 mdekker File Added: export_data_spss.php
2009-03-11 09:40 mdekker File Added: fix_02950.patch
2009-03-11 09:50 mdekker Severity partial_block => minor
2009-03-11 09:50 mdekker Status assigned => resolved
2009-03-11 09:50 mdekker Resolution open => fixed
2009-03-23 21:57 lemeur Status resolved => closed
2009-10-01 06:26 user1286 Note Added: 09684
2009-10-01 06:26 user1286 Status closed => feedback
2009-10-01 06:26 user1286 Resolution fixed => reopened
2009-10-01 09:06 user1286 Issue End Monitor: user1286
2009-10-01 09:06 user1286 Issue Monitored: user1286
2009-10-01 09:12 user372 File Deleted: export_data_spss.php
2009-10-01 09:13 user372 File Deleted: survey_14156_SPSS_syntax_file.sps
2009-10-01 09:13 user372 File Deleted: limesurvey_survey_14156.csv
2009-10-01 09:13 user372 File Deleted: fix_02950.patch
2009-10-01 09:13 user372 Status feedback => closed
2009-10-01 09:13 user372 Resolution reopened => fixed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)