Managing custom fields via data (CSV) Import.

[Виктор Островкский]

Hi for all!

I need to create a multi select custom field..

The number of options in this custom field will be up to 80...

Q: Are any functionality which I can use to import a list of custom field options into Jira?

[Nir Haimov]

Hi,

You can create all 80 values without add-on by using the import issues by CSV.

generate your self new CSV file with 3 columns:

1. issuetype
2. summary
3. your-customfield

Create 80 raws in your excel, for exmaple:

Task     summary 1     value 1 (your actual value)

Task     summary 2     value 2 (your actual value)

Task     summary 3     value 3 (your actual value)

Task     summary 4     value 4 (your actual value)

Task     summary 5     value 5 (your actual value)

And so on....

Use the import issues with CSV, it will create you 80 issues, but the values you put in the column of your customfield, will be updated as values in your Jira.

So after import the CSV simply delete the 80 issues and you don't really need them, you use this only for update field values.

[Виктор Островкский]

Hi, Nir!

I'm sorry, but it is not working with my Jira :(

The validation process has found 3 warning/s

• The value [ {null=a2} ] can't be added to the Custom Field [ Certifications ]. The value [ {null=a2} ] can't be found or is in the incorrect format
• The value [ {null=b1} ] can't be added to the Custom Field [ Certifications ]. The value [ {null=b1} ] can't be found or is in the incorrect format
• The value [ {null=b2} ] can't be added to the Custom Field [ Certifications ]. The value [ {null=b2} ] can't be found or is in the incorrect format

[Nir Haimov]

Can you please send here screen shot of your CSV file?

[Виктор Островкский]

[Nir Haimov]

i think you are doing something wrong in the import wizard..
Can you upload short video of your steps?
mapping fields and values

[Виктор Островкский]

[Nir Haimov]

I need also the screen before "Map Values"
when you map the fields of the excel to the fields in Jira

[Виктор Островкский]

Nir, it is enough or i must share something additionally?

[Виктор Островкский]

[Nir Haimov]

OK,

Try this instead:

Summary      Certifications      Certifications      Certifications

     1                     a1                       a2                     b1

[Nir Haimov]

So you will have only 1 line of headers and 1 line of input

[Виктор Островкский]

The truth is nearby :) but new error

[Nir Haimov]

That is strange, it thinks you are passing "None" as value, but you are not.

Never seen this error.

I will try to ask another community champions to help here.

[Deleted user]

Hi @Виктор Островкский,

To achieve this functionality you can use JIRA Command Line Interface(CLI) add-on. You can find some of the examples from the Examples page.

To create the multi-select custom field you need to use the addCustomField parameter action. To add values to the multi-select custom field, you need to use runFromCsv parameter action. You can go through the How to use runFromCsv page.

Regards,
Kishore Kumar Gangavath.

[Виктор Островкский]

Hello, Kumar!

Thank you for your reply!

Would you be so kind to support me with applying runFromCsv parameter action?

If my multi-select custom field name is "Certifications",

And if I have csv file (comma-separated values) with list of options:

a1
a2
b1
b2

Please, suggest me a right order of actions with CLI add-on if i want to import up-mentioned options into  "Certifications" field.

Thank you very much in advance!