Lab Instrument Data Hub
Collects raw test curves and metrics from legacy Windows XP machines, serial instruments and spreadsheets onto an offline LAN server — without replacing hardware or touching vendor software
In many materials, rubber and chemical testing labs, rheometers, Mooney viscometers and tensile testers stay mechanically sound for over a decade while still running on aging Windows XP PCs. Vendor software upgrades are costly, raw files sit scattered across isolated machines, and overlaying curves across batches is painful. Deployed on a single LAN server, this platform follows two strict rules: never modify vendor control software or existing files on instrument PCs, and keep collection agents purely transport-only so all parsing and calculation happen centrally. Four ingestion paths work together: a zero-dependency 32-bit Windows XP agent (compiled with Go 1.10) scans folders read-only with offline queueing and HMAC-signed uploads; serial-to-Ethernet boxes stream bytes from standalone instruments over TCP with auto-reconnect; a visual CSV/Excel mapper auto-detects GBK/UTF-8 encodings to onboard new table layouts without writing code; and drag-and-drop USB uploads deduplicate by SHA-256. Built-in GB/ISO algorithms compute vulcanization (ML, MH, ts1, ts2, t10, t50, t90), Mooney viscosity/scorch, and rubber tensile strength alongside vendor-reported values. Raw files are append-only at both application and database-trigger levels, allowing historical re-parsing whenever rules evolve, backed by tamper-evident hash-chained audit logs, print-ready PDF reports, and an offline Windows service installer verified by 65 automated tests.
- 01
Windows XP 32-bit single-binary read-only agent with offline queue and HMAC-SHA256 signing
- 02
Direct TCP ingestion from serial-to-Ethernet converters with automatic segmentation and reconnect
- 03
No-code CSV/Excel import templates with GBK/UTF-8 auto-detection and dry-run verification
- 04
Built-in GB/ISO vulcanization, Mooney and tensile curve calculations alongside vendor metrics
- 05
Multi-batch curve overlay comparison, Excel curve export and print-ready vector PDF reports
- 06
Append-only raw vault with historical re-parsing, hash-chained audit verification and daily incremental backups
- 07
Self-contained offline Windows service installer plus standalone field serial recorder



