What checks should be performed on CMM data before importing into Form 3?

Before importing CMM data into Form 3, verify that the data is from the correct part, drawing or model revision, inspection plan, CMM program, and production condition, and that each result maps cleanly to the intended ballooned characteristic. Do not treat the import as a clerical step only. In an AS9102 or similar first article context, a bad import can create a clean-looking record with incorrect traceability.

Minimum checks before import

• Part and revision match: Confirm the part number, drawing revision, model revision, specification revision, work order, serial number, lot number, and operation context match the Form 3 record.
• Characteristic mapping: Check that CMM feature names, balloon numbers, drawing zones, and characteristic IDs align. This is a common failure point when naming conventions differ between inspection planning, ballooning software, and CMM output.
• Units and precision: Verify inch versus millimeter, angular units, decimal places, and significant digits. Also confirm how the import handles rounding, truncation, and trailing zeros.
• Tolerance interpretation: Confirm nominal values, upper and lower limits, unilateral tolerances, profile tolerances, true position, datum references, and any special acceptance rules. GD&T results are especially prone to misinterpretation if the CMM export and Form 3 template are not aligned.
• Datum and alignment basis: Confirm the CMM setup, datum scheme, fixture, coordinate system, and alignment method match the approved inspection plan. A valid measurement from the wrong alignment basis is still not valid evidence for the intended characteristic.
• CMM program status: Verify the CMM program version, approval status, and change history. If the program was edited after approval, the change should be reviewed under the site’s inspection and quality change control process.
• Equipment and calibration: Confirm the CMM, probes, fixtures, and relevant gages were within calibration and suitable for the required tolerance range at the time of measurement.
• Completeness: Identify missing characteristics, skipped features, repeated measurements, out-of-tolerance results, conditional requirements, and manually entered values. The import should not silently drop or overwrite results.
• Sample and production basis: Confirm whether the data represents the correct first article unit, partial FAI, delta FAI, family part, cavity, tool, or serialized item. This is site- and customer-dependent.
• Raw data retention: Retain the original CMM report or export file, import log, reviewer identity, timestamp, and any transformation rules used. This supports traceability but does not by itself guarantee acceptance.

Checks specific to the import process

The import template or parser should be validated for the file format being used. Typical issues include shifted columns, renamed headers, special characters, merged cells, locale-specific decimal separators, hidden rows, and inconsistent CMM report formats across machines or plants.

If CMM data is transformed before import, the transformation logic should be controlled. This includes unit conversion, tolerance calculations, characteristic renaming, pass/fail logic, and rounding rules. In regulated environments, uncontrolled spreadsheets and ad hoc scripts are a frequent source of weak evidence.

Brownfield system realities

In many plants, Form 3 data sits between ballooning tools, CMM software, MES, ERP, PLM, QMS, and customer portals. These systems often do not share one clean characteristic master. Full replacement is usually unrealistic because of validation cost, qualification burden, downtime risk, integration complexity, traceability obligations, and long equipment lifecycles.

For that reason, the practical control is usually not a perfect end-to-end digital thread on day one. It is a controlled mapping process, defined ownership, import validation, exception handling, and reviewer signoff before the Form 3 record is released.

What should not be assumed

A successful import does not prove the measurement was correct, the CMM program was suitable, the part was conforming, or the FAI package will be accepted. It only shows that data was loaded into the form. The quality value comes from the upstream inspection controls, the correctness of the mapping, and the review evidence retained with the record.