ModDbExport

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #14383
    Matt3
    Participant

    Dear Mikhail

    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?

    Kind regards
    Matt

    #14386
    JurasskPark
    Participant

    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.

    #14387
    Mikhail
    Moderator

    Hello,

    The feature to export data on timer is available in Rapid SCADA 6.
    Using 5.8.4, you can try the above method, but it seems too tricky.

    #14389
    Matt3
    Participant

    Thank you. I will take a look at both suggestions.

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.