Linking assets objects using CSV

[Douglas Henrique Braun]

Hello,

I'm struggling with the AQL while attempting to import a CSV file that needs to connect the Employee with an object Laptop.

I have the following Schema Tree

•  Laptops
  • MacOS
  • Windows
• Employee

As attributes for MacOS, I have the identifier Label named Serial Number.

As an object attribute for my Employee, I have the "Laptop Apple".

My CSV file contains the following:

Username, Email, Serial Laptop
d.braun, dbraun@email.com, XXXX123XXXX

While importing, I'm getting the message: Invalid placeholders in the AQL for attribute Laptop Apple

I'm pretty sure that my AQL at the import attributes mapping is wrong, but I'm unable to figure out the correct AQL.

Thanks in advance

[Fabian Lim · Accepted solution]

Hi @Douglas Henrique Braun

Welcome to the community!

Can you share the mapping you are using for your laptop for the import?  And also the a screenshot of the laptop's attributes and the employee's attributes?

Cheers

[Douglas Henrique Braun]

Hey Fabian,

I may have ended by finding the solution right after posting by stressing a bit more about the solution.

Indeed, my problem was with the AQL that I was trying to use the label name instead of the Label itself. By changing that, everything worked as expected.

[Douglas Henrique Braun]

Just sharing, using

• Label = ${Serial Number}

where Serial Number, in my case, is the column identifier on my CSV file worked.