Migration story
From WinWam + mLO to one platform
A pragmatic migration plan from two end-of-life systems (and one Excel-driven metrology lab) to a single, modern portal.
Today (legacy stack)
WinWam
EOL / fragile
SQL/VB Pro · EOL 2027 · weights & measures
mLO
EOL / fragile
Systems Automation · EOL 2027 · licensing
Metrology lab
manual
Excel + paper certificates · 2,500+/yr
Sealer reporting
manual
PDFs + email · 188 sealers, ≥5 missing 2023 reports
Cross-agency data
EOL / fragile
Ad-hoc CSV exports by request
This portal (target state)
One database
shipped here
Postgres · audited · single source of truth
Field workspace
shipped here
iPad/Android tablet · offline-first · NIST inline
Public surface
shipped here
Mass.gov-styled · accessible · multilingual
Cross-agency feeds
shipped here
OAuth-secured JSON to MassDOT, MassCEC, EVICC, AGO
AI-driven trends
shipped here
AI-backed risk scoring & anomaly detection
How we get there
1
Read-only mirror
Ingest WinWam + mLO data into the unified Postgres schema. The portal goes live as a read-only transparency layer for staff and the public.
2
Field workspace cuts over first
Inspectors do every routine inspection from the new tablet. Sync writes back to WinWam for 90 days while staff confirm parity.
3
Licensing migration
License renewals (especially Motor Fuel) move to the new applicant portal. Discipline history and cross-agency prefill arrive on day one.
4
Metrology lab consolidation
The lab's Excel workbook becomes a first-class table. Certificates print from the new system; tolerance auto-validation lives next to NIST handbooks.
5
Sealer outreach
The 5 towns missing 2023 reports get auto-reminders and a 1-tap upload form. Sealer dashboard surfaces compliance at a glance.
6
WinWam + mLO retirement
Once parity is verified for two reporting cycles, the legacy systems are decommissioned. Audit trail preserves every event from migration day forward.