How to Get Operating Pressure And Other Process Information On The Isogen Title Block [TN]


  
 Applies To 
  
 Product(s):Project Administrator; AutoIsogen
 Version(s):V8i Edition
 Environment: N/A
 Area: N/A
 Subarea: N/A
 Original Author:Derek Cornell, Bentley Technical Support Group
  

Overview

In AutoPLANT V8i, it is now possible to specify Pipeline Attributes via the Project Administrator rather than by modifying the OPCFHDR.EBS file. This feature will allow users to pull data from the database and position it using Isogen's POS text positioning file.

Solution

  1. In the AutoPLANT Project database, go to the PROCESS table.
  2. Populate values in the column POPP_NOM and save the changes.
  3. Open the Project Administrator.
  4. Go to ..\project name\Isogen\System\
  5. Select the empty place below number 34, right click select add item.
  6. Enter a description in the description field (Operating Pressure).
  7. Go to number 32 copy the query statement.

    Note: There are several different ways to create the SQL statement. If a user knows SQL, they can create it on their own. It's also possible to link to tables through the MS Access interface, then change the view to the "SQL statement". But the easiest way is to copy one of the existing statements in Project Administrator and modify the table name and field name in the statement.
  8. Change the SQL Statement as follows and paste it into the Query field.

    SELECT DISTINCT PROCESS.POPP_NOM AS FieldtoDisp FROM PROCESS INNER JOIN tag_reg ON PROCESS.keytag=tag_reg.keytag WHERE tag_reg.tag_no='+linenumber+'

  9. Save the changes in Project Administrator.
  10. Repeat steps 1 - 7 for additional attributes and modify the field name to reflect the field the data needs to be pulled from.
  11. Open the following file in notepad. ..\project name\config\isogen\final\final.pos
  12. Adjust the isogen pos file to reflect the new attribute numbers for text placement. The attribute number in Project Administrator corresponds to the -600 numbers in the FINAL.POS. Therefore, number 35 for operating pressure will correspond to -635 in the FINAL.POS.
  13. Adjust the XY coordinates as needed and save the file.

  14. Run Isogen.

    Note:
    If the values do not appear on the iso, review the steps again. Make sure that all changes were made in the same project and that there are values specified in the PROCESS table of the project database.

See Also

Product TechNotes and FAQs

Plant TechNotes And FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

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