Import of Containers

What is container import?

Through the form Containers import it's possible to massively load a large number of containers inside the KanbanBOX Containers master.

Procedure:

Link on Master data > Import > Containers;
In the page Containers import (add) click on import_bin.xlsx in the field Download Excel template;
The empty Excel file is automatically downloaded: here you can enter the new containers;
Open the Excel file import_bin.xlsx;
The first sheet Instructions shows a brief guide on how to compile the file. To insert the new containers, click on the second sheet Containers;
Fill in all the data (see details below, in the compilation guide);
Save the Excel file (keeping the name import_bin.xlsx is not mandatory);
Re-enter KanbanBOX in Master data > Import > Containers;
In the field Excel file for Containers click on Choose file;
Search for and select the file saved in point 7;
Click on Open;
The file is now selected and loaded into the space provided. Then click on Containers import;

In the new screen, the data entered in the Excel will be re-proposed. Pay particular attention to the last two columns:

Field	Description
Errors	If the import causes an error, the line will be placed at the top of the containers list and will not be imported to the system. It is possible to know the reason for the error in this column.
Action	Update: the container is not new, but it will be updated into the KanbanBOX Containers master. Attention: every updated container loses all the information previously entered in all fields and acquires the new ones inserted in the Excel file! Add new: a new container is added in the Parts master.

Click on Containers import (add) to complete the import. The data will now be entered into the Containers master.

The sheet is divided into:

Columns: based on the maximum number of fields that can be imported in the Containers master;
Lines: number of codes that you want to massively import in the Containers master.

Column	Field	Description	Field constraints
1	Bin name	Bin name	Required field. It must be unique for each bin of the master
2	Description	Bin description	Optional
3	Bin number	Bin identification code	Optional
4	Weight	Weight of the container in LB	Optional
5	Length	Length of the container	Optional
6	Width	Width of the container	Optional
7	Height	Height of the container	Optional
8	Custom field 1	Bin custom field 1	Optional
9	Custom field 2	Container custom field 2	Optional
10	Custom field 3	Container custom field 3	Optional

For each completed line, a new container code will be added to Containers master.

When compiling, follow the following rules:

Do not change the name of the sheet Containers or it will not be considered during the import;
Do not change the name of the fields or the data will not be considered during the import;
Additional sheets will not be considered during import;
Additional columns will not be considered during import;
Any missing columns will be considered as invalid values;
The cells of the columns cannot contain formulas.