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

not able to import organization and request type

SD Admin Apr 17, 2018

Hi,

I tested with the cloud external system import tool and using the csv file format for service_desk project type.

The organization & request type fail to import. Checked the setting are correctly spelled. Does anyone encounter this warning message before? What have I miss? Thanks

Pls. refer below import log,

=======================================================

WARN - Cannot add value [ [OrganizationABC] ] to CustomField Organizations in Issue with summary 'CR-002': For input string: "OrganizationABC"

WARN - Cannot add value [ [Time] ] to CustomField Request Type in Issue with summary 'CR-002'. Probably value was in incorrect format

=====================================================

2 answers

0 votes
Micky CARITTE Community Leader Apr 24, 2018

Hi Angeline!

Hope you're doing great!

It's "known" that Service Desk stores Request Type and other fields in a "proprietary" format. There's an open Bug (with a workaround) for Request type here:

https://jira.atlassian.com/browse/JSDCLOUD-1335

I'm pretty sure (but ca't find the query) you can achieve the same for Organizations. As soon as you know the IDs, you can use them! Another option is to create a request with the type you want and the organization you want, and check the custom fields values in DB to get their storage format!

Hope this helps!

Cheers

0 votes
Jeffrey Bauer Aug 31, 2018

I found a way to get the internal names for the request types that doesn't require submitting a ticket with Atlassian.

  1. Create a sample issue for each of your Jira Service Desk request types on your project.
  2. Create a report that returns the issues you just created.
  3. Use the download icon in the top right corner of the report (hover labeled "Export this filter in another format") and download the list using the "Export Excel CSV (all fields)" option.
  4. Open up the CSV and find the field named "Custom field (Request Type)".

The rows contain the internal name of the custom field for each request type. They are in the form "<project_label><GUID>".

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira Service Desk

4 changes to queues and issues you don’t want to miss

Hello Atlassian Community! I'm Tania, a Senior Product Marketing Manager for Jira Service Desk Cloud! I'm excited to announce some exciting improvements coming up for those who work with queues and...

447 views 8 8
Read article

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