Defect #8549

Export CSV has character encoding error

Added by Steven Wong over 6 years ago. Updated almost 6 years ago.

Status:ClosedStart date:2011-06-07
Priority:NormalDue date:
Assignee:Toshi MARUYAMA% Done:

100%

Category:Issues
Target version:1.3.0
Resolution:Fixed Affected version:

Description

1. login and issues tab
2. when the ui language is English ,export the Chinese encoding issues, the CSV file is Malformed.just like this:

  1. Status 椤圭洰 璺熻釜
    宸插叧闂?涓婃捣绉诲姩璁¢噺鑰冩牳绯荤粺 Bug 绔嬪嵆淇

Related issues

Related to Redmine - Defect #7096: CSV Issues Export + Ruby 1.9 + Thin + non-ascii character... Closed 2010-12-11
Duplicated by Redmine - Defect #6621: Multibyte symbols are wrongly displayed in issues CSV exp... Closed 2010-10-11

Associated revisions

Revision 7811
Added by Toshi MARUYAMA about 6 years ago

add functional test to export time entry report csv encoded in Big5 on Traditional Chinese locale (#8549)

Revision 7812
Added by Toshi MARUYAMA about 6 years ago

add functional test to export time log csv encoded in Big5 on Traditional Chinese locale (#8549)

Revision 7818
Added by Toshi MARUYAMA about 6 years ago

move iconv from utf8 logic from pdf to lib/redmine/codeset_util.rb for common use (#8549)

Revision 7819
Added by Toshi MARUYAMA about 6 years ago

fix malformed time log csv encoding in case of unable to convert (#8549)

Revision 7820
Added by Toshi MARUYAMA about 6 years ago

fix malformed time entry report csv encoding in case of unable to convert (#8549)

Revision 7821
Added by Toshi MARUYAMA about 6 years ago

add functional test to export issue csv encoded in Big5 on Traditional Chinese locale (#8549)

Revision 7822
Added by Toshi MARUYAMA about 6 years ago

fix malformed issues csv encoding in case of unable to convert (#8549)

Revision 7947
Added by Toshi MARUYAMA almost 6 years ago

fix time entry csv last line encoding (#8549)

History

#1 Updated by Toshi MARUYAMA over 6 years ago

  • Target version set to 1.3.0

#2 Updated by Toshi MARUYAMA over 6 years ago

  • Assignee set to Toshi MARUYAMA

#3 Updated by Toshi MARUYAMA over 6 years ago

  • Category set to Issues

#4 Updated by Toshi MARUYAMA over 6 years ago

source:trunk/config/locales/en.yml@5999#L140
general_csv_encoding: ISO-8859-1

You can see Chinese characters in Chinese locale.
I will replace invalid characters to '?' like PDF in 1.3.

#5 Updated by Toshi MARUYAMA over 6 years ago

  • Subject changed from Export CSV hase character error to Export CSV has character error

#6 Updated by François Trahan over 6 years ago

Just a little remark : The encoding used for CSV export is dependent on the user interface choice. Unfortunately, because I work with an English interface doesn't mean that every comment is going to be in English.

Here, we had to replace pretty much every local's yml file to specify UTF-8 for csv export encoding.

On the same basis, exporting french comments with ISO-8859-1 yields bad characters, making this a poor encoding choice for the french locale...

#7 Updated by Toshi MARUYAMA about 6 years ago

  • % Done changed from 0 to 100

#8 Updated by Toshi MARUYAMA almost 6 years ago

  • Subject changed from Export CSV has character error to Export CSV has character encoding error

#9 Updated by Toshi MARUYAMA almost 6 years ago

  • Status changed from New to Closed
  • Resolution set to Fixed

Committed in r7947.

Also available in: Atom PDF