Import of multiprocess relations

What is the Multiprocess relation import?

Through the form Import Multiprocess Relations, it's possible to massively load a large number of multiprocess relations in KanbanBOX.

How to import new multiprocess relations

Procedure:

1. Get in Masters > Import> Multiprocess Relations;
2. In the page Import Multiprocess Relations click on import_multiprocess.xlsx in the field Download Excel template;;
3. The empty Excel file is automatically downloaded: here you can enter the new relations;
4. Open the Excel file import_multiprocess.xlsx;
5. The first sheet Help shows a brief guide on how to compile the file. To insert the relations, click on the second sheet Multiprocess;
6. Fill in all the data (see details below, in the compilation guide);
7. Save the Excel file (keeping the name import_multiprocess.xlsx is not mandatory);
8. Re-enter KanbanBOX in Masters > Import> Multiprocess Relations;
9. In the field Excel file for multiprocess relations, click on Choose file;
10. Search for and select the file saved in point 7;
11. Click on Open;
12. The file is now selected and loaded into the space provided. Then click on Import Multiprocess Relations;

13. 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 relations list and will not be imported to the system. It is possible to know the reason for the error in this column.
    Action	Add new: a new multiprocess relation is added. Attention: for each parent kanban loop in the import file, all current relations will be deleted and replaced with the new ones. Make sure that, for each parent kanban loop in the import file, the file contains all its relations.

14. Click on Import data in KanbanBOX to complete the import. The data will now be entered into the Multiprocess kanbans.

How to update multiprocess relations by the import

Procedure:

1. Get in Kanban > Multiprocess Kanban;
2. In the table, filter the partners you want to update;
3. Click on the icon in the table menu Export, edit and import multiprocess relations;
4. The file import_multiproceso.xlsx is downloaded automatically: it contains all the relations filtered in the table Multiprocess kanbans;
5. Open the Excel file import_multiprocess.xlsx;
6. The first sheet Help shows a brief guide on how to compile the file. To modify the relations, click on the second sheet Multiprocess;
7. Edit the file and save it (keeping the name import_multiprocess.xlsx is not mandatory);
8. Go back to KanbanBOX in Masters > Import> Multiprocess Relations;
9. In the field Excel file for multiprocess relations click on Choose file;
10. Search for and select the file saved in step 7;
11. Click on Open;
12. The file is now selected and loaded into the space provided. Then click on Import Multiprocess Relations;

13. 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 relations list and will not be imported to the system. It is possible to know the reason for the error in this column.
    Action	Add new: a new multiprocess relation is added. Attention: for each parent kanban loop in the import file, all current relations will be deleted and replaced with the new ones. Make sure that, for each parent kanban loop in the import file, the file contains all its relations.

14. Click on Import data in KanbanBOX to complete the import. The data will now be entered into the Multiprocess kanbans.

How to fill in the multiprocess relations import sheet

For each completed line, a new multiprocess relation will be added to the table Multiprocess kanban. When compiling, follow these rules:

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