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

      Summary

      When the user exports an issue from Service desk to CSV(all fields) the "Customer Request type" do not show the actual name of the request type, instead it shows a code from it.

      Steps to Reproduce

      1. Search for service desk issue that contains not default request types
      2. Click on Export Excel CSV (all fields)

      Expected Results

      On the exported csv, "Customer Request type" field shows the name of the request type.

      Actual Results

      It shows a code from it.

      Take note that the exported value is in the form of: Project_Key/Request_Type_Key

      Workaround

      Run this SQL query from the database:
      NOTE this is written in PostgreSQL syntax and may need to be modified for for your database type:

       select vp."KEY" as project_key, vpf."NAME" as Request_type_Name, vpf."KEY" AS request_type from "AO_54307E_VIEWPORT" vp join "AO_54307E_VIEWPORTFORM" vpf on vpf."VIEWPORT_ID" = vp."ID";
      

      Then base on the KEY to find the NAME.

          Form Name

            [JSDSERVER-4520] "Customer Request type" field get encoded when exported to CSV

            Hi apetridou, the fix has been deployed to Jira Service Desk 4.4.0 onwards, and accordingly to the compatibility matrix, this version is only compatible with Jira Core 8.3.0 onward.

            Rodrigo Baldasso added a comment - Hi apetridou , the fix has been deployed to Jira Service Desk 4.4.0 onwards, and accordingly to the compatibility matrix , this version is only compatible with Jira Core 8.3.0 onward.

            Hi,

            This is not fixed. 
            Jira Version 7.9.0 , 8.2.4 

            Athena Petridou [Nimaworks] added a comment - Hi, This is not fixed.  Jira Version 7.9.0 , 8.2.4 

            Hi Dylan,
            A workaround we've been using is to export to HTML instead of CSV from the Issue Filter Screen. Then, use Excel to open the HTML file. You'll get the correct Customer Request Type that way. There is a bit of clean-up to do after you open the file, but it's a workable solution if you're looking to export Customer Request Type. Hope this helps.
            Thanks,
            Chris H.

            Christopher Heritage added a comment - Hi Dylan, A workaround we've been using is to export to HTML instead of CSV from the Issue Filter Screen. Then, use Excel to open the HTML file. You'll get the correct Customer Request Type that way. There is a bit of clean-up to do after you open the file, but it's a workable solution if you're looking to export Customer Request Type. Hope this helps. Thanks, Chris H.

            Dylan Hebb added a comment -

            Is there a workaround for this issue? High priority - need it for metrics. 

            Dylan Hebb added a comment - Is there a workaround for this issue? High priority - need it for metrics. 

            Is there a better workaround?

            Khai Shaun Ng added a comment - Is there a better workaround?

            Same  - would be great to resolve, as there are considerable reporting implications.

            David Malinowicz added a comment - Same  - would be great to resolve, as there are considerable reporting implications.

            Any news on this issue????

            Cedric DEVAUX added a comment - Any news on this issue????

            Atlassian, 

            Can we get an update on this bug?

             

            Version 3.15.3 is affected

            Tara Caroline Fowler added a comment - Atlassian,  Can we get an update on this bug?   Version 3.15.3 is affected

            There are lot many reasons when you need to export data into excel to generate meaningful metrics and such issues affect a lot and increase the workload. Service Desk being one of the popular tool in market, please do not let these minor bugs affect the overall customer satisfaction towards the product.

            Ajit Rajput added a comment - There are lot many reasons when you need to export data into excel to generate meaningful metrics and such issues affect a lot and increase the workload. Service Desk being one of the popular tool in market, please do not let these minor bugs affect the overall customer satisfaction towards the product.

            Huw Evans added a comment -

            @ivan, being ignored I suspect. 

            Huw Evans added a comment - @ivan, being ignored I suspect. 

              siddharth@atlassian.com Siddharth Srivastava
              bcasaroli Bernardo Casaroli (Inactive)
              Affected customers:
              79 This affects my team
              Watchers:
              60 Start watching this issue

                Created:
                Updated:
                Resolved: