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

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

Accepted answers

All comments

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.

Martin Luethi _Mobility Stream_

Hi @James Malone ,

I've worked with Jira Assets for quite a while, and in my experience CSV imports, especially for object reference fields with multiple values, can be tricky and sometimes produce unexpected results. I haven't tested this specific scenario recently, but it's possible the newer Assets Data Manager has improved support for these kinds of imports.

If your data follows a predictable pattern and you're mainly looking for an efficient way to populate object reference fields across a large set of Assets, there is another option.

We recently released Asset Manager for Jira, an app that lets you edit Jira Assets in a spreadsheet-like interface. You can filter down to the Assets you want, enter the dependencies on one row, and then copy, paste, or fill down across many Assets, similar to Excel. It works well for one-time or occasional bulk updates where many Assets share similar values.

It won't replace CSV imports in every situation, but for certain bulk-editing scenarios it's often much faster and easier.

Feel free to reach out if you'd like to see whether it would fit your use case.

Best regards,

Martin

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