MRP Production Serial Matrix Import Xlsx

This module adds Excel import and export to the serial/lot matrix screen of a manufacturing order.

On the matrix form you get two new buttons: - "Download Template" builds an Excel file with one row per finished product serial number and one column per tracked component, pre-filled with the component lots already recorded, and downloads it. - "Import from XLSX" reads an uploaded Excel file and rebuilds the matrix lines from it. It is only shown when a file has been uploaded and the matrix is not in progress or done.

A new "Upload Excel File" field is added to the form (with its file name kept in the background). When you import, the module reads the first sheet, takes the finished serial numbers from the first column and the component lots from the other columns. Finished serial numbers that do not exist yet are created automatically for the manufactured product. Component lots must already exist: if a lot written in the file cannot be found for the component product, the import stops with an error message naming the lot, the column and the serial number. Existing matrix lines are replaced by the imported ones.

The columns offered are built from the components of the manufacturing order: serial-tracked components get one column per unit, and lot-tracked components get a column only when the matrix is set to include lots.