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

[Matt Doar · Accepted solution]

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]

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.  

[Jordan Loverock]

You can also see the integer you need when you hover your mouse over the organization listed in your customers window. It's the last part of the URL shown in the bottom info bar of your browser.

[Amalishiya Robert Alexander]

Thank you so much! I was struggling with this today. Simple and working :)

[Johannes Rudolf]

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