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.
Open the Piping Commodity Material Control Data sheet.
Locate the record, edit the Valve Operator Part Number value, and then type M at the beginning of the record.
In the Part Classes sheets, locate the valve parts affected by the changes.
At the beginning of each affected valve part record, type M.
Bulkload the spreadsheet, and review the log file.
Use Catalog Checker to review the impact of the proposed changes.
Because editing the Valve Operator Part Number impacts the modeled objects, use Synchronize Model with Catalog to mark the out-of-date objects.
Use Synchronize Workspace to update the objects.
Verify your changes, and resolve any discrepancies.
Use the following SQL statement to find all affected valves:
x10.ItemName as PartOcc,
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