Zum Inhalt springen
Tasks
- In this tutorial we’ll show you how to import delivery data to FoodChain-Lab via our Excel templates.
- We will first import the initial data for the outbreak locations and then successively add the delivery data for caterers and other suppliers via autogenerated back- and forward-tracing templates.
1
- Select Food-Lab > Open DB Gui… in the menu bar to open the database interface.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/1.png)
2
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/2.png)
3
- For this tutorial we have already pre-prepared “Start Tracing Forward” templates for two Caterers, at which some contaminated food products were detected.
- These templates contain deliveries from the Caterers to several Educational Institutions.
- Here we start with “Forward” instead of “Backward” templates, since we first want to know the recipients of the Caterers’ menus and not the suppliers of the ingredients.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/3.png)
4
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/4.png)
5
- To import the files click on the Table import button in the upper left corner of the database interface.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/5.png)
6
- In the file dialog that appears, select “Start_Tracing_Forward_Caterer1.xlsx” and “Start_Tracing_Forward_Caterer2.xlsx”.
- Then press Open.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/6.png)
7
- You’ll see a message that the import was successful.
- Press OK.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/7.png)
8
- In the database interface you’ll notice, that there is now data in the tables.
- Now we want to do a backtracing starting from the caterers to see where they got the ingredient of the meals from.
- Press the button for generating backtracing templates, which is marked by the red circle.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/8.png)
9
- Since we want to do the backtracing for the caterers, select Caterer only and press OK.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/9.png)
10
- In the file dialog that appears, you can specify the folder where the generated templates should be saved.
- Select or create the desired folder and press Save.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/10.png)
11
- You’ll be noticed, that 2 templates were generated in the folder you specified.
- Press OK.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/11.png)
12
- Open the generated template for Caterer 1.
- In the upper part of the sheet you can see all the outgoing deliveries of Caterer 1, that were imported with the “Start Forward Template”. These deliveries belong to two different lots: “C1M1” and “C1M2”.
- The cells here have grey background. That means that you should not edit them.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/12.png)
13
- Scroll down to the section where you can enter the ingredient for the two lots.
- A delivery of “Frozen Strawberries” from “Frozen Fruit Sales” was used as an ingredient in lot “C1M1”.
- So lets enter this delivery here (marked by the red box).
- Save and close the document.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/13.png)
14
- Now open the generated template for Caterer 2.
- Analogously to the previous template you can see all the outgoing deliveries of Caterer 2.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/14.png)
15
- Scroll down to the section where you can enter the ingredient for the two lots.
- Two deliveries of “Frozen Strawberries” from “Frozen Fruit Sales” were used as ingredients in lot “C2M1”.
- Enter the deliveries here (marked by the red box).
- Then save and close the document.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/15.png)
16
- To import the two files into the database click on the Table import button in the upper left corner of the database interface.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/16.png)
17
- In the file dialog that appears, select both backtracing templates.
- Then press Open.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/17.png)
18
- You’ll see a message that the import was successful.
- Press OK.
![](https://github.com/SiLeBAT/BfROpenLabResources/raw/master/GitHubPages/documents/foodchainlab_datacollecting_1/18.png)