Steamulo

N7.CBL Application

A web application for automated, secure generation of the N7.CBL file, replacing an Excel/VBA tool, for Colissimo's OPB industrial sorting system.

DevelopmentDevOpsAI & Data
2024

Context & objectives

As part of modernising the OPB industrial sorting system, La Poste wanted to replace a legacy tool for generating the N7.CBL file — a central file used by automated sorting equipment. Previously generated via an Excel tool with VBA macros, this process carried a high risk of human error, maintenance difficulties, no traceability and no secure access.

The goal: design an ergonomic, secure and maintainable web application that automatically generates the N7.CBL file, with configuration, editing, simulation and visualisation features.

0%

less processing time

0 months

to replace the obsolete process

Architecture & features

Co-built through framing workshops then developed in Agile Scrum (two-week sprints), the application relies on a robust stack: ReactJS 18 / TypeScript on the front, Java 17 / Spring Boot on the back, a PostgreSQL database, Jenkins & GitlabCI CI/CD, Ansible + AWX deployment on an internal Ubuntu VM (no internet access).

Key features: automatic N7.CBL generation, a configuration interface (sequences, associations, labels), version management and history, simulation and export, preview and built-in consistency checks (format, ranks, business constraints).

Results

In under 3 months, the application replaced an obsolete process with a modern, secure solution: a secured generation process, drastically reduced human error, processing time cut by 70%, strengthened compliance and maintainability ensured by module decoupling and deployment automation.

Ready to scale up your projects?

Our experts are ready to audit your strategy and identify your first AI acceleration levers.