| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 09909 | Bug reports | Import/Export | public | 2015-09-23 01:08 | 2016-08-29 12:38 |
| Reporter | hvgard | Assigned To | DenisChenu | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.05+ | ||||
| Target Version | 2.50.x | Fixed in Version | 2.50.x | ||
| Summary | 09909: Empty colums in export file while data visible in GUI | ||||
| Description | When we view responses there is data in the [MWhyStop_time] column (answer = Y) but on export (to CSV, XLS, PDF) that column is empty in the output. | ||||
| Steps To Reproduce | View responses | ||||
| Additional Information | I'm a chemist not a programmer. Hesitant to use things like comfort-upgrade while running surveys for customers :-) | ||||
| Tags | No tags attached. | ||||
| Bug heat | 8 | ||||
| Complete LimeSurvey version number (& build) | Version 2.05+ Build 141229 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Several, mainly Firefox | ||||
| Database type & version | mySQL | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | I guess apache | ||||
| PHP Version | PHP Version 5.3.10-1ubuntu3.11 | ||||
 |
Someone I work with (a looonnnngggg-time programmer said): The only unique thing I can come up with that might explain why it happened is: it's the first answer after another multiple-choice question with an "other" choice. Maybe the "other" choice messed up something in the export. If I was the programmer I'd look there. |
 |
Same issue with your survey and master GIT version PS: vv export seems fine |
|
|
It's due to time : you have 2 times the same column .... |
|
|
Will admit right away that I don't know / never used the VV export. Will try later today. Which 2 columns are the same? I don't see it. They all some unique. |
|
|
No : the "time" column used by Survey timing have same name than the coluln used for the sub question time. |
|
|
OK, so to AVOID that issue we could (for the time being, next survey) not use [time] as a sub-question name. Good to know and happy fixing :-) |
|
|
Hard to fix this one ..... |
|
|
For this one we only had 200 responses and typed in the 28 "Y" answers in the XLS. So we are fine. But suppose one has 10.000 responses ..... thanks. |
 |
Prohibit usage of keywords 'time' and 'other' as subquestion codes. |
|
|
Thanks Carsten. Good to see it will be solved. |
|
|
@Carsten : other is already managed in Question rules : prohibit only if Question is set to "other"/Y. Then : we can use "array filter" with other on another question. It's OK with this. |
 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20205 |
|
|
2 issues with the fix: Not done for import and Remote |
|
|
|
|
|
I can not confirm this issue : export function does the job in last version. See the screenshot |
|
|
Uploaded
having time or TIME is not the issue. I revert the fix |
|
|
OK, time !== TIME We can allow TIME, but disallow time ..... Actually : best seems to update manually the DB (rename the colum time to Time and the Subquestion code to Time). |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20275 |
|
|
@C_schmitz : https://github.com/LimeSurvey/LimeSurvey/pull/528 fix it really. BUt seems awfull for maintenance .... |
|
|
Version 2.51.0 Build 160829 released |
