View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
06141Bug reportsImport/Exportpublic2012-10-01 12:26
Reporteruser9189Assigned ToTMSWhite  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00RC1 
Fixed in Version2.00+ 
Summary06141: Import Excel survey structure reads relevance incorrectly
Description

In some cases (reason unknown) the relevance equation imports as "GENERAL" instead of 1. In other words, the Excel structure file contains 1 for relevance, but this gets imported incorrectly.

This shows up as errors in the survey logic file.

The practical implication is that the questions are not shown when executing the survey.

Steps To Reproduce

Import attached file.

TagsNo tags attached.
Attached Files
Bug heat8
Complete LimeSurvey version number (& build)9999
I will donate to the project if issue is resolvedNo
BrowserChromium
Database type & versionmysql 5.5.22
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.0
PHP VersionVersion 5.3.10-1ubuntu3.1

Users monitoring this issue

abita1

Activities

TMSWhite

TMSWhite

2012-05-27 20:39

reporter   ~18927

Andrie - since you're starting to work on this, I'll assign this task to you. Thanks!

c_schmitz

c_schmitz

2012-07-27 11:32

administrator   ~20021

Andrie, any progress on this?

abita1

abita1

2012-08-06 06:05

reporter   ~20212

Last edited: 2012-08-06 15:04

Using the reporter's excel file supporting the original bug, for me on 2RC7 generates the error stack uploaded. The error on RC7 is in the cell formatting code of excel-reader2, which makes no sense to me. I striped formatting, just in case, and there is no change.

There is nothing that I notice in the xls file that comes to mind to generate the specific error. The only anomaly in the file, as I can see, is that the SQ relevance cells have values duplicating the name cells; in theory, this shouldn't matter.


Ran also on Tom W's 192+ , locally, with Tom's excel import/export code included. Essentially the same thing happens...except

On that 192+, it successfully imports the file, and shows off a 1 for relevance for the questions [not the string "GENERAL"]. The survey executes both questions without problems. The 4 errors that hit on import [I force echo them from the exception...at the end of the import_function:excelImportSurvey] :

Notice: Undefined offset: 14 in C:\xampp\htdocs\limesurvey\admin\classes\excel\excel_reader2.php on line 1247

Notice: Undefined offset: 15 in C:\xampp\htdocs\limesurvey\admin\classes\excel\excel_reader2.php on line 1247

Notice: Undefined offset: 14 in C:\xampp\htdocs\limesurvey\admin\classes\excel\excel_reader2.php on line 1247

Notice: Undefined offset: 14 in C:\xampp\htdocs\limesurvey\admin\classes\excel\excel_reader2.php on line 1247

I have no idea why sheet formatting should pop as a source for an error...

c_schmitz

c_schmitz

2012-10-01 12:26

administrator   ~20950

This was resolved when we switched to the tab format

Issue History

Date Modified Username Field Change
2012-05-27 19:21 user9189 New Issue
2012-05-27 19:21 user9189 Status new => assigned
2012-05-27 19:21 user9189 Assigned To => TMSWhite
2012-05-27 19:21 user9189 File Added: limesurvey_survey_197878_extract.xls
2012-05-27 19:23 user9189 Description Updated
2012-05-27 20:38 TMSWhite Assigned To TMSWhite => user9189
2012-05-27 20:39 TMSWhite Note Added: 18927
2012-07-27 11:32 c_schmitz Note Added: 20021
2012-07-27 11:32 c_schmitz Status assigned => feedback
2012-08-06 06:05 abita1 Note Added: 20212
2012-08-06 15:04 abita1 Note Edited: 20212
2012-08-07 15:40 abita1 Issue Monitored: abita1
2012-10-01 12:26 c_schmitz Note Added: 20950
2012-10-01 12:26 c_schmitz Status feedback => closed
2012-10-01 12:26 c_schmitz Assigned To user9189 => TMSWhite
2012-10-01 12:26 c_schmitz Resolution open => fixed
2012-10-01 12:26 c_schmitz Fixed in Version => 2.00+
2021-08-18 06:22 guest Bug heat 6 => 8