Desktop Automation Tool for Equipment Inspections

Manufacturing facilities conduct yearly equipment inspections. Before this tool, engineers wasted hours manually copying inspection data from Word reports into Excel files, maintaining separate spreadsheets with no single source of truth, and searching through multiple files to find component history.

I built a Windows desktop application that eliminates all of that.

The app automatically extracts inspection data from Word documents using intelligent parsing, centralizes everything in portable SQLite databases (one per plant), and tracks component health across inspection years in a single matrix view.

Key features:

Automatic data extraction from .docx files via python-docx, handling multi-language documents, varying table layouts, Wingdings encoding, and corrupted data

Centralized database with real-time search across all components and inspection years

Multi-user collaboration with automatic conflict resolution for SharePoint/OneDrive teams

One-click PDF export for landscape reports and documentation

Full audit trail tracking who changed what and when, authenticated via OS credentials

The frontend is built with Electron for cross-platform desktop support. The backend uses Python for intelligent document parsing. Data lives in SQLite databases that are portable, zero-admin, and SharePoint-compatible.

Security was a priority: renderer sandbox, input sanitization, XSS prevention, and OS-authenticated audit logging.

The app is tested with 53+ automated test cases covering parser accuracy and database integrity.

The application is production-ready and currently deployed. Engineers who used to spend hours on manual data entry now upload a Word document and have everything parsed, stored, and searchable in seconds.