I have issue about database import (MYSQL)

Forum Home Forums Understanding the Software I have issue about database import (MYSQL)

Viewing 5 posts - 16 through 20 (of 20 total)
  • Author
    Posts
  • #15437
    joey
    Participant

    Thank you very much. I have received the data now, but some of it is a bit strange. For example, I selected an integer but still got a float. Also, the data in the database is ‘Yellow’, but when I requested it, I only got the first four characters, ‘Yell’, as shown in image 5. Lastly, in the Webstation, the data is displayed in an unreadable language, as shown in image 6.

    #15448
    Mikhail
    Moderator

    Could you provide screenshots?
    The driver works with numbers and 4-character strings. Long strings currently not supported by the driver.

    #15449
    Mikhail
    Moderator

    To display strings in the web app, set channel data type to Unicode string.

    #15480
    Evan
    Participant

    I have a problem with the data showing on the webstation. the ID and DateTime are not shown in the correct data form I fetched from the database. In scadaAdmin the data are fine but when it comes to webstation it is messing up. How do I fix this?

    https://drive.google.com/drive/folders/1W7bhqnszH_xriF4_G7F61mZ6dbfkqExd?usp=sharing

    #15493
    Mikhail
    Moderator

    Hi,
    Set Data type to empty for all channels except 103.
    Set Format for the channel 102

Viewing 5 posts - 16 through 20 (of 20 total)
  • You must be logged in to reply to this topic.