Automating Attributes

[Adam Long]

Hello! I apologize if this question has been asked before. 

Awhile ago, we've listed our devices with specialty software. We made an attribute slot for each applicable software that was installed on one's laptop. I'll attach a picture to make better sense of it. However, shortly after, Jira must've updated, because now we can put several software objects in one Attribute slot. 

And going forward, I apologize if I'm not labeling everything correctly. As you can guess, I'm extremely new to figuring this stuff out. 

So, as an example, I've set up a test Schema called "Assets Test"
In it is a schema tree for "Laptops" and "Software" software includes basic objects such as "email" "call" "cad" and under laptops we have "bill laptop" with attributes of "All Software" "Software 1" and "Software 2" There are objects in "Software 1" and "Software 2" however we want to automatically move all existing objects in the slots to "All Software". Making sure to not delete anything from Software 1 & 2 just in case something goes wrong. Again, I'll attach pictures so it makes more sense.

I'm having a lot of trouble working on the Automation Rule. I've come across this post here:
https://community.atlassian.com/forums/Jira-Service-Management/Add-multiple-objects-to-Object-field-using-Edit-Object/qaq-p/3121565
However, me being new, I'm having a hard time making sense of it all.

Any help at all would be GREATLY appreciated. Outside of the test schema there are several laptops and desktops that need stuff moved and going through and manually moving them will take forever.

If there is any further information I can provide that will help with this. Don't hesitate to let me know.
This is also done on the browser version of Jira. I believe with cloud service?
Thank you!

[Jeroen Poismans]

Hi and welcome to the community!

I will gladly help you with this, but can you elaborate with the screenshots, maybe also the more precise layout of your scheme, objecttypes ...?

At first glance, it looks to me that what you are trying to do is going to be easier with the import functionality, rather than automation. But again, let's have a deeper look at the setup?

Jeroen

[Adam Long]

Hello - thank you for getting back to me!

Hopefully these pictures help clear things up. These are examples set up in the test Schema we have. We currently have a lot of Desktops and Laptops set up with Software listings. In this example there is "Software 1" and "Software 2" But in our main schema it is "Specialty Software #1-20" And we want to get them all in to one spot. In this example that spot is "All Software" Since there are so many machines we would like something we could run that would do it for us automatically. We really only need it done once. 

We'll need the objects to remain in their previous spots as well just in case something goes wrong with the automation we don't end up losing everything we had logged. 

And just for scope, on top of the laptops and desktops, we have a Users sections with several licenses tied to them as well that we'd like to move. 



Thank you for your help!

[Jeroen Poismans]

Hi!

As I suspected its better to do this with an import. This is what I would do:

• Export the current objects
• Manipulates the csv so that you combine the separate fields for software into one, separating them with a double pipe "||". Call this column AllSoftware. In your example this would contain email||call.
• The Build an import where you map the identifier and populate the new "All Software field"

To map all values, separated by || into one field use this AQL:

Name IN (${AllSoftware${0}})

Where Name is the attribute on the software objecttype containing the name and AllSoftware is the column in your csv having the separated values. The source fields should not be mapped so they will remain untouched by the import.

This Community post explains this mechanism:
https://community.atlassian.com/forums/Jira-Service-Management/Import-multiple-values-into-single-field/qaq-p/2095081

More info about building an import:
https://support.atlassian.com/assets/docs/import-objects-into-asset-in-jira-service-management/

Good luck!