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

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

    XMLWordPrintable

Details

    Description

      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

      Attachments

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

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-62679 Export CSV with Current Fields not a CSV representation of Filter Results

          • Low - Low priority issues
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-61244 Export to Excel CSV Current Fields Does Not Show Same Order as WebUI

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-61891 Exports search results to Excel result in empty sheets due to Microsoft update

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-62217 Export (CSV, All Fields) and Export (CSV, Current Fields) Issue link value shows in multiple column

          • Low - Low priority issues
          • Closed

          Suggestion - JRACLOUD-62115 Feedback on the new "Export to CSV" functionality

          • Closed

          Suggestion - JRACLOUD-77322 Add ability of HTML and CSV export (all fields) to be in the order that is displayed in UI

          • Closed

          Suggestion - JRACLOUD-62216 Export (CSV, All Fields) and Export (CSV, Current Fields) shows the heading as 'Custom field (<field name>)'

          • Under Consideration
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRACLOUD-32352 Excel Export Is Broken With Office 2010 or 2013 / LibreOffice / Numbers

          • Medium - Medium priority issues
          • Closed

          Suggestion - JRACLOUD-62366 Export to Excel CSV is displaying username instead of full names

          • Closed
          mentioned in

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: