To add Additional Field to Component Data, and to make it an editable data field in Piping.
Add the Data to the Catalog
The first step to adding component data, is to add the data to the component. There are several available fields in the catalogs that can be used for a piece of user defined data. (i.e. Alt_P_Mark, User 1, User 2, User 3), User may also create a new field. As always, data must be entered manually into the Catalog Databases. ***In cases where the chosen data is simply a series or other form which Microsoft Office can calculate, the data may be created in Excel and then copied over to the Catalog MDB in Access as a shortcut***Note: Ensure all the above-mentioned steps should be done under the supervision of some Database Admin/Specialist.
Although all Catalog Data is generally stored in the GData of each component, only valid fields from the Piping Table are included in Component Data for BOM. Once the data field is part of component data then user simply need to add the field exactly as it appears in the catalog to the Piping Table. This can be done in Project Administrator by following the steps below:
To create the new queries in SQL Server Management Studio kindly refer the below steps to add and modify the queries.
Although all components created from this point forward will automatically be populated with the new data, previously created components will need to be updated. Running the command Piping>Database Tools>Update From Spec should take care of the update.
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!