View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04622Bug reportsOtherpublic2010-10-13 16:22
Reporterdavet902 Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.90+ 
Fixed in Version1.90+ 
Summary04622: Data browsing and export show different column headings and data
Description

I'm on the most recent version: Version 1.90+ Build 9118

Looking at the responses shows (slightly) different info when you're browsing it in Limesurvey versus exporting the data (to excel, for example).

I've got some multiple choice and multiple with options questions. When browsing, multiple choice with options lists the question text and then the text for the individual choice < What degrees completed (High School) >. The export only gives the question text (the same every time - no choice text at all). The export should include the option text when you ask for full headings (not abbreviated or question codes).

The other way around, for straight multiple-choice questions, browse shows the answer number (A4) while export gives you the text of the answer. In this case, I'd rather see the actual answer in the browse view as well.

Steps To Reproduce

Browse and export data with multiple choice and multiple choice with option responses.

Additional Information

Attachment includes the excel dump and the browse screen capture, with differences circled and hilighted.

TagsNo tags attached.
Attached Files
exportResponses.xls (173,056 bytes)
Bug heat6
Complete LimeSurvey version number (& build)9118
I will donate to the project if issue is resolved
BrowserFirefox 3.6, explorer 8, chrome, safari ...
Database type & versionMySQL 5.0.32
Server OS (if known)Debian
Webserver software & version (if known)Apache 2.2.3
PHP Version5.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2010-09-28 13:52

administrator   ~12914

I cannot reproduce the issue with the missing subquestion text in the export header. Can you attach a small sample survey please and explain in detail how to reproduce it with that sample survey?

davet902

davet902

2010-09-28 17:24

reporter   ~12921

OK, so here's a survey with one "multiple options with comments" question. Do the survey once, and fill in something for high school and undergrad (for instance). Browse the responses to see a similar display to the one I attached above. Export to excel with full headers to see the excel column headings - they list the question text ( Which degrees/ certifications have you completed (please specify a discipline where appropriate) ) but not which option the column refers to (high school). I've attached the screenshot and the excel output again, for this particular survey.

DenisChenu

DenisChenu

2010-09-28 17:33

developer   ~12922

Carlsten : it work for multi option, list etc ... but not for multi with comments.

:)

c_schmitz

c_schmitz

2010-10-07 20:26

administrator   ~13030

Thank you. Fixed in rev. 9181

c_schmitz

c_schmitz

2010-10-13 16:22

administrator   ~13134

Released in latest Plus version

Issue History

Date Modified Username Field Change
2010-09-24 13:46 davet902 New Issue
2010-09-24 13:46 davet902 File Added: exportResponses.xls
2010-09-26 17:58 c_schmitz Assigned To => c_schmitz
2010-09-26 17:58 c_schmitz Status new => assigned
2010-09-28 13:52 c_schmitz Note Added: 12914
2010-09-28 13:52 c_schmitz Status assigned => feedback
2010-09-28 17:21 davet902 File Added: limesurvey_survey_25972.lss
2010-09-28 17:24 davet902 Note Added: 12921
2010-09-28 17:24 davet902 Status feedback => assigned
2010-09-28 17:24 davet902 File Added: results-survey25972.xls
2010-09-28 17:25 davet902 File Added: ilab.management.dal.ca - 2010-09-28 - 12-24-38.png
2010-09-28 17:33 DenisChenu Note Added: 12922
2010-10-07 20:26 c_schmitz Note Added: 13030
2010-10-07 20:26 c_schmitz Status assigned => resolved
2010-10-07 20:26 c_schmitz Fixed in Version => 1.90+
2010-10-07 20:26 c_schmitz Resolution open => fixed
2010-10-13 16:22 c_schmitz Note Added: 13134
2010-10-13 16:22 c_schmitz Status resolved => closed
2010-10-25 00:21 c_schmitz Category Data Access => (No Category)