SES Quality: from course case to product

The case came from a digitalisation course at the University of Southern Denmark: inspection of finished goods at a Danish manufacturer. Deviations were written on paper, serious faults were reported by word of mouth at the line, no photos were taken, and corrective actions were not followed through.

The first solution was built in Power Apps on SharePoint lists. It showed the idea and the limits:

• Queries were cut short without warning once a list passed a few thousand rows
• Photos were stored as text in a column
• Every user needed a Microsoft licence
• There was no audit trail, and a record could be overwritten

SES Quality was rebuilt from scratch as a standalone system: a web app for phone and tablet that works without a network, a PostgreSQL database where customers' data is separated by the database itself, and an audit trail the database does not allow to be changed.

The deviation catalogue, severity codes and lines are data each customer controls. No customer has code of its own.

The system is tested against a real database and has been through several internal reviews. Each review is written up with its findings and what was done about each one.

The core and two optional modules are built. The product is looking for its first customer, so there are no results from production to show yet. When there are, they will go here with a description of how they were measured.