Manufacturing projects for IEE

Production monitoring

A web application for production monitoring. It provides a quick overview of the current situation in the production hall. Behind it, a production order is exported to the production scanning system (traceability). The scan results have to be compared with the recipe from SAP and with the materials and tools issued by other external systems. The application prepares and displays summary data and lets users drill down into progressively more detailed information. A key part is a complex HTML table showing the completeness of the production order across individual shifts and processes. The view provides comprehensive information about the current situation, and multi-level expansion of rows and columns reveals the details of each step of the process. The solution also tracks the users who scanned in to a process that requires an ESD check (electrostatic discharge – since the work involves electronics) and shows a warning if someone has skipped the check.

Other projects:

• Database migration (MaxDB -> DB2) – a tool for migrating data and other database structures (constraints, triggers, …) from the old SAP MaxDB v7.4 database to IBM DB2 (v. 9.+).
• Reliable Sender library (MQTT, JMS) – wraps sending messages to a broker and survives connection outages (messages are kept in a local store and sent once the connection is restored). The implementation had to be thread-safe and, after reconnecting, had to send all the data collected during the outage.
• ESD Terminal (Warmbier PGT120 + Datalogic TD1100) – an app for testing people for electrostatic charge (employees who work with open circuits and sensitive devices). It communicates with a barcode scanner (identification) and an electrostatic testing device and sends the results to a server. The client application for the testing station was built in JavaFX.
• Device Manager – an IoT server for managing devices, extensible for specific device types. It communicates via an API with the “Sensorium” application.
• Sensorium – a web application for collecting data from IoT devices (temperature, humidity, etc.) and visualizing the collected data. It sends an alarm when a value leaves its allowed range. It uses WSO2 ESB and MB for message flow.
• and more