Flagship automation project

Dental Lab Automation

A Python workflow for dental lab case intake that converts scanned slips and digital portal records into structured, reviewable fields before handoff into an Access-based lab management process.

Python OCR/document parsing Playwright SQLite Microsoft Access Validation

Measured outcome

From manual intake to reviewable automation

The workflow watches scanned files, waits for stable writes, extracts patient and case metadata, stores the original record, flags possible duplicates, and keeps staff verification before final case creation.

  • Reduced one recurring case-intake workflow from about 3 hours to about 5 minutes.
  • Handled paper slips and browser-retrieved digital cases from external dental portals.
  • Extracted fields such as patient, doctor, case ID, shade, due date, material, notes, and related metadata.
Watch scanned folders
OCR and parse case slip
Retrieve digital portal cases
Validate and warn on duplicates
Staff review before Access handoff

What it handles

The workflow is designed around imperfect intake data: scanned slips, portal records, inconsistent case metadata, and fields that still need a human check before they enter the lab system.

Workflow safeguards

Parsed records stay reviewable before handoff. Duplicate warnings, validation, logging, and staff verification keep the automation useful without pretending OCR or messy documents are always perfect.