Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,500
Community Members
 
Community Events
176
Community Groups

how to import values for dropdown field?

We are moving from Rally to Jira and I want to create custom fields in Jira that will have values that we currently use. Is there a way, through an API or other interface, that I can populate these dropdowns? Adding values one at a time from the UI will be very time consuming

3 answers

1 accepted

1 vote
Answer accepted

Hi @Karen Gwynn - if you want to do this using the built-in "External System Import" feature in Jira, then I think your CSV file needs to have each option for the <Application Area> field in a different row; your example file seems to have all the import values on the same row.

Header: Summary,Application Area,Application Area,Application Area
Row: Sample Issue,Account Administration,APIs & ODBC Views,Archive Feature for DCB Objects

 


The steps I follow for bulk uploading into a single-select dropdown field is:

 

1) Create the custom field in Jira and manually add one of the required values (or a dummy value) to the list of options.

 

2) Prep the CSV file containing all the other values you want to bulk import, eg:

 Capture1.JPG

 

3) Import the CSV file using the "External System Import" feature under Settings > System > Import and Export

Capture2.JPG

 

Example of the dropdown list with the imported values:

 

Capture3.JPG

That worked! I think the thing I was missing previously was to create at least one value in the custom field before importing.

Thanks so much! This will help us tremendously

Like John Funk likes this

This is what I did: created a custom field (named Application Area) of type dropdown (single select). Added the field to all Issues types where I want it.

Following the instructions in Importing data from CSV, I created a CSV with the following headings

Header: Summary,Application Area,Application Area,Application Area

Row:      Sample Issue,Account Administration,APIs & ODBC Views,Archive Feature for DCB Objects

Used the Import Wizard, mapping Application Area to my custom field and Summary to Summary

Ran the import

Result: one Issue but no values for the custom field.

 

Please let me know what I need to do differently.

 

Thanks

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events