Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Database import: Attribute transfer based on the product ID

Marko Otholt
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 28, 2024

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?

1 answer

0 votes
Kai Becker
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 28, 2024

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 29, 2024

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.Screenshot 2024-02-29 125115.png

Kai Becker
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 2, 2024

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events