-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
2
-
Summary
Allow the user to set a default field separator they prefer to use when exporting CSV files and have Jira observe it.
Notes
When the CSV file format was developed to represent spreadsheet data, it was done so with the expectation that most spreadsheets would only contain numbers and short text labels, and since numbers would often contain the decimal point (.) but not commas, the comma (,) would be a very good delimiter.
Issue Type,Issue key,Issue id,Summary,Assignee,Reporter,Priority,Status,Resolution,Created,Updated,Due Date,Fix Version/s,Fix Version/s,Custom field (Epic Link) Bug,TEST-6780,832043,This is a test comment,TEST,jbrouss,Critical,Done,Done,14/Dec/16 2:28 PM,03/Apr/17 1:03 PM,,AAA 2.1,TEST,TEST-6779
This is not always appropriate and it would help if the users had a choice of what delimeter JIRA will use.
Workaround
When opening CSV files in Excel, it looks for a field separator character in the top of an incoming CSV file. If it's there, that's what it uses. If it isn't there, it uses the system default. This is done using a line such as sep=, or sep=;
Rather than inputting this manually, it would be great if JIRA asks the user prior to the export and appends this to the file.
- duplicates
-
JRASERVER-62414 Allow users to configure the delimiter in CSV export
- Closed
- is related to
-
JRASERVER-65160 Allow the user to set a checkbox indicating whether to include the sep=x marker at the top of any CSV files they export
- Gathering Interest