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

Export CSV - Ability to export Team field by name rather than ID

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Gathering Interest (View Workflow)
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Issue - Actions
    • Labels:
      None
    • UIS:
      1
    • Support reference count:
      1
    • Feedback Policy:
      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

      When exporting issues via CSV, the Portfolio field "Team" is exported by ID rather than by name. While this format is better for further JIRA imports, it is not human readable and isn't helpful for those cases where the export functionality is used to produce reports.

      Steps to Reproduce

      1. Create a Portfolio Project.
      2. Create a Team under the project. Ex: "Team Jira".
      3. Configure the scope, associating a team (and a board) to the project.
      4. Raise a ticket, assigning it to any specific team in the project previously configured.
      5. Go to the Issue Navigator and export the issue to CSV (All Fields).

      Expected Results

      You should see the team name under the "Teams" column.

      Actual Results

      You will see the Portfolio Team ID for the team configured for the issue(s) exported.

      Workaround

      Currently, the only workaround is to export as HTML (which requires Jira 7.6 already installed to work seamlessly) and then do some manual work:

      1. Open the HTML file in Excel.
      2. Copy the headers + data part in a new spreadsheet, then save it as CSV.
      3. The resulting CSV file will include the team name instead of the ID.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              scapuzzimato Stefano Capuzzimato
              Votes:
              11 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated: