nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Java Core, Adding +100 items to a custom field list

eto strike

Hi ,

I want to be able to create a custom field list where I can select one room from over 100 when I create a new issue.

Each room has a specific name. I have an excel list of the room names, is there anyway I can import this instead of adding them one by one when I create the custom field.

I am only evaluating java core at the moment and haven't decided if cloud based or inhouse would be better so if I can get in via a backdoor if I set it up on my own server to add lists like this let me know.

Accepted answers

All comments

Steven Meadows (e-Core)

There are multiple add ons which can help with this. You could install Scriptrunner which has a 'Bulk Import Custom Field Values' feature.

https://scriptrunner.adaptavist.com/latest/jira/builtin-scripts.html#_bulk_import_custom_field_values should help you to achieve this.

Custom Field Value Importer can also handle this (for Server).

eto strike

Thanks, I will take a look

eto strike

Can you suggest any other addons, when I try script runner as a demo 'bulk import custom filed values' is not provided as a built in script.

Nic Brough -Adaptavist-

There's another hack that requires no clever code.

Create a "scraps" project. I usually giv it a name people will never want to use for real projects, and a permission scheme that is "administrator only"

Create a spreadsheet with two columns. One column contains the options, the other column should contain something unique to each line (frankly, just use the options column again, it's easiest). Save the file as CSV

Configure the project so that it uses your custom field for the default issue type

Go to Admin -> CSV import, and import it, mapping one column to "summary" and the other to your custom field. Tell the import to create new options.

If you're bothered, deleted the new issues you've just created.

eto strike

Hi Nic, thanks for the quick reply,:) I have tried what you said but unsure how I

'Tell the import to create new options.' for my custom field?

There doesn't seem to be anywhere to select 'create new options,' it rejects any new values. from my csv.

I have a custom field called 'position' that I am trying to populate with approx 100 room names.

eto strike

I get the following error for each position I try to import

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

Nic Brough -Adaptavist-

Odd, I get a "add new" when I do it. You are a system admin?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira