View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03967 | Bug reports | Other | public | 2009-12-07 22:09 | 2009-12-11 12:16 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.85+ | ||||
Fixed in Version | 1.87RC5 | ||||
Summary | 03967: Native Languages support in csv file export and import | ||||
Description | i discovered a bug in CSV File export and import regards Arabic and possibly Japanese Language. Most of us use Microsoft Excel to manipulate CSV files 1- comma as a separator are different with localizations in windows operating system, some use semicolon(default in arabic) and some use other characters 2- Limesurvey exports UTF-8 Without BOM encoded CSV Files, Excell only can read UTF WITH BOM (BYTE ORDER MARK) Correctly. This doesn't affect english only foregin characters e.g. arabic language 3- Excel Exports CSV Files as Windows/Dos File format. in Windows Encoding (cp1256 in arabic language) a special Converter is required to convert this to utf-8. | ||||
Additional Information | SOLUTIONS:1- Use This Reg File To patch client system Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Control Panel\International] 2- patch limesurvey // Export UTF8 WITH BOM File: admin/tokens.php // Export UTF8 WITH BOM 3- there are an open source arabic php projext at add the arabic package to your site and insert this code to convert the input to utf For import vv functions
You can do the same thing in token file for csv token import | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 1.85 | ||||
I will donate to the project if issue is resolved | |||||
Browser | ALL | ||||
Database type & version | XAMPP Windows 1.70 | ||||
Server OS (if known) | Windows 7 7600 Ultimate | ||||
Webserver software & version (if known) | APACHE | ||||
PHP Version | PHP Version 5.2.8 | ||||
@ c_schmitz: please have a look at the suggested modifications! |
|
I implemented suggestion 2.) - Thank you! VVIMport is only designed to import/export UTF-8 therefore we won't convert anything there. Tokens import already has a cp1256 input filter Thank you very much! |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2009-12-07 22:09 |
|
New Issue | |
2009-12-07 22:09 |
|
Status | new => assigned |
2009-12-07 22:09 |
|
Assigned To | => user372 |
2009-12-07 22:09 |
|
LimeSurvey build number | => 1.85 |
2009-12-07 22:09 |
|
Browser | => ALL |
2009-12-07 22:09 |
|
Database & DB-Version | => XAMPP Windows 1.70 |
2009-12-07 22:09 |
|
Operating System (Server) | => Windows 7 7600 Ultimate |
2009-12-07 22:09 |
|
Webserver | => APACHE |
2009-12-07 22:09 |
|
PHP Version | => PHP Version 5.2.8 |
2009-12-07 22:11 |
|
Note Added: 10507 | |
2009-12-07 22:11 |
|
Assigned To | user372 => c_schmitz |
2009-12-07 23:10 |
|
Relationship added | related to 03968 |
2009-12-08 02:35 | c_schmitz | Note Added: 10514 | |
2009-12-08 02:35 | c_schmitz | Status | assigned => resolved |
2009-12-08 02:35 | c_schmitz | Fixed in Version | => 1.87RC5 |
2009-12-08 02:35 | c_schmitz | Resolution | open => fixed |
2009-12-08 13:37 | gwenguillaume | Issue Monitored: gwenguillaume | |
2009-12-08 13:37 | gwenguillaume | Issue End Monitor: gwenguillaume | |
2009-12-11 12:16 | c_schmitz | Status | resolved => closed |
2010-05-06 10:27 | c_schmitz | Category | Import / Export => (No Category) |