How to bulk relate objects to an asset via CSV import

[James Malone]

Hello, 

I have an asset type in my schema with custom field called "dependencies". This field is an object field and links to other items in the schema. It is not set to unique and cardinality is maximum.

I am trying to bulk update this field via CSV. Each Asset will have multiple dependency objects. However when I run the import it only relates the first object in the csv not the subsequent objects. 

The CSV looks like this now after ROVO suggested using the || separator..

NAME,one
Security incident detection and monitoring,SCD-27911,SCD-26436||SCD-26437

[Marc -Devoteam-]

Hi @James Malone 

Welcome to the community.

You need to provide the workspace id and the id of the object, as follows workspace_id:object_id

As example: c31785fc-7034-4281-814c-47e16553bce7:213

See this KB for more information; bulk-update-assets-object-custom-fields-via-external-system-import 

[James Malone]

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..

[Marc -Devoteam-]

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

[James Malone]

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. 

[Marc -Devoteam-]

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:

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

[James Malone]

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..