How to bulk relate objects to an asset via CSV import

Ok, CSV now looks like this..

NAME,one
Security incident detection and monitoring,8e79e1ec-032d-45e0-92ba-fef72254a81a:26437
Security incident detection and monitoring,8e79e1ec-032d-45e0-92ba-fef72254a81a:27036

However it still only relates the first object in the list. Added a couple of screenshots..

Hi @James Malone 

Try it as follows, as this is behaviour that is normal for multi-select fields.

Name,one,one
Security incident detection and monitoring,8e79e1ec-032d-45e0-92ba-fef72254a81a:27036,8e79e1ec-032d-45e0-92ba-fef72254a81a:26437

I'm afraid that still only relates the first object. BTW I'm removing the current linked object from the asset before I run the imports so I know the import is sorta working. 

Thanks for trying to help btw, its much appreciated. 

Hi @James Malone 

The || option on importing is on importing multiple options in an asset object, but not in a custom asset field in a Jira work item.

What happens if you use, see semi colon (;) between the asset objects:

No dice I'm afraid. 

I've found this question which is the same as what I'm trying to achieve. I've followed their solution and updated the import to use the AQL and the CSV to use the || separator but it still only imports the first object in the list. I'm starting to think there's a bug here. 

Solved: How to import CSV on JSM ASSET with multiple Asse...

here's my current import using the AQL suggested..

Hi @James Malone 

I think there has been a misunderstanding.

You want to import assets objects into a schema and use these assets in Jira work items.

You can use || then, but don't use spaces, use value1||value2

See this KB, how-to-import-assets-object-types-with-attributes-referencing-existing-objects 

You need to use the name of the reference not One, as this is the attribute that show the depended options.

Correct, I already have the schema and it is populated with assets. I want to bulk update the "dependencies" of one asset type so that they relate to another. Basically I want to bulk link what we call "Business Services" to "Applications" in my schema. There will be a 1 to many relationship.

There are no spaces in my CSV and my AQL now looks like the insructions.

I raised a ticket with support and they suggested adding || to the Concatenator field in the advanced mapping option but that hasn't helped either. Still only relates the first asset in the list within the CSV. 

Hi @James Malone 

I think you are using the reference in the import wrong.

I think the advanced clause needs to be Label IN (${one${0}}), if one is the name of you column in the csv containing the names of the objects you want to reference.

You can't use the keys of these objects.

Thanks for the continued suggestions. Changing Key to Label results in no objects being related rather than the first as before. I presume because I don't have a label field on my Assets. I even replaced the keys with the object names in the CSV as I thought label might relate to that but that didn't work either.  

Hi @James Malone 

Label is by default set to the Name attribute of the object you want to reference, so the objects you want to see in attribute one. you.

See the explanation in https://community.atlassian.com/forums/Jira-Service-Management/How-to-import-CSV-on-JSM-ASSET-with-multiple-Asset-on-one/qaq-p/2921492

You have created attribute "one" in a schema, this is a object attribute, so it references another attribute in another or the same schema.

The column in the CSV "one" is the reference, but check the objects you are referencing, what attribute has the label icon?

Thanks. As I said I replaced the keys with the names in the CSV and used Label in the AQL but still not working correctly. Atlassian support have escalated to their engineering team as they cannot see why this isn't working either.