How to obtain Valve Location while creating AutoPLANT Report

Overview

User requirement is to show the Valve location Coordinates in generated reports from AutoPLANT.

Steps to Accomplish:

Below steps need to be followed to obtain Valve port coordinates in Report Excel file.

When Using SQL Database.

1. Open SQL Database of the associated Project and in same Database Piping Table add X, Y & Z column as shown below.
   
   
   
   

   
   

2. Once the X,Y,Z columns are added, save and close the Database.
   
   

3. Now open Client Machine where AutoPLANT is installed and navigate to the below path and open pipedata.ebs file in notepad.
   
   
   
   
4. Once Opened add the below lines in the Pipedata.ebs file
   
   
   
   Add below lines in file as shown in above screenshot.
   
   Dim   mypoint        As at_point
   
   
   status = at_Component_getpoint (mypoint, compID, "Port1.LOC")
   status = at_DbExt_put (mypoint.X, AT_DB_TABLE_PIPING, AT_CURRENT_DOCUMENT, compID, "X")
   status = at_DbExt_put (mypoint.Y, AT_DB_TABLE_PIPING, AT_CURRENT_DOCUMENT, compID, "Y")
   status = at_DbExt_put (mypoint.Z, AT_DB_TABLE_PIPING, AT_CURRENT_DOCUMENT, compID, "Z")
    
   After adding above lines save and close pipedata.ebs file.
   
   
5. Now open Drawing File and generate the report of the selective components.
6. Once report is generated go the below path and check for the latest generated report and noticed that now X, Y, Z coordinates are available in the generated report, now this report can be saved anywhere for further reference.
   
   
   

See Also:

https://communities.bentley.com/products/plant/w/plant_design_and_engineering__wiki/35584/customization-autoplant-modeler

Comments or Corrections?

Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!