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

Asset CSV Import AQL question

Dennis Mattei

Hey All!

I am trying to import into Assets and I have objects that are Offices like "HQ" and "CA Office", I do have the address for "HQ" in there as "1 Main Street CITY STATE ZIP"

I am trying to import a CSV of people and map the office location, some users have "1 Main street" some have "main street CITY ZIP", I realize I may have to do some data clean up but Im trying to figure out how to get the AQL to match.

I had some minor luck using the anyattribute. Its very hard to test by making a change and importing and checking.

Accepted answers

Evgenii

Haven't used Assets for Cloud, but if there is an opportunity to use regexp in import, you can try it.

It is usually configured in mapping of columns from file and object attributes.

All comments

Evgenii

Haven't used Assets for Cloud, but if there is an opportunity to use regexp in import, you can try it.

It is usually configured in mapping of columns from file and object attributes.

Dennis Mattei

Thanks! I don't think I have that option

I have tweaked my CSV so that the building is the same as the name of the office location, so this AQL is working, but obviously having to do manual intervention is not ideal.

Name = ${Building}

Evgenii

I see column "Regular Expression". It's what I was talking about.

And another hint: you can use Name LIKE ${Building}, it is more wider choice, then = or ==

Dennis Mattei

Wow! any closer right? I feel silly. I will look into that. Im not sure what they accept, but I assume the documentation will point me in the right direction. Thanks!

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