View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
07998 | Bug reports | Import/Export | public | 2013-07-12 12:01 | 2013-10-09 18:05 |
Reporter | lucass | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 07998: Problem with exporting "Array (numbers)" subqestions to .xls | ||||
Description | When there is underscore "_" character in subqestion code of "Array (numerical)" question, the subquestion string is not exported to .xls file. Instead of string value of this subqestion, there are these signs in spreadsheet: [] Probably the issue is the same with other special characters. | ||||
Steps To Reproduce | Use attached survey. Enter response, and try to export results to .xls file with default settings. Check that in column E and G there are strings: "Question 1 [Some example subquestion][]", with "[]" at the end, instead of string. | ||||
Tags | No tags attached. | ||||
Attached Files | lime.patch (408 bytes)
--- exportresults_helper.php.old 2013-08-08 09:52:20.010015017 +0200 +++ exportresults_helper.php 2013-08-07 14:47:16.196474343 +0200 @@ -1099,6 +1099,8 @@ break; case ':': + $subHeading .= ' ['.$this->stripTagsFull($field['subquestion1']).']['.$this->stripTagsFull($field['subquestion2']).']'; + break; case ';': //print_r($field); echo "\n"; | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 130708 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 22, Opera 12 | ||||
Database type & version | Mysql 5.5.31.0.1 | ||||
Server OS (if known) | Debian 7.0 | ||||
Webserver software & version (if known) | Apache/2.2.22 | ||||
PHP Version | 5.4.4.14.7.2 | ||||
In file 'lime.patch' there is a patch which resolves this issue. Please check it and include in regular LS distribution. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13096 |
|
Thank you! |
|
Version 2.00+ Build 130929 released |
|
Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13209 |
|
LimeSurvey: master afa7e188 2013-09-27 18:10 Details Diff |
Fixed issue 07998: Underscore character in subqestion code breaks export of Array (numerical) questions - patch by lucass |
Affected Issues 07998 |
|
mod - application/helpers/admin/exportresults_helper.php | Diff File | ||
LimeSurvey: 2.05 af33002c 2013-10-09 17:40 Details Diff |
Fixed issue 07998: Underscore character in subqestion code breaks export of Array (numerical) questions |
Affected Issues 07998 |
|
mod - application/helpers/admin/export/Writer.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2013-07-12 12:01 | lucass | New Issue | |
2013-07-12 12:01 | lucass | File Added: export problem.lsa | |
2013-07-12 12:01 | lucass | Issue Monitored: lucass | |
2013-09-03 15:05 | lucass | File Added: lime.patch | |
2013-09-03 15:06 | lucass | Note Added: 26144 | |
2013-09-27 18:08 | c_schmitz | Assigned To | => c_schmitz |
2013-09-27 18:08 | c_schmitz | Status | new => assigned |
2013-09-27 18:11 | c_schmitz | Changeset attached | => LimeSurvey master afa7e188 |
2013-09-27 18:11 | c_schmitz | Note Added: 26405 | |
2013-09-27 18:11 | c_schmitz | Resolution | open => fixed |
2013-09-27 18:11 | c_schmitz | Note Added: 26406 | |
2013-09-27 18:11 | c_schmitz | Status | assigned => resolved |
2013-09-27 18:11 | c_schmitz | Fixed in Version | => 2.00+ |
2013-09-28 22:54 | mfaber | Issue Monitored: mfaber | |
2013-09-29 15:27 | c_schmitz | Note Added: 26423 | |
2013-09-29 15:27 | c_schmitz | Status | resolved => closed |
2013-10-09 18:05 | c_schmitz | Changeset attached | => LimeSurvey 2.05 af33002c |
2013-10-09 18:05 | c_schmitz | Note Added: 26677 | |
2021-08-02 16:09 | guest | Bug heat | 4 => 8 |