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

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

   

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

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!