YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

Tag renaming - All Of them! Advice Sought. Options · View
milesUK
#1 Posted : Friday, September 30, 2011 9:37:10 AM
Rank: Advanced Member
Groups: Member

Joined: 5/28/2009
Posts: 75
Location: Cheshire, UK
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
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
squatty
#2 Posted : Friday, September 30, 2011 11:39:50 AM
Rank: Advanced Member

Groups: Member

Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
We had the same problem when we had to chane a bunch of tagnames, we had 20-30 reports which will be referencing wrong tagnames, so we started by using pointID and not tagnames in our reports. This is now a standard in our reports to insert pointID and use PI-Datalink to convert pointID to Tagname.

Do yourself a huge favour and replace all our datasets with calculated tags (if you have anough tag licenses available), I don't mind the odd dataset here and there, but we use dataset to do quick calculations and if needed create the tags.

(5) You will have to copy/paste the VBA code to each display in order to complete this, why don't you create and PBook Add-In, that scans a certain folder for pdi files and open it, find dataset/s, extract dataset properties,replace old with new. It's not going to be easy.
milesUK
#3 Posted : Friday, September 30, 2011 2:49:51 PM
Rank: Advanced Member
Groups: Member

Joined: 5/28/2009
Posts: 75
Location: Cheshire, UK
squatty,

using the PointID; marvelous idea and one I have just passed on to the other users. Thanks.ThumbsUp Saw that formula but never understood the need for it. Got me thinking that there are other features there that I must make time to explore.RollEyes

I certainly agree that calulated tags would better in the long run than datasets. However many datasets refer to data already in the historian and not just to data from the data of creation onwards. Calculated tags would be of little help there. I believe!

(5). I agree that the code must reside in a display in a processbook but it need not be in every one. I already have code based on Rhys' Framework http://www.rjksolutionsl...-for-PIProcessBook.aspx that uses code in one processbook display(PDI) to modify trends on Dislpays in another Book. My opo in Scotland has also produced a bit of code that does almost what you suggest. I need to modify it to lookup the found tag and replace with the new one.

It's good to talk (as The British Telecom ad used to say) - thanks.Smile
MilesUK
ProcessBook v3.0.15.3
RJK Solutions
#4 Posted : Friday, October 07, 2011 6:02:51 PM
Rank: Administration

Groups: Administration

Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
Miles, you (well your employer) really need to invest in AF! Let me know if you do. BigGrin
Would make life so much easier as adoption of PI and it's tools grow within your business. You can bring more value, quicker, and everything you describe here is handled without effecting clients, calculations, etc.
Principal Consultant
Real-Time Data Management @ Wipro Technologies
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.