Siemens S7-1200 - Recipe DB Example

Extended instructions
8.7 Recipes and Data logs
S7-1200 Programmable controller
370 System Manual, 03/2014, A5E02486680-AG
Recipe export (from recipe DB to CSV file)
The complete set of recipe records can be generated as a CSV file using the RecipeExport
instruction. Unused recipe records are also exported.
Recipe import (from CSV file to recipe DB)
Once a recipe export operation is completed, then you can use the generated CSV file as a
data structure template.
1. Use the file browser page in the CPU web server to download an existing recipe CSV file
from the CPU to a PC
2. Modify the recipe CSV with an ASCII text editor. You can modify the start values
assigned to components, but not the data types or data structure
3. Upload the modified CSV file from PC back to the CPU. However, the old CSV file in CPU
load memory (with the same name) must be deleted or renamed before the CPU Web
server allows the upload operation.
4. After the modified CSV file is uploaded to the CPU, then you can use the RecipeImport
instruction to transfer the new start values from the modified CSV file (in CPU load
memory) to the recipe DB (in CPU load memory).
8.7.1.2
Recipe DB example
Example recipes
The table below shows how to prepare recipe information for use in a recipe DB. The
example recipe DB stores five records, three of which are used. The fourth and fifth records
are free for later expansions. Each table row represents one record that stores the recipe
name, component data types, and component values.
productname
water
barley
wheat
hops
yeast
waterTmp
mashTmp
mashTime
QTest
Pils
10
9
3
280
39
40
30
100
0
Lager
10
9
3
150
33
50
30
120
0
BlackBeer
10
9
3
410
47
60
30
90
1
Not_used
0
0
0
0
0
0
0
0
0
Not_used
0
0
0
0
0
0
0
0
0