Quickly populate Select List (Cascading)

Question

I am looking for a way to format a csv import perhaps, to quickly create a Select List (Cascading). Manually adding all the values with take too long.

I have 14 Parents with 10 children each. Please can you advise how to format this. I have seen Parent => Child but I am not sure how to add each of the extra options or format the csv so they will all end up in the same custom field.

I could use script-runner if there is a recommended way to do it there.

Florian Bonniec · Accepted Answer

Hi @Dani Miles

What I used to do is to create a single issue in a test project, then update this issue using CSV import, if you are an admin and your are using the Import From external system it wil create the options. You just have to import Key, Summary and Field value.

TEST-1, summary, value1 => value2

Reagrds

Dani Miles · Accepted Answer

Thanks @Florian Bonniec

That helped me sort this. So I created a ticket in a test project where my custom field was configured. I used the External System Import:-

Cog > System > External System Import

And I formatted the csv like this, only mapping the "Concatenate" field to my Custom Field Select List (Cascading) that I wanted to populate.

Mapping
Key = Issue Key
Summary = Summary
Type = Issue Type
Concatenate = Select List (Cascading) custom field

Worked Perfectly.