Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Insight import CSV

Kay
Contributor
February 13, 2023 edited

I deleted an object type by accident. I got an older export, but I don't know how to import the following correctly. The last value of the CSV looks like this:

... ,ITSM-9997||ITSM-10033||ITSM-10074||ITSM-10043||ITSM-10063

In the import config I mapped the fields, but I have to add some AQL. When I do it like this it shows only one thing in the end for software, which even does not match any of the keys above. The keys map to obejcts in the object type "Software".

Bildschirmfoto 2023-02-13 um 21.10.47.png

When I try the AQL

Software IN (${Software${0}})

is says 

Invalid placeholders in the AQL for attribute Software & Access. Placeholder Software is not present as data locator

I just know objects types, objects and attributes here. What the hell are placeholders in this context, same for data locator... Why is it so confusing?

Thanks a lot!

1 answer

1 accepted

3 votes
Answer accepted
Riley Venable
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 13, 2023
You need to use the Object Mapping (Assets Query Language (AQL)) column to enter AQL that maps the label of the reference to a placeholder for the data locator. If you are mapping multiple references from the data, enter Label IN (${Locator${0}}) where Locator is replaced by the name of the Locator.
Kay
Contributor
February 14, 2023

Thank you for the reply. 

I am still struggling with the AQL. I have no clue what to set for Label or Locator. I tried different combinations but none of them worked. :-(

Like • 3 people like this
Kay
Contributor
February 14, 2023

Okay, this made the job:

Key IN (${Software & Access${0}})
Like • 2 people like this

Suggest an answer

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

Atlassian Community Events