Project

General

Profile

Actions

Defect #19092

closed

CSV Export and general csv separator

Added by Alberto Martinelli almost 10 years ago. Updated about 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
No feedback
Affected version:

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

excel2013-ja.png (6.32 KB) excel2013-ja.png Toshi MARUYAMA, 2015-02-12 13:42
Actions

Also available in: Atom PDF