Distribution warehouse filled with steel sections, tubes and beams, with an overhead crane

An essential task few people want to do, now automated and reliable.

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.

A collaboration between
Groupe Picard
Métalium

The project in numbers

Hours spent reading PDFs.Automated processing, from receipt to delivery.

80 to 90%
targeted reduction in processing time
41,600
certificates processed per yearFor a single company, based on 800 certificates per week
01ReceiptThe certificate arrives by email
02AI extractionThe relevant fields are read, whatever the language
03ValidationA person confirms each document
04SearchBy heat number or product code
05DeliveryConsolidated file sent to the customer
Companies involved
Groupe Picard and Métalium
Industry
Steel products distribution
Solution
Developed by Openmind (Code&Steel)
Interior of a steel distribution shop with an overhead crane, and beams, tubes and angles stacked on the floor

The context

Automating mill certificate processing without disrupting the way each company works.

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.

Worker handling steel beams in a fabrication plant

The solution

An intelligent engine, built for the reality of steel distributors.

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

Assembled steel structures in a structural steel fabrication plant

Results and next steps

A solution designed with its users, ready for production.

A solution shaped by real needs

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.

A shared foundation for what comes next

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

Let's connect

Tell us more about your needs so that we can better route your project to our specific SWAT team.

1

Brainstorm

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.

2

Requirement

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.

3

Kickoff

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.

This field is for validation purposes and should be left unchanged.
Would you like to receive our best AI resources, including practical tools, upcoming events, success stories, and actionable insights to bring AI into your operations?(Required)
By continuing, I agree to the Openmind Technologies privacy policy.