Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki How to Get Updated Revision in Isometrics Drawing Using DBQuery in OpenPlant Isometric Manager CONNECT Edition
    • Sign In
    • -OpenPlant | AutoPLANT 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
          • [FAQ] - OpenPlant Isometrics Manager CONNECT Edition
          • Release Notes- OpenPlant Isometrics Manager CONNECT Edition
          • +OpenPlant Isometrics Manager CONNECT - OpenPlant
          • +OpenPlant Isometrics Manager CONNECT - AutoPLANT
          • How the North for isometrics can be change in OpenPlant Isometrics Manager CONNECT Edition.
          • How to add End type Information in Isometric BOM Cut list OPIM CE
          • How To Add Field components Under Shop Material In BOM OPIM CE
          • How to Add Plant Area in Isosheet Name.
          • How to change Dimension color in OPIM CE
          • How to convert units of Dimension & Size in Isometrics.
          • How To Create Custom Style in OpenPlant Isometrics Manager Connect Edition .
          • How to Create new Drawing Attribute Combining Multiple other Drawing Attributes and Map with New Text Node in OpenPlant Isometrics Manager
          • How to customization ISO sheet number (split sheet number / Total number of sheet) In OpenPlant Isometrics Manager
          • How to disable Dimension for Existing Component State
          • How To Display only Support List for Bill Of Material Report in OpenPlant Isometrics Manager
          • How to Generate Reports based on Size in OpenPlant Isometrics Manager Connect
          • How to get Co-ordinate Values in Meters in Iso Output via OPIM
          • How to Get Updated Revision in Isometrics Drawing Using DBQuery in OpenPlant Isometric Manager CONNECT Edition
          • How to Hide Branch Dimensions
          • How to modify/edit Dimension Text of extracted DWG from OPIM CE
          • How to place Text Node in OPIM CE
          • How to Remove Insulation/Tracing for desired components in Isometrics.
          • How To Resolve the error message " OPIM_SCHEMA_PATH points to an invalid location".
          • How To Set Reducer Size Annotation for Bill Of Material Report in OpenPlant Isometrics Manager
          • How To Set Reducer Size Annotation in BOM Report OPIM CE
          • How to Show 3 Port Information PIPE_LATERAL_TEE_REDUCING_ONE_RUN_AND_BRANCH in Isometric Drawing
          • How to Show Calculated Pipe Weight for Bill Of Material in OpenPlant Isometrics Manager
          • To Fix Bend Angle Precision value in OpenPlant Isometrics Manager
        • +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 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
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
      • +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
      • Your Feedback is important to us!

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

    How to Get Updated Revision in Isometrics Drawing Using DBQuery in OpenPlant Isometric Manager CONNECT Edition


    Applies To 
    Product(s): OpenPlant Isometrics Manager
    Version(s):

    Connect Edition Update 8 (10.08.00.51)

    Environment:  Windows 10 (64-bit)
    Area:  Customization
    Subarea:  N/A
    Original Author: Ashutosh Patil, Bentley Product Advantage Group

    Background

    In OpenPlant Isometrics Manager, Isometrics output drawing title block contains revision field but it does not get updated. Below steps will aid user to update the Revision using DB Query inside Textnode.txt file present under style folder. As a prerequisite, user should be aware of SQL or Access and able to create new file and must be knowing version compatibility and relevant terms like creating table and assigning datatype etc. Below steps explained using 64 bit ODBC drivers. 


    Steps to Accomplish

    1. Create just a new mdb file, say TESTISORev.mdb (don’t enter any fields in it) & place it in any Isometric style folder,
      See below path to store it.Considering IFC: C:\ProgramData\Bentley\OpenPlant CONNECTEdition\Configuration\WorkSpaces\WorkSpace\WorkSets\OpenPlantMetric\Standards\OpenPlant\Isometrics\styles\IFC\config



      It can be Stored any where to get read.
        
    2. Launch the textnodes.txt from IFC style config folder.



      Std Path: C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\Workspaces\WorkSpace\WorkSets\OpenPlantMetric\Standards\OpenPlant\Isometrics\styles\IFC\config
        
    3. In textnodes.txt write db query as given below:
      Query:

      myDSN=Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\ProgramData\Bentley\OpenPlant CONNECT Edition\Configuration\Workspaces\WorkSpace\WorkSets\OpenPlantMetric\Standards\OpenPlant\Isometrics\styles\IFC\config\TESTISORev.mdb

       

      # this creates a table in the database and puts a unique index on the filename field

      @a0 = DBQUERY ($(myDsn), Create Table iso_revisions (filename varchar(255), revision int))

      @a1 = DBQUERY ($(myDsn), Create UNIQUE index index1 on iso_revisions (filename))

       

      # This inserts a row for the filename if not yet there and initializes the revision to 1

      @a2 = DBQUERY ($(myDsn), Insert into iso_revisions (filename, revision) VALUES ('$(NAME)', 1))

       

      # this gets the current revision number for the table

      @Rev = DBQUERY ($(myDsn), Select revision from iso_revisions where filename = '$(NAME)')

       

      # this increments the revision table number (for the next time)

      @a3 = DBQUERY ($(myDsn), Update iso_revisions set revision = $(rev)+1 where filename = '$(NAME)')

       

      REV_MAIN=$(Rev)
       

      Make sure the space between .mdb and .accedb is verified if the output is not perfect after generating the isometric.Save and Close the file.

    4. Go to Pipeline manager in Openplant Modeler where pipeline was placed and regenerate the isometric select correct style i.e IFC where files has been stored to get the changes reflected in isometric.
       

        
    5. TESTISORev.mdb gets updated as per query with addition one revision value instead of one its get reflected as 2 due to below mentioned in step 3 i.e $(rev)+1

      # this increments the revision table number (for the next time)
      @a3 = DBQUERY ($(myDsn), Update iso_revisions set revision = $(rev)+1 where filename = '$(NAME)')
        


    6. Similary try to regenerate the isometric again and Rev number gets updated as shown below



    7. When click on Drawing Components the REV_MAIN can be seen with how many time the isometric getting generated.Below the Isometric is generated 3rd time.


      Thus Isometric generation can be tracked down through revision no easily.

       

    See Also

    OpenPlant Isometrics Manager CONNECT
    Generate intelligent isometrics from multiple sources OpenPlant Isometrics Manager CONNECT Edition is the first software to extract intelligent isometric information from any design system’s 3D model…
    Last edited 2 months ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    Still a Problem?

    If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround

    • automatic revision
    • rev
    • OPIM CE
    • Revision
    • Share
    • History
    • More
    • Cancel
    • Ashutosh Patil Created by Bentley Colleague Ashutosh Patil
    • When: Wed, Dec 2 2020 2:06 PM
    • Ashutosh Patil Last revision by Bentley Colleague Ashutosh Patil
    • When: Fri, Dec 4 2020 5:42 AM
    • Revisions: 2
    • 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

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