VKT-7 by Teplocom. Automatic retrieval of current data or accumulated data. OPC serverPreliminary requirementsTypically, the VKT-7 device is connected to the computer via an RS-232 serial port (COM port) and sends data using a nonstandard version of the Modbus RTU protocol. You can also connect it to the computer via an RS232-to-Ethernet convertor. In that case, you can access the heat calculator unit remotely over a network. If you are using a GSM modem with the device, make sure that the modem can automatically connect to the Internet. SetupIf VKT-7 is connected to the computer via a COM port, you need to install Advanced Serial Data Logger (see the top link). If the device is connected to the computer via a local network or over the Internet, you need to install Advanced TCP/IP Data Logger (see the top link). You also need to install the "Binary parsers" module, which enables the logger to work with VKT-7. The module will send data requests to the heat calculator unit on a schedule, process its responses, and prepare data for exporting. Communication settings1. Configure the heat calculator unit connection, that is, COM port or TCP connection parameters (figures 1 and 2).
2. Select the parser module for the VKT-7 device in the program's settings. If the heat calculator unit is connected to the computer via a COM port, you also need to select the respective data request module (figure 3; the module is not shown).
Data reading settingsYou can specify the heat calculator unit's port number and device ID, which can be used when exporting data or writing data to a database (figure 1).
Set up a data reading schedule in the parser module's settings (figures 2 and 3). You can set up a separate schedule for each data type (current, hourly, daily, or accumulated data).
Writing data to a databaseYou can use the "ODBC Database" data export module to write data to a database. The module can write data to almost any database, provided that there is a respective ODBC driver. You can write data from multiple heat calculator units to a single database table. In that case, each row will contain a unique device ID and a port number. 1. Manually create a table with the necessary rows and columns (fields) in your database. Below you can find some table-creating scripts that we recommend to use. You can download the "database.mdb" database file from here. 2. Open the data export module's settings and enable writing to the database. Then switch to the "Connection" tab, click the "Configure" button, and create a connection to your database (figures 1 - 3).
3. Switch to the "Binding" tab, import the table structure from the database, and bind the parser variables to the respective columns (fields). Then delete all the unbound columns for which there is a default value in the table-creating script (figures 4 and 5).
Logging data to a plain-text fileOur program can log all the collected and processed data to plain-text files in addition to writing data to a database. You can use such log files as backup copies or keep them for later analysis. Our program can automatically create a new log file every day, every week, or every month (figures 1 and 2).
OPC serverOur program has a built-in OPC DA2 server that allows you to retrieve and view the last-read current or accumulated values at any time. The recommended OPC server settings are shown in figures 1 and 2.
To make data viewing easier, you can use different tag groups for current data and accumulated data. To do it, you can specify a data grouping rule for the OPC server. In the example, the data are grouped by serial number and data type.
Related articles: VKT-7 by Teplocom. Automatic retrieval of current data or accumulated data. OPC serverLog Monitor & Export - Read more about:Log monitor Log monitoring RS232 pinout and signals Cables and signals Data monitor cables |
|
