Hi,
I am want to us the switch state of a shelly relay in a grafana time series. The status is coming in as "on" or "off". I would like to convert to a number (int/float whatever) so that Grafana can process it, but I get an error in Node-Red. I have the following setup:
29.8.2022, 18:11:46[node: debug 4]relay 0 : msg.payload : number
1
29.8.2022, 18:11:46[node: Shelly 1 Europiccola]
msg : error
"Error: A 400 Bad Request error occurred: {"error":"partial write: field type conflict: input field "value" on measurement "europiccola_ext_relay" is type float, already exists as type string dropped=1"}↵"
Yes, it is. I implemented a two-point temperature controller with a shelly (Boiler temperature and relay switching). Doesn't work too good though. What are you measuring?
My La Pavoni is plugged into a smart plug with power monitoring.
I can turn it on from the Node-red dashboard and it turns off again after 30 minutes.
The power consumption data (from switch-on to the pressurestat cutting off the power) is used to estimate the current boiler fill level; it refuses to turn on if the estimate is too low.
I didn't know that a dashboard can be create in Node-red. I am currently using grafana to display all data. Even though I am not sure whether I could implement a button there.
I am not (yet) interested in the power consumption of the Europiccola. Currently I am more focused on the correct temperature for the perfect capuccino. I am using a shelly 1 and the temperature add on. Unfortunately the sensors are little too big and as I do not want to drill into the machine, the measurements can only be a rough guide.