Importing data into FoodChain-Lab with All-in-one template
Tasks
- In this tutorial we’ll show you how to import delivery data to FoodChain-Lab via our All-in-one Excel template.
- All data will be entered in one file.
- The All-in-one template can be download from here: https://github.com/SiLeBAT/BfROpenLa…
- If you do not want to fill the template yourself, you can download the filled out result of this tutorial from here: https://github.com/SiLeBAT/BfROpenLa…
Step 1
- Open “All_In_One_Template.xlsx” and select the Stations sheet.
- Here you must enter all stations of the delivery network.
- The Company_ID column is mandatory, all other columns are optional.
- Next to Additional Fields you can specify your own columns, for which you would like to enter data.

Step 2
- Now select the Deliveries sheet.
- Here you must enter all deliveries between the stations defined in the previous sheet.
- The columns with the red headers are mandatory. In Station and Recipient you must enter Company_IDs from the previous sheet.
- Next to Additional Fields you can specify your own columns, for which you would like to enter data.

Step 3
- Now select the Deliveries2Deliveries sheet.
- Here you can connect two deliveries from the previous sheet. In both columns you must enter DeliveryIDs.
- The From-delivery is a part/ingredient of the To-delivery. A contamination can spread from “From” to “To”.

Step 4
- Switch back to the Stations sheet and enter the data from the screenshot.

Step 5
- Switch to the Deliveries sheet and enter the data from the screenshot.
- The “Yogurt Factory” produces two lots of yogurt. Milk from delivery “L117_1” is used for the first lot (“LY1”) and milk from deliveries “L117_2” and “L14_1” is used for the second lot (“LY2”). This ingredient information will be entered in the next sheet.

Step 6
- In this sheet you can only reference deliveries and not lots.
- Therefore we have to connect “L117_1” to both deliveries of lot “LY1” (“LY1_1” and “LY1_2”).
- And “L117_2” and “L14_1” have to be connected to both deliveries of lot “LY2” (“LY2_1” and “LY2_2”).

Step 7
- After entering all data in the template, please open KNIME now.
- Then select Food-Lab > Open DB Gui… in the menu bar to open the database interface.

Step 8
- To import this file click on the Table import button in the upper left corner of the database interface.

Step 9
- In the file dialog that appears, select “All_In_One_Template.xlsx” and press Open.

Step 10
- You’ll see a message that the import was successful.
- Press OK.

Step 11
- In the database interface you’ll notice, that there is now data in the tables.
