View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04705Bug reportsImport/Exportpublic2010-10-28 17:442010-11-03 20:41
Reporterelisa Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.90+ 
Summary04705: Export to excel fails when exporting token fields with data
Description

When I export data to excel and mark all token fields to be exported, the file is created but has strange format and error messages inside (see the attached file). I cannot read the data from the file. There is no problem when I export only the single "Token" field and no other token control fileds together with the data. The excel export file with only the token field added to data is OK. If I try any other fields except "Token" the export fails.

TagsNo tags attached.
Attached Files
results-survey77357.xls (13,180 bytes)
limesurvey_survey_77357.lss (205,314 bytes)
exportresults.php (55,051 bytes)
Bug heat4
Complete LimeSurvey version number (& build)9321
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMySQL: 5.0.45
Server OS (if known)Apache/2.2.4
Webserver software & version (if known)ankieta.cem.pl
PHP Version5.2.14

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-10-28 21:49

administrator   ~13370

Last edited: 2010-10-28 22:08

I cannot reproduce the issue here. Can you attach your survey please?
Another question: If you go to your token table, can you see all the tokens?
elisa

elisa

2010-10-28 22:35

developer   ~13371

Yes, I can see the tokens. In fact I have two similar surveys, the second one is a slightly changed copy of the first one and in both cases I have the same issue with Excel export.
c_schmitz

c_schmitz

2010-10-28 22:55

administrator   ~13372

Please use attached file and tell me if it fixes your problem.
Thank you!
elisa

elisa

2010-10-28 23:14

developer   ~13373

Yes, this fixes it. The exported excel files look perfect. Thanks a lot.
c_schmitz

c_schmitz

2010-11-03 20:41

administrator   ~13407

Fix was released in latest 1.90+ version.

Issue History

Date Modified Username Field Change
2010-10-28 17:44 elisa New Issue
2010-10-28 17:44 elisa File Added: results-survey77357.xls
2010-10-28 21:49 c_schmitz Assigned To => c_schmitz
2010-10-28 21:49 c_schmitz Status new => assigned
2010-10-28 21:49 c_schmitz Note Added: 13370
2010-10-28 21:49 c_schmitz Status assigned => feedback
2010-10-28 22:03 c_schmitz Note Edited: 13370
2010-10-28 22:08 c_schmitz Note Edited: 13370
2010-10-28 22:32 elisa File Added: limesurvey_survey_77357.lss
2010-10-28 22:35 elisa Note Added: 13371
2010-10-28 22:35 elisa Status feedback => assigned
2010-10-28 22:55 c_schmitz Status assigned => feedback
2010-10-28 22:55 c_schmitz File Added: exportresults.php
2010-10-28 22:55 c_schmitz Note Added: 13372
2010-10-28 23:14 elisa Note Added: 13373
2010-10-28 23:14 elisa Status feedback => assigned
2010-10-28 23:39 c_schmitz Status assigned => resolved
2010-10-28 23:39 c_schmitz Fixed in Version => 1.90+
2010-10-28 23:39 c_schmitz Resolution open => fixed
2010-11-03 20:41 c_schmitz Note Added: 13407
2010-11-03 20:41 c_schmitz Status resolved => closed