← All project packs

Touch HMI with activation traceability and SQL Server

Plant-floor touch screen with authentication, an auditable log of every manual activation and synchronization with the ERP.

Runs on: TouchBerry Pi — Node-RED / JavaScript flows.

The application

A process plant needed every manual activation of the mixer to be recorded with user, reason and comment — a quality audit requirement. A TouchBerry Pi runs the Node-RED dashboard with a virtual keyboard and an expiring administrator session; each activation is written to a local CSV file (exportable to USB) and a Python bridge inserts it into SQL Server, which in turn publishes machine status over MQTT back to the HMI.

Architecture

• TouchBerry Pi with Node-RED dashboard (control and history pages)
• Admin authentication with virtual keyboard and session timeout
• Activation → local CSV + live table + digital output Q0
• Python bridge MQTT ↔ SQL Server (statuses and activations)
• History export to USB from the panel itself

Bill of materials

• TouchBerry Pi — Industrial Shields controller
• Contactor on Q0 — mixer control
• Existing SQL Server — traceability in the plant ERP

What is in the pack

• activation-log-csv-table.js
• admin-auth-virtual-keyboard-timeout.js
• dashboard-mqtt-status-leds.js
• digital-output-q0-rpiplc-node-red.js
• export-history-usb.js
• mqtt-sql-server-bridge.py
• Bill of materials + README