Defect #19092
closedCSV Export and general csv separator
Description
Hi everyone, this report is for redmine 2.4.3.stable (I've not found in any mention of this problem in changelog for 2.4.x, 2.5.x or 2.6.x)
For CSV Export I've found a bug when users uses redmine general_csv_separator in subject or description.
Steps to reproduce problem (I assume that general_csv_separator used is ;)
1) open a new issue
2) as subject use test;1 and description test;1
3) save issue
4) export as csv
5) open csv with excel, you don't see inserted test or description
To solve this problem, I suggest together try to follow best practices with CSV (starting for example from Wikipedia ).
Following Wikipedia links I've found this (see 6):
6. Fields containing line breaks (CRLF), double quotes, and commas
should be enclosed in double-quotes. For example:
"aaa","b CRLF
bb","ccc" CRLF
zzz,yyy,xxx
so i propose to change redmine csv export when a field there is csv separator, adding double-quotes, what do you think?
Note: I know that I can change my csv separator settings in locale, for example using another separator as | or $, but this is not solving this issue, because users can enter anything in any field.
Note2: could please admins add a new category for issues related to CSV export?
Thank you
Files
