Afternoon all,
Hoping someone can help. I have SBFSpot add-on installed and working as expected. It connects to my SunnyBoy ST5000, pulls the data over Bluetooth and uploads to PVOutput reliably.
I have seperate sensors around both Power and Energy consumption: sensor.current_cost_total_daily_usage for Daily Energy use and sensor.current_cost_5_min_avg for current power usage
Can somone please help me create an automation that will upload these values into the MariaDB database called “sbfspot”, table name “Consumption” (it was created by sbfspot as part of setup, but is currently empty as my Solar intervor only records power/energy creation from the panels and not consumption for the house)
Currently I have a rest command uploading the sensors to PVOutput every 5 mins - see PVOuput Uploader - #26 by rieschard as a reference but my preference would be to store the values in the Database and have SBFSpot deal with the uploading of consumption data
Thanks in Advance