Import of Bins

What is bins import?

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

Procedure:

Link on Masters > Import > Bins;
In the page Bins 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 bins;
Open the Excel file import_bin.xlsx;
The first sheet Help shows a brief guide on how to compile the file. To insert the new bins, click on the second sheet Bins;
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 Masters > Import > Bins;
In the field Excel file for Bins 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 Bins 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 bins 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 bin is not new, but it will be updated into the KanbanBOX Bins master. Attention: every updated bin loses all the information previously entered in all fields and acquires the new ones inserted in the Excel file! Add new: a new bin is added in the Parts master.

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

The sheet is divided into:

Columns: based on the maximum number of fields that can be imported in the Bins master;
Lines: number of codes that you want to massively import in the Bins 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	Bin custom field 2	Optional
10	Custom field 3	Bin custom field 3	Optional

For each completed line, a new bin code will be added to Bins master.

When compiling, follow the following rules:

Do not change the name of the sheet Bins 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.