Archive Data – Export to DB

[roska]

Hello,

I configured ModDBExport to send data to a MySQL Database, which basically works. If I enable the export of current data, the database gets filled, also events are exported.

Now I tried the export of Archive Data, but nothing happens. If I use the generator to export archive data, it will show up in the database, but when will this happen automatically?

Background of my question: I don’t want to annoy the SQL Server (which is on an other machine) and the network with all the data, and send only data once a minute (which is my archive period), so I thought that this would happen if I enable the Archive Data export.

Thanks,

Robert

[Mikhail]

Hi,

Export of archive data works for some devices. It depend on a driver. Some devices (e.g. electricity meter) can store data in their memory and then provide to SCADA. In this case a driver reads archives from devices and transfer archives to SCADA-Server.

To implement the logic you described (sending data periodically), the export module should be upgraded.

Alternatively, you can poll devices once a minute in Communicator, but this affect refreshing current data.

[roska]

I would like to keep the device polling as fast as possible to see the current values in the scada interface.
To get what I want (periodic archive data in a remote sql database), I think I will feed the current values to a local database, and write a small script to periodically send data to a remote database.

[Mikhail]

I think I will feed the current values to a local database, and write a small script to periodically send data to a remote database.

Possible solution.
We would like to include the required feature in the Export Module, we are looking for who sponsors this job.

[Author]

Posts