Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-61244

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

XMLWordPrintable

      NOTE: This bug report is for JIRA Cloud. Using JIRA Server? 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

        1. WebvsCSV.png
          WebvsCSV.png
          317 kB
        2. screenshot-1.png
          screenshot-1.png
          40 kB
        3. screenshot-2.png
          screenshot-2.png
          41 kB
        4. FilterColumnsInJIRASoftware_7.2.5.png
          FilterColumnsInJIRASoftware_7.2.5.png
          42 kB
        5. Create and track feature requests for Atlassian products. 2017-09-29T03-14-05+0000.csv
          170 kB

              Unassigned Unassigned
              scranford Shawn C
              Votes:
              14 Vote for this issue
              Watchers:
              46 Start watching this issue

                Created:
                Updated:
                Resolved: