I built a PHP and MySQL tool that automatically imports service tickets from our POS system into DispatchTrack, our tech-routing platform — streamlining ticket management while mentoring an apprentice developer through the build.
Two Systems, One Manual Gap
Service tickets started in the POS and had to end up in DispatchTrack for routing, and the handoff was manual, slow, and error-prone. Automating it meant reliably moving data between two systems that were never designed to talk to each other.
What I Delivered
Automated import
Built a PHP/MySQL tool that moves service tickets from POS into DispatchTrack automatically.
System integration
Bridged two platforms that didn't natively talk — clean, reliable data on every ticket.
Faster routing
Streamlined ticket management so routing and scheduling ran on accurate, up-to-date data.
Mentored an apprentice
Trained an apprentice developer through the build — hands-on guidance in real software practice.
Skills & Tools
The stack behind this build — tap any to see related work.
The Impact
Service tickets flowing automatically from POS to DispatchTrack — faster routing, fewer manual errors, and an apprentice developer leveled up along the way.
Let the Systems Do the Typing
The most reliable data entry is the kind nobody has to do. Automating the POS-to-DispatchTrack handoff removed a daily manual chore and its errors, and mentoring an apprentice through it meant the skill stuck around too.
Image credits: “CERN Server 03” by Florian Hirzinger – www.fh-ap.com (CC BY-SA 3.0) · “Bridge Global developers' bay, Apr 2019” by Arunvrparavur (CC BY-SA 4.0)
