Remark from File
The Remark from File subfunction allows batch renaming of containers and automatic creation of related Events based on an imported Excel file.
When the button is clicked, a local Excel file must be selected. The file must include three columns:
Column | Description |
Current Container Number | Existing container name |
New Container Number | New name to assign |
Date | Date to be assigned to the event |
Up to 2,000 rows can be processed in one file.
Column Mapping
After selecting the file, the system will prompt for confirmation of which columns contain the required data. By default, the system expects:
Container № — Column A;
New Container № — Column B;
Date — Column C.
If the specified columns do not contain valid data, an error message appears: "Unable to find columns".
If valid data is found, the system renames the containers listed in the file and creates event objects based on the provided dates:
One event is created for each unique date.
All containers with the same date are grouped into the same event.
Processing Errors
During processing, the system may detect invalid containers. Three types of errors are possible:
"Container not found" — The specified container does not exist in the system.
"Invalid status: Sold or None" — Containers with these statuses cannot be renamed.
"Invalid name format" — The new container name does not match the required pattern (4 letters + 7 digits).
All valid containers will be renamed even if some errors are found.
