How to bulk update issues with Asset Object values?

[Kiran Ya]

Hi, we accidentally deleted an Asset Object type which had 160 objects. We were able to get the backup and imported those Asset Objects.

However, custom fields with that Asset type were deleted from the issues when the Object type was deleted .

So now we have to bulk update the issues that are linked to those objects. 

We have a backup list of all the issues and the Asset type Custom field values. 

How can we bulk update the issues using that list? 

Btw, this scenario is on a data center version.

Thanks!

[Hannes Obweger - JXL for Jira]

Hi @Kiran Ya

welcome to the community!

Just to add to @Sagar Mahajan's great answer: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including Assets fields - much like you’d do in e.g. Excel or Google Sheets. You can also bulk edit your issue fields via copy/paste, like so (Inventory is an Assets field):

This works within JXL, but also between JXL and pretty much any other app (including Excel or Google Sheets). You can update any number of issues in one action, so I'd hope that this could save you quite a bit of time!

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Sagar Mahajan]

Hi @Kiran Ya Did you tried CSV import to bulk update the custom field values as you already have the issues list so you can you use the CSV import to bulk edit/update those issues.

https://confluence.atlassian.com/adminjiraserver/importing-data-from-csv-938847533.html