Movicon 11.6: How To Use Recipe?

     Friendly Reminder:     

    Before starting the post I would like to give some of useful links below for someone who don't want to read all story.

• Movicon Recipe Sample Programme
• My Recipe Sample Programme(I used MSAccess for Database, but you can find SQLServer2012 Database Configuration from my another YouTube Video) 
• How to use Recipe YouTube Video

    Processing data storing(recipe management) is such an handy function at Movicon SCADA. As I mentioned before the types of storing recipe data, one way to use recipe is to hold data into the database. With exporting and importing of the recipes, archiving could be applied for the production processes. You can see the database and recipe diagram from below figure.

Fig: Recipe And Database Diagram

    First step is to create Structure Prototype of the recipe and then adding a variable which in the type of structure(Recipe_Structure).

Fig: Step1(Creating Structure Prototype of Recipe)

    After creating structure prototype and structure type variable, second step is to add "Recipe"(right click onto the "Data Loggers And Recipes" part) and to assign the execution variables of the recipe(you need to use structure type variable that you created before) as you can see the recipe execution assignment below figure.

Fig: Step2(Adding Recipe & Execution Variable Assignment)

Some of important execution variables can be listed like :

• Activate Variable: This execution variable is used for activating  the temporary variables of the recipe's own variables.
• Save Variable: This execution variable is used for the selected recipe save. The recipe data temporary loaded into the variable will also be saved in the Database with this command.
• Delete Variable: This execution variable is used for elemination of the selected recipe. After executing this command, recipe will be deleted from the Database at the same time.
• Read Command Action: This command is used for reading recipe values from the field and updating values read with the selected recipe's temporary variables. I have prepared how to use and act the Read command action below. For more visaul explanation can be seen from this link.
• List Recipe Variable: This execution variable is used for displaying the list of saved recipes.
• Export Command Actions: This command is used for exporting the indicated report in a  file (format can be selected from the "Export Format" property). The exported report is saved in the project's  "DLOGGERS" folder with the name "<ReportName >.<extension>".
• Import Command Actions: This command imports a recipe from the "csv"  file to the temporary variables of the Recipe selected in the "Data Logger/Recipe" field, using the character set in the " Separator Import/Export Recipe" field as the separator. Therefore temporary variables should have previously been associated  to the Recipe fields.  The file must be formatted correctly by providing all the fields  belonging to the Recipe selected in the "Data Logger/Recipe" field.

These variables will then be set to 'zero' value by Movicon once the operation has been executed.  

    Now, we are ready to create our recipe management screen easily. After creating the common page, you can use(add or remove functions however you want) the objects into your specific designed page. Below figure shows how to create this screen.

Fig: Step3(Creating Recipe Screen)

Result screen can be seen below.

Fig: Recipe Screen

    Last step for recipe management is to connect recipe to the desired database connection plugin. Movicon provides many kind of database options. I used MSAccess to store recipe data. 

Fig: ODBC Connection Plugins

Inside project folder("...\DLOGGERS\recipesample_DLR.mdb"), you can find Microsoft Access Database(*.mdb) to examine the stored recipes. 

Fig: Microsoft Access Screen

    For configuring database and recipe, you can watch my YouTube video that I prepared for this process.

Video: Movicon 11.6 - Recipe Operations

Thanks For Reading...

Okan Okumuş

02.07.2020