More about DBExport.

Forum Home Forums Understanding the Software More about DBExport.

This topic contains 3 replies, has 2 voices, and was last updated by Mikhail Mikhail 3 weeks, 5 days ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #5849
    Avatar
    AndrejusFi
    Participant

    Hi, i have a question about DBExport. What is the trigger of the exporting current data? Because i have created the project with only one modbus device, with 1min data reading period. In the Line Stats log there is only one reading per one minute. But in my MYSQL table i have two records for same reading. One with the same time stamp like in the Line Stats log, ant other with same value, but time differs in few seconds. This difference is same for all duplicated records. But if i restarting the server this difference has other value. Where from is comming this second record? Htank you.
    Some pictures:
    https://ibb.co/HVsH8bh

    https://ibb.co/z2TZPgC

    https://ibb.co/6vSp5kw

    https://ibb.co/ncFspCr

    • This topic was modified 4 weeks ago by Avatar AndrejusFi.
    • This topic was modified 4 weeks ago by Avatar AndrejusFi.
    • This topic was modified 4 weeks ago by Avatar AndrejusFi.
    #5857
    Mikhail
    Mikhail
    Moderator

    Hi,

    What is the trigger of the exporting current data?

    When Communicator sends data to the Server app. It sends the values twice, because it does it after a communication session, and with fixed intervals.
    If you set “Period of sending all device tags” to 0 (in Communication – Common Parameters), you will avoid duplication.

    #5858
    Avatar
    AndrejusFi
    Participant

    After setting the time to 0 it seems everything is fine. Thank you!
    It is possible to customize data sending to DB, because i need to send for example only 1 tag from 1 device, but in visualisation I’m using more tags from same device.
    Greately thank yuo.

    #5859
    Mikhail
    Mikhail
    Moderator

    It is possible to customize data sending to DB

    You can filter data by changing SQL queries in the module settings.

    Note: if you’d like, you can write to the Russian forum. It’s up to you.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.