Skip to main content
InSource Solutions

TN - 1191 Updating Historian Descriptions for Converted Legacy Field Attributes

Description

This article from InSource shows how to update missing attribute descriptions when Legacy field attributes are converted to object attributes in AVEVA System Platform 2020 R2.

  • Author:  Rich Brooks
  • Published:  10/18/2021
  • Applies to:  System Platform 2020 R2 & higher

Details

The following example uses objects upgraded from v3.1 SP2 to 2020 R2 P01.  There is an incorrect assignment during conversion of Legacy field attributes.

Picture1.png

The objects had descriptions assigned to the field attributes.  They are used from the Historian Client to describe each trend pen.

Picture2.png

The short description (Me.ShortDesc) for the object is assigned in the conversion.  This needs to the the attribute description rather than the object description.

Picture3.png

The correct assignment is Me.<AttributeName>.Description.

Create a Galaxy Dump from the IDE for the object instances that need to be updated.  Use find and replace from Excel to update the CSV file.  

Picture5.png

Find what:  me.ShortDesc

Replace with:  =CONCATENATE("me.",LEFT(INDIRECT(ADDRESS(ROW()-1,COLUMN())),FIND(".",INDIRECT(ADDRESS(ROW()-1,COLUMN())),1)-1),".Description")

Also, run the following find and replace for objects that have more than one instance.

Find what:  Me.me.description

Replace with:  =INDIRECT(ADDRESS(ROW()-1,COLUMN()))

Save the file in CSV format and load the updates to the Galaxy using the IDE.  The attribute descriptions will then display properly from the Historian Client Trend.