Problem
Orders and priorities needed a clear view in both office and factory environments without relying on scattered documents or constant manual checking.
PRODUCTION SYSTEM
IN PRODUCTIONProduction
Operations
Windows desktop, NAS and factory display
I built an application to organize production orders in the office, automate the arrival of new orders and maintain a shared TV/Focus view on the factory floor.
Deployment10+ computers · 1 TV · 20+ professionals · 9 areas
TechnologiesPython · PySide6 · SQLite · OCR · PyInstaller · Windows
My workProduct · architecture · development · installation · training · support
APPLICATION SCREENS
Office and factory in the same workflow
The public screens preserve the application experience with fictional data.
Internal use
The TV acts as a shared reference for new orders and for locating each order across the factory areas.
Privacy
The operational database, paths, documents, customers and real orders are not part of the publication.
What I built
A desktop application, SQLite database, history, Office and TV/Focus modes, configurable areas, reviewable imports, local cache, migrations, installer and isolated demo mode.
New-order automation
An integration workstation checks the NAS in read-only mode, creates an initial baseline and looks for new documents Monday through Friday at 10:00 and 15:00. It does not move, rename or delete source files.
Current result
- Installed on 10+ computers and one TV.
- Used in the office and supports 20+ people across nine production areas.
- Training, guidance and follow-up after deployment.
Continuity
Local cache helps keep the TV useful during transient failures while the NAS source remains read-only.
Next evolution
A multi-site expansion would require corporate identity, a central transactional database, workstation telemetry and observability.
This case presents a sanitized public version of a system deployed and used in daily operations.
Next projectCommercial Proposal
Contact