View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
03936Bug reportsOtherpublic2009-12-02 16:332009-12-11 12:16
Reporterrfaber Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.86 
Fixed in Version1.87RC5 
Summary03936: Export: underscore added at the end of every variable name when I select "convert spaces to underscores"
Description

When I export results to application (not SPSS, R or VV) and check options "use question codes" and "convert spaces in question text to underscores" all variables will have an underscore added as last character. This suggests that at some point the variables have a space character added to their question code. This should be deleted by trimming the string again, before this replacement function can be applied.

Tagsexport, xls
Bug heat6
Complete LimeSurvey version number (& build)7697
I will donate to the project if issue is resolved
BrowserFirefox 3.0.4
Database type & versionMySQL 5.0.86
Server OS (if known)FreeBSD
Webserver software & version (if known)Apache
PHP Version5.2.11

Users monitoring this issue

There are no users monitoring this issue.

Activities

rfaber

rfaber

2009-12-02 16:42

reporter   ~10408

This is when exported to Excel, Word has the same problem, csv is OK.
rfaber

rfaber

2009-12-03 16:40

reporter   ~10422

Error is in admin/exportresults.php line 854:
$firstline .= "$fquest $separator";

please change to $firstline .= "$fquest$separator"; and all seems to be OK.
Applying the trim function on line 859 did not work.
Thanks.

user372

2009-12-03 17:32

  ~10424

@c_schmitz: may you please have a look at the suggested modification by rfaber?
c_schmitz

c_schmitz

2009-12-04 19:16

administrator   ~10458

Thank you!

Issue History

Date Modified Username Field Change
2009-12-02 16:33 rfaber New Issue
2009-12-02 16:33 rfaber Status new => assigned
2009-12-02 16:33 rfaber Assigned To => user372
2009-12-02 16:33 rfaber LimeSurvey build number => 7697
2009-12-02 16:33 rfaber Browser => Firefox 3.0.4
2009-12-02 16:33 rfaber Database & DB-Version => MySQL 5.0.86
2009-12-02 16:33 rfaber Operating System (Server) => FreeBSD
2009-12-02 16:33 rfaber Webserver => Apache
2009-12-02 16:33 rfaber PHP Version => 5.2.11
2009-12-02 16:38 rfaber Tag Attached: export
2009-12-02 16:42 rfaber Note Added: 10408
2009-12-03 10:36 rfaber Tag Attached: xls
2009-12-03 16:40 rfaber Note Added: 10422
2009-12-03 17:32 user372 Note Added: 10424
2009-12-03 17:32 user372 Assigned To user372 => c_schmitz
2009-12-04 19:16 c_schmitz Note Added: 10458
2009-12-04 19:16 c_schmitz Status assigned => resolved
2009-12-04 19:16 c_schmitz Fixed in Version => 1.87RC5
2009-12-04 19:16 c_schmitz Resolution open => fixed
2009-12-11 12:16 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)