Edit PI points

Complete the following task before retrieving PI points: Retrieve PI points by searching.

After you retrieve PI points into Microsoft Excel with PI Builder, you can edit the point attributes and then publish those changes to Data Archive.

1. If necessary, add additional columns that contain the point attributes that you want to change and click Retrieve to retrieve current values.

   See Set column headers in a worksheet.

2. Optional: Clear all values from the Selected(x) column in the worksheet.

   You want to mark only the rows that contain edits with an X. Clearing the column before you begin can help you track which rows changed.

3. Edit any attributes that you want to change.

   You cannot change all point attributes. Specifically, PI Builder ignores changes that you make to read-only system attributes: changedate, changer, creationdate, creator, pointid, ptclassname, and srcptid. To change the point name (the tag attribute), include the NewName column and enter the new point name in that column.

   If you enter a space or null value for an attribute, PI Builder will reset the attribute to its default value when you publish worksheet changes.

4. Set the Selected(x) column to X for any point that has a changed attribute value.

5. Publish the changed points to Data Archive:

   1. Click Publish to open the Publish Options window.

   2. From the Edit Mode list, select Edit Only.

      With this choice, PI Builder will only edit existing points. You can also select Create and Edit; then, PI Builder will edit existing points and create any points that do not already exist. PI Builder uses the Name column to find existing points with the same name.

   3. Click OK.

      PI Builder edits the points on Data Archive. The Publish Selected Objects window shows the operations completed.

   4. Click Close.