Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. 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

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • None
    • 1
    • 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 checkbox indicating whether to include the sep=x marker at the top of any CSV files they export

      Related to https://jira.atlassian.com/browse/JSWSERVER-15826

      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:
              2 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: