Importing cascading field using CSV file in Jira

Importing data with cascading fields into Jira via CSV is tricky due to the hierarchical nature of the field, but it's not impossible and below steps will help you how to import the cascading field data into Jira using using CSV file.

Prepare Your CSV File --> Make sure your CSV file has all the necessary fields for your Jira issues, like Issue key, Issue Summary, Cascading field, etc
The cascading field need to represent in a single column
Each value in the cascading field need to be separated by the appropriate delimiter like (->, =>, >). The default delimiter in Jira is usually ">".

If not sure about the format then export the test data --> Create a test issue with the cascading field data, export this issue in CSV format and you will able to see the structure of the field in CSV format.

Construct the Cascading Field --> In your CSV file, make sure that each value in the cascading field follows the hierarchy, separated by the delimiter. (->, =>, >)
For example, if your cascading field has levels like "opt 1 > opt 2", then in CSV file it will be shown as "opt 1 > opt 2".

Import the CSV file Jira --> Navigate to Issues > Import Issues from CSV.
Map the fields, and import the data

Review the import result --> After the import, review the imported issues to confirm if everything imported as expected.

The important steps while importing the cascading is the constructing the field values in the CSV file and mapping it to the correct type of the field in Jira

 

Below is the sample example for migrating the two issues having cascading field values.

Capture 2024-02-23 at 9.28.26.pngCapture 2024-02-23 at 9.26.10.png

Capture 2024-02-23 at 9.28.53.png

Capture 2024-02-23 at 9.42.33.png

Capture 2024-02-23 at 9.47.12.png

Capture 2024-02-23 at 9.48.41.png

Capture 2024-02-23 at 10.12.29.pngCapture 2024-02-23 at 10.11.58.png

5 comments

Pramodh M
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 22, 2024

Hi Sagar,

Great Article. 

Can you please incorporate an example and may be screenshots to make it more intuitive, and this would help beginners

Thanks,

Pramodh

Sagar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 22, 2024

Hi @Pramodh M Sure, I have added a screenshots of the sample data import to get more understanding.

Pramodh M
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 22, 2024

Thanks @Sagar It looks great

Cristea Marinescu
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 27, 2024

Jira Cloud,
It just works for the parent field without children. Tried all combinations (->, =>, >)

Like # people like this
Damon Chow
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 1, 2024

Same for me, It runs and says no issues/errors but only the parent field (opt1) of the two is added 

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events