Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki Adding Data from The Process Table to Isometric Backing Sheet, Drawing Frame, Seed File
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • -OpenPlant Isometrics Manager v8i
          • +OpenPlant Isometrics Manager for OpenPlant
          • -OpenPlant Isometrics Manager for AutoPLANT
            • Installation/Upgradation Steps of OpenPlant Isometrics Manager for AutoPLANT
            • +Errors, Logs, Messages, Crashes - OpenPlant Isometrics Manager for AutoPLANT
            • +Open/Save - OpenPlant Isometrics Manager for AutoPLANT
            • +Processing - OpenPlant Isometrics Manager for AutoPLANT
            • -Settings/Attributes - OpenPlant Isometrics Manager for AutoPLANT
              • +Modifying Text and Annotation for AutoPLANT - OpenPlant Isometrics
              • +Modifying Symbols for AutoPLANT - OpenPlant Isometrics
              • +Modifying Dimensions for AutoPLANT - OpenPlant Isometrics
              • -Modifying DB Query: Usage, Logging, Debugging
                • Adding Data from The Process Table to Isometric Backing Sheet, Drawing Frame, Seed File
                • Creation of External Database Path Variable for Textnode.txt File
                • DB query for Multimode Project Environment
                • How to Add Data from External Database in OpenPlant Isometrics Manager Backing Sheet
              • +Modifying BOM for AutoPLANT - OpenPlant Isometrics
              • +Modifying Isometric Content for AutoPLANT - OpenPlant Isometrics
              • How to Append Tag Name of Instrument in Long Description
              • How to Change the Cursor Crosshair Color in OpenPlant Isometrics Manager
              • How to Enable OpenPlant Isometrics Manager to Read AutoPLANT Spool Number
              • How to Get AutoPLANT Weld IDs in OpenPlant Isometrics Manager
              • How to Get Model Name(filename) from AutoPLANT In Isometrics Using OPIM
              • How to Report the Reinforcing Pad Using Schema Customization in OpenPlant Isometrics Manager
              • How to Show Reserved Weld IDs in AutoPLANT - OpenPlant Isometrics
              • How to Show Spool Identifier and Test Port Instrument Bubble Tag Number In Isometric
              • How to Show User Label only for Reducing Branch Size
              • How to Skip THREAD or SOCKET Weld IDs in OpenPlant Isometric Manager
              • How to Suppress ‘UBR_STUB_IN’ in OpenPlant Isometrics Manager Bill of Material
              • How to Import Isometric Cells from One Project Cell Library to Another Project Cell Library
              • How to Make OpenPlant Isometrics Manager Styles Stored Globally for All Projects Using AutoPLANT Modeler
              • How to Label Pipe Support Tag
              • How to Use Grid Lines in OpenPlant Isometrics Manager for AutoPLANT
              • How to Use Isometric Cleanup When the Output Format is DWG for AutoPLANT
              • How to Add Material Property in PCF file
              • How to enable the specific Component Tags to be shown in Isometrics Using User Label
              • OpenPlant Isometrics for AutoPLANT settings for Project Isometrics
          • +Release Notes - OpenPlant Isometrics Manager
          • OpenPlant Isometrics Manager [FAQ]
        • +OpenPlant Project Administrator v8i
        • +OpenPlant PID v8i
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

     
     Questions about this article, topic, or product? Click here. 

    Adding Data from The Process Table to Isometric Backing Sheet, Drawing Frame, Seed File

    Applies To
    Product(s): OpenPlant Isometrics Manager
    Version(s): 08.11.09.XXX (SS5) | 08.11.11.XX (SS6)
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Settings/Attributes
    Subarea: DBQuery
    Original Author: Abhijit Bute, Bentley Product Advantage Group

    Background

    In general, the majority of data for Isometric output is gathered from the Piping table. However, situations can arise where data from other tables in the Project Database could be valuable for placement on Iso's. The following illustrated steps demonstrate how to pull a field from the Process table into Isometric backing sheet.

    Steps to Accomplish

    Adding Configuration Files

    In workspace for isometrics does not include the query and grid functionality. It can be added by adding 2 configuration files. Copy attached gridlines.txt and textnodes.txt and paste it in style configuration directory. Ex. \Bentley\Plant V8i\Bentley PlantV8i Projects\SAMPLE_IMPERIAL\Config\OpenPlant\Isometrics\Styles\IFC\ Config

    Please find the query file below to be pasted in style configuration directory:

    Gridlines & Textnodes File.zip

    Create New Drawing Attribute & Define Query

    To get database attribute in Drawing Tag dialog ,user need to add query, project database location in textnodes.txt file,While creating an isometric AP adds a few standard drawing attributes. Currently these are:

      FILENAME     ISO-L1000.r017

      STYLE        IFC

      DATE         3-3-2014

      TIME         11:45:28

      PRJ_NAME     ROTAT1

      SIZE1        150

      SIZE2        0

      SPECMAIN     MCS150

      LINENUMBER   L1000

      UNIT         U

      SERVICE      S

      NAME         ISO-L1000

      ALIAS        ISO-L1000

      ACTIVE       True

    Marked LINENUMBER in upper case, as this attribute will be used in the examples to query the database.

    A For MS Access (32bit) Following Query should be added in Textnodes.txt 

    mydsn=Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq= C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_METRIC\Projdata\projdata.mdb;

    00_keytag = DBQUERY ($(mydsn), select keytag from TAG_REG where tag_no='$(LINENUMBER)')

    Note: The above project path shown is an example. User need to set their own path as per their project.

    The DBQUERY above gets the value of the KEYTAG column in the TAG_REG table from the row where the TAG_NO column equals the value contained in LINENUMBER drawing attribute. The resulting value is stored in a new drawing attribute named 00_KEYTAG.

    Please note that $(attrname) is expanded to the value of the drawing attribute attrname. LINENUMBER is a drawing attribute that was already added by the AP interface to OPIM

    Similarly we can define query for other attributes like popp_nom, popt_nom, FLUID_FILL as described below.

    00_popp_nom = DBQUERY($(mydsn), select popp_nom from process where keytag='$(00_keytag)')

    00_popt_nom = DBQUERY($(mydsn), select popt_nom from process where keytag='$(00_keytag)')

    00_FLUID_FILL = DBQUERY($(mydsn), select FLUID_FILLING_FACTOR from process where keytag= '$ 00_keytag)')

    Refer below image for edit textnodes.txt file.

    B For MS Access (64bit) Following Query should be added in Textnodes.txt 

    mydsn=Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\SAMPLE_METRIC\Projdata\projdata.mdb;

    00_keytag = DBQUERY ($(mydsn), select keytag from TAG_REG where tag_no='$(LINENUMBER)')

    00_popp_nom = DBQUERY($(mydsn), select popp_nom from process where keytag='$(00_keytag)')

    00_popt_nom = DBQUERY($(mydsn), select popt_nom from process where keytag='$(00_keytag)')

    00_FLUID_FILL = DBQUERY($(mydsn), select FLUID_FILLING_FACTOR from process where keytag='$ (00_keytag)')

    C For SQL database following query should be added in textnodes.txt

    mydsn=Driver={SQL Server};Server=SQL Server name;Database=sql databse name;

    Uid=user id;Pwd=password;

    00_keytag = DBQUERY ($(mydsn), select keytag from TAG_REG where tag_no='$(LINENUMBER)')

    00_popp_nom = DBQUERY($(mydsn), select popp_nom from process where keytag='$(00_keytag)')

    00_popt_nom = DBQUERY($(mydsn), select popt_nom from process where keytag='$(00_keytag)')

    00_FLUID_FILL = DBQUERY($(mydsn), select FLUID_FILLING_FACTOR from process where keytag='$ (00_keytag)')

    The isometric result can be viewed using the Show Tag Data tool (first 4 lines)

      

    Display Drawing Attributes

     Below are the steps to get the attributes displayed in backing sheet.

    1. To get attributes in backing sheet we have to add drawing attributes in Node2da.txt file. See new attributes added in yellow marked below.

      36, checked

      63,UNIT_NAME

      64,STYLE

      1001,00_KEYTAG

      1002,00_POPP_NOM

    2. Open seed file and go to Isoextractor>text node editor.
    3. Text node editor will show newly added attribute. Right click on text node number and click on place text node and place text node on desired location.



    4. Save the seed file.
    5. Generate isometric to verify the result.

    See Also

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/18475.dbquery-usage-logging-debugging

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/17953.db-query-for-multimode-project-environment

    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!

    • AutoPLANT
    • data
    • 08.11.09.404
    • AUTOPLANT ISOGEN SERVER
    • Settings/Attributes - OpenPlant Isometrics Manager
    • AutoPLANT Isometrics
    • how to
    • Customization
    • OpenPlant Isometrics Manager
    • AutoPLANT Piping
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Abhijit Bute Created by Bentley Colleague Abhijit Bute
    • When: Sun, Jun 29 2014 1:37 PM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Dec 19 2018 5:31 PM
    • Revisions: 17
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies