Defect #19523
closed
problem in exporting Arabic text to csv
Added by vijay krishna about 9 years ago. Updated about 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 about 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 about 9 years ago
- Priority changed from Urgent to Normal
Updated by Toshi MARUYAMA about 9 years ago
I don't know what Arabic standard code page is.
http://en.wikipedia.org/wiki/Windows-1256
Updated by vijay krishna about 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 about 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 about 9 years ago
Is this a limitation? can someone respond please.
Updated by Toshi MARUYAMA about 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 about 9 years ago
- Related to Feature #7037: CSV export encoding and excel. UTF-8 and BOM added
Updated by Toshi MARUYAMA about 9 years ago
- Category changed from Issues to I18n
Try #7037#note-11 patch.
Updated by Toshi MARUYAMA about 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 about 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 about 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 about 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 about 9 years ago
- Status changed from New to Closed
- Resolution set to Duplicate
Duplicate of #11116.
Updated by Toshi MARUYAMA about 9 years ago
- Is duplicate of Defect #11116: CSV export encoding problem when issues and interface languages are not equal added