problem understanding JIRA CLI with cascading field and csv

Hi

We use a cascading field in JIRA and it is set as required. We need to create 100s or more test cases via the CLI

We have the following csv to import

action,project,type,summary,assignee,reporter, customfield_10133,asCascadeSelect

createIssue,VTP,TestCase,deleteme,jon.smith,jon.smith,15486,15487

I am able to create the first half of the menu item, but not the second.

I have tried commas, quotes, etc.

If we remove the customfield and disable it as required, we can import. We want to keep the menu required and import the field as part of the csv import.
The values from the database are:
<colgroup><col span="3" width="64"> <col width="194"> <col span="2" width="64"> </colgroup>
ID CUSTOMFIELD CUSTOMFIELDCONFIG PARENTOPTIONID customvalue
15486 10133 10163 NULL File Menu
15487 10133 10163 15486 Symbols > New...
15488 10133 10163 15486 Symbols > Load...

1 answer

1 accepted

Cascade select types are a bit of pain. There are 2 options for this. If you have any problems, open a support issue at JIRA Command Line Interface.

1. Use --common "--asCascadeSelect" on runFromCsvwith something like

action,project,type,summary,reporter,field,values
createIssue,VTP,TestCase,deleteme,john.smith,customfield_10133,"15486,15487"

2. Use --common "--asCascadeSelect" on runFromCsvwith something like

action,project,type,summary,reporter,field,values,issue
createIssue,zjiracli,task,deleteme,admin,
setFieldValue,,,,,customfield_10133,"15486,15487",@issue@

Thank you! I used the first example and added a comma between values and customerfiled_10133 and it worked.

Cheers mate!

Oops - I was having some cut/paste issues with the editor :(. That was extraneous data - you don't need (and shouldn't have) the custom field in the header line. I fixed the reference. Good job in getting it working anyway!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,006 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot