Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bulk import custom field values

I have a list of more than 500 values to be add in "Select List (Single Choice)" custom field.

I have tried adding by import issues using CSV file and mapping the Custom field name to the values but its throwing an error:

The value [ {null=Test 2} ] can't be added to the Custom Field. The value [ {null=Test 2} ] can't be found or is in the incorrect format

Scriprunner option is also not available for free.

I am using Jira Cloud free option as of now exploring the possibility to automate a process.

Is there any other option to get this done.

2 answers

Hi Jitesh,

To be honest, it is not a good idea to have so many values as it will impact performance. Is there any specific reason that you need this many values? Can it be done in another way? 

That being said, you should check the REST API.



Its a list of items based on which next course of action will be decided.

Not sure if there is a better way other than, putting it under choice dropdown values, as we don't want type errors in the selection.

Curt Holley Community Leader Jan 09, 2022

Have I got this right.. you want a list of over 500 options placed into a single choice select list, that is based on (over 500) options for the "next course of action" of something.

How many of these options would ever be selected? How many stories/issues will ever have any selected?

A list of over 500 anything should not be loaded in any one field, I would argue.

Sounds more like a confluence page to me. From there the options that are going to be the next course of action can be curated and then the shortlist added to a Jira field.

Alternatively, if you believe all will be actioned at some point, why not make them tasks? As seeing you are intending making them a single select filed, any Jira issue could only pertain to one option anyway, By doing it this way you could load them via CSV via the import issues functionality.

The workflow which I am exploring is to get automation Training lifecycle.

We have a requestor IDelivery Team) we have Training team and we have COEs / SMEs.

We have two drop downs one for customer (500 + values) and another for Skills (1000 + values) Customer field will guide to whom the ticket should be assigned (SMEs teams) for recommendations and  Skills will tell SMEs team what should be the recommendations. 

I've not worked on or explored Confluence yet.

Curt Holley Community Leader Jan 11, 2022

Do the "customers" have a Jira license? If so, you could make use of a User Picker field.
If not, I would recommend grouping them and adding those groups to a picklist.

Same for the skills, as you definitely do not want a picklist with over 1000 entries.

As @Dave Bosman _Realdolmen_ has suggested, these two fields could be really sluggish re performance.

Actually, just remembered. You are using a free Jira plan, so you have less than 10 licensed users. So my initial question is redundant. Which leads me to; This seems to be a very scaled desire, for a Jira set-up used by such a small number of people.  

As mentioned I am exploring the possibility of using Jira that's why I am using a free version. once I share a POC we will go for a licensed version as well. I will try to explore various options shared. Thanks to @Curt Holley and @Dave Bosman _Realdolmen_ for your suggestions.

Like Curt Holley likes this

Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Work Management

Lessons from Vilius Zigmantas’ path to Continuous Process Improvement at GeoComply

  “Organizations are made of people who create and follow processes which are constantly changing and are in need to be supported and nurtured… this is the spot where I realized I can br...

1,726 views 9 19
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you