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

communities.bentley.com/.../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!