Jira Insight Import file with a reference to another object

[Tiago Ferreira]

Hello everyone,

Im trying to run a CSV import where a particular import field needs to match an existing object type in Jira Insight.

For example, I am importing a list of custom hardware items that my organisation manages, where one of the fields is Hardware version. All existing Hardware versions are managed in another object type already imported into Insight.

In the new object attributes, I have defined the hardware version attribute as an object type and selected the correct object type.

When doing the import mapping (for the CSV import), it asks me to include an AQL reference. In this specific case, I have tried Label IN ${"BEE Version"} ( and some other variations) but I always get the following error:

Invalid placeholders in the AQL for attribute BEE Version. Placeholder BEE Version is not present as data locator

Anyone has an idea on how I can solve this?

Thanks so much in advance!

[Tiago Ferreira · Accepted solution]

Found out the issue. The data locator actually refers to the CSV column. So, it is about mentioning the CSV column on the AQL field and not the attribute of the object you are trying to match.

A bit confusing, but I got there in the end!