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

Export to Excel CSV Current Fields Does Not Show Same Order as WebUI

    XMLWordPrintable

    Details

      Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Atlassian Update: 27nd September 2016

      Hi Everyone,

      This issue is fixed in Both JIRA Cloud and JIRA Server.

      • JIRA Cloud users have already got their instances updated.
      • JIRA Server users have to upgrade to JIRA 7.2.2 Server which is now available to download at https://www.atlassian.com/download .

      Thanks,
      Ignat Alexeyenko
      JIRA Bugmaster.

       

      Summary

      When using the Excel (CSV, Current Fields) Export option, column order does not match what was selected in the WebUI and the Issue ID field is included (though it was not selected).

      Environment

      • JIRA v1000.25.1 Cloud

      Steps to Reproduce

      1. Perform a JIRA Issue Search
      2. Configure custom Columns and Column Order
      3. Export Issues to CSV using Export > Excel (CSV, Current Fields)

      Expected Results

      Downloaded CSV file only shows Columns (and results) based on what is selected in the WebUI

      Actual Results

      No Errors in logs.
      The IssueID field (column) is added
      Order does not keep to what was configured in the WebUI
      Shown in screenshot:

      WebUI Issue Type, Issue Key, Summary, Assignee, Reporter, Priority, Status, Resolution, Created Date, Updated Date, Affects Version/s, Links
      CSV Export Summary, Issue Key, Issue id, Issue Type, Status, Priority, Resolution, Assignee, Reporter, Created, Updated, Outward issue link (Blocks)

      Notes

      Appears that the Excel (CSV) Export options were added in April 19th but listed as a Service Desk Feature: https://confluence.atlassian.com/display/Cloud/What's+New#What'sNew-servicedesk

      Workaround

      • As a workaround you can use the Export HTML Report (current field/all fields). You can then edit the name of the file from <filename>.html to <filename>.xls and it should open up in your spreadsheet program. You may run into this bug: https://jira.atlassian.com/browse/JRA-61891

        Attachments

        1. FilterColumnsInJIRASoftware_7.2.5.png
          42 kB
        2. screenshot-1.png
          screenshot-1.png
          40 kB
        3. screenshot-2.png
          screenshot-2.png
          41 kB
        4. WebvsCSV.png
          WebvsCSV.png
          317 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              scranford Shawn C
              Votes:
              14 Vote for this issue
              Watchers:
              51 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: