Importing values into a custom field via CSV

[Chima Abah]

Hi,

I have created a custom field "AD student group" which has a global configuration. I  want to import multiple values into that field for use in a project. I created a csv file like below:

Summary,AD Student Group
test,CEE Academic

I only need values in the AD student group column to be imported . However, when I try the import as csv or excel, the next button is greyed out. Any assiatnce will be appreciated.

Regards

[Trudy Claspill]

What screen are you on where the "Next" button is disabled?

Are you a JIRA Administrator importing the data through the System administration function for External System Import, or are you using the functionality available to an ordinary end user?

Are you trying to populate values into issues that already exist? If so, you must provide the Issue ID for each issue you are trying to update, and that sort of update to an existing issue through csv import can be done only by a JIRA Admin.

Also, is the field "AD Student Group" a multi-select field? And are "CEE" and "Academic" separate values? If you want to import multiple discrete values into a multi-select field then you need to have a column for each value you want to import with each of those columns having the same header, like this:

Summary,AD Student Group,AD Student Group
test,CEE,Academic

[Chima Abah]

Hi Trudy,

Thanks for your prompt response! Below is the screen I am referring to.

I am a JRA administrator using the external system import function. I created a new select-list (single choice) custom field to be used for screens in different issues. The list is quite long so I am trying to avoid having to manually populate the field. 

I saved it as CSV and even tried using the dummy line you created but I keep getting the same error: A jira Summary field mapping is required to enable import. Any ideas?

Regards

[Trudy Claspill]

When using Import to either create new issues or update existing issues there are some minimally required fields. Summary is one of those required fields. You will have to include Summary as an element in your CSV.

Are you trying to add the value to issues that already exist in your project? 

If so, then be advised whatever you include for the value of the Summary field will overwrite what already exists in the issue.

Also, you will need to include Issue Key as an element in your CSV and provide the issue key (i.e. XYZ-123) for each issue you are trying to update.

If you are not trying to update the field in already existing issue, please explain exactly what you are trying to accomplish by using the Import function.

[Chima Abah]

Hi Trudy,

Thank you for your reply.  I created a new select-list (single choice) custom field to be used for screens in different issues. I plan to populate the options list but the list is quite long so I am trying to avoid having to manually populate the options. Is there an option to populate it from a CSV?

Regards

[Trudy Claspill]

@Chima Abah 

No, unfortunately you cannot populate the options in a Custom Field definition through CSV import. The CSV import is for creating and updating issues in projects. Entering and updating issues through the UI would not allow you to add new values to a Single Select Custom Field, so you won't be able to do it through CSV import either.

You will have to enter the selection values through the Custom Field administration screen.

Alternately you can look at the REST API to see if there is an API for modifying the selection values available in a Custom Field definition.