nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database import: Attribute transfer based on the product ID

Marko Otholt_11l5gk

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?

Accepted answers

Kai Becker

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.

All comments

Kai Becker

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_11l5gk

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

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

data-center

jira-service-management

jira-service-management-data-center