Need help working from home with your Bentley software? We're here to help - click here
In general, the majority of data for Isogen 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 Isogen.
1. In order to pull any data into Isogen, it must first be inserted into the PCF, the text file that Isogen uses for its data collection. The Pipeline attributes selected for inclusion in Isogen can be selected within the Project Administrator by going to %ProjectName%>Isogen>System as shown below:
For the purposes of this demonstration, I will simply pull a general piece of data into the PCF through use of the ‘General PCF Data' box near the top of the System display for Isogen.
2. Right click inside the box and select ‘Add Item'. The description field can be filled out to your liking. The query field is in general SQL query format, and is what we will use to direct the PCF to pull data from the Process table in this case. Since I have chosen to add the POPP_NOM field to my PCF my query is as follows:
SELECT DISTINCT PROCESS.POPP_NOM AS FieldtoDisp FROM PROCESS INNER JOIN tag_reg ON PROCESS.keytag=tag_reg.keytag WHERE tag_reg.tag_no='+linenumber+'
The emboldened portion is my field name. The rest of the query is designed is designed to link the linenumber in your iso selection set to the data in the process table. Once the query is properly designed, the data should populate into the PCF file with the Attribute number specified in the General PCF data box.
Now that we have successfully pulled the data into the PCF, we must instruct Isogen on the proper placement of the data into the Iso itself. This can be accomplished by adding a line for t our newly defined attribute in the final.pos positioning file found in the Projects Isogen config file (%ProjectRoot%>%ProjectName%>Config>Isogen>Final) I have defined the new attribute in this case as attribute 35 as you see below:
Now using this attribute number we can place the data on our Iso in a position of our choice by entering the following information in Final.pos:
The X and Y position can be adjusted according to your desired placement of the data. This should complete the steps to add Process Table data to an Iso. The final result of our Project can be seen below:
Product TechNotes and FAQs
Plant TechNotes And FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!