Closed (fixed)
Project:
Webform
Version:
6.x-3.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
24 Mar 2010 at 14:38 UTC
Updated:
18 Jul 2011 at 16:16 UTC
Jump to comment: Most recent file
Comments
Comment #1
Elian commentedBy the way, same problem with webform-3.x-dev.
Comment #2
quicksketchWhat are the settings for your download (CSV, TSV, Excel, etc?) I've successfully imported files with all kinds of characters (Arabic, Chinese, French). Often times this is a matter getting Excel to read your files properly, as opposed to something wrong with the files. More recent versions of Office give you trouble when dealing with Webform's xls files, I suggest using TSV for everything.
Whatever you do, do NOT use CSV. That format by standards does not support non-latin characters. It it is impossible to get them working with CSV. TSV is definitely the safest way to go (which is why it is the default).
Comment #3
Elian commentedThank You for Your answer!
Yes, I tried all options. I don't think that's because of Excel settings, because webform 2 exports everything fine. I tried French, Hebrew, Russian, only English is displayed correctly.
I can attach images of what I see and .tsv files if it helps.
Thanks!
Comment #4
quicksketchWell this is slightly embarrassing, everything would be working if we were doing a simple comparison correctly. Webform encodes everything perfectly, but is forgetting the infamous "BOM" marker beginning the file. This small change makes XLS and TSV files download and open in Excel properly. I tested with French and Hebrew and they downloaded just fine.
Comment #5
quicksketchThese changes are included in the beta 4 version which will be available shortly.
Comment #7
avner commentedSorry for reopening this but this issue seems to come back
I am using 6.x-3.11 and when trying to export a TSV (or CSV for this manner) file with non Lating chars i get gibberish when on Linux machines
on Windows this works fine, however on linux machines the non Latin chars are unreadable
Comment #8
avner commentedComment #9
avner commentedComment #10
quicksketchI can't reproduce any problems when exporting TSV/Excel files. As noted, you shouldn't use CSV files for exports because they specifically do not support UTF8 characters.
Comment #11
avner commentedsorry,
didnt see your reply
As i said i tested on TSV as well
the issue is on Linux
On windows its working fine
Comment #12
avner commentedok, the issue is with my Linux configuration
I checked it with two other Linux machines and it seems fine
Sorry of this
Avner