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

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


      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 .

      Ignat Alexeyenko
      JIRA Bugmaster.



      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).


      • 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)


      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


      • 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

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

            Unassigned Unassigned
            scranford Shawn C
            14 Vote for this issue
            51 Start watching this issue