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 | ||||
| Git branch / Pull Request URL | |||||
|
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 |