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; } } }

How to set Organization field per issue with CSV import for Jira Service Desk

Glemser JIRA Admin

Hello Atlassian team,

I'm attempting to migrate data via a CSV file and set the organization based on a single column "Organizations". If I add the organization by name, I get the following error:

Cannot add value [ [Glemser Test] ] to CustomField Organizations in Issue with summary 'Mobic Oral Suspension V2': For input string: "Glemser Test"

"Glemser Test" is a defined organization name for this project but it doesn't seem to be able to link the organization based on it's name. Additionally, though Organizations is listed as a "CustomField", it is setup on project creation and has security implications built into Jira Service Desk. It is important that we are able to import this field via csv as we have over a thousand tickets that need to be in one of four different organizations.

Thanks for any help,
-Matt

Accepted answers

Matt Doar_tzgiej

Take a look at a ticket that already uses that Organization value. Use Export, XML in regular Jira and see what value it is using. Try that value in the CSV import perhaps

All comments

Matt Doar_tzgiej

Take a look at a ticket that already uses that Organization value. Use Export, XML in regular Jira and see what value it is using. Try that value in the CSV import perhaps

Glemser JIRA Admin

I was struggling hard to find the export to csv option from the individual project window. Your response set me back on that path and helped me get the correct identifier. Thank you for your help!!

Matt Doar_tzgiej

Glad to hear it. What did the identifier look like in the end?

Glemser JIRA Admin

It's an integer. It seems like they increment based on your instance. For my test files and test organizations I was importing it was 13 and 14 which seems about right given the number of other organizations on other products I have. I also made one after the other.

The only way I could find to retrieve the integer value was to set the organization to an issue and export the issues to a csv. It's a bit round about, but it works. Thanks again for your help. Sorry for the late response.

Johannes Rudolf_ep01hv

Great! Many thanks for your efforts and for sharing! It has helped a lot.

Welcome!

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

Quick Links

Find more posts tagged with

jira-service-desk