Create PI points

Specify a Data Archive server.

With PI Builder, you can enter the specification for new points in a Microsoft Excel worksheet, and then publish the worksheet to Data Archive to create the points. With the auto-fill features in Excel, you can easily create multiple points with similar specifications.

1. Add columns to the worksheet for the point attributes that you want to specify.

   See Set column headers in a worksheet.

   Note: To base your new points from existing points, retrieve those existing points into your worksheet, and then change the name and any other attributes.

2. Specify the point attribute values for the new points.

   You must specify a unique name for each point. If you do not specify values for other attributes, PI Builder sets the attribute to its default value.

   PI Builder ignores any entries you make for read-only system attributes: changedate, changer, creationdate, creator, pointid, ptclassname, and srcptid.

3. Set the Selected(x) column to X for any point that you want to create.

4. Publish the new points to Data Archive:

   1. Click Publish to open the Publish Options window.

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

      With this choice, PI Builder will only create new points. If a point already exists with the same name, PI Builder generates an error. 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 creates the points on Data Archive. The Publish Selected Objects window shows the operations completed.

   4. Click Close.