I exported my SQLTag file to XML so that I could edit multiple alarm tags at one time.
However, I have hundreds of alarm tags that I need to update the ‘notes’ section of. Is there a way I can take the data from my excel spreadsheet that already has the new ‘notes’ dialog into my XML file?
I could go through and do this manually (copy and paste into each one) but I have hundreds, if not thousands, that I would need to change.
Thanks!
You could go the copy paste route. You could possibly use something like Sublime Text 2 and do a “Find All” “Replace All” to make this easier.
I would make a csv file that has a column for tagpaths and a column with the notes data, if you already have that in your excel spreadsheet. you could then import that into a table in your database and use a script to write to the notes section of each tag that you have in your list.
here is an example of writing to the notes part of a tag.
note = "test"
system.tag.write('03301/CommStatus.AlertNotes',note)
If you need more help let me know.