Edit the Valve Operator Part Number in the Piping Commodity Material Control Data Sheet - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Help
Version_S3D
12.x(2018)

The Valve Operator Part Number in the Piping Commodity Material Control Data sheet is not a property used to create the unique ID definition of the record. Therefore, you can mark the existing record as modified by typing M at the beginning of the record. However, because the valve operator is an output to the symbol definition of the valve, you must mark all affected valve part records as modified by typing M at the beginning of each record.

  1. Open the Piping Commodity Material Control Data sheet.

  2. Locate the record, edit the Valve Operator Part Number value, and then type M at the beginning of the record.

  3. In the Part Classes sheets, locate the valve parts affected by the changes.

  4. At the beginning of each affected valve part record, type M.

  5. Bulkload the spreadsheet, and review the log file.

  6. Use Catalog Checker to review the impact of the proposed changes.

  7. Because editing the Valve Operator Part Number impacts the modeled objects, use Synchronize Model with Catalog to mark the out-of-date objects.

  8. Use Synchronize Workspace to update the objects.

  9. Verify your changes, and resolve any discrepancies.

Use the following SQL statement to find all affected valves:

Select

x1.oid,

x10.ItemName as PartOcc,

x11.PartNumber,

x15.PrimarySize,

x15.PriSizeNPDUnits,

x15.SecondarySize,

x15.SecSizeNPDUnits,

x14.Name as ClassName,

x4.ValveOperatorCatalogPartNumber as 'Operator PartNumber'

From JPartOcc x1

Join JNamedItem x10 on x10.Oid = x1.oid

Join XmadeFrom x2 on x2.OidOrigin = x1.oid

Join JDPart x11 on x11.Oid = x2.OidDestination

Join JDPipeComponent x15 on x15.Oid = x11.oid

Join XSymbolDefinitionforPartClass x13 on x13.OidDestination = x11.oid

Join JDPartClass x14 on x14.Oid = x13.OidOrigin

Join XPartOccToMaterialControlData x3 on x3.OidOrigin = x1.oid

Join JValveOperatorInfo x4 on x4.Oid = x3.OidDestination

Where x4.ValveOperatorCatalogPartNumber Not like ''

Order by x11.PartNumber, x15.PrimarySize, x15.PriSizeNPDUnits, x15.SecondarySize, x15.SecSizeNPDUnits