LogTool – Log Conversion & Analysis
A Python-based desktop tool built to convert, structure, analyse, and validate medical device production logs while reducing manual work and improving production visibility.
Problem
Production test logs were stored as raw TXT files with inconsistent formats, duplicated timestamps, missing device tracking, and manual Excel handling that made analysis slow and difficult.
Finding missing devices, validating passed units, checking failed tests, and preparing batch reports required a large amount of repetitive manual work.
Solution
I developed LogTool — a Python desktop application that automatically parses production logs, detects batch information, identifies missing devices, converts logs into structured Excel files, and generates analysis summaries for faster decision-making.
Key Features
- TXT log conversion to structured Excel reports
- Automatic batch and serial number detection
- Missing device finder by batch and serial range
- Specific batch search across multiple TXT files
- PASS / FAIL validation and filtering
- Analysis sheet with pass rates and test statistics
- SFTP integration for remote file access
- Standalone desktop EXE with CustomTkinter UI