Renaming of PI Points

Good day all,

 

I have t a tsk to rename approx. 3000 Pi Points, How do I find references of these Pi points in :

  1. PI Vision
  2. Asset Framework
  3. and if possible Pi Data Link

Kind regards

Bala Moodley

  • I would suggest using PI Builder (an Excel add-in) for finding and renaming PI Points.

  • I thought that AF used PointID internally because I've see renaming tags in the DA just show-up in AF. Vision may be similar but I agree with starting in the DA with PIBuilder.

  • Chiming in some more. Whether you absolutely need to change Tag names in an application depends upon whether that application uses only Names or if it uses PointIDs.

     

    In AF, when you "Create or Update PI Point", the data reference will at that instant attempt to find the PI Point using Tag Name. If it is found, then the data reference then saves the PointID into a hidden portion of the ConfigString. Any subsequent requests to find PI Point will then use the saved PointID for a much faster lookup. Using PointID also means that if the Tag name is changed elsewhere that find should still work.

     

    If you were to later issue another "Create or Update PI Point" on the same tags, then the lookup would fail since it would try to lookup by a name that has been changed.

     

    For DataLink, it is possible to lookup by PointID but I have rarely seen this done. Just like with AF, it requires a Tag name look up first in order to save the PointID to the spreadsheet. Therefore, Tag names in a spreadsheet would need to also be changed in order for any DataLink commands to work properly.

     

    As you have tagged the post with "General Programming", let me guess that you are really asking about writing a custom app to walkover an AFDatabase to find & change tag names embedded in the ConfigString, and/or another app to open an Excel Workbook to also find & change tag names stored as text in cells.

     

    Walking over an AFDatabase could be relatively straightforward with AF SDK, trying to edit Excel Workbooks is far more complicated since you must read text in a cell. How would you know that a given cell is to contain a Tag name or something else? Do any of the tags have Performance Equations that require you to edit the tag names embedded within the PE? Do you have sufficient programming skills to do this?

  • Hello everyone,

    I’m new to OSI PI (Oracle/Aspen background) and looking for a quicker way to rename about 2,000 tags (Phase 1) without manually editing them in the Excel PI Builder add-in.

    Background:

    • We’re moving to a new DCS and standardising tag names.
    • Goal is to rename existing tags, not create or replicate them, while retaining historical data.

    Questions:

    1. AF & PI Vision references – Do they use the tag name or the Point ID/Record number?
    2. Historian bulk rename – Can I do a mass update via scripts/mapping table to rename tags and update exDesc and point source fields?
    3. PI Adapter mappings – Must these be manually updated, or can they be reverse-engineered from exDesc?
    4. SQL backend – Since AF and PI Vision use SQL, can I identify and bulk-update attribute/display sources from a staging table?

    That’s my “lazy” way of doing it — is it possible?

  • AF and PI Vision use tag names. If you rename the tags in PI Archive, the referenced tags in PI Vision and PI AF tags will be renamed as well and no rework is required.

    The best option I suggest to edit is via builder.