Import CSV in Jira Assets - Issue linking objects between different schemas.

Giorgi Artsivadze, giorgi.artsivadze@space.ge
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 20, 2024

Good day,

We are migrating to Jira Assets and we would like to import our objects through CSV file.

In this CSV file we have multiple columns. 

Asset Name, Service Type Owner Email, Group Email, Owner, Description, Team Name, Lifecycle, URL.

I created a schema called Services. Including all of the corresponding attributes. Names are correct and there are no typos. 

CSV File is called "Services"
Schema where I want to import objects is called "Services"

I have a schema called "Service Type" in which I have 4 objects. Internal Service, External Service, GE External Service, Other External Service

We would like this import to assign objects from "Service Type" schema.

The "Service Type" column in CSV file contains upper mentioned entries. No typos, case sensitive. These are perfectly aligned with "Service Type" schema objects. 

When I go to Object Schema Configuration -> Import -> CSV all attributes are correctly created.

AQL statement: objectType == "Service Type"

Issue:

Basically, it imports everything else correctly but assigns the first object in Service Type schema only. So, all of the imported entries have for example "Other External Service" written while in CSV they are assigned different statuses. 

I tried changing up AQL statement but didn't get far. This is one of the entries I used "objectType = "Service Type" AND objectName = "Object Type"

I have checked spelling and names of everything multiple times. At this point I am thinking this is either a bug or a feature of sorts.

Any help will be appreciated!

1 answer

1 accepted

2 votes
Answer accepted
Jeroen Poismans
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2024

Hi and welcome to the Atlassian Community!

Seems like you're getting the AQL in the import wrong.

Say you have following Service Types (in the Service Type schema):

  • Name: TypeA, ID: 2
  • Name: TypeB, ID:3

Your input CSV might have an entry in column Service Type like "TypeA".

If you want to link to the Service Type schema in the import, you AQL would have to be something like:

objectType = "Service Type" and Name in (${Service Type})

where ${Service Type} is the column name in your input.

Regards

 

Giorgi Artsivadze, giorgi.artsivadze@space.ge
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 20, 2024

This worked! 

Thank you for specifying. I tried something like that but unfortunately, I didn't get the syntax correctly it seems like. 

Thanks a lot Jeroen!

Like Jeroen Poismans likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events