Automating mill test reports
How major steel distributors equipped themselves with a solution to automate the processing of their mill certificates (Mill Test Reports): a platform developed by Openmind, powered by Claude from Anthropic.
The project in numbers
The context
In the steel industry, every heat of raw material produced by a mill comes with a Mill Test Report (MTR): a certificate signed by a chemist, attesting to the metal’s composition and properties. This certificate must then follow the material along the entire chain, from the mill to the distributor and on to the end customer, who must be able to account for it if a problem arises.
For distributors, this tracking is particularly complex: a batch of parts delivered to a customer does not always come from a single heat, and the same heat can end up in several different batches. Without a structured system, every certificate received by email had to be checked manually, then filed in a folder, with no way to search inside the PDFs themselves.
For one of the participating companies, the issue had become urgent: the person responsible for this task was retiring. The work is considered essential, since it affects material compliance and quality, but it is tedious, unrewarding and hard to staff.
Rather than each developing their own solution, the participating companies chose to join forces around a shared solution, developed by Openmind, to speed up its rollout and reduce the risks.
The solution
Developed by Openmind (Code&Steel) and powered by Claude from Anthropic, the solution sits upstream of existing systems, without replacing them. It monitors a dedicated email inbox: as soon as a Mill Test Report arrives, the document is processed automatically, whatever its language. It also handles scanned documents, with reliability tracked separately for native and scanned files.
Artificial intelligence extracts only the information that is genuinely useful for searching: the heat number, the associated product lines, the certificate number, the supplier name and the date the report was produced. The rest of the information, less relevant day to day, is not extracted: the goal is not to digitize everything, but to make what matters quick to find.
Every document is still validated by a person before it is filed or sent: human validation is an integral part of the process and confirms, at every step, the accuracy of the automatic recognition. The solution can also automatically redact irrelevant or confidential information before it is shared externally, a feature added during the project at the request of the participating companies.
In practice, the solution makes it possible to:
›Automatically receive and process Mill Test Reports sent by email
›Use artificial intelligence to extract key information, whatever the document’s language
›Instantly find a certificate by heat number or by product code
›Have a person validate each document before it is filed or sent
›Automatically redact irrelevant or confidential information before sending it to a third party
›Archive all certificates in one central, searchable place
›Combine several certificates into a single consolidated document, selecting the heats to include
›Send the document to the end customer by email, directly from the solution
Results and next steps
The participating companies contributed at every stage of the project: initial requirements gathering, testing during development, then adjusting priorities. The automatic redaction feature, for example, was not planned at the outset; it was added along the way following their feedback from the field.
The solution was designed as a modular foundation, able to evolve with real needs: possible integration with existing ERP systems, new features prioritized with users, and potential rollout to other distributors in the industry, in Canada as well as the United States.
This solution is designed to turn a manual, repetitive and risky task into a reliable, fast and scalable process, tailored to real needs on the ground.
Developed by Openmind in short cycles and powered by Claude from Anthropic.
Contact
Tell us more about your needs so that we can better route your project to our specific SWAT team.
During the brainstorming phase, we work with you to identify potential solutions to your business challenges to generate the technology response that aligns with your business objectives.
Through our requirements gathering process, we work closely with you to define and prioritize your needs, ensuring that our solutions are tailored to meet your specific requirements.
This phase marks the beginning of our partnership. We’ll finalize the project plan and establish clear communication channels to ensure a smooth and successful project execution.