Defect #19523
closed
problem in exporting Arabic text to csv
Added by vijay krishna over 9 years ago. Updated over 9 years ago.
0%
Description
We have problem in exporting arabic text to excel in csv format using english locale.
we have changed "general_csv_encoding: UTF-8" in en.yml config file. Please help on this.
Files
| issues.xlsx (36.2 KB) issues.xlsx | vijay krishna, 2015-03-30 11:29 | ||
| en.yml (48 KB) en.yml | vijay krishna, 2015-03-30 11:29 | ||
| issuesreported.xlsx (144 KB) issuesreported.xlsx | vijay krishna, 2015-04-01 10:34 | ||
| issuesreported.xlsx (155 KB) issuesreported.xlsx | vijay krishna, 2015-04-01 12:07 | ||
| Issues.xlsx (29.2 KB) Issues.xlsx | vijay krishna, 2015-04-06 11:47 |
Related issues
Updated by Toshi MARUYAMA over 9 years ago
- Subject changed from problem in exporting Arabic text to csv using english locale to problem in exporting Arabic text to csv
Updated by Toshi MARUYAMA over 9 years ago
- Priority changed from Urgent to Normal
Updated by Toshi MARUYAMA over 9 years ago
I don't know what Arabic standard code page is.
http://en.wikipedia.org/wiki/Windows-1256
Updated by vijay krishna over 9 years ago
- File issuesreported.xlsx issuesreported.xlsx added
i tried to change the "general_csv_encoding: Windows-1256" also, but still same issue.
Checked in my sql db the the arabic text is saving correctly, attaching the document for your reference.
Please help to suggest on this.
Updated by vijay krishna over 9 years ago
- File issuesreported.xlsx issuesreported.xlsx added
i have created issue #19543 to replicate the issue here in this forum. same problem i am getting while exporting this to csv format. Please help on this.
Updated by vijay krishna over 9 years ago
Is this a limitation? can someone respond please.
Updated by Toshi MARUYAMA over 9 years ago
http://stackoverflow.com/a/1502134
Excel uses the machine-specific ANSI encoding.
It seems you uses English Windows.
In this case you need to set UTF-8 in en.yml
and convert to Arabic encoding.
https://www.google.co.jp/search?q=excel%20utf-8
Updated by Toshi MARUYAMA over 9 years ago
- Related to Feature #7037: CSV export encoding and excel. UTF-8 and BOM added
Updated by Toshi MARUYAMA over 9 years ago
- Category changed from Issues to I18n
Try #7037#note-11 patch.
Updated by Toshi MARUYAMA over 9 years ago
Toshi MARUYAMA wrote:
It seems you uses English Windows.
In this case you need to set UTF-8 in en.yml
and convert to Arabic encoding.
Sorry, it is wrong.
There is no easy way.
Try #7037#note-12 patch.
Updated by Toshi MARUYAMA over 9 years ago
Toshi MARUYAMA wrote:
Toshi MARUYAMA wrote:
It seems you uses English Windows.
In this case you need to set UTF-8 in en.yml
and convert to Arabic encoding.Sorry, it is wrong.
There is no easy way.
Try this.
http://stackoverflow.com/a/11249968
Updated by vijay krishna over 9 years ago
- File Issues.xlsx Issues.xlsx added
Getting below error while trying to install the "redmine_csv_with_bom-master" plugin. please see attached for reference.
Updated by vijay krishna over 9 years ago
D:\redmine-2.5.1>rake redmine:plugins:migrate RAILS_ENV=production
rake aborted!
NameError: undefined method `issues_to_csv' for module `IssuesHelper'
D:/redmine-2.5.1/plugins/redmine_csv_with_bom-master/init.rb:4:in `block in <top
(required)>'
D:/redmine-2.5.1/plugins/redmine_csv_with_bom-master/init.rb:3:in `module_eval'
D:/redmine-2.5.1/plugins/redmine_csv_with_bom-master/init.rb:3:in `<top (require
d)>'
D:/redmine-2.5.1/lib/redmine/plugin.rb:150:in `block in load'
D:/redmine-2.5.1/lib/redmine/plugin.rb:141:in `each'
D:/redmine-2.5.1/lib/redmine/plugin.rb:141:in `load'
D:/redmine-2.5.1/config/initializers/30-redmine.rb:19:in `<top (required)>'
D:/redmine-2.5.1/config/environment.rb:14:in `<top (required)>'
Tasks: TOP => redmine:plugins:migrate => environment
(See full trace by running task with --trace)
Updated by Toshi MARUYAMA over 9 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
Duplicate of #11116.
Updated by Toshi MARUYAMA over 9 years ago
- Is duplicate of Defect #11116: CSV export encoding problem when issues and interface languages are not equal added