The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Import Options for Single Choice Field from Excel

Razmik Mikayelyan
February 11, 2022

I have 700+ options for a custom field in excel, can you suggest any scriptrunner option or something else so that I would not type these options manually, but import them from a file

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Thomas Opiolka - codefortynine
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 12, 2022

Another option would be to use the app External Data for Jira Fields. One of the main features is the synchronisation of field options from an external data source.

You can use a fixed CSV file as a data source and import you data that way. In case the excel list changes in the future you have an easy way to resync the data without much effort.

I hope this helps,

Thomas

Disclaimer: I am the product manager of the app.

0 votes
Radek Dostál
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 11, 2022

ScriptRunner has a built-in script called something like "Import custom field options" - you would just need to select the field, the context, and then copy the values over to a text prompt and it will create those options.

0 votes
Guilhem Dupuy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 11, 2022

Hello @Razmik Mikayelyan ,

You can achieve that by doing a csv import of issues in Jira which includes all of your field values, and selecting the option for adding the unknown values at the existing ones.

Let me know if it helps, 

Guilhem

Comments for this post are closed

Community moderators have prevented the ability to post new answers.