Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,321
Community Members
 
Community Events
176
Community Groups

CSV Import of Request Types

When running a CSV import for Service Projects, it’s not possible to import the request type field with its current names, like “Get IT Help“ or “Onboard new employees“.

It’s necessary to use the request type keys, and to get that information, the users need to reach out to Atlassian Support. But there’s a way to retrieve this information using an API endpoint.

Instructions

  1. Pick one ticket on your cloud site from the Issue Type that contains the Request Type you need to run the import
    image.png

  2. Export this ticket to XML (“…“ > Export XML) to get its ID
    image.png

    image.png

  3. Now that you have the ID, access the following endpoint on your web browser (change the {your-instance} and {ticket-ID}):
    https://{your-instance}.atlassian.net/rest/servicedesk/1/servicedesk/request/{ticket-ID}/request-types

  4. And you’ll see a page like below, related to the Request type “Investigate a problem“ and also all other Request Types related to the ticket’s Issue Type:
    image.png
  5. The information on the key field can also have a different format, like on the image below, and you can use it the same way:
    image.png
    For these cases, you need to check the relevant Request Type basing on the field “name“.
  6. And the information you need is: portalKey and key. The format needed for the CSV import is:
    portalkey/key => tf/investigateproblem
                              => bug/f8f3cdb9-8e4d-479c-941b-6976ac7d6da9

  7. And you need to use this value on the request type field when running the CSV import. Remember to also map the Issue Type field to have a correct import
    image.png

3 comments

Hi,

I am trying to run CSV import to create issues for "Jira Service Management - Cloud". I was able to get the Request Type Keys per the instructions above. However, when mapping fields in the CSV import wizard, there is no "Request Type" field to map to.  When I use JQL, Request Type shows up as a custom field but it does not show up in the list of custom or Jira fields to map to.

Like Adam Kassoff likes this

@H Crain Hi - you need to map the field to screens before it will show up there. Find the field in your Custom Fields list in Project settings and associate it to the appropriate screen(s) used for the rest of your project. 

@H Crain I've done imports with "External system import" from the menu below. Please try this.

Administration > System > Import & export > External system import

https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events