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

What do you set for the mapping of a reference attribute when performing a Jira Assets CSV import?

David Quiram

I am planning on mass importing assets via CSV. One of the attributes we have setup in our object type is a reference to another object in a different schema.

When setting up the attribute mapping, the field tells me: "When specifying an attribute referencing to another object the reference AQL must be supplied"

The documentation provided isn't super specific on how to go about figuring this step out.

Accepted answers

Riley Venable

You can use the Object Mapping (Assets Query Language (AQL)) column to enter AQL that maps the label of the reference to a placeholder for the data locator. If you are mapping only one reference from the data, enter Label = ${Locator} where Locator is replaced by the name of the Locator. If you are mapping multiple references from the data, enter Label IN (${Locator${0}}) where Locator is replaced by the name of the Locator.

All comments

Riley Venable

David Quiram

Thank you for this information. I didn't get notified to your response, so I had opened a case with support asking the same question.

The problem with the documentation and your answer is that "Label" and "Locator" don't really tell me much contextually. Saying "Locator is replaced by the name of the Locator" is basically self-referencing and not very descriptive. I'm sorry if I'm ignorant of Jira vocabulary standards if those terms are common knowledge.

The support agent was able to put it into different terminology that made so much more sense to me.

AQL should be "Attribute Name from the schema you are linking to" = ${Header Name used in CSV}

Alan Williams_7346rl

How would this look if the attribute were in a different shared schema?

David Quiram

@Alan Williams It would be the same. When you setup the attribute, that's where you establish the link to the other schema.

The CSV upload feature only cares about the data and that it can match it to a record via the link that was established.

If that didn't address your question, provide more context and I might be able to give you a better answer.

Simon Sahli

Just to clarify with an example, which might help some.

Usually you will use an AQL like Name =${Type} for the case where you want to link to an object, since you look for the Name of the object.
So in this case I look for the name of the type in the "data source field", which is the import file (.csv or whatever).
Just try this with your attribute name for "Type":

Michael diLorenzo_wo0emp

None of you make any sense lol. I guess I'll open my own ticket with the Jira folks.

Michael diLorenzo_wo0emp

None of these answers makes any sense to me.

I have a .csv of laptop assets. One of the columns is "Model." In Jira, I have these object types:

Computer Models - has an attribute called "Name." This is the model name of the computer.

Laptops - has an attribute called "Model," which is a reference to the Computer Model object type.

I want to import the .csv, and I want the Model field from the .csv to populate the Model attribute of the Laptop, but actually create a reference to the Computer Model object type.

Right now, I have created another attribute called "Model (Text)," which is a plain text field. I import the csv by mapping the Model column of the .csv to the Model (Text) attribute. That way I can at least see what the model is. But I'd like to actually create the object reference in Laptops.

What would be the AQL for this?

David Quiram

I would think your AQL would be as follows: Name = ${Model}

Now, to be clear, this will not create the entries in your Computer Models object. You have to create those yourself so that when you import your laptops the system can find the corresponding entry that you are referencing in your CSV.

Michael diLorenzo_wo0emp

Yep, that was it, thanks. I found it on Reddit just before you answered. :-)

Welcome!

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

Quick Links

Find more posts tagged with

cloud

atl-gruland

jira-service-management-cloud

jira-service-management