Welcome to our new forum
All users of the legacy CODESYS Forums, please create a new account at account.codesys.com. But make sure to use the same E-Mail address as in the old Forum. Then your posts will be matched. Close

Sqlite Trend Values

RoryLDM
2019-01-16
2019-11-12
  • RoryLDM - 2019-01-16

    For instance it has a value of 1076546816 for something that should be between 2 and 4 degrees C.

    How should I go about converting this?

    Here is the SQlite file.

     
  • eschwellinger

    eschwellinger - 2019-01-17

    Hi,

    In fact the TS value uses a higher resolution seconds. The trend recording encodes all values into a column of integral type and therefore real/lreal values cannot be directly interpreted from that column. To convert that values the value has to be put into a 8 byte binary value and then reinterpreted as real/lreal (respecting the byteorder of the recording device).

    The documented way of reading a trenddatabase would be using the according API from the library VisuTrendStorageAccess. An according example can be found with the CODESYS Store: https://store.codesys.com/trend-api-example.html

    BR
    Edwin

     
  • RoryLDM - 2019-01-17

    Ah, thanks Edwin.

     
  • AlexRoss - 2019-11-12

    Edwin Schwellinger hat geschrieben:
    The documented way of reading a trenddatabase would be using the according API from the library VisuTrendStorageAccess. An according example can be found with the CODESYS Store: https://store.codesys.com/trend-api-example.html

    Hi Edwin,
    The API example is a simple implementation of the ITrendStorageReaderConsumer interface, but where I can found the documentation for it? There is no information about the VisuTrendStorageAccess library in the Library Manager or Online Help. How to use those instruments more efficiently? At least to understand what methods in which order are called...

    Thanks!

     

Log in to post a comment.