I have an application working in version 5.8.4.
I want to now export channel data 100-118 to a number of tables in an MS Server database.
At the moment when I add a “Current data trigger”, the values are written at 1 to 2 seconds intervals continuously.
I want to export data to table1m at 1 minute, to table5m at 5 minutes and to table1h at 1 hour intervals. How can I export at these time intervals?
If you have good knowledge of SQL writing queries, you can make a temporary table where you will add the current values. the trigger in this temporary table will sort the values into the required tables.
I wrote my own module and SQL scripts for this.