Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-1335

Can't import CSV generated from JIRA due to incorrect Customer Request Type format

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

      Issue Summary

      When trying to import the CSV file generated from the Jira service desk project, the import doesn't work successfully as the request types are not mapped correctly in the CSV file. As a result, the Customer request type field is left empty. i.e. showing the value No Match or None.

      Steps to reproduce

      1. Export issues created in a Service Desk from JIRA to csv
      2. Import issues back into JIRA mapping the Customer Request Type field to the one exported by JIRA

      Expected Behaviour
      JIRA imports issues successfully with the expected Customer Request Type

      Actual Behaviour
      Issues are imported but without the Customer Request Type

      The following is seen in the log

      2015-01-10 12:32:08,448 JiraTaskExectionThread-5 ERROR admin 752x2267x1 55b6dr 192.168.1.173 /secure/admin/ImporterLogsPage!import.jspa [internal.customfields.origin.VpOriginManagerImpl] Invalid stored origin value Get IT help
      2015-01-10 12:32:08,448 JiraTaskExectionThread-5 WARN admin 752x2267x1 55b6dr 192.168.1.173 /secure/admin/ImporterLogsPage!import.jspa [imports.importer.impl.AbstractDataImporter$1Thread[http-bio-8080-exec-5,5,main]] Cannot add value [ [Get IT help] ] to CustomField Customer Request Type in Issue null. Probably value was in incorrect format
      

      Workaround
      Replace the value in the CSV with the "correct format" value.

      • Contact Atlassian Support to extract the "correct format" values from the database.

            [JSDCLOUD-1335] Can't import CSV generated from JIRA due to incorrect Customer Request Type format

            Seerat added a comment -

            Suggested workaround to move around this error:

            Cannot add value [ [xxxxxx)] ] to CustomField Request Type in Issue with summary 'xxxxxxx'. Probably value was in incorrect format  

            On your CSV, you need to replace the name of the request type with the value from the request_type_key column.

            To correctly specify the "request type" in your CSV file, you need to use the request type ID instead of the request type name.

            • Navigate to Your Project:
              • Go to your Jira Service Management project.
              • Click on Project Settings.
            • Access Request Types:
              • Within the project settings, select Request types.
            • Identify the Request Type ID:
              • Click on the specific request type you need (e.g., "Epic (EPIC)" or "Story (STORY)").
              • Look at the URL in your browser's address bar. The number at the end of the URL is the request type ID you need to use in your CSV file.
                For example, if the URL is:
                https://test-support.atlassian.net/jira/servicedesk/projects/FOERD/settings/request-types/request-type/30/request-form 

                The request type ID is 30.

            Seerat added a comment - Suggested workaround to move around this error: Cannot add value [ [xxxxxx)] ] to CustomField Request Type in Issue with summary 'xxxxxxx' . Probably value was in incorrect format On your CSV, you need to replace the name of the request type with the value from the request_type_key  column. To correctly specify the "request type" in your CSV file, you need to use the request type ID instead of the request type name. Navigate to Your Project: Go to your Jira Service Management project. Click on  Project Settings . Access Request Types: Within the project settings, select  Request types . Identify the Request Type ID: Click on the specific request type you need (e.g., "Epic (EPIC)" or "Story (STORY)"). Look at the URL in your browser's address bar. The number at the end of the URL is the request type ID you need to use in your CSV file. For example, if the URL is: https: //test-support.atlassian.net/jira/servicedesk/projects/FOERD/settings/request-types/request-type/30/request-form The request type ID is  30 .

            Christian added a comment -

            Hi, I'm Christian on the JSD team owning this component.

            After having a close look at what the best way forward is, we've decided to create a suggestion for an XML issue import and close this bug. The reason is that we can't support both human-readable and machine-readable output using a limited format like CSV.

            In particular, we can't fix the problem raised in this bug report without breaking https://jira.atlassian.com/browse/JSDCLOUD-4520. This bug has more affected customers, but I would prefer a solution where don't need to choose which use-case to support.

            Support for a more powerful format for issue import, like XML, is the only way to ensure machine-readability in all circumstances. There are multiple related issues called out in our suggestion that are not realistic to support from CSV. See the list here: https://jira.atlassian.com/browse/JRACLOUD-74852.

            Please vote for, and watch, the suggestion to ensure it being addressed with urgency.

             

            Thanks for understanding,

            Christian

            Christian added a comment - Hi, I'm Christian on the JSD team owning this component. After having a close look at what the best way forward is, we've decided to create a suggestion for an XML issue import and close this bug. The reason is that we can't support both human-readable and machine-readable output using a limited format like CSV. In particular, we can't fix the problem raised in this bug report without breaking  https://jira.atlassian.com/browse/JSDCLOUD-4520 . This bug has more affected customers, but I would prefer a solution where don't need to choose which use-case to support. Support for a more powerful format for issue import, like XML, is the only way to ensure machine-readability in all circumstances. There are multiple related issues called out in our suggestion that are not realistic to support from CSV. See the list here:  https://jira.atlassian.com/browse/JRACLOUD-74852 . Please vote for, and watch, the suggestion to ensure it being addressed with urgency.   Thanks for understanding, Christian

            Asim K added a comment -

            Hi Folks!

            As a part of our efforts to make sure that our bug reports have as much useful information in them as they can, I've gone through and reverified this issue, updated the issue description to make it a bit clearer. Please contact Atlassian support to apply the workaround for you.

            Cheers,

            Asim
            Atlassian Support

            Asim K added a comment - Hi Folks! As a part of our efforts to make sure that our bug reports have as much useful information in them as they can, I've gone through and reverified this issue, updated the issue description to make it a bit clearer. Please contact Atlassian support to apply the workaround for you. Cheers, Asim Atlassian Support

            Jira Cloud CSV export doesn't export the internal customer request type anymore. So, the only way is to ask support (

            Andrey Kiyanovskiy added a comment - Jira Cloud CSV export doesn't export the internal customer request type anymore. So, the only way is to ask support (

            simple solution: provide the admins an export req type feature so he can at any time export the technical ID for further use... simple and quick solution... for a ticket that is open since 4.5 years...!

            Daniel Cabaco added a comment - simple solution: provide the admins an export req type feature so he can at any time export the technical ID for further use... simple and quick solution... for a ticket that is open since 4.5 years...!

            Hello Bridy,

             

            thank you for your quick reply. Unfortunately, the field "Customer Request Type" does not appear in our bulk update page. Maybe it is because we use Jira Cloud...

            BUT: In the meantime I found another solution. There is actually an internal ID for the Request type, that you can import via csv. If you export an issue where the request type is set, (e.g. CSV "export all fields"), the field Custom Field (Request Type) is included and it contains the internal Request Type ID 

            In our case, e.g. "service/b7e54c65-4371-49a2-a83b-dad055038902"

             

            Regards,

            Jennifer 

            Jennifer Fölster added a comment - Hello Bridy,   thank you for your quick reply. Unfortunately, the field "Customer Request Type" does not appear in our bulk update page. Maybe it is because we use Jira Cloud... BUT: In the meantime I found another solution. There is actually an internal ID for the Request type, that you can import via csv. If you export an issue where the request type is set, (e.g. CSV "export all fields"), the field Custom Field (Request Type) is included and it contains the internal Request Type ID  In our case, e.g. "service/b7e54c65-4371-49a2-a83b-dad055038902"   Regards, Jennifer 

            Hi Jennifer,

            From the Bulk Update page, you'll update the field called "Customer Request Type."  In our case, we had a 1:1 mapping between issue type and customer request type, so I was able to filter for each issue type and set the matching customer request type.  If you have a many:1 mapping, you'll want to import something else to search on (label, for example), so you know which issues to set to each request type.

            Bridy

            Bridy Frett added a comment - Hi Jennifer, From the Bulk Update page, you'll update the field called "Customer Request Type."  In our case, we had a 1:1 mapping between issue type and customer request type, so I was able to filter for each issue type and set the matching customer request type.  If you have a many:1 mapping, you'll want to import something else to search on (label, for example), so you know which issues to set to each request type. Bridy

            Hello Bridy, how did you bullk update the issues after the migration? 

            Jennifer Fölster added a comment - Hello Bridy, how did you bullk update the issues after the migration? 

            The query in the workaround only supplied 4 request types on 2 sandbox projects and nothing from the main JSD project.  I tried using the same string format (<portal key/request type key>), but the values still weren't set during a CSV import (migration from Zendesk).  Thankfully I can bulk update the records after the migration is complete.

            Bridy Frett added a comment - The query in the workaround only supplied 4 request types on 2 sandbox projects and nothing from the main JSD project.  I tried using the same string format (<portal key/request type key>), but the values still weren't set during a CSV import (migration from Zendesk).  Thankfully I can bulk update the records after the migration is complete.

            Steven F Behnke added a comment - - edited

            just kidding, apparently not

            Steven F Behnke added a comment - - edited just kidding, apparently not

              Unassigned Unassigned
              malmeida Marcus Silveira
              Affected customers:
              13 This affects my team
              Watchers:
              40 Start watching this issue

                Created:
                Updated:
                Resolved: