Quickly populate Select List (Cascading)

[Dani Miles]

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. 

[Dani Miles · Accepted solution]

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. 

[Florian Bonniec · Accepted solution]

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