Importing values into a custom field via CSV

Question

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 P Claspill · Answer

@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.

Chima Abah · Answer

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 P Claspill · Answer

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.