csv import and links between objects

Heiko Lotz

I need help with importing csv files and linking objects.

I have two csv files: customers and (as a child of customers) employees of the customer:

Customer object Attributes:
Name (type standard, text), customer number (type standard, integer)

Employee object Attributes:
Employee name (type standard, text), CustomerNo (type standard, integer), Ref customer (type object, object customer, reference)

The customers were all imported via csv. When importing the employees, a link should now be created between the customers and the employees via the customer number (Customer) / CustomerNo (Employee).

I have mapped the fields when importing the employees via csv:

csv.name > employee name
csv.customer number > CustomerNo
csv.customer > Ref customer (AQL: CustomerNo ={CustomerNumber})

How can I ensure that the Ref customer field is linked to the customer during the import? I allready tried several AQL-statements but had no luck.: CustomerNo = CustomerNumber, CustomerNo = ${CustomerNumber}

I would be delighted to receive a tip.

Alex Koxaras -Relational-

Hi @Heiko Lotz and welcome to the community,

While using the AQL to bind objects you have to keep this in mind. E.g. you have this AQL:

CustomerNo =${CustomerNumber}

CustomerNo should be the insight attribute and

CustomerNumber should be the column name of your csv.

That would be the case for 1-to-1 mapping. Make the corrections and try again. Let me know how it went.