A public works department put 112 trucks, tippers and plant on one maintenance record, serviced by engine hours where it counts.
The challenge
Records lived in a desktop database only the shop could open, and inspections were paper forms filed by month.
Hydraulic equipment on tippers was serviced by calendar, so busy trucks went too long and idle ones too soon.
What they changed
The CSV import moved 112 units in an afternoon; the preview caught 14 VIN typos and three duplicate unit numbers before anything was loaded.
Hydraulic services moved to engine hours with a yearly backstop, and each department got its own depot and roles.
“The audit question used to be 'can you find it?'. Now it is 'which format do you want it in?'.”
Where they are now
Auditors received a per-vehicle export of every check and repair for the year in one download.
Department heads see their own trucks and costs; the shop sees one queue.