It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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

1 answer

1 accepted

2 votes
Answer accepted

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

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!!

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

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.  

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Service Desk

Tell us how you've implemented Change Management

Hello Community 👋, I'm a product manager at Atlassian, looking at improving change management capabilities across our products. In particular, we're looking at bridging the gap between Dev & ...

280 views 0 5
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you