Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-65161

Allow an end user to set a default field separator they prefer to use when exporting CSV files and have Jira observe it.

    XMLWordPrintable

Details

    • Suggestion
    • Status: Gathering Interest (View Workflow)
    • Resolution: Unresolved
    • None
    • None
    • 2
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      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.

      Example:

      Attachments

        1. fixed.png
          fixed.png
          16 kB
        2. sep.png
          sep.png
          11 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ajean Andy J.
              Votes:
              8 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: