View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
05857Bug reportsImport/Exportpublic2012-02-27 17:552012-05-17 10:27
Reportergwwri Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.92+ 
Summary05857: response id doesn't get included in SPSS export when there are too many attributes
Description

We have a survey with 16 attribute fields ( they get used for token based conditions). When we export the data to SPSS the response id variable ("id") is not included in either the .dat file or refereed to in any way in the spss syntax file generated either. The variable can be exported as normal to excel or csv via the "export to application" option. Since the id variable is usually placed immediately after the attribute fields in the SPSS export, I suspect that the high number of attributes is some how overwriting the id variable and causing it not to export.

Steps To Reproduce

Make a survey with a bunch of attributes, make a few test tokens, take the survey and then try an export. I don't know at what number of attributes the exporting stops working but I'd guess it's between 10 and 16.

TagsNo tags attached.
Bug heat10
Complete LimeSurvey version number (& build)10951
I will donate to the project if issue is resolvedNo
Browserfirefox
Database type & versionSQL server 2008
Server OS (if known)Linux
Webserver software & version (if known)red hat 5
PHP Version5.3.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-02-27 21:19

administrator   ~17663

Menno, can you please take care of this one?
mdekker

mdekker

2012-02-29 12:45

reporter   ~17688

Can you please attach the syntax file, I don't need the data and the survey so I can have a look.
mdekker

mdekker

2012-02-29 12:56

reporter   ~17689

Not able to reproduce on mysql, maybe it is a sql server related problem? Not sure if someone else can test that?
c_schmitz

c_schmitz

2012-03-21 00:42

administrator   ~18018

Please re-open if this is still an issue with 1.92.
gwwri

gwwri

2012-04-10 18:38

reporter   ~18306

We've upgraded to 1.92 and this still happens.
Mazi

Mazi

2012-04-16 22:39

updater   ~18397

gwwri: Please attach a sample survey for testing!

Thanks.
TMSWhite

TMSWhite

2012-05-16 19:36

reporter   ~18794

This works fine in 1.92+. Tested with 84 attributes.

However, LS should consider using reserved words for question code names. If the survey author creates a question code "id", that will override the internal "id" variable, which might account for the behavior the user saw.
c_schmitz

c_schmitz

2012-05-17 10:27

administrator   ~18809

New 1.92+ version released.

Issue History

Date Modified Username Field Change
2012-02-27 17:55 gwwri New Issue
2012-02-27 21:18 c_schmitz Assigned To => mdekker
2012-02-27 21:18 c_schmitz Status new => assigned
2012-02-27 21:19 c_schmitz Note Added: 17663
2012-02-29 12:45 mdekker Note Added: 17688
2012-02-29 12:56 mdekker Note Added: 17689
2012-03-21 00:42 c_schmitz Note Added: 18018
2012-03-21 00:42 c_schmitz Status assigned => closed
2012-03-21 00:42 c_schmitz Resolution open => unable to reproduce
2012-04-10 18:38 gwwri Note Added: 18306
2012-04-10 18:38 gwwri Status closed => feedback
2012-04-10 18:38 gwwri Resolution unable to reproduce => reopened
2012-04-16 22:39 Mazi Note Added: 18397
2012-04-16 22:39 Mazi Status feedback => assigned
2012-05-16 19:36 TMSWhite Note Added: 18794
2012-05-16 19:36 TMSWhite Status assigned => resolved
2012-05-16 19:36 TMSWhite Fixed in Version => 1.92+
2012-05-16 19:36 TMSWhite Resolution reopened => fixed
2012-05-17 10:27 c_schmitz Note Added: 18809
2012-05-17 10:27 c_schmitz Status resolved => closed