- ioBroker Community Home
- Deutsch
- Skripten / Logik
- Node-Red
- [Gelöst] Benötige Hilfe mit Node-Red in Verbindung mit homee
NEWS
[Gelöst] Benötige Hilfe mit Node-Red in Verbindung mit homee
Geplant
Angeheftet
Gesperrt
Verschoben
Node-Red
121
Beiträge
3
Kommentatoren
17.3k
Aufrufe
4
Watching
Dieses Thema wurde gelöscht. Nur Nutzer mit entsprechenden Rechten können es sehen.
-
Danke
[ { "id": "95b979349f1fd3f0", "type": "ioBroker out", "z": "b8ad42061a6d5f2e", "name": "Geräteliste", "topic": "0_userdata.0.System.homee.Tabelle", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Tabelle", "role": "", "payloadType": "array", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1570, "y": 1500, "wires": [] }, { "id": "1b3e55fcd8eadc58", "type": "debug", "z": "b8ad42061a6d5f2e", "name": "Geräte Tabelle", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1380, "y": 1440, "wires": [] }, { "id": "9c7798317b60270e", "type": "json", "z": "b8ad42061a6d5f2e", "name": "Tabelle JSON", "property": "payload", "action": "str", "pretty": false, "x": 1380, "y": 1500, "wires": [ [ "95b979349f1fd3f0" ] ] }, { "id": "dfb85691acadb5e8", "type": "change", "z": "b8ad42061a6d5f2e", "name": "Geräte Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\",\"color\":\"#886fa9\"},{\"id\":2,\"name\":\"ZigBee\",\"color\":\"#ee6c1e\"},{\"id\":3,\"name\":\"EnOcean\",\"color\":\"#44abb2\"},{\"id\":9,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"},{\"id\":12,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "states", "pt": "msg", "to": "[{\"id\":1,\"name\":\"aktiv\",\"color\":\"green\"},{\"id\":2,\"name\":\"inaktiv\",\"color\":\"red\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]", "tot": "json" }, { "t": "set", "p": "battery", "pt": "msg", "to": "[{\"level\":30,\"color\":\"green\"},{\"level\":20,\"color\":\"yellow\"},{\"level\":15,\"color\":\"orange\"},{\"level\":0,\"color\":\"red\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" :name,\t \"type\" : note,\t \"protocol\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = protocol}).color & '\\\"> ' & $single($$.protocols, function($v){$v.id = protocol}).name,\t \"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name,\t \"battery\" : (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 8 ? attributes[type=8 ].current_value : \t (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 69 ? attributes[type=69 ].current_value = 0 ? 100 : 10\t} ~> |$|{\"battery\" : $exists(battery) ? ' <font color=\\\"' & $filter($$.battery, function($v){battery >= $v.level})[0].color & '\\\"> ' & battery & \" %\" : \"Keine Batterie\"}|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1120, "y": 1500, "wires": [ [ "9c7798317b60270e", "1b3e55fcd8eadc58" ] ] } ]Bitte sehr:
[ { "id": "ec3a06e2c6315f14", "type": "change", "z": "9c280ddf049b2b4d", "name": "VIS Tabelle 7", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"ZWave\"},{\"id\":2,\"name\":\"Zigbee\"},{\"id\":3,\"name\":\"EnOcean\"},{\"id\":9,\"name\":\"WLan\"}]", "tot": "json" }, { "t": "set", "p": "states", "pt": "msg", "to": "[{\"id\":1,\"name\":\"aktiv\",\"color\":\"green\"},{\"id\":2,\"name\":\"inaktiv\",\"color\":\"rot\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]", "tot": "json" }, { "t": "set", "p": "battery", "pt": "msg", "to": "[{\"level\":30,\"color\":\"green\"},{\"level\":20,\"color\":\"yellow\"},{\"level\":15,\"color\":\"orange\"},{\"level\":0,\"color\":\"red\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" :name,\t \"type\" : cube_type,\t \"note\" : note,\t \"protocol\" : $single($$.protocols, function($v){$v.id = protocol}).name,\t \"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name,\t \"battery\" : (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 8 ? attributes[type=8 ].current_value : \t (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 69 ? attributes[type=69 ].current_value = 0 ? 100 : 0\t} ~> |$|{\"battery\" : $exists(battery) ? ' <font color=\\\"' & $filter($$.battery, function($v){battery >= $v.level})[0].color & '\\\"> ' & battery & \" %\" : \t$contains(note,\"Plug\") ? \"Strombetrieben\": \"Keine Information vorhanden\"},\"note\"|\t", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1550, "y": 3220, "wires": [ [ "04161f23a6913ee8" ] ] } ]
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
Bitte sehr:
[ { "id": "ec3a06e2c6315f14", "type": "change", "z": "9c280ddf049b2b4d", "name": "VIS Tabelle 7", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"ZWave\"},{\"id\":2,\"name\":\"Zigbee\"},{\"id\":3,\"name\":\"EnOcean\"},{\"id\":9,\"name\":\"WLan\"}]", "tot": "json" }, { "t": "set", "p": "states", "pt": "msg", "to": "[{\"id\":1,\"name\":\"aktiv\",\"color\":\"green\"},{\"id\":2,\"name\":\"inaktiv\",\"color\":\"rot\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]", "tot": "json" }, { "t": "set", "p": "battery", "pt": "msg", "to": "[{\"level\":30,\"color\":\"green\"},{\"level\":20,\"color\":\"yellow\"},{\"level\":15,\"color\":\"orange\"},{\"level\":0,\"color\":\"red\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" :name,\t \"type\" : cube_type,\t \"note\" : note,\t \"protocol\" : $single($$.protocols, function($v){$v.id = protocol}).name,\t \"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name,\t \"battery\" : (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 8 ? attributes[type=8 ].current_value : \t (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 69 ? attributes[type=69 ].current_value = 0 ? 100 : 0\t} ~> |$|{\"battery\" : $exists(battery) ? ' <font color=\\\"' & $filter($$.battery, function($v){battery >= $v.level})[0].color & '\\\"> ' & battery & \" %\" : \t$contains(note,\"Plug\") ? \"Strombetrieben\": \"Keine Information vorhanden\"},\"note\"|\t", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1550, "y": 3220, "wires": [ [ "04161f23a6913ee8" ] ] } ]Vielen Dank, noch eine letzte Fragen und dann bist du mich los, versprochen!!!!!
Wenn der Flow nicht nur bei einer State Änderung ausgeführt werden soll, sondern auch, wenn sich an den Batterien was ändert, oder sich die Anzahl der Gräte ändert.
Wie muss ich das schreiben?
Gruß
Oliver -
Vielen Dank, noch eine letzte Fragen und dann bist du mich los, versprochen!!!!!
Wenn der Flow nicht nur bei einer State Änderung ausgeführt werden soll, sondern auch, wenn sich an den Batterien was ändert, oder sich die Anzahl der Gräte ändert.
Wie muss ich das schreiben?
@oli Ich bin mir nicht mal sicher ob der Filter funktioniert, da ich keine Ahnung habe wann Du wo den globalen Kontext schreibst. Wenn der Kontext noch alt ist und das Gerät neue Information hat dann geht es. Es funktioniert auch jetzt schon bei neuen Geräten, da dann ja im Kontext das Gerät noch nicht enthalten ist und in sofern der state nicht gleich sein kann.
[ { "id": "8d51d3dcf40934ba", "type": "switch", "z": "9c280ddf049b2b4d", "name": "Nur wenn Gerätestatus geändert", "property": "(\t payload.nodes[id=$$.device.node.id].state = device.node.state\t) and (\t payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 1170, "y": 3280, "wires": [ [ "43da9c222d7086f2", "43fca4060b0a75d7" ] ] } ]
( payload.nodes[id=$$.device.node.id].state = device.node.state ) and ( payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value )Wie gesagt - ich habe momentan nicht das Gefühl dass Du was zu NodeRed lernen möchtest, sondern dass ich Deine vis Tabelle perfektioniere.
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli Ich bin mir nicht mal sicher ob der Filter funktioniert, da ich keine Ahnung habe wann Du wo den globalen Kontext schreibst. Wenn der Kontext noch alt ist und das Gerät neue Information hat dann geht es. Es funktioniert auch jetzt schon bei neuen Geräten, da dann ja im Kontext das Gerät noch nicht enthalten ist und in sofern der state nicht gleich sein kann.
[ { "id": "8d51d3dcf40934ba", "type": "switch", "z": "9c280ddf049b2b4d", "name": "Nur wenn Gerätestatus geändert", "property": "(\t payload.nodes[id=$$.device.node.id].state = device.node.state\t) and (\t payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 1170, "y": 3280, "wires": [ [ "43da9c222d7086f2", "43fca4060b0a75d7" ] ] } ]( payload.nodes[id=$$.device.node.id].state = device.node.state ) and ( payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value )Wie gesagt - ich habe momentan nicht das Gefühl dass Du was zu NodeRed lernen möchtest, sondern dass ich Deine vis Tabelle perfektioniere.
@mickym said in Benötige Hilfe mit Node-Red in Verbindung mit homee:
payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value
Jetzt noch eine Verständnisfrage, warum schreibst du "and" und nicht "or"
Gruß
Oliver -
@mickym said in Benötige Hilfe mit Node-Red in Verbindung mit homee:
payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value
Jetzt noch eine Verständnisfrage, warum schreibst du "and" und nicht "or"
@oli Ja im Moment funktioniert mein Test nicht mehr - muss noch mal schauen. Ich denke es muss and sein, da ja nur wenn beide Bedingungen wahr sind, nichts geändert wurde. Ich muss das aber nochmal testen, wie es sich mit nicht batteriebetriebenen Geräten verhält.
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@mickym said in Benötige Hilfe mit Node-Red in Verbindung mit homee:
payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value
Jetzt noch eine Verständnisfrage, warum schreibst du "and" und nicht "or"
@oli So ich habs jetzt getestet musste nochmal geändert werden. Wie gesagt es muss AND sein, weil ja nur dann nichts geändert wurde, wenn beide Parameter nicht geändert wurden.
So um das für strom und batteriegebundenen Geräten zu gültig zu machen, ist die Bedingung doch etwas komplizierter:
Du kannst selbst testen: Gerät 62 ist batteriegebunden, Gerät 71 strom. Wenn Du state änderst funktioniert es und wenn Du current_value im attribute type 8 änderst.
[ { "id": "dfd67d5090a5ee3c", "type": "change", "z": "9c280ddf049b2b4d", "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "device", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 700, "y": 3280, "wires": [ [ "40ce65fe6c573d84" ] ] }, { "id": "40ce65fe6c573d84", "type": "change", "z": "9c280ddf049b2b4d", "name": "hole alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.nodes", "pt": "msg", "to": "homee.nodes", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 3280, "wires": [ [ "8d51d3dcf40934ba" ] ] }, { "id": "8d51d3dcf40934ba", "type": "switch", "z": "9c280ddf049b2b4d", "name": "Nur wenn Gerätestatus geändert", "property": "(\t payload.nodes[id=$$.device.node.id].state = device.node.state\t) and (\t device.node.attributes[type=8] ? payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value : true\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 1170, "y": 3280, "wires": [ [ "43da9c222d7086f2", "43fca4060b0a75d7" ] ] }, { "id": "ce392b92472130c0", "type": "switch", "z": "9c280ddf049b2b4d", "name": "verify device", "property": "payload.node", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 490, "y": 3280, "wires": [ [ "dfd67d5090a5ee3c" ] ] }, { "id": "5af35c4e9a5c92c8", "type": "link in", "z": "9c280ddf049b2b4d", "name": "", "links": [ "d87f2174cf715cf2" ], "x": 355, "y": 3280, "wires": [ [ "ce392b92472130c0" ] ] }, { "id": "c89774bbb921130b", "type": "inject", "z": "9c280ddf049b2b4d", "name": "Gerät 62", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"node\":{\"added\":1646555512,\"attributes\":[{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"4.61\",\"editable\":0,\"id\":398,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":44,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"0.16\",\"editable\":0,\"id\":399,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":45,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":400,\"instance\":0,\"last_changed\":1675339200,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":91,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":20,\"data\":\"\",\"editable\":0,\"id\":401,\"instance\":0,\"last_changed\":1678481730,\"last_value\":22,\"maximum\":100,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"automations\":[\"step\"]},\"state\":1,\"step_value\":1,\"target_value\":20,\"type\":18,\"unit\":\"%25\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":55,\"data\":\"\",\"editable\":0,\"id\":402,\"instance\":0,\"last_changed\":1678428470,\"last_value\":85,\"maximum\":100,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"history\":{\"day\":182,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":55,\"type\":8,\"unit\":\"%25\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":403,\"instance\":0,\"last_changed\":1678428470,\"last_value\":1,\"maximum\":4,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":258,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":404,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":180,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":180,\"target_value\":0,\"type\":90,\"unit\":\"%C2%B0\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":405,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":30,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":5,\"target_value\":0,\"type\":259,\"unit\":\"s\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":406,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":260,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":2,\"data\":\"\",\"editable\":1,\"id\":407,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":3,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":2,\"type\":261,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":408,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":5,\"minimum\":-5,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":0.1,\"target_value\":0,\"type\":64,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":20.87,\"data\":\"\",\"editable\":0,\"id\":409,\"instance\":0,\"last_changed\":1678481730,\"last_value\":20.78,\"maximum\":125,\"minimum\":-50,\"name\":\"\",\"node_id\":62,\"options\":{\"can_observe\":[5],\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":20.87,\"type\":5,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":21,\"data\":\"\",\"editable\":1,\"id\":410,\"instance\":0,\"last_changed\":1678428171,\"last_value\":21,\"maximum\":28,\"minimum\":8,\"name\":\"\",\"node_id\":62,\"options\":{\"automations\":[\"step\"],\"can_observe\":[6],\"history\":{\"day\":35,\"month\":1,\"stepped\":true,\"week\":5}},\"state\":1,\"step_value\":0.5,\"target_value\":21,\"type\":6,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":0,\"id\":411,\"instance\":0,\"last_changed\":1674031459,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"history\":{\"day\":182,\"month\":6,\"stepped\":true,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":69,\"unit\":\"\"},{\"based_on\":0,\"changed_by\":0,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":493,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":385,\"unit\":\"\"}],\"cube_type\":1,\"favorite\":0,\"history\":0,\"id\":62,\"image\":\"default\",\"name\":\"EG / Wohnzimmer / Heizung Balkon\",\"note\":\"# EUROtronic Spirit Z-Wave Plus\",\"order\":4,\"owner\":1,\"phonetic_name\":\"Heizung Wohnzimmer Balkon\",\"profile\":3006,\"protocol\":1,\"routing\":0,\"security\":0,\"services\":7,\"state\":1,\"state_changed\":1678428481}}", "payloadType": "json", "x": 300, "y": 3340, "wires": [ [ "ce392b92472130c0" ] ] }, { "id": "43fca4060b0a75d7", "type": "debug", "z": "9c280ddf049b2b4d", "name": "Status geändert", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1300, "y": 3340, "wires": [] }, { "id": "999cc6c5ddb7d1a9", "type": "inject", "z": "9c280ddf049b2b4d", "name": "Gerät 71", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"node\":{\"added\":1646564569,\"attributes\":[{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":0,\"id\":445,\"instance\":0,\"last_changed\":1678481630,\"last_value\":1,\"maximum\":4,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":33,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"V2 (6.1.0.18912)\",\"editable\":0,\"id\":446,\"instance\":0,\"last_changed\":1646564575,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":45,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":447,\"instance\":0,\"last_changed\":1646564576,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":170,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":0,\"id\":448,\"instance\":0,\"last_changed\":1678480957,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":35,\"month\":1,\"stepped\":true,\"week\":5}},\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":76,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":180,\"data\":\"PIR\",\"editable\":1,\"id\":449,\"instance\":0,\"last_changed\":1646591363,\"last_value\":0,\"maximum\":65535,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":180,\"type\":196,\"unit\":\"s\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":0,\"id\":450,\"instance\":0,\"last_changed\":1678481630,\"last_value\":1,\"maximum\":65534,\"minimum\":1,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":11,\"unit\":\"lx\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":14.75,\"data\":\"\",\"editable\":0,\"id\":451,\"instance\":0,\"last_changed\":1678479841,\"last_value\":15.03,\"maximum\":60,\"minimum\":-20,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":14.75,\"type\":5,\"unit\":\"%C2%B0C\"},{\"based_on\":0,\"changed_by\":0,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":500,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":385,\"unit\":\"\"}],\"cube_type\":2,\"favorite\":0,\"history\":0,\"id\":71,\"image\":\"nodeicon_presence\",\"name\":\"DG / Schlafzimmer / Bewegungsmelder / Kirsten\",\"note\":\"# Philips Hue Bewegungsmelder\",\"order\":45,\"owner\":1,\"phonetic_name\":\"Bewegungsmelder Kirsten\",\"profile\":4035,\"protocol\":2,\"routing\":0,\"security\":0,\"services\":5,\"state\":1,\"state_changed\":1678427715}}", "payloadType": "json", "x": 300, "y": 3380, "wires": [ [ "ce392b92472130c0" ] ] } ]( payload.nodes[id=$$.device.node.id].state = device.node.state ) and ( device.node.attributes[type=8] ? payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value : true )Das Ganze sind aber langsam Logikfragen und haben weniger mit NodeRed zu tun. ;)
Wie gesagt das Ganze steht und fällt aber damit, wann der globale Kontext geändert wird und ob die einzelnen Nodes vorher ankommen, bevor der globale Kontext geändert wird.
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli So ich habs jetzt getestet musste nochmal geändert werden. Wie gesagt es muss AND sein, weil ja nur dann nichts geändert wurde, wenn beide Parameter nicht geändert wurden.
So um das für strom und batteriegebundenen Geräten zu gültig zu machen, ist die Bedingung doch etwas komplizierter:
Du kannst selbst testen: Gerät 62 ist batteriegebunden, Gerät 71 strom. Wenn Du state änderst funktioniert es und wenn Du current_value im attribute type 8 änderst.
[ { "id": "dfd67d5090a5ee3c", "type": "change", "z": "9c280ddf049b2b4d", "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "device", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 700, "y": 3280, "wires": [ [ "40ce65fe6c573d84" ] ] }, { "id": "40ce65fe6c573d84", "type": "change", "z": "9c280ddf049b2b4d", "name": "hole alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.nodes", "pt": "msg", "to": "homee.nodes", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 3280, "wires": [ [ "8d51d3dcf40934ba" ] ] }, { "id": "8d51d3dcf40934ba", "type": "switch", "z": "9c280ddf049b2b4d", "name": "Nur wenn Gerätestatus geändert", "property": "(\t payload.nodes[id=$$.device.node.id].state = device.node.state\t) and (\t device.node.attributes[type=8] ? payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value : true\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 1170, "y": 3280, "wires": [ [ "43da9c222d7086f2", "43fca4060b0a75d7" ] ] }, { "id": "ce392b92472130c0", "type": "switch", "z": "9c280ddf049b2b4d", "name": "verify device", "property": "payload.node", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 490, "y": 3280, "wires": [ [ "dfd67d5090a5ee3c" ] ] }, { "id": "5af35c4e9a5c92c8", "type": "link in", "z": "9c280ddf049b2b4d", "name": "", "links": [ "d87f2174cf715cf2" ], "x": 355, "y": 3280, "wires": [ [ "ce392b92472130c0" ] ] }, { "id": "c89774bbb921130b", "type": "inject", "z": "9c280ddf049b2b4d", "name": "Gerät 62", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"node\":{\"added\":1646555512,\"attributes\":[{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"4.61\",\"editable\":0,\"id\":398,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":44,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"0.16\",\"editable\":0,\"id\":399,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":45,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":400,\"instance\":0,\"last_changed\":1675339200,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":91,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":20,\"data\":\"\",\"editable\":0,\"id\":401,\"instance\":0,\"last_changed\":1678481730,\"last_value\":22,\"maximum\":100,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"automations\":[\"step\"]},\"state\":1,\"step_value\":1,\"target_value\":20,\"type\":18,\"unit\":\"%25\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":55,\"data\":\"\",\"editable\":0,\"id\":402,\"instance\":0,\"last_changed\":1678428470,\"last_value\":85,\"maximum\":100,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"history\":{\"day\":182,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":55,\"type\":8,\"unit\":\"%25\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":403,\"instance\":0,\"last_changed\":1678428470,\"last_value\":1,\"maximum\":4,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":258,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":404,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":180,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":180,\"target_value\":0,\"type\":90,\"unit\":\"%C2%B0\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":405,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":30,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":5,\"target_value\":0,\"type\":259,\"unit\":\"s\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":406,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":260,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":2,\"data\":\"\",\"editable\":1,\"id\":407,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":3,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":2,\"type\":261,\"unit\":\"\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":408,\"instance\":0,\"last_changed\":1646555513,\"last_value\":0,\"maximum\":5,\"minimum\":-5,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":0.1,\"target_value\":0,\"type\":64,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":20.87,\"data\":\"\",\"editable\":0,\"id\":409,\"instance\":0,\"last_changed\":1678481730,\"last_value\":20.78,\"maximum\":125,\"minimum\":-50,\"name\":\"\",\"node_id\":62,\"options\":{\"can_observe\":[5],\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":20.87,\"type\":5,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":21,\"data\":\"\",\"editable\":1,\"id\":410,\"instance\":0,\"last_changed\":1678428171,\"last_value\":21,\"maximum\":28,\"minimum\":8,\"name\":\"\",\"node_id\":62,\"options\":{\"automations\":[\"step\"],\"can_observe\":[6],\"history\":{\"day\":35,\"month\":1,\"stepped\":true,\"week\":5}},\"state\":1,\"step_value\":0.5,\"target_value\":21,\"type\":6,\"unit\":\"%C2%B0C\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":0,\"id\":411,\"instance\":0,\"last_changed\":1674031459,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"options\":{\"history\":{\"day\":182,\"month\":6,\"stepped\":true,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":69,\"unit\":\"\"},{\"based_on\":0,\"changed_by\":0,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":493,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":62,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":385,\"unit\":\"\"}],\"cube_type\":1,\"favorite\":0,\"history\":0,\"id\":62,\"image\":\"default\",\"name\":\"EG / Wohnzimmer / Heizung Balkon\",\"note\":\"# EUROtronic Spirit Z-Wave Plus\",\"order\":4,\"owner\":1,\"phonetic_name\":\"Heizung Wohnzimmer Balkon\",\"profile\":3006,\"protocol\":1,\"routing\":0,\"security\":0,\"services\":7,\"state\":1,\"state_changed\":1678428481}}", "payloadType": "json", "x": 300, "y": 3340, "wires": [ [ "ce392b92472130c0" ] ] }, { "id": "43fca4060b0a75d7", "type": "debug", "z": "9c280ddf049b2b4d", "name": "Status geändert", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1300, "y": 3340, "wires": [] }, { "id": "999cc6c5ddb7d1a9", "type": "inject", "z": "9c280ddf049b2b4d", "name": "Gerät 71", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"node\":{\"added\":1646564569,\"attributes\":[{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":0,\"id\":445,\"instance\":0,\"last_changed\":1678481630,\"last_value\":1,\"maximum\":4,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":33,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"V2 (6.1.0.18912)\",\"editable\":0,\"id\":446,\"instance\":0,\"last_changed\":1646564575,\"last_value\":0,\"maximum\":0,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":45,\"unit\":\"text\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":1,\"id\":447,\"instance\":0,\"last_changed\":1646564576,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":170,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":0,\"data\":\"\",\"editable\":0,\"id\":448,\"instance\":0,\"last_changed\":1678480957,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":35,\"month\":1,\"stepped\":true,\"week\":5}},\"state\":1,\"step_value\":1,\"target_value\":0,\"type\":76,\"unit\":\"n%2Fa\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":180,\"data\":\"PIR\",\"editable\":1,\"id\":449,\"instance\":0,\"last_changed\":1646591363,\"last_value\":0,\"maximum\":65535,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":180,\"type\":196,\"unit\":\"s\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":0,\"id\":450,\"instance\":0,\"last_changed\":1678481630,\"last_value\":1,\"maximum\":65534,\"minimum\":1,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":11,\"unit\":\"lx\"},{\"based_on\":1,\"changed_by\":1,\"changed_by_id\":0,\"current_value\":14.75,\"data\":\"\",\"editable\":0,\"id\":451,\"instance\":0,\"last_changed\":1678479841,\"last_value\":15.03,\"maximum\":60,\"minimum\":-20,\"name\":\"\",\"node_id\":71,\"options\":{\"history\":{\"day\":1,\"month\":6,\"week\":26}},\"state\":1,\"step_value\":1,\"target_value\":14.75,\"type\":5,\"unit\":\"%C2%B0C\"},{\"based_on\":0,\"changed_by\":0,\"changed_by_id\":0,\"current_value\":1,\"data\":\"\",\"editable\":1,\"id\":500,\"instance\":0,\"last_changed\":0,\"last_value\":0,\"maximum\":1,\"minimum\":0,\"name\":\"\",\"node_id\":71,\"state\":1,\"step_value\":1,\"target_value\":1,\"type\":385,\"unit\":\"\"}],\"cube_type\":2,\"favorite\":0,\"history\":0,\"id\":71,\"image\":\"nodeicon_presence\",\"name\":\"DG / Schlafzimmer / Bewegungsmelder / Kirsten\",\"note\":\"# Philips Hue Bewegungsmelder\",\"order\":45,\"owner\":1,\"phonetic_name\":\"Bewegungsmelder Kirsten\",\"profile\":4035,\"protocol\":2,\"routing\":0,\"security\":0,\"services\":5,\"state\":1,\"state_changed\":1678427715}}", "payloadType": "json", "x": 300, "y": 3380, "wires": [ [ "ce392b92472130c0" ] ] } ]( payload.nodes[id=$$.device.node.id].state = device.node.state ) and ( device.node.attributes[type=8] ? payload.nodes[id=$$.device.node.id].attributes[type=8].current_value = device.node.attributes[type=8].current_value : true )Das Ganze sind aber langsam Logikfragen und haben weniger mit NodeRed zu tun. ;)
Wie gesagt das Ganze steht und fällt aber damit, wann der globale Kontext geändert wird und ob die einzelnen Nodes vorher ankommen, bevor der globale Kontext geändert wird.
@mickym
sorry, aber ich kann das spielen nicht lassen und habe versucht noch etwas an der Tabelle zu ändernIch wollte, wenn nur der Batteriestatus 69 vorhanden ist keine Zahlen, sondern einen Text hinterlegt haben. In der JSONata klappt das auch
Heizungsthermostate haben beides, da wird mir der Prozentwert hinterlegt:
Netatmo Geräte haben nur 69, da wird mir der Text hinterlegt:
Im Flow bringt er mir aber folgenden Fehlermeldung:
Hier der Flow
[ { "id": "9731f891b382fe8c", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": [] }, { "id": "11fd1028247a8897", "type": "change", "z": "9731f891b382fe8c", "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.nodes|{\"name\":$decodeUrlComponent(name),\t\"note\":$decodeUrlComponent(note),\t\"phonetic_name\":$decodeUrlComponent(phonetic_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 500, "y": 120, "wires": [ [ "05ccc17805c274e2" ] ] }, { "id": "05ccc17805c274e2", "type": "change", "z": "9731f891b382fe8c", "name": "Alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.nodes", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 710, "y": 120, "wires": [ [ "21f49844d0f9be61" ] ] }, { "id": "21f49844d0f9be61", "type": "change", "z": "9731f891b382fe8c", "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 120, "wires": [ [ "65f883047ce1db69" ] ] }, { "id": "93a74a370ce33f6a", "type": "change", "z": "9731f891b382fe8c", "name": "hole alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.nodes", "pt": "msg", "to": "homee.nodes", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 300, "y": 120, "wires": [ [ "11fd1028247a8897" ] ] }, { "id": "73447e82349b1ddc", "type": "inject", "z": "9731f891b382fe8c", "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 120, "wires": [ [ "93a74a370ce33f6a" ] ] }, { "id": "357d692fea66dd1e", "type": "debug", "z": "9731f891b382fe8c", "name": "Geräte Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1400, "y": 120, "wires": [] }, { "id": "65f883047ce1db69", "type": "change", "z": "9731f891b382fe8c", "name": "Geräte Tabelle8", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\",\"color\":\"#886fa9\"},{\"id\":2,\"name\":\"ZigBee\",\"color\":\"#ee6c1e\"},{\"id\":3,\"name\":\"EnOcean\",\"color\":\"#44abb2\"},{\"id\":9,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"},{\"id\":12,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "states", "pt": "msg", "to": "[{\"id\":1,\"name\":\"verfügbar\",\"color\":\"green\"},{\"id\":2,\"name\":\"nicht verfügbar\",\"color\":\"red\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]", "tot": "json" }, { "t": "set", "p": "battery", "pt": "msg", "to": "[{\"level\":30,\"color\":\"green\"},{\"level\":20,\"color\":\"yellow\"},{\"level\":15,\"color\":\"orange\"},{\"level\":0,\"color\":\"red\"}]", "tot": "json" }, { "t": "set", "p": "battery69", "pt": "msg", "to": "[{\"level\":0,\"name\":\"Batterie ok\",\"color\":\"green\"},{\"level\":1,\"name\":\"Batterie wechseln\",\"color\":\"red\"}]", "tot": "str" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" :name,\t \"type\" : note,\t \"protocol\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = protocol}).color & '\\\"> ' & $single($$.protocols, function($v){$v.id = protocol}).name,\t \"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name,\t \"battery69\" : (attributes[type=8 ] ? 0 : attributes[type=69 ]).type = 69 ? attributes[type=69 ].current_value,\t \"battery\" : (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 8 ? attributes[type=8 ].current_value\t} ~> |$|{\"battery\" : $exists(battery69) ? ' <font color=\\\"' & $filter($$.battery69, function($v){battery69 >= $v.level})[0].color & '\\\"> ' & $single($$.battery69, function($v){$v.level = battery69}).name :\t$exists(battery) ? ' <font color=\\\"' & $filter($$.battery, function($v){battery >= $v.level})[0].color & '\\\"> ' & battery & \" %\" :\t$contains(type,\"Plug\") ? ' <font color=\\\"#40E0D0\\\"> ' & \"Strombetrieben\": \"Keine Information vorhanden\"},\"note\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1140, "y": 120, "wires": [ [ "357d692fea66dd1e" ] ] } ]Ich will es nur verstehen
Gruß
Oliver -
@mickym
sorry, aber ich kann das spielen nicht lassen und habe versucht noch etwas an der Tabelle zu ändernIch wollte, wenn nur der Batteriestatus 69 vorhanden ist keine Zahlen, sondern einen Text hinterlegt haben. In der JSONata klappt das auch
Heizungsthermostate haben beides, da wird mir der Prozentwert hinterlegt:
Netatmo Geräte haben nur 69, da wird mir der Text hinterlegt:
Im Flow bringt er mir aber folgenden Fehlermeldung:
Hier der Flow
[ { "id": "9731f891b382fe8c", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": [] }, { "id": "11fd1028247a8897", "type": "change", "z": "9731f891b382fe8c", "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.nodes|{\"name\":$decodeUrlComponent(name),\t\"note\":$decodeUrlComponent(note),\t\"phonetic_name\":$decodeUrlComponent(phonetic_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 500, "y": 120, "wires": [ [ "05ccc17805c274e2" ] ] }, { "id": "05ccc17805c274e2", "type": "change", "z": "9731f891b382fe8c", "name": "Alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.nodes", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 710, "y": 120, "wires": [ [ "21f49844d0f9be61" ] ] }, { "id": "21f49844d0f9be61", "type": "change", "z": "9731f891b382fe8c", "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 120, "wires": [ [ "65f883047ce1db69" ] ] }, { "id": "93a74a370ce33f6a", "type": "change", "z": "9731f891b382fe8c", "name": "hole alle Geräte", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.nodes", "pt": "msg", "to": "homee.nodes", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 300, "y": 120, "wires": [ [ "11fd1028247a8897" ] ] }, { "id": "73447e82349b1ddc", "type": "inject", "z": "9731f891b382fe8c", "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 120, "wires": [ [ "93a74a370ce33f6a" ] ] }, { "id": "357d692fea66dd1e", "type": "debug", "z": "9731f891b382fe8c", "name": "Geräte Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1400, "y": 120, "wires": [] }, { "id": "65f883047ce1db69", "type": "change", "z": "9731f891b382fe8c", "name": "Geräte Tabelle8", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\",\"color\":\"#886fa9\"},{\"id\":2,\"name\":\"ZigBee\",\"color\":\"#ee6c1e\"},{\"id\":3,\"name\":\"EnOcean\",\"color\":\"#44abb2\"},{\"id\":9,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"},{\"id\":12,\"name\":\"WLAN\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "states", "pt": "msg", "to": "[{\"id\":1,\"name\":\"verfügbar\",\"color\":\"green\"},{\"id\":2,\"name\":\"nicht verfügbar\",\"color\":\"red\"},{\"id\":12,\"name\":\"wird aktualisiert\",\"color\":\"orange\"}]", "tot": "json" }, { "t": "set", "p": "battery", "pt": "msg", "to": "[{\"level\":30,\"color\":\"green\"},{\"level\":20,\"color\":\"yellow\"},{\"level\":15,\"color\":\"orange\"},{\"level\":0,\"color\":\"red\"}]", "tot": "json" }, { "t": "set", "p": "battery69", "pt": "msg", "to": "[{\"level\":0,\"name\":\"Batterie ok\",\"color\":\"green\"},{\"level\":1,\"name\":\"Batterie wechseln\",\"color\":\"red\"}]", "tot": "str" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" :name,\t \"type\" : note,\t \"protocol\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = protocol}).color & '\\\"> ' & $single($$.protocols, function($v){$v.id = protocol}).name,\t \"state\" : ' <font color=\\\"' & $single($$.states, function($v){$v.id = state}).color & '\\\"> ' & $single($$.states, function($v){$v.id = state}).name,\t \"battery69\" : (attributes[type=8 ] ? 0 : attributes[type=69 ]).type = 69 ? attributes[type=69 ].current_value,\t \"battery\" : (attributes[type=8 ] ? attributes[type=8 ] : attributes[type=69 ]).type = 8 ? attributes[type=8 ].current_value\t} ~> |$|{\"battery\" : $exists(battery69) ? ' <font color=\\\"' & $filter($$.battery69, function($v){battery69 >= $v.level})[0].color & '\\\"> ' & $single($$.battery69, function($v){$v.level = battery69}).name :\t$exists(battery) ? ' <font color=\\\"' & $filter($$.battery, function($v){battery >= $v.level})[0].color & '\\\"> ' & battery & \" %\" :\t$contains(type,\"Plug\") ? ' <font color=\\\"#40E0D0\\\"> ' & \"Strombetrieben\": \"Keine Information vorhanden\"},\"note\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1140, "y": 120, "wires": [ [ "357d692fea66dd1e" ] ] } ]Ich will es nur verstehen
gelöscht. ;)
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@mickym
verstehe ich jetzt nicht, da schreibe ich doch den value Wert rein, 0 = Batterie ok, 1 = Batterie wechseln@oli Ich habs . Ich merke schon Du willst mich auf die Probe stellen. ;)
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:
@mickym
vielen Dank, du bist der BesteNa ja - ich hab da viel zu lange gebraucht, um darauf zu kommen. ;)
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:
@mickym
vielen Dank, du bist der BesteNa ja - ich hab da viel zu lange gebraucht, um darauf zu kommen. ;)
ich leider schon wieder, war heute fleißig und habe sogar einen Flow, ohne deine Hilfe hinbekommen
Ich versuche gerade die Settings auszulesen, was bis jetzt auch gut geklappt hat.
Jetzt hänge ich aber wieder an so einer dämlichen Tabelle, die eigentlich ganz einfach aus sahHier die Daten:
{"language":"de","remote_access":1,"beta":0,"webhooks_key":"XXXXXXXXXXXX","automatic_location_detection":1,"polling_interval":60,"enable_analytics":0,"homee_name":"XXXXXXXX","b2b_partner":"homee","country":"Deutschland","country_code":"DE","state":"XXX","city":"XXXX","latitude":XXXXX,"longitude":XXXXX,"zip":"XXXX","address":"XXXXXX","timezone":"Europe%2FBerlin","last_automatic_location_detection":1674998871,"local_ssl_enabled":true,"wlan_enabled":1,"wlan_ip_address":"XXXXX","wlan_ssid":"XXXXX","wlan_mode":2,"internet_access":true,"lan_enabled":0,"available_ssids":["XXXX,XXXX"],"time":1678749606,"civil_time":"2023-03-14 00:20:06","version":"2.38.3+10a3a6dd","uid":"XXXXX","cubes":[{"protocol":1,"type":1,"order":1,"firmware":"3.95.0","secure_add":1,"missing_nodes":0,"resettable":true,"heal":true,"device_exclude_supported":true,"device_reinitialize_supported":true},{"protocol":3,"type":3,"order":2,"resettable":false},{"protocol":2,"type":2,"order":3,"firmware":"2.6.3","nw_channel":12,"resettable":true}],"extensions":{"weather":{"enabled":1},"amazon_alexa":{"enabled":1},"google_assistant":{"enabled":0,"syncing":0},"apple_homekit":{"configNumber":1,"enabled":0,"paired":0,"syncing":0},"ftp":{"enabled":1,"protocol":0,"hostname":"XXXXXX","port":XX,"username":"XXXX","has_password":1,"path":"Public/homee/","testing":0},"history":{"enabled":1,"destination":1,"folder":"Verlaufsdaten"},"backup":{"enabled":1,"destination":1,"folder":"Backup%2F","manual_export":0},"proxy":{"enabled":1,"connected":true,"environment":1},"electricity_price":{"enabled":0},"ssh_tunnel":{"enabled":false},"notification":{"email_daily_count":0,"email_daily_limit":50,"email_monthly_count":0,"email_monthly_limit":1550,"email_next_daily_reset_date":1678834800,"email_next_monthly_reset_date":1680300000,"environment":1},"dropbox":{"enabled":false},"braindump":{"enabled":false},"watchdog":{"enabled":true,"run_period":10000},"mosquitto_mqtt":{}},"name":"homee Oliver"}Es sollen eigentlich nur von den Cubes "type" und "fimware" ausgelesen und in eine Tabelle geschrieben werden, aber stelle mich wieder zu blöd an
Hier der Flow mit meinem erfolglosen Versuch:
[ { "id": "2749496aa10f7c17", "type": "tab", "label": "homee Settings", "disabled": false, "info": "", "env": [] }, { "id": "3bb8ae97da664e72", "type": "change", "z": "2749496aa10f7c17", "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.settings|{\"name\":$decodeUrlComponent(homee_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 560, "y": 180, "wires": [ [ "af2cb67fb55f481d" ] ] }, { "id": "af2cb67fb55f481d", "type": "change", "z": "2749496aa10f7c17", "name": "Alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 750, "y": 180, "wires": [ [ "c718d649fbe26208" ] ] }, { "id": "c718d649fbe26208", "type": "change", "z": "2749496aa10f7c17", "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 960, "y": 180, "wires": [ [ "937a5862046b9d5f", "c7f5dce04b044676", "e3c876ba60d4c83b", "736aeef19db4d053", "fc927cb540b12985", "6fba09a1121470b2", "1e42f8900946d138", "7455cb50e5c795a5" ] ] }, { "id": "5f3d5e25b9cde8da", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 310, "y": 180, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "ccf2eb936b15a350", "type": "inject", "z": "2749496aa10f7c17", "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 180, "wires": [ [ "5f3d5e25b9cde8da" ] ] }, { "id": "937a5862046b9d5f", "type": "debug", "z": "2749496aa10f7c17", "name": "Settings", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1200, "y": 60, "wires": [] }, { "id": "e3c876ba60d4c83b", "type": "change", "z": "2749496aa10f7c17", "name": "UID Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.uid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 300, "wires": [ [ "cf048a91a8b51875", "f76a02bd74f8832c" ] ] }, { "id": "cf048a91a8b51875", "type": "debug", "z": "2749496aa10f7c17", "name": "UID Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 240, "wires": [] }, { "id": "736aeef19db4d053", "type": "change", "z": "2749496aa10f7c17", "name": "Firmeware", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.version", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 420, "wires": [ [ "e590a079e72bd879", "6eb4c1b40932e67c" ] ] }, { "id": "e590a079e72bd879", "type": "debug", "z": "2749496aa10f7c17", "name": "Firmeware", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 360, "wires": [] }, { "id": "c7f5dce04b044676", "type": "change", "z": "2749496aa10f7c17", "name": "homee Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.name", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 180, "wires": [ [ "f4cdf6d60a263c02", "2ff1da8ed1a5bc32" ] ] }, { "id": "f4cdf6d60a263c02", "type": "debug", "z": "2749496aa10f7c17", "name": "homee Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 120, "wires": [] }, { "id": "f76a02bd74f8832c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "UID Name", "topic": "0_userdata.0.System.homee.Cube1.Uid", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Uid", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 300, "wires": [] }, { "id": "2ff1da8ed1a5bc32", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "homee Name", "topic": "0_userdata.0.System.homee.Cube1.Name", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Name", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 180, "wires": [] }, { "id": "6eb4c1b40932e67c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Firmeware", "topic": "0_userdata.0.System.homee.Cube1.Firmeware", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Firmeware", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 420, "wires": [] }, { "id": "5a98cc34ad5d369c", "type": "debug", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1720, "y": 720, "wires": [] }, { "id": "ef618bf5f21d53fc", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "topic": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "role": "", "payloadType": "number", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1720, "y": 780, "wires": [] }, { "id": "c3f282786a48e754", "type": "change", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$count(payload)", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1460, "y": 780, "wires": [ [ "5a98cc34ad5d369c", "ef618bf5f21d53fc" ] ] }, { "id": "b6ce520fe699b5b4", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 720, "wires": [] }, { "id": "6fba09a1121470b2", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.type", "tot": "jsonata" }, { "t": "set", "p": "homee.settings", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 780, "wires": [ [ "b6ce520fe699b5b4", "c3f282786a48e754" ] ] }, { "id": "103dd420f1ae6f4f", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung über", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 480, "wires": [] }, { "id": "aaf4ea5be5e5d689", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung über", "topic": "0_userdata.0.System.homee.Cube1.Verbindung", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Verbindung", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 540, "wires": [] }, { "id": "fc927cb540b12985", "type": "function", "z": "2749496aa10f7c17", "name": "Verbindung über", "func": "var wlan = msg.payload.wlan_enabled\nvar lan = msg.payload.wlan_enabled\nvar verbindung = \"\";\n\nif (wlan == 1) {\n verbindung = \"Wlan\";\n} else if (lan == 1) {\n verbindung == \"Lan\";\n} else if (wlan == 0 && lan == 0) {\n verbindung = \"keine Verbindung\"\n}\n\nmsg.payload = verbindung;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 1220, "y": 540, "wires": [ [ "103dd420f1ae6f4f", "aaf4ea5be5e5d689" ] ] }, { "id": "9ea4d4898638727c", "type": "comment", "z": "2749496aa10f7c17", "name": "homee Settings", "info": "", "x": 140, "y": 80, "wires": [] }, { "id": "1e42f8900946d138", "type": "change", "z": "2749496aa10f7c17", "name": "Verbindung mit", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.wlan_ssid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 660, "wires": [ [ "a6f09f2bdda4dc43", "1504ff5a09d26392" ] ] }, { "id": "a6f09f2bdda4dc43", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung mit", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 600, "wires": [] }, { "id": "1504ff5a09d26392", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung mit", "topic": "0_userdata.0.System.homee.Cube1.Netzwerk", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Netzwerk", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 660, "wires": [] }, { "id": "8a43345ef2a70be0", "type": "change", "z": "2749496aa10f7c17", "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 480, "y": 760, "wires": [ [ "46a5350c5d867f97" ] ] }, { "id": "46a5350c5d867f97", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle homeegramme", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 730, "y": 760, "wires": [ [ "053f961317aeb04b" ] ] }, { "id": "053f961317aeb04b", "type": "switch", "z": "2749496aa10f7c17", "name": "Nur wenn Settings sich ändern", "property": "(\t payload.settings = settings\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 710, "y": 420, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "f1c83ffb994d87a7", "type": "switch", "z": "2749496aa10f7c17", "name": "verify settings", "property": "payload.settings", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 220, "y": 760, "wires": [ [ "8a43345ef2a70be0" ] ] }, { "id": "5f4368b7e682f493", "type": "link in", "z": "2749496aa10f7c17", "name": "", "links": [ "d87f2174cf715cf2" ], "x": 75, "y": 760, "wires": [ [ "f1c83ffb994d87a7" ] ] }, { "id": "7455cb50e5c795a5", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\"},{\"id\":2,\"name\":\"ZigBee\"},{\"id\":3,\"name\":\"EnOcean\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" : $single($$.protocols, function($v){$v.id = type}).name, \t \"firmware\" : $exists(firmware) ? firmware : \"k.A.\" \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1240, "y": 880, "wires": [ [ "d5594ef7e61b1649" ] ] }, { "id": "d5594ef7e61b1649", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1480, "y": 880, "wires": [] } ]Wäre schön, wenn du mir nochmal helfen könntest
Gruß
Oliver -
ich leider schon wieder, war heute fleißig und habe sogar einen Flow, ohne deine Hilfe hinbekommen
Ich versuche gerade die Settings auszulesen, was bis jetzt auch gut geklappt hat.
Jetzt hänge ich aber wieder an so einer dämlichen Tabelle, die eigentlich ganz einfach aus sahHier die Daten:
{"language":"de","remote_access":1,"beta":0,"webhooks_key":"XXXXXXXXXXXX","automatic_location_detection":1,"polling_interval":60,"enable_analytics":0,"homee_name":"XXXXXXXX","b2b_partner":"homee","country":"Deutschland","country_code":"DE","state":"XXX","city":"XXXX","latitude":XXXXX,"longitude":XXXXX,"zip":"XXXX","address":"XXXXXX","timezone":"Europe%2FBerlin","last_automatic_location_detection":1674998871,"local_ssl_enabled":true,"wlan_enabled":1,"wlan_ip_address":"XXXXX","wlan_ssid":"XXXXX","wlan_mode":2,"internet_access":true,"lan_enabled":0,"available_ssids":["XXXX,XXXX"],"time":1678749606,"civil_time":"2023-03-14 00:20:06","version":"2.38.3+10a3a6dd","uid":"XXXXX","cubes":[{"protocol":1,"type":1,"order":1,"firmware":"3.95.0","secure_add":1,"missing_nodes":0,"resettable":true,"heal":true,"device_exclude_supported":true,"device_reinitialize_supported":true},{"protocol":3,"type":3,"order":2,"resettable":false},{"protocol":2,"type":2,"order":3,"firmware":"2.6.3","nw_channel":12,"resettable":true}],"extensions":{"weather":{"enabled":1},"amazon_alexa":{"enabled":1},"google_assistant":{"enabled":0,"syncing":0},"apple_homekit":{"configNumber":1,"enabled":0,"paired":0,"syncing":0},"ftp":{"enabled":1,"protocol":0,"hostname":"XXXXXX","port":XX,"username":"XXXX","has_password":1,"path":"Public/homee/","testing":0},"history":{"enabled":1,"destination":1,"folder":"Verlaufsdaten"},"backup":{"enabled":1,"destination":1,"folder":"Backup%2F","manual_export":0},"proxy":{"enabled":1,"connected":true,"environment":1},"electricity_price":{"enabled":0},"ssh_tunnel":{"enabled":false},"notification":{"email_daily_count":0,"email_daily_limit":50,"email_monthly_count":0,"email_monthly_limit":1550,"email_next_daily_reset_date":1678834800,"email_next_monthly_reset_date":1680300000,"environment":1},"dropbox":{"enabled":false},"braindump":{"enabled":false},"watchdog":{"enabled":true,"run_period":10000},"mosquitto_mqtt":{}},"name":"homee Oliver"}Es sollen eigentlich nur von den Cubes "type" und "fimware" ausgelesen und in eine Tabelle geschrieben werden, aber stelle mich wieder zu blöd an
Hier der Flow mit meinem erfolglosen Versuch:
[ { "id": "2749496aa10f7c17", "type": "tab", "label": "homee Settings", "disabled": false, "info": "", "env": [] }, { "id": "3bb8ae97da664e72", "type": "change", "z": "2749496aa10f7c17", "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.settings|{\"name\":$decodeUrlComponent(homee_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 560, "y": 180, "wires": [ [ "af2cb67fb55f481d" ] ] }, { "id": "af2cb67fb55f481d", "type": "change", "z": "2749496aa10f7c17", "name": "Alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 750, "y": 180, "wires": [ [ "c718d649fbe26208" ] ] }, { "id": "c718d649fbe26208", "type": "change", "z": "2749496aa10f7c17", "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 960, "y": 180, "wires": [ [ "937a5862046b9d5f", "c7f5dce04b044676", "e3c876ba60d4c83b", "736aeef19db4d053", "fc927cb540b12985", "6fba09a1121470b2", "1e42f8900946d138", "7455cb50e5c795a5" ] ] }, { "id": "5f3d5e25b9cde8da", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 310, "y": 180, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "ccf2eb936b15a350", "type": "inject", "z": "2749496aa10f7c17", "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 180, "wires": [ [ "5f3d5e25b9cde8da" ] ] }, { "id": "937a5862046b9d5f", "type": "debug", "z": "2749496aa10f7c17", "name": "Settings", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1200, "y": 60, "wires": [] }, { "id": "e3c876ba60d4c83b", "type": "change", "z": "2749496aa10f7c17", "name": "UID Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.uid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 300, "wires": [ [ "cf048a91a8b51875", "f76a02bd74f8832c" ] ] }, { "id": "cf048a91a8b51875", "type": "debug", "z": "2749496aa10f7c17", "name": "UID Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 240, "wires": [] }, { "id": "736aeef19db4d053", "type": "change", "z": "2749496aa10f7c17", "name": "Firmeware", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.version", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 420, "wires": [ [ "e590a079e72bd879", "6eb4c1b40932e67c" ] ] }, { "id": "e590a079e72bd879", "type": "debug", "z": "2749496aa10f7c17", "name": "Firmeware", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 360, "wires": [] }, { "id": "c7f5dce04b044676", "type": "change", "z": "2749496aa10f7c17", "name": "homee Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.name", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 180, "wires": [ [ "f4cdf6d60a263c02", "2ff1da8ed1a5bc32" ] ] }, { "id": "f4cdf6d60a263c02", "type": "debug", "z": "2749496aa10f7c17", "name": "homee Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 120, "wires": [] }, { "id": "f76a02bd74f8832c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "UID Name", "topic": "0_userdata.0.System.homee.Cube1.Uid", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Uid", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 300, "wires": [] }, { "id": "2ff1da8ed1a5bc32", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "homee Name", "topic": "0_userdata.0.System.homee.Cube1.Name", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Name", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 180, "wires": [] }, { "id": "6eb4c1b40932e67c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Firmeware", "topic": "0_userdata.0.System.homee.Cube1.Firmeware", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Firmeware", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 420, "wires": [] }, { "id": "5a98cc34ad5d369c", "type": "debug", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1720, "y": 720, "wires": [] }, { "id": "ef618bf5f21d53fc", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "topic": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "role": "", "payloadType": "number", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1720, "y": 780, "wires": [] }, { "id": "c3f282786a48e754", "type": "change", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$count(payload)", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1460, "y": 780, "wires": [ [ "5a98cc34ad5d369c", "ef618bf5f21d53fc" ] ] }, { "id": "b6ce520fe699b5b4", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 720, "wires": [] }, { "id": "6fba09a1121470b2", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.type", "tot": "jsonata" }, { "t": "set", "p": "homee.settings", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 780, "wires": [ [ "b6ce520fe699b5b4", "c3f282786a48e754" ] ] }, { "id": "103dd420f1ae6f4f", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung über", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 480, "wires": [] }, { "id": "aaf4ea5be5e5d689", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung über", "topic": "0_userdata.0.System.homee.Cube1.Verbindung", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Verbindung", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 540, "wires": [] }, { "id": "fc927cb540b12985", "type": "function", "z": "2749496aa10f7c17", "name": "Verbindung über", "func": "var wlan = msg.payload.wlan_enabled\nvar lan = msg.payload.wlan_enabled\nvar verbindung = \"\";\n\nif (wlan == 1) {\n verbindung = \"Wlan\";\n} else if (lan == 1) {\n verbindung == \"Lan\";\n} else if (wlan == 0 && lan == 0) {\n verbindung = \"keine Verbindung\"\n}\n\nmsg.payload = verbindung;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 1220, "y": 540, "wires": [ [ "103dd420f1ae6f4f", "aaf4ea5be5e5d689" ] ] }, { "id": "9ea4d4898638727c", "type": "comment", "z": "2749496aa10f7c17", "name": "homee Settings", "info": "", "x": 140, "y": 80, "wires": [] }, { "id": "1e42f8900946d138", "type": "change", "z": "2749496aa10f7c17", "name": "Verbindung mit", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.wlan_ssid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 660, "wires": [ [ "a6f09f2bdda4dc43", "1504ff5a09d26392" ] ] }, { "id": "a6f09f2bdda4dc43", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung mit", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 600, "wires": [] }, { "id": "1504ff5a09d26392", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung mit", "topic": "0_userdata.0.System.homee.Cube1.Netzwerk", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Netzwerk", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 660, "wires": [] }, { "id": "8a43345ef2a70be0", "type": "change", "z": "2749496aa10f7c17", "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 480, "y": 760, "wires": [ [ "46a5350c5d867f97" ] ] }, { "id": "46a5350c5d867f97", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle homeegramme", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 730, "y": 760, "wires": [ [ "053f961317aeb04b" ] ] }, { "id": "053f961317aeb04b", "type": "switch", "z": "2749496aa10f7c17", "name": "Nur wenn Settings sich ändern", "property": "(\t payload.settings = settings\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 710, "y": 420, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "f1c83ffb994d87a7", "type": "switch", "z": "2749496aa10f7c17", "name": "verify settings", "property": "payload.settings", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 220, "y": 760, "wires": [ [ "8a43345ef2a70be0" ] ] }, { "id": "5f4368b7e682f493", "type": "link in", "z": "2749496aa10f7c17", "name": "", "links": [ "d87f2174cf715cf2" ], "x": 75, "y": 760, "wires": [ [ "f1c83ffb994d87a7" ] ] }, { "id": "7455cb50e5c795a5", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\"},{\"id\":2,\"name\":\"ZigBee\"},{\"id\":3,\"name\":\"EnOcean\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" : $single($$.protocols, function($v){$v.id = type}).name, \t \"firmware\" : $exists(firmware) ? firmware : \"k.A.\" \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1240, "y": 880, "wires": [ [ "d5594ef7e61b1649" ] ] }, { "id": "d5594ef7e61b1649", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1480, "y": 880, "wires": [] } ]Wäre schön, wenn du mir nochmal helfen könntest
@oli sagte in Benötige Hilfe mit Node-Red in Verbindung mit homee:
{"language":"de","remote_access":1,"beta":0,"webhooks_key":"XXXXXXXXXXXX","automatic_location_detection":1,"polling_interval":60,"enable_analytics":0,"homee_name":"XXXXXXXX","b2b_partner":"homee","country":"Deutschland","country_code":"DE","state":"XXX","city":"XXXX","latitude":XXXXX,"longitude":XXXXX,"zip":"XXXX","address":"XXXXXX","timezone":"Europe%2FBerlin","last_automatic_location_detection":1674998871,"local_ssl_enabled":true,"wlan_enabled":1,"wlan_ip_address":"XXXXX","wlan_ssid":"XXXXX","wlan_mode":2,"internet_access":true,"lan_enabled":0,"available_ssids":["XXXX,XXXX"],"time":1678749606,"civil_time":"2023-03-14 00:20:06","version":"2.38.3+10a3a6dd","uid":"XXXXX","cubes":[{"protocol":1,"type":1,"order":1,"firmware":"3.95.0","secure_add":1,"missing_nodes":0,"resettable":true,"heal":true,"device_exclude_supported":true,"device_reinitialize_supported":true},{"protocol":3,"type":3,"order":2,"resettable":false},{"protocol":2,"type":2,"order":3,"firmware":"2.6.3","nw_channel":12,"resettable":true}],"extensions":{"weather":{"enabled":1},"amazon_alexa":{"enabled":1},"google_assistant":{"enabled":0,"syncing":0},"apple_homekit":{"configNumber":1,"enabled":0,"paired":0,"syncing":0},"ftp":{"enabled":1,"protocol":0,"hostname":"XXXXXX","port":XX,"username":"XXXX","has_password":1,"path":"Public/homee/","testing":0},"history":{"enabled":1,"destination":1,"folder":"Verlaufsdaten"},"backup":{"enabled":1,"destination":1,"folder":"Backup%2F","manual_export":0},"proxy":{"enabled":1,"connected":true,"environment":1},"electricity_price":{"enabled":0},"ssh_tunnel":{"enabled":false},"notification":{"email_daily_count":0,"email_daily_limit":50,"email_monthly_count":0,"email_monthly_limit":1550,"email_next_daily_reset_date":1678834800,"email_next_monthly_reset_date":1680300000,"environment":1},"dropbox":{"enabled":false},"braindump":{"enabled":false},"watchdog":{"enabled":true,"run_period":10000},"mosquitto_mqtt":{}},"name":"homee Oliver"}
Ich versuchs mal - ich versteh ja dass Du bestimmte Dinge aus- x - aber wenn Du den JSON kaputt machst - dann muss ich erst mal 5 Minuten den JSON nach bearbeiten.
das nächste Mal jagst Du Deinen JSON bitte hier durch: https://jsonformatter.org/
und kopierst dann den formatierten JSON hier rein (also das rechte Fenster - und wenn das nicht geht dann beseitige erst mal die Fehler:
So ist der JSON nun korrigiert.
{ "language": "de", "remote_access": 1, "beta": 0, "webhooks_key": "XXXXXXXXXXXX", "automatic_location_detection": 1, "polling_interval": 60, "enable_analytics": 0, "homee_name": "XXXXXXXX", "b2b_partner": "homee", "country": "Deutschland", "country_code": "DE", "state": "XXX", "city": "XXXX", "latitude": "XXXXX", "longitude": "XXXXX", "zip": "XXXX", "address": "XXXXXX", "timezone": "Europe%2FBerlin", "last_automatic_location_detection": 1674998871, "local_ssl_enabled": true, "wlan_enabled": 1, "wlan_ip_address": "XXXXX", "wlan_ssid": "XXXXX", "wlan_mode": 2, "internet_access": true, "lan_enabled": 0, "available_ssids": [ "XXXX,XXXX" ], "time": 1678749606, "civil_time": "2023-03-14 00:20:06", "version": "2.38.3+10a3a6dd", "uid": "XXXXX", "cubes": [ { "protocol": 1, "type": 1, "order": 1, "firmware": "3.95.0", "secure_add": 1, "missing_nodes": 0, "resettable": true, "heal": true, "device_exclude_supported": true, "device_reinitialize_supported": true }, { "protocol": 3, "type": 3, "order": 2, "resettable": false }, { "protocol": 2, "type": 2, "order": 3, "firmware": "2.6.3", "nw_channel": 12, "resettable": true } ], "extensions": { "weather": { "enabled": 1 }, "amazon_alexa": { "enabled": 1 }, "google_assistant": { "enabled": 0, "syncing": 0 }, "apple_homekit": { "configNumber": 1, "enabled": 0, "paired": 0, "syncing": 0 }, "ftp": { "enabled": 1, "protocol": 0, "hostname": "XXXXXX", "port": "XX", "username": "XXXX", "has_password": 1, "path": "Public/homee/", "testing": 0 }, "history": { "enabled": 1, "destination": 1, "folder": "Verlaufsdaten" }, "backup": { "enabled": 1, "destination": 1, "folder": "Backup%2F", "manual_export": 0 }, "proxy": { "enabled": 1, "connected": true, "environment": 1 }, "electricity_price": { "enabled": 0 }, "ssh_tunnel": { "enabled": false }, "notification": { "email_daily_count": 0, "email_daily_limit": 50, "email_monthly_count": 0, "email_monthly_limit": 1550, "email_next_daily_reset_date": 1678834800, "email_next_monthly_reset_date": 1680300000, "environment": 1 }, "dropbox": { "enabled": false }, "braindump": { "enabled": false }, "watchdog": { "enabled": true, "run_period": 10000 }, "mosquitto_mqtt": {}, "name": "homee Oliver" } }Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
ich leider schon wieder, war heute fleißig und habe sogar einen Flow, ohne deine Hilfe hinbekommen
Ich versuche gerade die Settings auszulesen, was bis jetzt auch gut geklappt hat.
Jetzt hänge ich aber wieder an so einer dämlichen Tabelle, die eigentlich ganz einfach aus sahHier die Daten:
{"language":"de","remote_access":1,"beta":0,"webhooks_key":"XXXXXXXXXXXX","automatic_location_detection":1,"polling_interval":60,"enable_analytics":0,"homee_name":"XXXXXXXX","b2b_partner":"homee","country":"Deutschland","country_code":"DE","state":"XXX","city":"XXXX","latitude":XXXXX,"longitude":XXXXX,"zip":"XXXX","address":"XXXXXX","timezone":"Europe%2FBerlin","last_automatic_location_detection":1674998871,"local_ssl_enabled":true,"wlan_enabled":1,"wlan_ip_address":"XXXXX","wlan_ssid":"XXXXX","wlan_mode":2,"internet_access":true,"lan_enabled":0,"available_ssids":["XXXX,XXXX"],"time":1678749606,"civil_time":"2023-03-14 00:20:06","version":"2.38.3+10a3a6dd","uid":"XXXXX","cubes":[{"protocol":1,"type":1,"order":1,"firmware":"3.95.0","secure_add":1,"missing_nodes":0,"resettable":true,"heal":true,"device_exclude_supported":true,"device_reinitialize_supported":true},{"protocol":3,"type":3,"order":2,"resettable":false},{"protocol":2,"type":2,"order":3,"firmware":"2.6.3","nw_channel":12,"resettable":true}],"extensions":{"weather":{"enabled":1},"amazon_alexa":{"enabled":1},"google_assistant":{"enabled":0,"syncing":0},"apple_homekit":{"configNumber":1,"enabled":0,"paired":0,"syncing":0},"ftp":{"enabled":1,"protocol":0,"hostname":"XXXXXX","port":XX,"username":"XXXX","has_password":1,"path":"Public/homee/","testing":0},"history":{"enabled":1,"destination":1,"folder":"Verlaufsdaten"},"backup":{"enabled":1,"destination":1,"folder":"Backup%2F","manual_export":0},"proxy":{"enabled":1,"connected":true,"environment":1},"electricity_price":{"enabled":0},"ssh_tunnel":{"enabled":false},"notification":{"email_daily_count":0,"email_daily_limit":50,"email_monthly_count":0,"email_monthly_limit":1550,"email_next_daily_reset_date":1678834800,"email_next_monthly_reset_date":1680300000,"environment":1},"dropbox":{"enabled":false},"braindump":{"enabled":false},"watchdog":{"enabled":true,"run_period":10000},"mosquitto_mqtt":{}},"name":"homee Oliver"}Es sollen eigentlich nur von den Cubes "type" und "fimware" ausgelesen und in eine Tabelle geschrieben werden, aber stelle mich wieder zu blöd an
Hier der Flow mit meinem erfolglosen Versuch:
[ { "id": "2749496aa10f7c17", "type": "tab", "label": "homee Settings", "disabled": false, "info": "", "env": [] }, { "id": "3bb8ae97da664e72", "type": "change", "z": "2749496aa10f7c17", "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.settings|{\"name\":$decodeUrlComponent(homee_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 560, "y": 180, "wires": [ [ "af2cb67fb55f481d" ] ] }, { "id": "af2cb67fb55f481d", "type": "change", "z": "2749496aa10f7c17", "name": "Alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 750, "y": 180, "wires": [ [ "c718d649fbe26208" ] ] }, { "id": "c718d649fbe26208", "type": "change", "z": "2749496aa10f7c17", "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 960, "y": 180, "wires": [ [ "937a5862046b9d5f", "c7f5dce04b044676", "e3c876ba60d4c83b", "736aeef19db4d053", "fc927cb540b12985", "6fba09a1121470b2", "1e42f8900946d138", "7455cb50e5c795a5" ] ] }, { "id": "5f3d5e25b9cde8da", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 310, "y": 180, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "ccf2eb936b15a350", "type": "inject", "z": "2749496aa10f7c17", "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 180, "wires": [ [ "5f3d5e25b9cde8da" ] ] }, { "id": "937a5862046b9d5f", "type": "debug", "z": "2749496aa10f7c17", "name": "Settings", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1200, "y": 60, "wires": [] }, { "id": "e3c876ba60d4c83b", "type": "change", "z": "2749496aa10f7c17", "name": "UID Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.uid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 300, "wires": [ [ "cf048a91a8b51875", "f76a02bd74f8832c" ] ] }, { "id": "cf048a91a8b51875", "type": "debug", "z": "2749496aa10f7c17", "name": "UID Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 240, "wires": [] }, { "id": "736aeef19db4d053", "type": "change", "z": "2749496aa10f7c17", "name": "Firmeware", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.version", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 420, "wires": [ [ "e590a079e72bd879", "6eb4c1b40932e67c" ] ] }, { "id": "e590a079e72bd879", "type": "debug", "z": "2749496aa10f7c17", "name": "Firmeware", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 360, "wires": [] }, { "id": "c7f5dce04b044676", "type": "change", "z": "2749496aa10f7c17", "name": "homee Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.name", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 180, "wires": [ [ "f4cdf6d60a263c02", "2ff1da8ed1a5bc32" ] ] }, { "id": "f4cdf6d60a263c02", "type": "debug", "z": "2749496aa10f7c17", "name": "homee Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 120, "wires": [] }, { "id": "f76a02bd74f8832c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "UID Name", "topic": "0_userdata.0.System.homee.Cube1.Uid", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Uid", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 300, "wires": [] }, { "id": "2ff1da8ed1a5bc32", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "homee Name", "topic": "0_userdata.0.System.homee.Cube1.Name", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Name", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 180, "wires": [] }, { "id": "6eb4c1b40932e67c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Firmeware", "topic": "0_userdata.0.System.homee.Cube1.Firmeware", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Firmeware", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 420, "wires": [] }, { "id": "5a98cc34ad5d369c", "type": "debug", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1720, "y": 720, "wires": [] }, { "id": "ef618bf5f21d53fc", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "topic": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "role": "", "payloadType": "number", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1720, "y": 780, "wires": [] }, { "id": "c3f282786a48e754", "type": "change", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$count(payload)", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1460, "y": 780, "wires": [ [ "5a98cc34ad5d369c", "ef618bf5f21d53fc" ] ] }, { "id": "b6ce520fe699b5b4", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 720, "wires": [] }, { "id": "6fba09a1121470b2", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.type", "tot": "jsonata" }, { "t": "set", "p": "homee.settings", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 780, "wires": [ [ "b6ce520fe699b5b4", "c3f282786a48e754" ] ] }, { "id": "103dd420f1ae6f4f", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung über", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 480, "wires": [] }, { "id": "aaf4ea5be5e5d689", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung über", "topic": "0_userdata.0.System.homee.Cube1.Verbindung", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Verbindung", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 540, "wires": [] }, { "id": "fc927cb540b12985", "type": "function", "z": "2749496aa10f7c17", "name": "Verbindung über", "func": "var wlan = msg.payload.wlan_enabled\nvar lan = msg.payload.wlan_enabled\nvar verbindung = \"\";\n\nif (wlan == 1) {\n verbindung = \"Wlan\";\n} else if (lan == 1) {\n verbindung == \"Lan\";\n} else if (wlan == 0 && lan == 0) {\n verbindung = \"keine Verbindung\"\n}\n\nmsg.payload = verbindung;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 1220, "y": 540, "wires": [ [ "103dd420f1ae6f4f", "aaf4ea5be5e5d689" ] ] }, { "id": "9ea4d4898638727c", "type": "comment", "z": "2749496aa10f7c17", "name": "homee Settings", "info": "", "x": 140, "y": 80, "wires": [] }, { "id": "1e42f8900946d138", "type": "change", "z": "2749496aa10f7c17", "name": "Verbindung mit", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.wlan_ssid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 660, "wires": [ [ "a6f09f2bdda4dc43", "1504ff5a09d26392" ] ] }, { "id": "a6f09f2bdda4dc43", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung mit", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 600, "wires": [] }, { "id": "1504ff5a09d26392", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung mit", "topic": "0_userdata.0.System.homee.Cube1.Netzwerk", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Netzwerk", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 660, "wires": [] }, { "id": "8a43345ef2a70be0", "type": "change", "z": "2749496aa10f7c17", "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 480, "y": 760, "wires": [ [ "46a5350c5d867f97" ] ] }, { "id": "46a5350c5d867f97", "type": "change", "z": "2749496aa10f7c17", "name": "hole alle homeegramme", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 730, "y": 760, "wires": [ [ "053f961317aeb04b" ] ] }, { "id": "053f961317aeb04b", "type": "switch", "z": "2749496aa10f7c17", "name": "Nur wenn Settings sich ändern", "property": "(\t payload.settings = settings\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 710, "y": 420, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "f1c83ffb994d87a7", "type": "switch", "z": "2749496aa10f7c17", "name": "verify settings", "property": "payload.settings", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 220, "y": 760, "wires": [ [ "8a43345ef2a70be0" ] ] }, { "id": "5f4368b7e682f493", "type": "link in", "z": "2749496aa10f7c17", "name": "", "links": [ "d87f2174cf715cf2" ], "x": 75, "y": 760, "wires": [ [ "f1c83ffb994d87a7" ] ] }, { "id": "7455cb50e5c795a5", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\"},{\"id\":2,\"name\":\"ZigBee\"},{\"id\":3,\"name\":\"EnOcean\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\"name\" : $single($$.protocols, function($v){$v.id = type}).name, \t \"firmware\" : $exists(firmware) ? firmware : \"k.A.\" \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1240, "y": 880, "wires": [ [ "d5594ef7e61b1649" ] ] }, { "id": "d5594ef7e61b1649", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1480, "y": 880, "wires": [] } ]Wäre schön, wenn du mir nochmal helfen könntest
@oli So Du musst nicht den alten Schmus mit kopieren. Wenn Du nächstes Mal Hilfe brauchst, musst die Daten nur in eine Inject Node kopieren und einspeisen. ;)
Ich habs Dir mal vorgemacht. ;)Ich hab den Flow mal so angepasst, was völlig ausreichend ist. ;)
[ { "id": "2749496aa10f7c17", "type": "tab", "label": "homee Settings", "disabled": false, "info": "", "env": [] }, { "id": "35f2e60b460d3176", "type": "junction", "z": "2749496aa10f7c17", "x": 1060, "y": 260, "wires": [ [ "7455cb50e5c795a5", "1e42f8900946d138", "c7f5dce04b044676", "937a5862046b9d5f", "fc927cb540b12985", "736aeef19db4d053", "e3c876ba60d4c83b", "6fba09a1121470b2" ] ] }, { "id": "3bb8ae97da664e72", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.settings|{\"name\":$decodeUrlComponent(homee_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 560, "y": 400, "wires": [ [ "af2cb67fb55f481d" ] ] }, { "id": "af2cb67fb55f481d", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "Alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 750, "y": 400, "wires": [ [ "c718d649fbe26208" ] ] }, { "id": "c718d649fbe26208", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 460, "wires": [ [] ] }, { "id": "5f3d5e25b9cde8da", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "hole alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 310, "y": 400, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "ccf2eb936b15a350", "type": "inject", "z": "2749496aa10f7c17", "d": true, "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 400, "wires": [ [ "5f3d5e25b9cde8da" ] ] }, { "id": "937a5862046b9d5f", "type": "debug", "z": "2749496aa10f7c17", "name": "Settings", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1200, "y": 60, "wires": [] }, { "id": "e3c876ba60d4c83b", "type": "change", "z": "2749496aa10f7c17", "name": "UID Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.uid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 300, "wires": [ [ "cf048a91a8b51875", "f76a02bd74f8832c" ] ] }, { "id": "cf048a91a8b51875", "type": "debug", "z": "2749496aa10f7c17", "name": "UID Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 240, "wires": [] }, { "id": "736aeef19db4d053", "type": "change", "z": "2749496aa10f7c17", "name": "Firmeware", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.version", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 420, "wires": [ [ "e590a079e72bd879", "6eb4c1b40932e67c" ] ] }, { "id": "e590a079e72bd879", "type": "debug", "z": "2749496aa10f7c17", "name": "Firmeware", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 360, "wires": [] }, { "id": "c7f5dce04b044676", "type": "change", "z": "2749496aa10f7c17", "name": "homee Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.name", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 180, "wires": [ [ "f4cdf6d60a263c02", "2ff1da8ed1a5bc32" ] ] }, { "id": "f4cdf6d60a263c02", "type": "debug", "z": "2749496aa10f7c17", "name": "homee Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 120, "wires": [] }, { "id": "f76a02bd74f8832c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "UID Name", "topic": "0_userdata.0.System.homee.Cube1.Uid", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Uid", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 300, "wires": [] }, { "id": "2ff1da8ed1a5bc32", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "homee Name", "topic": "0_userdata.0.System.homee.Cube1.Name", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Name", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 180, "wires": [] }, { "id": "6eb4c1b40932e67c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Firmeware", "topic": "0_userdata.0.System.homee.Cube1.Firmeware", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Firmeware", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 420, "wires": [] }, { "id": "5a98cc34ad5d369c", "type": "debug", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1720, "y": 720, "wires": [] }, { "id": "ef618bf5f21d53fc", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "topic": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "role": "", "payloadType": "number", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1720, "y": 780, "wires": [] }, { "id": "c3f282786a48e754", "type": "change", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$count(payload)", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1460, "y": 780, "wires": [ [ "5a98cc34ad5d369c", "ef618bf5f21d53fc" ] ] }, { "id": "b6ce520fe699b5b4", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 720, "wires": [] }, { "id": "6fba09a1121470b2", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.type", "tot": "jsonata" }, { "t": "set", "p": "homee.settings", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 780, "wires": [ [ "b6ce520fe699b5b4", "c3f282786a48e754" ] ] }, { "id": "103dd420f1ae6f4f", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung über", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 480, "wires": [] }, { "id": "aaf4ea5be5e5d689", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung über", "topic": "0_userdata.0.System.homee.Cube1.Verbindung", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Verbindung", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 540, "wires": [] }, { "id": "fc927cb540b12985", "type": "function", "z": "2749496aa10f7c17", "name": "Verbindung über", "func": "var wlan = msg.payload.wlan_enabled\nvar lan = msg.payload.wlan_enabled\nvar verbindung = \"\";\n\nif (wlan == 1) {\n verbindung = \"Wlan\";\n} else if (lan == 1) {\n verbindung == \"Lan\";\n} else if (wlan == 0 && lan == 0) {\n verbindung = \"keine Verbindung\"\n}\n\nmsg.payload = verbindung;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 1220, "y": 540, "wires": [ [ "103dd420f1ae6f4f", "aaf4ea5be5e5d689" ] ] }, { "id": "9ea4d4898638727c", "type": "comment", "z": "2749496aa10f7c17", "name": "homee Settings", "info": "", "x": 140, "y": 80, "wires": [] }, { "id": "1e42f8900946d138", "type": "change", "z": "2749496aa10f7c17", "name": "Verbindung mit", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.wlan_ssid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 660, "wires": [ [ "a6f09f2bdda4dc43", "1504ff5a09d26392" ] ] }, { "id": "a6f09f2bdda4dc43", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung mit", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 600, "wires": [] }, { "id": "1504ff5a09d26392", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung mit", "topic": "0_userdata.0.System.homee.Cube1.Netzwerk", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Netzwerk", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 660, "wires": [] }, { "id": "8a43345ef2a70be0", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 480, "y": 760, "wires": [ [ "46a5350c5d867f97" ] ] }, { "id": "46a5350c5d867f97", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "hole alle homeegramme", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 730, "y": 760, "wires": [ [ "053f961317aeb04b" ] ] }, { "id": "053f961317aeb04b", "type": "switch", "z": "2749496aa10f7c17", "d": true, "name": "Nur wenn Settings sich ändern", "property": "(\t payload.settings = settings\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 730, "y": 560, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "f1c83ffb994d87a7", "type": "switch", "z": "2749496aa10f7c17", "d": true, "name": "verify settings", "property": "payload.settings", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 220, "y": 760, "wires": [ [ "8a43345ef2a70be0" ] ] }, { "id": "5f4368b7e682f493", "type": "link in", "z": "2749496aa10f7c17", "d": true, "name": "", "links": [ "d87f2174cf715cf2" ], "x": 75, "y": 760, "wires": [ [ "f1c83ffb994d87a7" ] ] }, { "id": "7455cb50e5c795a5", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\"},{\"id\":2,\"name\":\"ZigBee\"},{\"id\":3,\"name\":\"EnOcean\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.{\"name\" : $single($$.protocols, function($v){$v.id = type}).name, \t \"firmware\" : $exists(firmware) ? firmware : \"k.A.\" \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1240, "y": 880, "wires": [ [ "d5594ef7e61b1649" ] ] }, { "id": "d5594ef7e61b1649", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1480, "y": 880, "wires": [] }, { "id": "bff3d9cc6b00b7ea", "type": "inject", "z": "2749496aa10f7c17", "name": "", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"language\":\"de\",\"remote_access\":1,\"beta\":0,\"webhooks_key\":\"XXXXXXXXXXXX\",\"automatic_location_detection\":1,\"polling_interval\":60,\"enable_analytics\":0,\"homee_name\":\"XXXXXXXX\",\"b2b_partner\":\"homee\",\"country\":\"Deutschland\",\"country_code\":\"DE\",\"state\":\"XXX\",\"city\":\"XXXX\",\"latitude\":\"XXXXX\",\"longitude\":\"XXXXX\",\"zip\":\"XXXX\",\"address\":\"XXXXXX\",\"timezone\":\"Europe%2FBerlin\",\"last_automatic_location_detection\":1674998871,\"local_ssl_enabled\":true,\"wlan_enabled\":1,\"wlan_ip_address\":\"XXXXX\",\"wlan_ssid\":\"XXXXX\",\"wlan_mode\":2,\"internet_access\":true,\"lan_enabled\":0,\"available_ssids\":[\"XXXX,XXXX\"],\"time\":1678749606,\"civil_time\":\"2023-03-14 00:20:06\",\"version\":\"2.38.3+10a3a6dd\",\"uid\":\"XXXXX\",\"cubes\":[{\"protocol\":1,\"type\":1,\"order\":1,\"firmware\":\"3.95.0\",\"secure_add\":1,\"missing_nodes\":0,\"resettable\":true,\"heal\":true,\"device_exclude_supported\":true,\"device_reinitialize_supported\":true},{\"protocol\":3,\"type\":3,\"order\":2,\"resettable\":false},{\"protocol\":2,\"type\":2,\"order\":3,\"firmware\":\"2.6.3\",\"nw_channel\":12,\"resettable\":true}],\"extensions\":{\"weather\":{\"enabled\":1},\"amazon_alexa\":{\"enabled\":1},\"google_assistant\":{\"enabled\":0,\"syncing\":0},\"apple_homekit\":{\"configNumber\":1,\"enabled\":0,\"paired\":0,\"syncing\":0},\"ftp\":{\"enabled\":1,\"protocol\":0,\"hostname\":\"XXXXXX\",\"port\":\"XX\",\"username\":\"XXXX\",\"has_password\":1,\"path\":\"Public/homee/\",\"testing\":0},\"history\":{\"enabled\":1,\"destination\":1,\"folder\":\"Verlaufsdaten\"},\"backup\":{\"enabled\":1,\"destination\":1,\"folder\":\"Backup%2F\",\"manual_export\":0},\"proxy\":{\"enabled\":1,\"connected\":true,\"environment\":1},\"electricity_price\":{\"enabled\":0},\"ssh_tunnel\":{\"enabled\":false},\"notification\":{\"email_daily_count\":0,\"email_daily_limit\":50,\"email_monthly_count\":0,\"email_monthly_limit\":1550,\"email_next_daily_reset_date\":1678834800,\"email_next_monthly_reset_date\":1680300000,\"environment\":1},\"dropbox\":{\"enabled\":false},\"braindump\":{\"enabled\":false},\"watchdog\":{\"enabled\":true,\"run_period\":10000},\"mosquitto_mqtt\":{},\"name\":\"homee Oliver\"}}", "payloadType": "json", "x": 930, "y": 260, "wires": [ [ "35f2e60b460d3176" ] ] } ]Die meisten Nodes die Du aus dem anderen Flow kopiert hast, machen eh keinen Sinn.
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli So Du musst nicht den alten Schmus mit kopieren. Wenn Du nächstes Mal Hilfe brauchst, musst die Daten nur in eine Inject Node kopieren und einspeisen. ;)
Ich habs Dir mal vorgemacht. ;)Ich hab den Flow mal so angepasst, was völlig ausreichend ist. ;)
[ { "id": "2749496aa10f7c17", "type": "tab", "label": "homee Settings", "disabled": false, "info": "", "env": [] }, { "id": "35f2e60b460d3176", "type": "junction", "z": "2749496aa10f7c17", "x": 1060, "y": 260, "wires": [ [ "7455cb50e5c795a5", "1e42f8900946d138", "c7f5dce04b044676", "937a5862046b9d5f", "fc927cb540b12985", "736aeef19db4d053", "e3c876ba60d4c83b", "6fba09a1121470b2" ] ] }, { "id": "3bb8ae97da664e72", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "decodeUrlComponents", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> |$.settings|{\"name\":$decodeUrlComponent(homee_name)},\"\"|", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 560, "y": 400, "wires": [ [ "af2cb67fb55f481d" ] ] }, { "id": "af2cb67fb55f481d", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "Alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 750, "y": 400, "wires": [ [ "c718d649fbe26208" ] ] }, { "id": "c718d649fbe26208", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "Geräte ausschliessen", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload ~> $filter(function($value){$value.id in [-1] != true})", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 920, "y": 460, "wires": [ [] ] }, { "id": "5f3d5e25b9cde8da", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "hole alle Settings", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 310, "y": 400, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "ccf2eb936b15a350", "type": "inject", "z": "2749496aa10f7c17", "d": true, "name": "trigger", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "true", "payloadType": "bool", "x": 130, "y": 400, "wires": [ [ "5f3d5e25b9cde8da" ] ] }, { "id": "937a5862046b9d5f", "type": "debug", "z": "2749496aa10f7c17", "name": "Settings", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1200, "y": 60, "wires": [] }, { "id": "e3c876ba60d4c83b", "type": "change", "z": "2749496aa10f7c17", "name": "UID Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.uid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 300, "wires": [ [ "cf048a91a8b51875", "f76a02bd74f8832c" ] ] }, { "id": "cf048a91a8b51875", "type": "debug", "z": "2749496aa10f7c17", "name": "UID Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 240, "wires": [] }, { "id": "736aeef19db4d053", "type": "change", "z": "2749496aa10f7c17", "name": "Firmeware", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.version", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 420, "wires": [ [ "e590a079e72bd879", "6eb4c1b40932e67c" ] ] }, { "id": "e590a079e72bd879", "type": "debug", "z": "2749496aa10f7c17", "name": "Firmeware", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 360, "wires": [] }, { "id": "c7f5dce04b044676", "type": "change", "z": "2749496aa10f7c17", "name": "homee Name", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.name", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 180, "wires": [ [ "f4cdf6d60a263c02", "2ff1da8ed1a5bc32" ] ] }, { "id": "f4cdf6d60a263c02", "type": "debug", "z": "2749496aa10f7c17", "name": "homee Name", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 120, "wires": [] }, { "id": "f76a02bd74f8832c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "UID Name", "topic": "0_userdata.0.System.homee.Cube1.Uid", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Uid", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 300, "wires": [] }, { "id": "2ff1da8ed1a5bc32", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "homee Name", "topic": "0_userdata.0.System.homee.Cube1.Name", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Name", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 180, "wires": [] }, { "id": "6eb4c1b40932e67c", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Firmeware", "topic": "0_userdata.0.System.homee.Cube1.Firmeware", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Firmeware", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1430, "y": 420, "wires": [] }, { "id": "5a98cc34ad5d369c", "type": "debug", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1720, "y": 720, "wires": [] }, { "id": "ef618bf5f21d53fc", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "topic": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.AnzahlCubes", "role": "", "payloadType": "number", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1720, "y": 780, "wires": [] }, { "id": "c3f282786a48e754", "type": "change", "z": "2749496aa10f7c17", "name": "Anzahl Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$count(payload)", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1460, "y": 780, "wires": [ [ "5a98cc34ad5d369c", "ef618bf5f21d53fc" ] ] }, { "id": "b6ce520fe699b5b4", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1430, "y": 720, "wires": [] }, { "id": "6fba09a1121470b2", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.type", "tot": "jsonata" }, { "t": "set", "p": "homee.settings", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 780, "wires": [ [ "b6ce520fe699b5b4", "c3f282786a48e754" ] ] }, { "id": "103dd420f1ae6f4f", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung über", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 480, "wires": [] }, { "id": "aaf4ea5be5e5d689", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung über", "topic": "0_userdata.0.System.homee.Cube1.Verbindung", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Verbindung", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 540, "wires": [] }, { "id": "fc927cb540b12985", "type": "function", "z": "2749496aa10f7c17", "name": "Verbindung über", "func": "var wlan = msg.payload.wlan_enabled\nvar lan = msg.payload.wlan_enabled\nvar verbindung = \"\";\n\nif (wlan == 1) {\n verbindung = \"Wlan\";\n} else if (lan == 1) {\n verbindung == \"Lan\";\n} else if (wlan == 0 && lan == 0) {\n verbindung = \"keine Verbindung\"\n}\n\nmsg.payload = verbindung;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 1220, "y": 540, "wires": [ [ "103dd420f1ae6f4f", "aaf4ea5be5e5d689" ] ] }, { "id": "9ea4d4898638727c", "type": "comment", "z": "2749496aa10f7c17", "name": "homee Settings", "info": "", "x": 140, "y": 80, "wires": [] }, { "id": "1e42f8900946d138", "type": "change", "z": "2749496aa10f7c17", "name": "Verbindung mit", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "payload.wlan_ssid", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1220, "y": 660, "wires": [ [ "a6f09f2bdda4dc43", "1504ff5a09d26392" ] ] }, { "id": "a6f09f2bdda4dc43", "type": "debug", "z": "2749496aa10f7c17", "name": "Verbindung mit", "active": false, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1440, "y": 600, "wires": [] }, { "id": "1504ff5a09d26392", "type": "ioBroker out", "z": "2749496aa10f7c17", "name": "Verbindung mit", "topic": "0_userdata.0.System.homee.Cube1.Netzwerk", "ack": "true", "autoCreate": "true", "stateName": "0_userdata.0.System.homee.Cube1.Netzwerk", "role": "", "payloadType": "string", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1440, "y": 660, "wires": [] }, { "id": "8a43345ef2a70be0", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "settings", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 480, "y": 760, "wires": [ [ "46a5350c5d867f97" ] ] }, { "id": "46a5350c5d867f97", "type": "change", "z": "2749496aa10f7c17", "d": true, "name": "hole alle homeegramme", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "{}", "tot": "json" }, { "t": "set", "p": "payload.settings", "pt": "msg", "to": "homee.settings", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 730, "y": 760, "wires": [ [ "053f961317aeb04b" ] ] }, { "id": "053f961317aeb04b", "type": "switch", "z": "2749496aa10f7c17", "d": true, "name": "Nur wenn Settings sich ändern", "property": "(\t payload.settings = settings\t)", "propertyType": "jsonata", "rules": [ { "t": "false" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 730, "y": 560, "wires": [ [ "3bb8ae97da664e72" ] ] }, { "id": "f1c83ffb994d87a7", "type": "switch", "z": "2749496aa10f7c17", "d": true, "name": "verify settings", "property": "payload.settings", "propertyType": "msg", "rules": [ { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 1, "x": 220, "y": 760, "wires": [ [ "8a43345ef2a70be0" ] ] }, { "id": "5f4368b7e682f493", "type": "link in", "z": "2749496aa10f7c17", "d": true, "name": "", "links": [ "d87f2174cf715cf2" ], "x": 75, "y": 760, "wires": [ [ "f1c83ffb994d87a7" ] ] }, { "id": "7455cb50e5c795a5", "type": "change", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":1,\"name\":\"Z-Wave\"},{\"id\":2,\"name\":\"ZigBee\"},{\"id\":3,\"name\":\"EnOcean\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.cubes.{\"name\" : $single($$.protocols, function($v){$v.id = type}).name, \t \"firmware\" : $exists(firmware) ? firmware : \"k.A.\" \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1240, "y": 880, "wires": [ [ "d5594ef7e61b1649" ] ] }, { "id": "d5594ef7e61b1649", "type": "debug", "z": "2749496aa10f7c17", "name": "Zusatzwürfel Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 1480, "y": 880, "wires": [] }, { "id": "bff3d9cc6b00b7ea", "type": "inject", "z": "2749496aa10f7c17", "name": "", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "{\"language\":\"de\",\"remote_access\":1,\"beta\":0,\"webhooks_key\":\"XXXXXXXXXXXX\",\"automatic_location_detection\":1,\"polling_interval\":60,\"enable_analytics\":0,\"homee_name\":\"XXXXXXXX\",\"b2b_partner\":\"homee\",\"country\":\"Deutschland\",\"country_code\":\"DE\",\"state\":\"XXX\",\"city\":\"XXXX\",\"latitude\":\"XXXXX\",\"longitude\":\"XXXXX\",\"zip\":\"XXXX\",\"address\":\"XXXXXX\",\"timezone\":\"Europe%2FBerlin\",\"last_automatic_location_detection\":1674998871,\"local_ssl_enabled\":true,\"wlan_enabled\":1,\"wlan_ip_address\":\"XXXXX\",\"wlan_ssid\":\"XXXXX\",\"wlan_mode\":2,\"internet_access\":true,\"lan_enabled\":0,\"available_ssids\":[\"XXXX,XXXX\"],\"time\":1678749606,\"civil_time\":\"2023-03-14 00:20:06\",\"version\":\"2.38.3+10a3a6dd\",\"uid\":\"XXXXX\",\"cubes\":[{\"protocol\":1,\"type\":1,\"order\":1,\"firmware\":\"3.95.0\",\"secure_add\":1,\"missing_nodes\":0,\"resettable\":true,\"heal\":true,\"device_exclude_supported\":true,\"device_reinitialize_supported\":true},{\"protocol\":3,\"type\":3,\"order\":2,\"resettable\":false},{\"protocol\":2,\"type\":2,\"order\":3,\"firmware\":\"2.6.3\",\"nw_channel\":12,\"resettable\":true}],\"extensions\":{\"weather\":{\"enabled\":1},\"amazon_alexa\":{\"enabled\":1},\"google_assistant\":{\"enabled\":0,\"syncing\":0},\"apple_homekit\":{\"configNumber\":1,\"enabled\":0,\"paired\":0,\"syncing\":0},\"ftp\":{\"enabled\":1,\"protocol\":0,\"hostname\":\"XXXXXX\",\"port\":\"XX\",\"username\":\"XXXX\",\"has_password\":1,\"path\":\"Public/homee/\",\"testing\":0},\"history\":{\"enabled\":1,\"destination\":1,\"folder\":\"Verlaufsdaten\"},\"backup\":{\"enabled\":1,\"destination\":1,\"folder\":\"Backup%2F\",\"manual_export\":0},\"proxy\":{\"enabled\":1,\"connected\":true,\"environment\":1},\"electricity_price\":{\"enabled\":0},\"ssh_tunnel\":{\"enabled\":false},\"notification\":{\"email_daily_count\":0,\"email_daily_limit\":50,\"email_monthly_count\":0,\"email_monthly_limit\":1550,\"email_next_daily_reset_date\":1678834800,\"email_next_monthly_reset_date\":1680300000,\"environment\":1},\"dropbox\":{\"enabled\":false},\"braindump\":{\"enabled\":false},\"watchdog\":{\"enabled\":true,\"run_period\":10000},\"mosquitto_mqtt\":{},\"name\":\"homee Oliver\"}}", "payloadType": "json", "x": 930, "y": 260, "wires": [ [ "35f2e60b460d3176" ] ] } ]Die meisten Nodes die Du aus dem anderen Flow kopiert hast, machen eh keinen Sinn.
-
@mickym
Vielen Dank, dass war keine Absicht, wollte nicht auch noch zusätzliche Arbeit machen, welche Nodes machen denn aus deiner Sicht keinen Sinn?@oli Na wenn du den Flow importiert hast, dann siehst ja (zumindest für die Zukunft, dass ich für die Analyse nur die Daten in einer Inject NOde brauche). Aber auch von dem Gesamtflow:
Gut hier weiss ich nicht
da Du das ausgeixt hast - ob der Name URL Zeichen enthielt.
Aber beim Aussschließen von Geräten kann man sich doch komplett sparen. Ich habe zumindest in dem ganzen settings Objekt KEINE Eigenschaft "id" entdeckt - also ist diese Node sinnlos.
EDIT: Berichtigung - Du kannst doch Objekte direkt miteinander vergleichen. Sorry. :( Also bei Dir alles OK. :) - war mein Fehler. Geht sogar alle Hierarchien durch. :)
Also das funktioniert:
Nochmals sorry. :(
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@mickym
ich bräuchte wieder mal deine UnterstützungWas habe ich vor?
- Auslesen der Logdatei
- Filtern nach "level", über einen Datenpunkt in ioBroker, Inhalt des Datenpunktes kann sein "any" für alle Logeinträge, "info", "error" und "warning"
- Nur eine gewisse Anzahl (max 30) an Einträgen nach dem Filtern anzeigen
- Diese Anzahl an Einträgen in einen Datenpunkt schreiben
- Flow ausführen, wenn sich der Filter-Datenpunkt ändert
Ich kann die Logdatei auslesen und in einen Tabelle schreiben, aber wie mache ich das mit dem Filtern und der Anzahl?
Hier mal der Flow:
[ { "id": "b86c034bc869f860", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": [] }, { "id": "bafe242abaf4e3e0", "type": "inject", "z": "b86c034bc869f860", "name": "", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "[{\"datetime\":\"2023-03-18 11:51:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:03\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:33\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:59\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.001 s error code: 8 error message: Connection timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.2472 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0002 s error code: 8 error message: Operation timed out after 15000 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:00:18\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:00:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:01:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:01:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:02:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:02:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:04:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:05:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:38\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:06:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" <resolve geolocation> response: timing: 50.0414 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 50.0297 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:11:13\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:11:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0151 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0122 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Wohnzimmer / Netatmo (nodeID:29) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> Netatmo Aussenraum (nodeID:30) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Büro / Netatmo (nodeID:31) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> DG / Schlafzimmer / Netatmo (nodeID:32) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0049 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:58\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:12:59\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0113 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:13:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Wohnzimmer / Netatmo (nodeID: 29) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> Netatmo Aussenraum (nodeID: 30) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Büro / Netatmo (nodeID: 31) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> DG / Schlafzimmer / Netatmo (nodeID: 32) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:00\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:26\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:56\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:16\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:37\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:11\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:32\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:43\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:25:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:38\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:25:39\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:25:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:55\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:21\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 30.2498 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 20.0186 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:33:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request failed (HTTP status code: 403): {\\\"error\\\":{\\\"code\\\":3,\\\"message\\\":\\\"Access token expired\\\"}}\"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"O_AUTH2_CLIENT\",\"level\":\"info\",\"message\":\" ✅ <refresh access> access successfully refreshed\"},{\"datetime\":\"2023-03-18 12:33:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0022 s error code: 8 error message: Operation timed out after 15001 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:35:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:54\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:48\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:42:17\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"}]", "payloadType": "json", "x": 190, "y": 140, "wires": [ [ "688bcd4b82f6fade" ] ] }, { "id": "ef455138a0ee4d91", "type": "debug", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 640, "y": 80, "wires": [] }, { "id": "fccb4af5d833ca96", "type": "json", "z": "b86c034bc869f860", "name": "Tabelle JSON", "property": "payload", "action": "str", "pretty": false, "x": 640, "y": 140, "wires": [ [] ] }, { "id": "688bcd4b82f6fade", "type": "change", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":\"error\",\"color\":\"red\"},{\"id\":\"warning\",\"color\":\"yellow\"},{\"id\":\"info\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\t \"datetime\" : datetime,\t \"topic\" : topic,\t \"level\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = level}).color & '\\\"> ' & level, \t \"message\" : message \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 420, "y": 140, "wires": [ [ "fccb4af5d833ca96", "ef455138a0ee4d91" ] ] }, { "id": "0b4c7d376b9e7a79", "type": "ioBroker in", "z": "b86c034bc869f860", "name": "Logfile Auswahl Filter", "topic": "0_userdata.0.System.homee.Logfile.AuswahlFilter", "payloadType": "value", "onlyack": "", "func": "all", "gap": "", "fireOnStart": "false", "outFormat": "MQTT", "x": 180, "y": 280, "wires": [ [] ] } ]Gruß
Oliver -
@mickym
ich bräuchte wieder mal deine UnterstützungWas habe ich vor?
- Auslesen der Logdatei
- Filtern nach "level", über einen Datenpunkt in ioBroker, Inhalt des Datenpunktes kann sein "any" für alle Logeinträge, "info", "error" und "warning"
- Nur eine gewisse Anzahl (max 30) an Einträgen nach dem Filtern anzeigen
- Diese Anzahl an Einträgen in einen Datenpunkt schreiben
- Flow ausführen, wenn sich der Filter-Datenpunkt ändert
Ich kann die Logdatei auslesen und in einen Tabelle schreiben, aber wie mache ich das mit dem Filtern und der Anzahl?
Hier mal der Flow:
[ { "id": "b86c034bc869f860", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": [] }, { "id": "bafe242abaf4e3e0", "type": "inject", "z": "b86c034bc869f860", "name": "", "props": [ { "p": "payload" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "[{\"datetime\":\"2023-03-18 11:51:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:03\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:33\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:59\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.001 s error code: 8 error message: Connection timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.2472 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0002 s error code: 8 error message: Operation timed out after 15000 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:00:18\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:00:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:01:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:01:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:02:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:02:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:04:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:05:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:38\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:06:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" <resolve geolocation> response: timing: 50.0414 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 50.0297 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:11:13\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:11:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0151 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0122 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Wohnzimmer / Netatmo (nodeID:29) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> Netatmo Aussenraum (nodeID:30) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Büro / Netatmo (nodeID:31) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> DG / Schlafzimmer / Netatmo (nodeID:32) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0049 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:58\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:12:59\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0113 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:13:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Wohnzimmer / Netatmo (nodeID: 29) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> Netatmo Aussenraum (nodeID: 30) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Büro / Netatmo (nodeID: 31) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> DG / Schlafzimmer / Netatmo (nodeID: 32) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:00\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:26\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:56\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:16\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:37\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:11\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:32\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:43\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:25:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:38\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:25:39\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:25:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:55\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:21\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 30.2498 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 20.0186 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:33:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request failed (HTTP status code: 403): {\\\"error\\\":{\\\"code\\\":3,\\\"message\\\":\\\"Access token expired\\\"}}\"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"O_AUTH2_CLIENT\",\"level\":\"info\",\"message\":\" ✅ <refresh access> access successfully refreshed\"},{\"datetime\":\"2023-03-18 12:33:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0022 s error code: 8 error message: Operation timed out after 15001 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:35:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:54\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:48\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:42:17\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"}]", "payloadType": "json", "x": 190, "y": 140, "wires": [ [ "688bcd4b82f6fade" ] ] }, { "id": "ef455138a0ee4d91", "type": "debug", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 640, "y": 80, "wires": [] }, { "id": "fccb4af5d833ca96", "type": "json", "z": "b86c034bc869f860", "name": "Tabelle JSON", "property": "payload", "action": "str", "pretty": false, "x": 640, "y": 140, "wires": [ [] ] }, { "id": "688bcd4b82f6fade", "type": "change", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":\"error\",\"color\":\"red\"},{\"id\":\"warning\",\"color\":\"yellow\"},{\"id\":\"info\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\t \"datetime\" : datetime,\t \"topic\" : topic,\t \"level\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = level}).color & '\\\"> ' & level, \t \"message\" : message \t}", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 420, "y": 140, "wires": [ [ "fccb4af5d833ca96", "ef455138a0ee4d91" ] ] }, { "id": "0b4c7d376b9e7a79", "type": "ioBroker in", "z": "b86c034bc869f860", "name": "Logfile Auswahl Filter", "topic": "0_userdata.0.System.homee.Logfile.AuswahlFilter", "payloadType": "value", "onlyack": "", "func": "all", "gap": "", "fireOnStart": "false", "outFormat": "MQTT", "x": 180, "y": 280, "wires": [ [] ] } ]@oli Nun zum Einen musst Du mal aufhören die HTML Formatierungen da rein zu machen, wenn Du mit den Daten arbeiten willst. Das ist halt ein Manko dieses Tabellen Widgets - aber man muss ja nicht alle Spalten anzeigen. Man kann das zwar wieder mit $contains machen - aber ich rate Dir einfach wenn Du nach severity filtern willst, dass Du eine extra Spalte level machst und dann noch eine mit der Du dann mit Deiner Formatierung arbeitest. Also ich hab mal ein level ohne Formatierung angelegt - wie gesagt solange Du hier immer HTML Formatierungen mitschleppen musst, würde ich halt unterschiedliche Spalten machen:
Anzeigen kannst Du dann level_d anstatt level - aber mit level wird gefiltert.
Oder alternativ - Du machst halt die Formatierung immer zum Schluss. Habe ich mal als Deine präferierte Lösung angenommen.
Wichtig ist, dass wenn Du die Anzahl begrenzen willst, ja wohl die neuesten Logeinträge sehen willst, deshalb habe ich mal absteigend nach datetime sortiert.
Das Auslesen der Logdatei habe ich mal in die Eigenschaft msg.log gemacht, somit ist die payload der Filter bzw. das level
[ { "id": "ab66ad002a717f0c", "type": "change", "z": "b86c034bc869f860", "name": "Log-Datei auslesen", "rules": [ { "t": "set", "p": "log", "pt": "msg", "to": "[{\"datetime\":\"2023-03-18 11:51:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:03\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:33\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:59\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.001 s error code: 8 error message: Connection timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.2472 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0002 s error code: 8 error message: Operation timed out after 15000 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:00:18\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:00:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:01:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:01:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:02:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:02:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:04:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:05:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:38\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:06:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" <resolve geolocation> response: timing: 50.0414 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 50.0297 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:11:13\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:11:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0151 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0122 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Wohnzimmer / Netatmo (nodeID:29) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> Netatmo Aussenraum (nodeID:30) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Büro / Netatmo (nodeID:31) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> DG / Schlafzimmer / Netatmo (nodeID:32) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0049 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:58\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:12:59\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0113 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:13:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Wohnzimmer / Netatmo (nodeID: 29) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> Netatmo Aussenraum (nodeID: 30) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Büro / Netatmo (nodeID: 31) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> DG / Schlafzimmer / Netatmo (nodeID: 32) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:00\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:26\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:56\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:16\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:37\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:11\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:32\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:43\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:25:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:38\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:25:39\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:25:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:55\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:21\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 30.2498 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 20.0186 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:33:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request failed (HTTP status code: 403): {\\\"error\\\":{\\\"code\\\":3,\\\"message\\\":\\\"Access token expired\\\"}}\"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"O_AUTH2_CLIENT\",\"level\":\"info\",\"message\":\" ✅ <refresh access> access successfully refreshed\"},{\"datetime\":\"2023-03-18 12:33:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0022 s error code: 8 error message: Operation timed out after 15001 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:35:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:54\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:48\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:42:17\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"}]", "tot": "json" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 410, "y": 280, "wires": [ [ "a0d3511f1e97b4cb" ] ] }, { "id": "1d94278206c3c1dc", "type": "change", "z": "b86c034bc869f860", "name": "Formatiere Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":\"error\",\"color\":\"red\"},{\"id\":\"warning\",\"color\":\"yellow\"},{\"id\":\"info\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\t \"datetime\" : datetime,\t \"topic\" : topic,\t \"level\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = level}).color & '\\\"> ' & level, \t \"message\" : message \t}", "tot": "jsonata" }, { "t": "delete", "p": "log", "pt": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 280, "wires": [ [ "893c55a574142a24", "8693a1915866b8d6" ] ] }, { "id": "893c55a574142a24", "type": "debug", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "true", "targetType": "full", "statusVal": "", "statusType": "auto", "x": 1420, "y": 240, "wires": [] }, { "id": "2468b33cf89e3660", "type": "switch", "z": "b86c034bc869f860", "name": "Filtern?", "property": "payload", "propertyType": "msg", "rules": [ { "t": "regex", "v": "error|warning|info", "vt": "str", "case": false }, { "t": "else" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 820, "y": 280, "wires": [ [ "768f74e270b64a67" ], [ "92546bb5880315fa" ] ] }, { "id": "a0d3511f1e97b4cb", "type": "change", "z": "b86c034bc869f860", "name": "Max = Anzahl - 1", "rules": [ { "t": "set", "p": "max", "pt": "msg", "to": "4", "tot": "num" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 630, "y": 280, "wires": [ [ "2468b33cf89e3660" ] ] }, { "id": "768f74e270b64a67", "type": "change", "z": "b86c034bc869f860", "name": "mit Filter", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "log[level=$$.payload]^(> datetime )[[0..$$.max]]", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 980, "y": 240, "wires": [ [ "1d94278206c3c1dc" ] ] }, { "id": "92546bb5880315fa", "type": "change", "z": "b86c034bc869f860", "name": "ohne Filter", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "log^(> datetime )[[0..$$.max]]", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 990, "y": 320, "wires": [ [ "1d94278206c3c1dc" ] ] }, { "id": "8693a1915866b8d6", "type": "json", "z": "b86c034bc869f860", "name": "Tabelle JSON", "property": "payload", "action": "str", "pretty": false, "x": 1420, "y": 280, "wires": [ [] ] } ]Du kannst in die Switch Node - die prüft ob gefiltert werden soll oder nicht für den 2. Ausgang auch "any" reinschreiben. Ich hab halt einfach gemacht, dass wenn es nicht error, warning oder info ist, dann wird nicht gefiltert.
EDIT: Flow nochmal zum Import editiert (12:06)
Jeder Flow bzw. jedes Script, das ich hier poste implementiert jeder auf eigene Gefahr. Flows und Scripts können Fehler aufweisen und weder der Seitenbetreiber noch ich persönlich können hierfür haftbar gemacht werden. Das gleiche gilt für Empfehlungen aller Art.
-
@oli Nun zum Einen musst Du mal aufhören die HTML Formatierungen da rein zu machen, wenn Du mit den Daten arbeiten willst. Das ist halt ein Manko dieses Tabellen Widgets - aber man muss ja nicht alle Spalten anzeigen. Man kann das zwar wieder mit $contains machen - aber ich rate Dir einfach wenn Du nach severity filtern willst, dass Du eine extra Spalte level machst und dann noch eine mit der Du dann mit Deiner Formatierung arbeitest. Also ich hab mal ein level ohne Formatierung angelegt - wie gesagt solange Du hier immer HTML Formatierungen mitschleppen musst, würde ich halt unterschiedliche Spalten machen:
Anzeigen kannst Du dann level_d anstatt level - aber mit level wird gefiltert.
Oder alternativ - Du machst halt die Formatierung immer zum Schluss. Habe ich mal als Deine präferierte Lösung angenommen.
Wichtig ist, dass wenn Du die Anzahl begrenzen willst, ja wohl die neuesten Logeinträge sehen willst, deshalb habe ich mal absteigend nach datetime sortiert.
Das Auslesen der Logdatei habe ich mal in die Eigenschaft msg.log gemacht, somit ist die payload der Filter bzw. das level
[ { "id": "ab66ad002a717f0c", "type": "change", "z": "b86c034bc869f860", "name": "Log-Datei auslesen", "rules": [ { "t": "set", "p": "log", "pt": "msg", "to": "[{\"datetime\":\"2023-03-18 11:51:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:52:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:53:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:54:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:03\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:55:46\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:56:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:33\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:57:59\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.001 s error code: 8 error message: Connection timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:58:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.2472 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 11:59:10\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 11:59:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0002 s error code: 8 error message: Operation timed out after 15000 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:00:08\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:00:18\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:00:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:00:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:13\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:01:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:01:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:01:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:02:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:02:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:04:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:05:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:18\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:06:19\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:06:38\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:06:51\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" <resolve geolocation> response: timing: 50.0414 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:08:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 50.0297 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:10:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:11:13\",\"topic\":\"WEB\",\"level\":\"error\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:11:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0151 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0122 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Wohnzimmer / Netatmo (nodeID:29) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> Netatmo Aussenraum (nodeID:30) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> EG / Büro / Netatmo (nodeID:31) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:12:22\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set unavailable> DG / Schlafzimmer / Netatmo (nodeID:32) | reason refreshAttributes\"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0049 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:12:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request timed out\"},{\"datetime\":\"2023-03-18 12:12:58\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:12:59\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <netatmo cpr get> response: timing: 15.0113 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get camera data> request timed out\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 29 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 30 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 31 unavailable\"},{\"datetime\":\"2023-03-18 12:13:02\",\"topic\":\"NETATMO\",\"level\":\"info\",\"message\":\" <refresh attributes> device not in map - set nodeID: 32 unavailable\"},{\"datetime\":\"2023-03-18 12:13:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Wohnzimmer / Netatmo (nodeID: 29) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> Netatmo Aussenraum (nodeID: 30) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> EG / Büro / Netatmo (nodeID: 31) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:36\",\"topic\":\"HAL\",\"level\":\"info\",\"message\":\" <set available> DG / Schlafzimmer / Netatmo (nodeID: 32) | reason refresh ok\"},{\"datetime\":\"2023-03-18 12:13:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:30\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:14:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:15:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:00\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:16:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:05\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:26\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:17:47\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:18:56\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:16\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:37\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:19:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:20:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:24\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:21:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:11\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:32\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:22:53\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:23:39\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:01\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:22\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:43\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:24:58\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" ⚠️ <homee proxy> no connection\"},{\"datetime\":\"2023-03-18 12:25:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:25\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:25:38\",\"topic\":\"MAIN\",\"level\":\"info\",\"message\":\" 📡 <homee proxy> connection established 👌\"},{\"datetime\":\"2023-03-18 12:25:39\",\"topic\":\"MAIN\",\"level\":\"warning\",\"message\":\" <system call> command: \\\"/etc/init.d/S49chrony restart\\\" exited with code: 1\"},{\"datetime\":\"2023-03-18 12:25:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:26:41\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:27:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:07\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:29\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:28:50\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:12\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:34\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:29:55\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:21\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:30:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:04\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:31:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 30.2498 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:18\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 20.0186 s error code: 8 error message: Resolving timed out after 15000 milliseconds http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:32:58\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:33:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <netatmo get weather station data> request failed (HTTP status code: 403): {\\\"error\\\":{\\\"code\\\":3,\\\"message\\\":\\\"Access token expired\\\"}}\"},{\"datetime\":\"2023-03-18 12:33:40\",\"topic\":\"O_AUTH2_CLIENT\",\"level\":\"info\",\"message\":\" ✅ <refresh access> access successfully refreshed\"},{\"datetime\":\"2023-03-18 12:33:44\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:09\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:34:31\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" <resolve geolocation> response: timing: 15.0022 s error code: 8 error message: Operation timed out after 15001 milliseconds with 0 bytes received http status code: 0 body: \"},{\"datetime\":\"2023-03-18 12:35:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 0): \"},{\"datetime\":\"2023-03-18 12:35:28\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:35:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:14\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:36:49\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:20\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:37:42\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:02\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:38:54\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:15\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:39:52\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:23\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:40:45\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:06\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:27\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:41:48\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"},{\"datetime\":\"2023-03-18 12:42:17\",\"topic\":\"WEB\",\"level\":\"warning\",\"message\":\" ⚠️ <resolve geolocation> request failed (HTTP status code: 429): \"}]", "tot": "json" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 410, "y": 280, "wires": [ [ "a0d3511f1e97b4cb" ] ] }, { "id": "1d94278206c3c1dc", "type": "change", "z": "b86c034bc869f860", "name": "Formatiere Tabelle", "rules": [ { "t": "set", "p": "protocols", "pt": "msg", "to": "[{\"id\":\"error\",\"color\":\"red\"},{\"id\":\"warning\",\"color\":\"yellow\"},{\"id\":\"info\",\"color\":\"#8f8f8f\"}]", "tot": "json" }, { "t": "set", "p": "payload", "pt": "msg", "to": "payload.{\t \"datetime\" : datetime,\t \"topic\" : topic,\t \"level\" : ' <font color=\\\"' & $single($$.protocols, function($v){$v.id = level}).color & '\\\"> ' & level, \t \"message\" : message \t}", "tot": "jsonata" }, { "t": "delete", "p": "log", "pt": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1210, "y": 280, "wires": [ [ "893c55a574142a24", "8693a1915866b8d6" ] ] }, { "id": "893c55a574142a24", "type": "debug", "z": "b86c034bc869f860", "name": "Logfile Tabelle", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "true", "targetType": "full", "statusVal": "", "statusType": "auto", "x": 1420, "y": 240, "wires": [] }, { "id": "2468b33cf89e3660", "type": "switch", "z": "b86c034bc869f860", "name": "Filtern?", "property": "payload", "propertyType": "msg", "rules": [ { "t": "regex", "v": "error|warning|info", "vt": "str", "case": false }, { "t": "else" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 820, "y": 280, "wires": [ [ "768f74e270b64a67" ], [ "92546bb5880315fa" ] ] }, { "id": "a0d3511f1e97b4cb", "type": "change", "z": "b86c034bc869f860", "name": "Max = Anzahl - 1", "rules": [ { "t": "set", "p": "max", "pt": "msg", "to": "4", "tot": "num" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 630, "y": 280, "wires": [ [ "2468b33cf89e3660" ] ] }, { "id": "768f74e270b64a67", "type": "change", "z": "b86c034bc869f860", "name": "mit Filter", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "log[level=$$.payload]^(> datetime )[[0..$$.max]]", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 980, "y": 240, "wires": [ [ "1d94278206c3c1dc" ] ] }, { "id": "92546bb5880315fa", "type": "change", "z": "b86c034bc869f860", "name": "ohne Filter", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "log^(> datetime )[[0..$$.max]]", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 990, "y": 320, "wires": [ [ "1d94278206c3c1dc" ] ] }, { "id": "8693a1915866b8d6", "type": "json", "z": "b86c034bc869f860", "name": "Tabelle JSON", "property": "payload", "action": "str", "pretty": false, "x": 1420, "y": 280, "wires": [ [] ] } ]Du kannst in die Switch Node - die prüft ob gefiltert werden soll oder nicht für den 2. Ausgang auch "any" reinschreiben. Ich hab halt einfach gemacht, dass wenn es nicht error, warning oder info ist, dann wird nicht gefiltert.
EDIT: Flow nochmal zum Import editiert (12:06)
vielen Dank für deine Hilfe, dein Flow funktioniert super und das Problem sitzt wieder mal hier vor der Tastatur.
Ich habe meinen Flow jetzt so verkabelt, ich hoffe das passt erstmal so?
Mir ist aufgefallen, dass es 2 - 3 Sekunden dauern kann, bis die aktuelle Log Datei abgerufen ist und deshalb bleibt wahrscheinlich auch meine Tabelle leer, kann man das irgendwie synchronisieren?
Wie kann ich dem Flow beibringen, dass egal wodurch er gestartet wird, er sich immer den Filter aus dem Datenpunkt holt?
Gruß
Oliver
Support us
751
Online32.5k
Benutzer81.8k
Themen1.3m
Beiträge
ioBroker Community 2014-2025
