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; } } }

Link objects directly during CSV import

Ann-Katrin

I plan to do a bulk import of various assets. I would like to assign the respective user to the assets directly during the import. I added my users via an AD export and CSV import.

Now I start with my assets.

Unfortunately, it is not possible for me to link the user who uses the asset directly to.

I don't want to have to do everything manually with over 4000 assets. I've already searched various sites, but I just can't get along with the AQL commands. I'm also slowly running out of ideas as to what else I could do to map two objects together

Everything I've tried doesn't work or the same user is written to every asset over and over again. 2023-02-23 07_39_19-Assets-Objektschema - Jira und 7 weitere Seiten - Geschäftlich – Microsoft Edge.png 2023-02-23 12_40_00-Objektschemakonfiguration - Jira und 14 weitere Seiten - Geschäftlich – Microsof.png 2023-02-23 11_58_53-Assets-Objektschema - Jira und 14 weitere Seiten - Geschäftlich – Microsoft Edg.png

Accepted answers

Kris Dewachter

Hi @Ann-Katrin ,

If i understand correctly, you are trying to link a user (which is stored in the object 'Mitarbeiter', to an object 'Smartphone'.

Normally, you should be able to link them via the 'UPN' which is defined as the unique key.

Can you also post here how you mapped this in the csv import?

Best regards,

Kris

All comments

Kris Dewachter

Hi @Ann-Katrin ,

If i understand correctly, you are trying to link a user (which is stored in the object 'Mitarbeiter', to an object 'Smartphone'.

Normally, you should be able to link them via the 'UPN' which is defined as the unique key.

Can you also post here how you mapped this in the csv import?

Best regards,

Kris

Ann-Katrin

Hi @Kris Dewachter

In my import file, I also have a column with the UPN attribute in the header.

Now when I define the mappings I get this notification that a reference AQL is needed. I have absolutely no idea where I can get the AQL reference from.

Kris Dewachter

Hi @Ann-Katrin ,

The AQL is used to lookup the corresponding object in order to make the link.

So in your case, the AOL you will probably have to enter will look like this:

Label=${UPN}

So when running your csv import, the system will create the 'Smartphone' objects.

It will use the UPN number from your csv file to lookup the corresponding user in the 'Mitarbeiter' objects. (This is what the AOL does. It will try to find a 'Mitarbeiter' with a label that matches the UPN number.

Hope this works,

Best regards,

Kris

Ann-Katrin

Hi @Kris Dewachter

i tired this - but what i get is

"Invalid placeholders in the AQL for the user attribute. Placeholder UPN does not exist as a data locator"

But i can't define a Placeholder at my "Mitarbeiter" attribute UPN

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management