Patch #37621

Field separator in CSV export options

Added by Karel Pičman about 1 month ago. Updated 21 days ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Text formatting
Target version:-

Description

I would like to add a field separator option to the CVS export option form.

Background:

If I have set the language e.g. to English in my Redmine profile, the separator is taken from config/locales/en.yml (general_csv_separator) and it is comma. If I have installed e.g. German Microsoft Office and try to open such a CSV, it expects that the separator is semicolon. Unfortunately, Microsoft Office doesn't offer to choose the separator prior opening a CSV file and always uses the default value.

It is also related to #37581, where many translations have set general_csv_separator to different value than is expected in Microsoft Office.

field_separator_in_csv_export_options.patch Magnifier (7.46 KB) Karel Pičman, 2022-08-30 09:37

field_separator_export_option.png (24.4 KB) Karel Pičman, 2022-08-30 09:50

History

#1 Updated by Go MAEDA 26 days ago

Is the ability to select decimal separator unnecessary?

I think you need to change the decimal separator to ";" when you change the field separator to ",".

#2 Updated by Karel Pičman 21 days ago

No, you needn't. When the decimal separator is comma, values containing comma are enclosed in apostrophes.

...2022-09-12,"","2,50","2,50",0,2022-09-12 07:37...

Also available in: Atom PDF