View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
04012Bug reportsOtherpublic2009-12-21 13:57
Reporterpavel Assigned Touser372 
PrioritynormalSeverityminor 
Status closedResolutionno change required 
Product Version1.87RC5 
Summary04012: During export tokens to scv file all hebrew words become gibberish
Description

Please see attachment

TagsNo tags attached.
Attached Files
tokens_41463.csv (231 bytes)
hebrew.docx (10,147 bytes)
Bug heat4
Complete LimeSurvey version number (& build)41463
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2009-12-21 12:47

updater   ~10618

Pavel, I think it's the first name and last name field which holds the hebrew characters?
Can you post how they should look like?
Can you try to open the file with a raw text editor?

pavel

pavel

2009-12-21 13:09

reporter   ~10619

Yes, it's should be:
first name: "???"
last name: "???"

pavel

pavel

2009-12-21 13:11

reporter   ~10620

please see attachment

pavel

pavel

2009-12-21 13:13

reporter   ~10621

I opened the file with notepad.It looks ok

Mazi

Mazi

2009-12-21 13:37

updater   ~10622

While trying to solve your problem I noticed that the export doesn't seem to be the cause of the problem and that it works well. When double clicking the file it is opened with Excel (2003 in my case) and shows broken characters. When having installed Excel 2007 and double clicking the file it shows up correctly. Same when opening the file with notepad++. So the problem is Excel not recognizing the file encoding at older versions, not the Limesurvey export.
You can try to rename the file to.txt and import it in Excel, telling the program that it's UTF-8 encoded.

pavel

pavel

2009-12-21 13:43

reporter   ~10623

thanks, it works!

Mazi

Mazi

2009-12-21 13:57

updater   ~10624

Excel problem, no Limesurvey bug -> closed

Issue History

Date Modified Username Field Change
2009-12-21 11:02 pavel New Issue
2009-12-21 11:02 pavel Status new => assigned
2009-12-21 11:02 pavel Assigned To => user372
2009-12-21 11:02 pavel File Added: tokens_41463.csv
2009-12-21 11:02 pavel LimeSurvey build number => 41463
2009-12-21 12:47 Mazi Note Added: 10618
2009-12-21 12:48 Mazi Status assigned => feedback
2009-12-21 13:09 pavel Note Added: 10619
2009-12-21 13:11 pavel Note Added: 10620
2009-12-21 13:11 pavel File Added: hebrew.docx
2009-12-21 13:13 pavel Note Added: 10621
2009-12-21 13:37 Mazi Note Added: 10622
2009-12-21 13:43 pavel Note Added: 10623
2009-12-21 13:57 Mazi Note Added: 10624
2009-12-21 13:57 Mazi Status feedback => closed
2009-12-21 13:57 Mazi Resolution open => no change required
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)