Track individual cell voltages #495
-
|
Hi, I want to track individual cell voltages. @mr-manuel has shared this screenshot and further info already The way to go: As far as I have found out, latest version of influxDB (v2.6.1) does not seem to be supported by the node-red-contrib-influxdb. @mr-manuel can you please share details/examples on how you to configure
thanks |
Beta Was this translation helpful? Give feedback.
Replies: 6 comments 32 replies
-
Node-REDImport the Node-RED flow and add/select your MQTT broker (Venus OS) in the MQTT nodes and InfluxDB in the InfluxDB nodes:
JSON Flow[
{
"id": "d4b1489e17daa213",
"type": "mqtt in",
"z": "42e5fe8b46267f4b",
"name": "",
"topic": "N/aa00aa00aa00/battery/1/Voltages/#",
"qos": "2",
"datatype": "auto-detect",
"broker": "",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 270,
"y": 700,
"wires": [
[
"3fc0a46a34bb0380"
]
]
},
{
"id": "3fc0a46a34bb0380",
"type": "function",
"z": "42e5fe8b46267f4b",
"name": "set Influx objects",
"func": "var topic = msg.topic.replace(/N\\/[0-9A-Za-z]{12}\\//g, \"\");\nvar topic_split = topic.split(\"/\");\nvar battery = topic_split[1];\nvar object = topic_split[3].toLowerCase();\nvar value = Math.round(msg.payload.value * 1000) / 1000;\n\nif(object.includes(\"cell\") && object.length == 5){\n object = object.replace(\"cell\", \"cell_0\");\n} else {\n object = object.replace(\"cell\", \"cell_\");\n}\n\n\nif(isNaN(value) == false){\n \n // do not store entries with a cell voltage of 0\n if(object.includes(\"cell\") == false || value != 0){\n \n msg.topic = topic;\n msg.payload = [{\n \"value\": value\n },\n {\n \"host\": \"nodered.docker.local\",\n \"source\": \"raspberry-pi-mqtt\",\n \"battery\": battery,\n \"object\": object\n }]\n \n return msg;\n \n }\n \n} else {\n \n return null;\n \n}",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 570,
"y": 700,
"wires": [
[
"4e0dd67bcc28328d"
]
]
},
{
"id": "4e0dd67bcc28328d",
"type": "influxdb out",
"z": "42e5fe8b46267f4b",
"influxdb": "",
"name": "",
"measurement": "battery_cells",
"precision": "",
"retentionPolicy": "",
"database": "database",
"precisionV18FluxV20": "ms",
"retentionPolicyV18Flux": "",
"org": "organisation",
"bucket": "bucket",
"x": 780,
"y": 700,
"wires": []
},
{
"id": "1a8d65c7365533b1",
"type": "mqtt out",
"z": "42e5fe8b46267f4b",
"name": "",
"topic": "R/aa00aa00aa00/keepalive",
"qos": "0",
"retain": "false",
"respTopic": "",
"contentType": "",
"userProps": "",
"correl": "",
"expiry": "",
"broker": "",
"x": 800,
"y": 600,
"wires": []
},
{
"id": "f6719f6e18806b8c",
"type": "inject",
"z": "42e5fe8b46267f4b",
"name": "30s interval",
"props": [
{
"p": "payload"
}
],
"repeat": "30",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "str",
"x": 210,
"y": 600,
"wires": [
[
"97c53dd8a1d69502"
]
]
},
{
"id": "97c53dd8a1d69502",
"type": "function",
"z": "42e5fe8b46267f4b",
"name": "set topics",
"func": "msg.payload = [\n \"battery/1/Voltages/#\",\n];\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 400,
"y": 600,
"wires": [
[
"af2cb839f606f5b8"
]
]
},
{
"id": "af2cb839f606f5b8",
"type": "json",
"z": "42e5fe8b46267f4b",
"name": "",
"property": "payload",
"action": "str",
"pretty": false,
"x": 570,
"y": 600,
"wires": [
[
"1a8d65c7365533b1"
]
]
},
{
"id": "dbd6aa4f38e3c224",
"type": "comment",
"z": "42e5fe8b46267f4b",
"name": "subscribe to retreive needed values",
"info": "",
"x": 260,
"y": 560,
"wires": []
},
{
"id": "3d36cf9abff035fd",
"type": "comment",
"z": "42e5fe8b46267f4b",
"name": "VRM Portal ID is found in Venus OS GUI -> Settings -> VRM online portal",
"info": "",
"x": 380,
"y": 520,
"wires": []
},
{
"id": "56cf642eafd00f21",
"type": "comment",
"z": "42e5fe8b46267f4b",
"name": "save cell voltages, diff and sum to influxdb",
"info": "",
"x": 280,
"y": 660,
"wires": []
},
{
"id": "cb7a6aef77a35130",
"type": "comment",
"z": "42e5fe8b46267f4b",
"name": "⚠️ Replace aa00aa00aa00 with your VRM Portal ID",
"info": "",
"x": 310,
"y": 480,
"wires": []
}
]GrafanaImport the dashboard provided via panel JSON and select the database where you stored your battery data with Node-RED:
Panel JSON{
"__inputs": [
{
"name": "DS_VICTRON_ENERGY",
"label": "victron_energy",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
],
"__elements": {},
"__requires": [
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "9.4.3"
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
"id": "timeseries",
"name": "Time series",
"version": ""
}
],
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "grafana",
"uid": "-- Grafana --"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": null,
"links": [],
"liveNow": false,
"panels": [
{
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"description": "Used voltage range: 2,90 V - 3,45 V<br>\nBalancing starts @3,40 V",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": 300000,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "area"
}
},
"decimals": 3,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "orange",
"value": 2.5
},
{
"color": "green",
"value": 2.9
},
{
"color": "purple",
"value": 3.4
},
{
"color": "orange",
"value": 3.45
},
{
"color": "red",
"value": 3.65
}
]
},
"unit": "volt"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 18,
"x": 0,
"y": 0
},
"id": 9,
"interval": "10s",
"options": {
"legend": {
"calcs": [
"min",
"max",
"mean",
"lastNotNull"
],
"displayMode": "table",
"placement": "right",
"showLegend": true,
"sortBy": "Last *",
"sortDesc": true,
"width": 320
},
"tooltip": {
"mode": "multi",
"sort": "desc"
}
},
"targets": [
{
"alias": "$tag_object",
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"battery"
],
"type": "tag"
},
{
"params": [
"object"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "battery_cells",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "object",
"operator": "!=",
"value": "sum"
},
{
"condition": "AND",
"key": "object",
"operator": "!=",
"value": "diff"
}
]
}
],
"title": "Battery cell voltages",
"type": "timeseries"
},
{
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"description": "Used voltage range: 2,90 V - 3,45 V<br>\nBalancing starts @3,40 V",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": 300000,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "area"
}
},
"decimals": 3,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "orange",
"value": 2.5
},
{
"color": "green",
"value": 2.9
},
{
"color": "purple",
"value": 3.4
},
{
"color": "orange",
"value": 3.45
},
{
"color": "red",
"value": 3.65
}
]
},
"unit": "volt"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 6,
"x": 18,
"y": 0
},
"id": 15,
"interval": "10s",
"options": {
"legend": {
"calcs": [
"min",
"max",
"mean",
"lastNotNull"
],
"displayMode": "table",
"placement": "right",
"showLegend": false,
"sortBy": "Last *",
"sortDesc": true
},
"tooltip": {
"mode": "multi",
"sort": "desc"
}
},
"targets": [
{
"alias": "$tag_object",
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"battery"
],
"type": "tag"
},
{
"params": [
"object"
],
"type": "tag"
},
{
"params": [
"previous"
],
"type": "fill"
}
],
"measurement": "battery_cells",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(\"value\") FROM \"battery_cells\" WHERE (\"object\" != 'sum' AND \"object\" != 'diff') AND \"time\" > now() - 15m GROUP BY time($__interval), \"battery\", \"object\" fill(null)",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"key": "object",
"operator": "!=",
"value": "sum"
},
{
"condition": "AND",
"key": "object",
"operator": "!=",
"value": "diff"
}
]
}
],
"timeFrom": "15m",
"title": "Battery cell voltages",
"type": "timeseries"
},
{
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": 300000,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "volt"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 18,
"x": 0,
"y": 12
},
"id": 10,
"interval": "10s",
"options": {
"legend": {
"calcs": [
"min",
"max",
"mean",
"lastNotNull"
],
"displayMode": "table",
"placement": "right",
"showLegend": true,
"width": 320
},
"tooltip": {
"mode": "multi",
"sort": "desc"
}
},
"targets": [
{
"alias": "$tag_battery - $tag_object",
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"battery"
],
"type": "tag"
},
{
"params": [
"object"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "battery_cells",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"condition": "AND",
"key": "object",
"operator": "=",
"value": "diff"
}
]
}
],
"title": "Battery cell voltage diff",
"type": "timeseries"
},
{
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": 300000,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "volt"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 18,
"y": 12
},
"id": 16,
"interval": "10s",
"options": {
"legend": {
"calcs": [
"min",
"max",
"mean",
"lastNotNull"
],
"displayMode": "table",
"placement": "right",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "desc"
}
},
"targets": [
{
"alias": "$tag_battery - $tag_object",
"datasource": {
"type": "influxdb",
"uid": "${DS_VICTRON_ENERGY}"
},
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"battery"
],
"type": "tag"
},
{
"params": [
"object"
],
"type": "tag"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "battery_cells",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [
{
"condition": "AND",
"key": "object",
"operator": "=",
"value": "diff"
}
]
}
],
"timeFrom": "15m",
"title": "Battery cell voltage diff",
"type": "timeseries"
}
],
"refresh": "5s",
"revision": 1,
"schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now/d",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"5s",
"15s",
"30s",
"1m",
"5m",
"15m",
"30m"
]
},
"timezone": "",
"title": "Battery Info",
"uid": "B3pLeBa4k",
"version": 3,
"weekStart": ""
} |
Beta Was this translation helpful? Give feedback.
-
|
Further informations can be found here: #473 |
Beta Was this translation helpful? Give feedback.
-
|
Thx for the flow - great :). Finally some monitoring on my cell voltages. Do you mind if i introduce this to the community of my YT-channel? Of cource with proper reference to your github account and the request to maybe donate? Do you have the flow available on your github account? Or maybe you want to make it available there? |
Beta Was this translation helpful? Give feedback.
-
|
Yes, the MOS temperature is shown in the APPs gui, but not in the dbus-serialbattery info on the Remote Console... Maybe it's a problem that i'm on the 3.00~25 beta Venus OS Large - so no hurry on this! Adapted your flow on the cell voltages for .../System/ - throws Min/Max Temp, but not MOSTemperature. Also tried MQTT Explorer to check for the topic - not availabe as it seems. |
Beta Was this translation helpful? Give feedback.
-
|
I also have installed the latest beta, so no issue on this. The GUI should look like this:
Maybe this is the problem. Did you also check with the
|
Beta Was this translation helpful? Give feedback.
-
|
Ok, i see you have another jk bms installed - i've got 8s version (B2A8S20P) installed (twice, with 0.14.3 firmware each). Maybe thats the problem - dbus-spy also does not show MOSTemperature. Maybe this BMS is not fully supported yet.
Anyway i switched to using Victrons Battery Monitor Node for Min/Max Temp hoping that also represents temp1/temp2. I think i'll take some time to investigate before opening an issue. Maybe i open a new discussion first to see if anyone else has this problem. |
Beta Was this translation helpful? Give feedback.
-
|
Try the version of my repo. Here you find install instructions: #421 (comment) |
Beta Was this translation helpful? Give feedback.
-
|
Thx again - i'll check after i figure out how to maintain my settings that are still in utils.py or how to get them into the config.ini ;). |
Beta Was this translation helpful? Give feedback.
-
|
I updated Venus OS from 3.00 23 to 3.00 29 and now the node-red flow no longer seems to work. No more cell data is coming in via mqtt. Does anyone else have this problem? |
Beta Was this translation helpful? Give feedback.
-
|
do you mean this value 2 for me? |
Beta Was this translation helpful? Give feedback.
-
|
Yes or check the dbus-spy for the VRM ID or the GUI/remote console |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for your help. It must be the ID 2 with me, but I get no data. in the MQTT is only the value ["battery/2/Voltages/#"] otherwise no data. Can you please support me? |
Beta Was this translation helpful? Give feedback.
-
|
Send an empty payload to keep alive to see all data. Then you can explore all topics with a MQTT Explorer. |
Beta Was this translation helpful? Give feedback.
-
|
Hello, I have now managed to write the values to the database. Now I have imported your Grafana Dashboard but where do I set from which database the data will be read? I have inserted the database into Grafana. |
Beta Was this translation helpful? Give feedback.
-
|
Hi @mr-manuel - I am getting such peaks in the display any idea where this peak is coming from? cheers |
Beta Was this translation helpful? Give feedback.
-
|
Hi,
|
Beta Was this translation helpful? Give feedback.
-
|
it is cell number 3. value goes over 8 ... no warnings in Daly BMS when I checked a while ago. But not on site atm. |
Beta Was this translation helpful? Give feedback.
-
|
The diff is provided as a value from Venus OS. Since there is no warning in Venus OS it might be only a problem in passing the data to the database. Else you can try to log the values of cell 3 in Node-RED. |
Beta Was this translation helpful? Give feedback.
-
|
Did anyone every figure this out, VenusOS is not sending cell data via MQTT? It seems to be the only thing missing. |
Beta Was this translation helpful? Give feedback.
-
|
Okay I must have missed something. I will go back over the documentation. |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
|
Hello, I am actually facing the same problem. I see the battery data on dbus-spy, but not on MQTT Explorer. I tried already requesting the data with R/b827......../battery , but unfortunately without success. What can I do to get the data with MQTT? |
Beta Was this translation helpful? Give feedback.
-
|
For you I copied over the second sentence of my link posted above:
Send a blank payload to |
Beta Was this translation helpful? Give feedback.
-
|
I already tried it with keepalive, but there is still not showing up a battery section on MQTT under N//battery and even not anywhere else on MQTT. I have installed the newest driver version for serialbattery and I run Venus OS v3.13 on a Raspberry PI 3. |
Beta Was this translation helpful? Give feedback.
Node-RED
Import the Node-RED flow and add/select your MQTT broker (Venus OS) in the MQTT nodes and InfluxDB in the InfluxDB nodes:
JSON Flow
[ { "id": "d4b1489e17daa213", "type": "mqtt in", "z": "42e5fe8b46267f4b", "name": "", "topic": "N/aa00aa00aa00/battery/1/Voltages/#", "qos": "2", "datatype": "auto-detect", "broker": "", "nl": false, "rap": true, "rh": 0, "inputs": 0, "x": 270, "y": 700, "wires": [ [ "3fc0a46a34bb0380" ] ] }, { "id": "3fc0a46a34bb0380", "type": "function", "z": "42e…