Copy text field value to asset field

Question

We are on Jira Data Center and we are looking to copy a text field to an Asset field. We do have ScriptRunner if we need to utilize that.  I tried using ScriptRunner's Copy Field Value and also a CSV import to copy the data but neither worked.

Hannes Obweger - JXL for Jira · Answer

Hi @Kristin Lyons

depending on your exact use case, 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 asset fields - much like you’d do in e.g. Excel or Google Sheets. It also allows bulk editing your issue fields via copy/paste. This works within your fields in JXL, but also across fields, and even across fields of different types. This is how it looks in action:

In the above clip, Inventory is an assets field, and Notes is a text field. As you can see, JXL successfully maps the text to asset objects - it really only requires the text items to "match" assets.

This works for any number of issues per action, so assuming that your data is generally valid, you should be done in no time. If your data doesn't quite match, you can also copy the text to e.g. Excel, make any changes there, and then copy back into JXL.

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

Kristin Lyons_j0hwd4 · Answer

This actually looks incredibly helpful.  Is it possible to find the text field and then match it automatically with the Asset?

Kristin Lyons_j0hwd4 · Answer

* We want to change all data in the former text field to the asset field, the assets should have all the options available that were used in the text field.
* We are using Object Type and default/text for the type and type value