diff_mto_scsa
Compare an MTO file with a Plant 3D SCSA export to identify quantity mismatches, removed items, and new items. Returns counts and lists for each scenario, with optional category filtering.
Instructions
Compare an MTO file against a Plant 3D SCSA export.
Read-only - never writes anything. Returns counts and item lists for the 3 scenarios: qty_mismatch, removed (in MTO, not in SCSA anymore), new (in SCSA, not yet in MTO). Items with matching qty in both are counted in summary.matched but not listed individually.
Args: mto_path: path to the MTO .xlsx file. scsa_path: path to the SCSA .xlsx export. category: optional filter - one of pipe/elbow/tee/reducer/flange/ valve/blind_flange/gasket/stud_bolt/bolt/nut/washer/ gate_valve/safety_valve/ball_valve/steam_trap/pipe_support/ insulation/structural_steel. Omit to diff everything.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | ||
| mto_path | Yes | ||
| scsa_path | Yes |