We are about to rename our tags (for various reasons including standardisation across our buisiness, correcting errors and more) and I was wondering if anyone else has come across any pitfalls that we can avoid.
Changes being proposed.
Our Tag name is made up as follows:
Region~Substation~Circuit~Nomenclature~Units~Type
Region~Voltage~Substation~Circuit~Nomenclature~EngUnits~Type
e.g. "W~132~Flint~Prestatyn/Colwyn Bay~MW~TAI"
The 'Region' and 'Type' is being changed in all tags. 'Voltage' added to all tags. Minor edits to 'Substation' & 'Circuit' in many tags. Changes to 'Units' (and the EngUnits attribute) in around 2000 cases.
Things we have identified so far:
(a) ProcessBook is quite happy with tag renaming (up to a point!) and will pick up the
(b) Tags in PB Datasets are not automatically changed and will need to be done by us.
(c) Tags in Excel (Datalink) are not automatically changed and will need to be done by us.
(d) MDB. Not investigated yet but suspect it may be OK although our aliases will need edits too.
My approach:
============
(1) Import tags into Excel. Approximately 13,000
(2) Excel Macro makes ALL changes to Tag Name (& EngUnits in some cases) in the sheet.
(3) Export tags NewName to PI Server.
(4) Distribute macro to Datalink users for them to make the exact same changes to their sheets.
The above is now in place and (almost) ready to roll.
The ProcessBook Support Tool can carry out Find/Replace in Datasets but our changes are not that simple and would involve thousands of R/R actions! So:
(5) Create ProcessBook VBA to identify tags in Datasets.
(6) For each tag find it's replacement in (from the sheet produced in 2 above).
(7) Replace tag.
(8) Repeat for each tag in the Datasets.
(9) Repeat for each Datasets.
All the above seems very simplistic and I would very much appreciate everyones experiences or advice on this matter.
MilesUK
ProcessBook v3.0.15.3