Asset import from CSV does not link to employee objects

[Cayce Hengeveld]

I am trying to import data on assets (laptops) from a CSV file. The "name" data on the end user stores correctly when storing it as text, but when trying to store the data as a reference to an object, it does not store.

The column in my CSV file has the header "Owner" and the destination attribute is "Assigned to", with the link being via the Name field of the user (Employee object) I have tried every possible permutation in AQL, but none seem to stick. This is the current AQL:

Name=${Owner}

Can someone help me resolve this please?

[Dave Mathijs]

Hi @Cayce Hengeveld welcome to the Atlassian Community!

Maybe this article can get you started: Prepare your data for importing into Assets

[Cayce Hengeveld]

I have reviewed this article prior to posting my question. However, following the instructions exactly (adapted for different column headers) did not resolve my issue.

[Dave Mathijs]

What is the name of the Object Type you're mapping the CSV column value to? Is it also Owner?

[Cayce Hengeveld]

Object Type is Employee, the attribute of that object I am trying to use is Name

[Dave Mathijs]

Does Name=${Employee} work?

[Cayce Hengeveld]

I get this error message: Invalid placeholders in the AQL for attribute Assigned to. Placeholder Employee is not present as data locator