Customer request type filed in empty for issues imported from CSV

[Mohamed Saad Taha]

Dears,

Iam importing some issues for certain project from csv but the issue:

type is imported correctly but the customer request type or request type filed in shown like no match attached screen shoot 

what is the filed name i have to import to correctly display this filed?

[Walter Buggenhout _ACA IT_]

Hi @Mohamed Saad Taha,

Request types in JSM use some weird and complex keys rather than the description you see in the UI. This related thread explains more about how it works and how you may be able to retrieve them.

Hope this helps!

[Mohamed Saad Taha]

Thanks alot for your reply indeed it is help but I have the below issues 

1- When I try to access endpoint on my web browser it show only one word "Null" screen below 

2- also when I try to map the filed from the excel to which filed in the mapping screen i have to select to import in request type filed 

screen below 

[Walter Buggenhout _ACA IT_]

Well; it is essential that you do have request types configured for the issue type you are trying to create. If you're unsure if this is all properly set up, check Atlassian documentation to learn more.

As an alternative, instead of doing complex manipulations to get the csv import right, you could also consider setting up an automation rule to update the request types of issues that do not have them properly filled out. You can use a scheduled automation rule to check for issues that don't have a request type filled out and use conditional logic (based on issue types) to fill out the missing request types.

The basic rule could look like this:

Of course, you'll need to define proper rules to map the right request types to their matching issue types.

[Mohamed Saad Taha]

@Walter Buggenhout _ACA IT_ 

For the first part of course, I have request type for every issue type but to import form CSV I must know two things first the field name that I need to fill (request type filed and it is system filed but I don't know its name in the mapping screen) second the value that I need to import and it is some how no easy is there any way from script runner to get this value ?

for the automation rule Iam using datacenter version 4.20.8 and I don't find scheduled automation rule is it exist in my version ?