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 How to Import Piping Design Data from CSV file to Isometric Backing Sheet.
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • +OpenPlant
      • -Bentley AutoPLANT
        • AutoPLANT Product Group Compatibility
        • +AutoPLANT Modeler CONNECT Edition
        • +AutoPLANT Modeler V8i
        • +AutoPLANT Piping
        • +AutoPLANT Equipment
        • +AutoPLANT I&W
        • +AutoPLANT P&ID
        • +AutoPLANT Isometrics
        • -AutoPLANT AutoISOGEN
          • Add Material Data To Isogen Bill Of Materials - Example Tag [TN]
          • AutoISOGEN - Personal Isogen Error Codes
          • AutoPLANT ISOGEN [FAQ]
          • Change The Color And Font For Text Placed By The Text Positon POS File [TN]
          • Changing The Font Of Your Isogen Output [TN]
          • Creating Custom Symbols In Isogen
          • Creating Isometrics of more than one Line number using AutoISOGEN
          • Having More Control with Isogen Dimensioning [TN]
          • How Do I Increase The Character Length Of The Spool Tag Annotation In Isogen [TN]
          • How Do I Split The Tag Number Annotation To Three Lines For A Pressue-Temperature Gauge In Isogen [TN]
          • How to Add Weld Summary Report in ISOGEN
          • How to Build Linenumber (Linenumber+Size+Spec) and add in AutoPLANT Isogen Backing Sheet.
          • How to Change the Support Symbol for Generated Isometric Drawing
          • How to create a custom symbol in Isogen
          • How to Import Piping Design Data from CSV file to Isometric Backing Sheet.
          • How to Populate Comment/Note Placed on any Component in Generated Isometrics.
          • How To Set Colors For Layers Or The BOM In ISOGEN [TN]
          • How To Show Insulation In ISOGEN [TN]
          • How to show Tracing in Isometrics using AutoISOGEN
          • How to Suppress supports on Isogen Continuations
          • How To Suppress The North Arrow In Isogen [TN]
          • Isogen Error Unable to find Key PWF for group MAP_ENDCOND4SKEY for module Base
          • Isogen Will Not Output A DWG Or DXF Error Plotfile-Prefix Must Have Trailing Path Delimiter [TN]
          • PCF Export Limitations [FAQ]
          • Remove Support Direction Text From Isogen Drawings [TN]
          • +Trouble Shooting AutoIsogen For AutoPLANT Plant Design Workgroup 2004 Edition [CS]
        • +Bentley Data Manager
        • +Vision/Document Manager
        • +Drawing Flattener
        • +DataSheets
        • +Specification Generator
        • +ProjectWise Integration
      • +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. 

    How to Import Piping Design Data from CSV file to Isometric Backing Sheet.

    Applies To 
    Product(s): AutoIsogen
    Version(s): 08.11.09.xxx
    Environment:  Windows XP/7(32/64 bit)
    Area:  Processing
    Subarea: 
    Original Author: Abhijit Bute, Bentley Product Advantage Group

    Background

    In general, the majority of data for Isogen output is gathered from the Piping table. However, situations can arise where user want to show piping design data on isometrics from external database.

    Steps to Accomplish

    1. Create external database file.
      Generate line list in Excel Spreadsheet format through Data Manager and then export in ‘CSV’ format, and rename it to ‘Final.att’
      Refer below image as sample.



      1LINE REF,2SERVICE,3NOMINAL SPEC,4NOMINAL SIZE,5NOMINAL OP PRESS,6NOMINAL OP TEMP,7TEST PRESS
      -----------------------------------------------------------------------------------------------
      " 1 "," 2 "," 3 "," 4 "," 5 "," 6 "," 7 "
      L-100-200-ST,S-100,SPEC1,200,500 PSIG,200,100
      L-200-300-ST,U-100,SPEC2,300,625 PSIG,150,150

      The header gives the order of the fields (texts) by number. The body text shows the content of the fields. The texts are separated by a comma as defined in the function definition file, DELIMITER-CHARACTER,

    2. Edit “Final.fdf” files add following entries.

      FUNCTION-DEFINITION-FILE
      PIPELINE-ATTRIBUTE-FILE
      DELIMITER-CHARACTER,
      IGNORE-CHARACTER "
      -900 1  ! LINE REF
      -901 2  ! SERVICE
      -902 3  ! NOMINAL SPEC
      -903 4  ! NOMINAL SIZE
      -904 5  ! NOMINAL OP PRESS
      -905 6  ! NOMINAL OP TEMP
      -906 7  ! TEST PRESS


    3. Edit ‘Final.ddf’ add following entries.

      PIPELINE-REFERENCE-LOCATION-DEFINITION
      FULL-REFERENCE  –900



    4. Edit ‘Final.POS’ file add attribute text position.

    5. Define location of Final.FDF, Final.ddf, Final.att, in ‘Isogen.fls’ file.

      PIPELINE-ATTRIBUTE-FILE   C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\test\Config\isogen\final\TEST.att

      FUNCTION-DEFINITION C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\test\Config\Isogen\FINAL\FINAL.FDF

      DRAWING-DEFINITION    C:\ProgramData\Bentley\Plant V8i\Bentley Plant V8i Projects\test\Config\Isogen\FINAL\FINAL.DDF

                6. Save the file and generate isometric to review the result.

                  

     

    Still a Problem

    If there is still some problem in using the key-in and opening an intermediate file, then please create a Service Request and contact Bentley Product Advantage group along with the list of all relevant details to get in depth analysis and for possible solution or workarounds. 

    See Also

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/4336.autoplant-autoisogen

    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!

    • 08.11.09.140
    • Share
    • History
    • More
    • Cancel
    • Abhijit Bute Created by Bentley Colleague Abhijit Bute
    • When: Tue, Feb 21 2017 2:01 PM
    • Revisions: 1
    • 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