How to update Alarm Priorities for all tags from a .CSV file

I get totally lost with all the Ignition scripting, and have run into a major issue. Finishing up an iFix to Ignition upgrade for customer. Now they decide to have different alarm priorities for their alarms (wanted all alarms the same initially). Gateway tags are a mix of UDT instances and individual tags. Customer provided an Excel sheet with the priority indications for tags:

Can someone shed some light on a method to iterate through all the tags in the dictionary, compare that tagname to the TagPath in the Excel file and dynamically update the alarm Priority? My issue is that all the discrete alarms have an alarm name of just "Alarm", but the analog tags with alarms have "High High", "High", etc.

I really don't want to have to "manually" go through 2700 tags to update them individually. I am very limited in my scripting ability so far. Their system is actually "live" now and in production, so don't want to do anything drastic to possibly affect plant performance.

Any suggestions/guidance is greatly appreciated!!

Here's the biggest issue you'll have, if you change the alarm priority for a UDT instance, either by hand or programmatically, it will override the entire alarm which then makes the UDT useless IMO.

IA, Travis Cox, released an alarm rationalization project available on the exchange. This might be helpful for you.

Link to exchange resource, Ignition Exchange | Inductive Automation

1 Like

This. A colleague recently learnt this the hard way.
You could create UDT params for each of your alarms and bind the alarm prioritiea to them, but that's a bit crap.. There's not really a good way to do it though

1 Like

I created a custom property just for this purpose. I agree it's weird but I don't know of any other way. I only have one alarm per tag so even though it's goofy it does work.