Recipe Db Example - Siemens S7-1200 System Manual

Hide thumbs Also See for S7-1200:
Table of Contents
Extended instructions
8.7 Recipes and Data logs
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
Pils
10
Lager
10
BlackBeer
10
Not_used
0
Not_used
0
370
barley
wheat
9
3
9
3
9
3
0
0
0
0
hops
yeast waterTmp
280
39
150
33
410
47
0
0
0
0
mashTmp mashTime
40
30
100
50
30
120
60
30
0
0
0
0
S7-1200 Programmable controller
System Manual, 03/2014, A5E02486680-AG
QTest
0
0
90
1
0
0
0
0
Table of Contents
loading

Table of Contents