In this short tutorial, we will configure a Movicon 11 Data Logger.
Movicon 11 has a built in ability to log data from its Real Time Database (RTDB) engine directly to a database of your choice. Some common examples include MS Access, MS SQL 2005/2008/2012 and the Express versions, MySQL, and Oracle.
Movicon will manage the database, table(s), and column(s) creation as well as inserting and removing records based on the Data Loggers Max Data Age property.
The data loggers can then be linked to historical and real-time trends for viewing of data directly on the HMI or SCADA screens. They can also be linked to powerful text and graphical reports which can be run on demand by an operator, published as web pages, and(or) automatically emailed, printed, or exported.
All of this is done very easily through the Movicon 11 Interactive Development Environment (IDE) also known as the editor.
After we have created a project, you will see the Data Loggers and Recipes inside the project tree in the Project Explorer window;
To create a new data logger, simply right click on the resource shown above and select "Add a new Data Logger" from the popup menu.
Doing so will create the new data logger which will automatically be named "DataLogger0000x" where x is the sequential numbered data logger. You can change this name in the next step... There are many properties associated with a data logger we will take a look at 4 important ones to begin.
- Name - Default name will be DataLogger0000x, which you can change at anytime to a name of your choice.
- The data logger name will also be the table name in the database, unless you specify a separate table name in the Advanced properties.
- Style - Default style is set to record on a time frequency, you can also change this property to match the configuration you preffer.
- Please note that multiple selection can be made, for example you could record every one minute using the Record On Time Frequency and on command from signal using the Record On Command.
- Time Settings - Set the hours, minutes, seconds, and/or millisecond frequency for recording intervals.
- This setting is used only when the Record On Time Frequency has been enabled.
- Data Max. Age - Property to set how long the data should be stored in the database before being flushed (oldest record deleted and a new record written or First In First Out (FIFO)).
Now that we have configured the data logger we can begin to add columns which will contain the data records we wish to log. There are a couple ways to link variables to the data loggers, for the purpose of this tutorial we will use the drag 'n' drop method to add variables to the data loggers.
First you will want to open the Data Logger and Recipe tree in the Project Explorer window to expose your data logger. Next open the variables project resource to expose the variables, using the mouse to select the variable(s) (mouse click with Shift key down for multiple variables, or holding the Ctrl key down to make single selections. Watch the video:
Once the variables have been added you can make changes to their configuration. When adding the variables this way Movicon automatically creates the data logger column and links it to the variable you selected. You can see this by selecting the column under the data logger...
then viewing the property window... This is where you could change the column name or variable that was linked.
Some points to note with data logger and column names:
- Avoid spaces in data logger and column names
- Data logger name becomes table name in database
- Avoid column names like From, To, Type,... as they can be misinterpreted for a SQL commands
- For databases like Oracle, avoid spaces in column names and using numbers in the beginning of the name (i.e. instead of 12TempReading, use TempReading12)
Upon completing the configuration you can save and run your project. The Movicon run time will make the necessary ODBC connections to your database and create the tables and columns as they where configured.
Download Project Example: