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

[Giorgi Artsivadze, giorgi.artsivadze@space.ge]

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!

[Jeroen Poismans · Accepted solution]

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]

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!