Sqlite Trend Values

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

    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

    RoryLDM - 2019-01-17

    Ah, thanks Edwin.

     
  • AlexRoss

    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.