How can I add a single picklist field with 5000 options in jira

[Bunny]

Hi Everyone,

Good Morning,

I have a situation where I need to add a single Picklist field with 5000 values.

The way i have it set up right now is I have a plugin, Database Custom Fields. The plugin is connected to our Oracle Database. I have created a custom Database field (Mapped to the proper table to get the values)where I can pull the values to the field.

I want to get rid of the plugin and have the field and its values in Jira itself. What are my options to do so.

Any help appreciated.

Thanks,

Bhanu

[Mohamed Benziane]

Hello, you can use a CSV file here the link https://confluence.atlassian.com/jirakb/how-to-bulk-import-custom-field-values-for-certain-types-of-custom-field-827123935.html

For informations in you csv fil, a colum summary is mandatory.

the csv have to look like this:

summary,value1

test,foo

test1,bar

etc

go to system>external system import>csv>choose your file>next>select your project>next>map summary and the value from you file. 

Hope it will help