How to import multiple objects into an object attribute

[Eric Templeton]

I am using object attributes to link objects in Assets.

• I have created an object type for users
• In the "Application" object type, I have a "Stakeholders (Linked)" (object) attribute linked back to the users object type.
• I have "Stakeholders (Linked)" cardinality set to max.
• I can populate the attribute manually with no issues, choosing as many users as needed
• When I export, all Stakeholders are listed, separated by ||
• When I attempt to import following the same format I get no results
• Import AQL mapping: "Stakeholders (Linked)" IN (${Stakeholders (Linked)})

Can someone help me figure out how to get multiple objects into an object attribute?

[Benjamin Črnjak · Accepted solution]

Hi Eric,

instead of AQL you've provided "Stakeholders (Linked)" IN (${Stakeholders (Linked)})

try this: 

So I'm not sure what naming you are using, but first column is name of the column in CSV, 2nd one is name of attribute and the last one is AQL for that.

Try to adjust your AQL according to your naming, and replace Label field name with name of the label field attribute of a related object.

Leave CSV file as it is. Use "||" between multiple values without spaces. I've tested it and it worked for me.

hope that helps.

Benjamin

[Eric Templeton]

Thanks Benjamin! This worked perfectly!