View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06141 | Bug reports | Import/Export | public | 2012-05-27 19:21 | 2012-10-01 12:26 |
Reporter | Assigned To | TMSWhite | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00RC1 | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06141: 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. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 9999 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chromium | ||||
Database type & version | mysql 5.5.22 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache 2.0 | ||||
PHP Version | Version 5.3.10-1ubuntu3.1 | ||||
Andrie - since you're starting to work on this, I'll assign this task to you. Thanks! |
|
Andrie, any progress on this? |
|
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... |
|
This was resolved when we switched to the tab format |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-05-27 19:21 |
|
New Issue | |
2012-05-27 19:21 |
|
Status | new => assigned |
2012-05-27 19:21 |
|
Assigned To | => TMSWhite |
2012-05-27 19:21 |
|
File Added: limesurvey_survey_197878_extract.xls | |
2012-05-27 19:23 |
|
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 |