Database import: Attribute transfer based on the product ID

[Marko Otholt]

I have a database import. It involves two tables. In one table the product is established (product cataloge): In this case, the attribute of the type designation of the server. The server item, i.e. the actual server, is stored in the second table.

This server has the ID 100 and refers in the data record to the product and service catalogue, with the product ID 1. However, I do not need the ID, but the type designation from the product catalogue.

How can I tell the system during import, that it should write the type designation of the Product (ID 1) for the server (ID 100) in the "Tpe of server" attribute?

Is there a way to implement this?

[Kai Becker · Accepted solution]

Hi @Marko Otholt 

welcome to the community and thank you for your question. 
You will need to map the data to the corresponding type and also add filtering in the import configuration.

Here is a detailed guide on how to setup a referenced import: https://confluence.atlassian.com/jirakb/how-to-import-assets-object-types-with-attributes-referencing-existing-objects-1095240988.html 

Hope this helps. 

[Marko Otholt]

Many thanks for the friendly welcome. I have already read the link and unfortunately it didn't help me. Pictures often say more than words, so I'll try again with a picture. We have also used CSV for imports in the past, but I have to say that it was not always stable, so we switched to the DB interface. A link to the product catalogue is also no problem, but I would like to use some attributes from the other table during import, e.g. to fill the server label with the manufacturer name and also the types, so that the name is more descriptive. I hope that someone has an idea how I can handle this case. Thank you for your time and effort.

[Kai Becker]

Hi @Marko Otholt 

sorry for not getting back to you earlier. Is this still an issue?

I'm still not a hundred percent sure if I got your problem right, but shouldn't you be able to update the import statement with a JOIN, to get data from both tables?

After that you should be able to use aql on the attribute mapping screen, to filter out the specific object for the type attribute based on the value from the join.

Actually I haven't done that before but I guess that should work.