Part Transcoding Import

What's the Part Transcoding Import?

Through the form Part Transcoding Import is possible to massively load a large number of items and link them to the part numbers of the connected supplier or customer.

The part transcoding allows the supplier (or potentially the customer) to associate in the master data each partner part number with a personal one. This allows the supplier (or customer) to view his part number on the board and immediately understand which component he is talking about.

The import can be done for one external customer/supplier at a time and the kanban loops associated with the external partner must be already active in the Kanban Board.

If the partner is a supplier in the kanban system, you will find the part numbers to be translated in the table Part number transcoding with supplier, from the menu Masters > Links > Transcoding purchase. If the partner is a supplier in the kanban system, you will find the part numbers to be translated in the table Part number transcoding with customer, from the menu Masters > Links > Transcoding sales.

How to import new transcoding

Procedure:

1. Link on Masters > Import > Part transcoding;
2. In the page Part Transcoding Import click on import_part_number_transcoding.xlsx in the form Download Excel template;
3. The empty Excel file is automatically downloaded: here you can enter the new transcoding part numbers;
4. Open the Excel file import_part_number_transcoding.xlsx;
5. The first sheet Help shows a brief guide on how to compile the file. To insert the new transcoding part numbers, click on the second sheet Transcoding part number;
6. Fill in all the data (see details below, in the compilation guide);
7. Save the Excel file (keeping the name import_part_number_transcoding.xlsx is not mandatory);
8. Re-enter KanbanBOX in Masters > Import > Part transcoding;
9. In the field Choose partner: select the external partner whose transcoding is going to be imported;
10. In the field Excel file for Transcoding click on Choose file;
11. Search for and select the file saved in point 7;
12. Click on Open;
13. The file is now selected and loaded into the space provided. Then click on Part Transcoding Import;
14. In the new screen, the data entered in the Excel will be re-proposed. Pay particular attention to the last two columns:

1. Click on Import data in KanbanBOX to complete the import. The data will now be entered into the tables Part number transcoding with customer or Part number transcoding with supplier.

How to fill in the transcoding import sheet

The sheet is divided into: - Columns: based on the maximum number of fields that can be imported in the Part Transcoding Import; - Lines: number of codes that you want to massively import in the Transcoding sale or Transcoding purchase tables.

For each completed line, a new part number will be added to the Partner Parts master.

When compiling, follow these rules:

• Do not change the name of the sheet Transcoding part number 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.