I have a Nibe Fighter 1235 heatpump where i from RS485 read all values each minute and store them in an My SQL table.
What is the best way to update an Item from a value in an MySQL table.
/mike
The best way is probably to write a script that pushes the latest values saved to the DB to an Item/Items using OH’s REST API or some other means (e.g. MQTT).
You could also use the Exec binding to run a script periodically that prints out the most recent value which gets set to the Item.
If you have access to it, you could augment your code that reads the RS485 values and have it publish the values to OH in addition to MySQL, bypassing the middle man.
I will try to send the Values with Mqqt when i save them to the database.
/Mike