How to obtain Valve Location while creating AutoPLANT Report




  
 Applies To 
  
 Product(s):AutoPLANT Modeler
 Version(s):08.11.XX.XXX
 Environment: Windows 7 / 8/10 (32/64 bit)
 Area: Customization - AutoPLANT Modeler
 Subarea: 
 Original Author:Vidit Ruhela, Bentley Product Advantage Group
  

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!

communities.bentley.com/.../settings-attributes---openplant-isometrics-manager