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. 

 

[Evgenii · Accepted solution]

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!

[Evgenii]

You can test Regular Expressions here:

https://regex101.com/