Gelöst: Wert in dynamische Struktur im ioBroker ablegen
-
@mickym
Ich habe hier noch einen Fehler im Flow. Ich habe nun die dynamische Datumsablage hinzugefügt und den iobroker out entsprechend geändert. Der Datenpunkt wird auch angelegt, aber als "number" und nicht als Array (mit [Wert1, Wert2,...].
[ { "id": "ae673cf6cd8433a0", "type": "subflow", "name": "Datum in Topic", "info": "", "category": "", "in": [ { "x": 60, "y": 80, "wires": [ { "id": "2e1ea06b2e94bf1a" } ] } ], "out": [ { "x": 820, "y": 80, "wires": [ { "id": "fc37f5f9d2b0297b", "port": 0 } ] } ], "env": [ { "name": "basePath", "type": "str", "value": "Test1.Test2" } ], "meta": {}, "color": "#DDAA99" }, { "id": "2e1ea06b2e94bf1a", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "datum", "pt": "msg", "to": "$moment().locale('de').format('YYYY.MMMM')", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 230, "y": 80, "wires": [ [ "0e8de9437c3c420a" ] ] }, { "id": "0e8de9437c3c420a", "type": "change", "z": "ae673cf6cd8433a0", "name": "März zu Maerz", "rules": [ { "t": "change", "p": "datum", "pt": "msg", "from": "März", "fromt": "str", "to": "Maerz", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 440, "y": 80, "wires": [ [ "fc37f5f9d2b0297b" ] ] }, { "id": "fc37f5f9d2b0297b", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "\"0_userdata.0.\" & $env(\"basePath\") & \".\" & datum & \".\" & topic", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 660, "y": 80, "wires": [ [] ] }, { "id": "1d93ae2f970605e5", "type": "debug", "z": "5c488c180ba51f18", "name": "debug 184", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 1050, "y": 180, "wires": [] }, { "id": "e700e5e9b292c820", "type": "ioBroker out", "z": "5c488c180ba51f18", "name": "", "topic": "", "ack": "true", "autoCreate": "true", "stateName": "", "role": "", "payloadType": "", "readonly": "false", "stateUnit": "", "stateMin": "", "stateMax": "", "x": 1060, "y": 120, "wires": [] }, { "id": "5e8ce599dad4fa74", "type": "subflow:ae673cf6cd8433a0", "z": "5c488c180ba51f18", "name": "", "env": [ { "name": "basePath", "value": "Test1.Test5.MonatsTabellen", "type": "str" } ], "x": 860, "y": 40, "wires": [ [ "e700e5e9b292c820", "1d93ae2f970605e5" ] ] }, { "id": "ff519a511afeb6f1", "type": "change", "z": "5c488c180ba51f18", "name": "", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$append(array-bezug, payload)", "tot": "jsonata" }, { "t": "set", "p": "array-bezug", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 670, "y": 40, "wires": [ [ "5e8ce599dad4fa74" ] ] }, { "id": "c617a78f8ddaca22", "type": "change", "z": "5c488c180ba51f18", "name": "Vorhandenes Array", "rules": [ { "t": "set", "p": "array-bezug", "pt": "msg", "to": "array-bezug", "tot": "flow" }, { "t": "set", "p": "array-bezug", "pt": "msg", "to": "array-bezug ? array-bezug : []", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 450, "y": 40, "wires": [ [ "ff519a511afeb6f1" ] ] }, { "id": "53d6131492b2abed", "type": "change", "z": "5c488c180ba51f18", "name": "Bezug", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "Strombezug", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 270, "y": 40, "wires": [ [ "c617a78f8ddaca22" ] ] }, { "id": "5bbdcd58332d0b96", "type": "ioBroker in", "z": "5c488c180ba51f18", "name": "Bezug täglich", "attrname": "payload", "topic": "0_userdata.0.Zaehler.Strombezug.Verbrauch.täglich", "payloadType": "value", "onlyack": "", "func": "all", "gap": "", "fireOnStart": "true", "outFormat": "MQTT", "x": 110, "y": 40, "wires": [ [ "53d6131492b2abed" ] ] } ] -
@martybr Also - ich habe nun gerade Deinen Flow importiert. Wäre übrigens auch gut, wenn Du mir eine Inject Node zur Simulation dran machen würdest, da ich ja in der Regel nicht deine Datenpunkte habe.
Dann machst Du einen gravierenden Fehler, wenn Du in JSONATA meinst, du kannst "array-bezug" schreiben. Dann versucht JSONATA von einer Nachrichteneigenschaft "array" den Betrag der Nachrichteneigenschaft "bezug" zu subtrahieren, was natürlich beides nicht definiert bzw. exisitiert.
Ich habe also in Deinem ganzen Flow - "array-bezug" durch "array_bezug" ersetzt.Dann haben wir doch besprochen, dass der iobroker KEINE Objekte bearbeiten kann. Also müssen wir bevor wir einen Datenpunkt beschreiben, diesen erst in einen String umwandeln.
Also lösche Deinen Datenpunkt nochmals und setze eine JSON Node vor die iobroker-Out Node, so wie besprochen.
Und zuletzt - speicherst Du zwar direkt in die Flow variable - aber Du wolltest doch persistent machen und Du liest ja nirgend Dein Array aus dem iobroker wieder ein?
Also hören wir doch mal auf, das Ergebnis - also das neue Array direkt abzuspeichern:
So nun muss man also wieder was aus dem Datenpunkt einlesen, den man in iobroker geschrieben hat. das ist aber kompliziert, da der Datenpunkt ja dynamisch sich dauernd ändert. Ich überlege mir mal was.
Inzwischen kannst Du Dir ja den modifizierten Flow - als Basis schon mal abspeichern - dann auf der Basis machen wir weiter.
=============================================================
Ich denke, ich muss den ganzen Flow etwas umstellen, damit es auch einigermaßen effizient wird. Also vergiß Deinen/Meinen bisherigen Flow.
-
@mickym
Konntest du dir den Flow zur Monatslänge (von 9:48 Uhr) mal anschauen? Ich habe da eine globale Variable "Monatstage" definiert. -
@martybr Warum das nun wieder - ich habe den Flow nun fertig und wenn der Monat wechselt wird automatisch ein neuer Datenpunkt durch Deinen Subflow angelegt und auch eingelesen.
Nein Sorry - Du hast Recht, wenn sich das Topic ändert, dann muss die Flowvariable noch gelöscht werden. Habe ich vergessen.
-
@mickym
Vielleicht irre ich mich auch. Ich habe von einem lieben Bekannten ein JavaScript, welches über die Werte iteriert. Hier werden die Zahl der Tage im Monat benötigt. Ich versuche hier mit deiner Hilfe Node-Red zu verstehen, da mich Javascript nicht angesprochen hat. Da gibt es mit async etc. genügend Fallstricke.
Daher kommen manche meiner Fragen, die für die bestimmt selbstverständlich sind. Ich fange ja gerade erst mit Node-Red an. Das Buch das ich mir gekauft habe war nicht so toll.
Einges habe ich schon in Node-Red umsetzen können:
Meine Bewegungsmelder mit Zeitsteuerung und Sperre bei manuellem Auslösen und mit deiner Hilfe die Speicherung von Strombezug und Einspeisung.
Ich konnte mit den Flows das ganze und weitere Anwendungen umsetzen, z.B. Wasserverbrauch, Gartenwasser, Solareinspeisung. Dadurch habe ich das Potential von Node-Red erkannt. Nun habe ich Zeit und versuche mich tiefer einzuarbeiten
-
@martybr Ja ich schau mir das gleich an -
Aber zu deinem Flow mit den dynamischen Monatsarrays habe ich eine andere Lösung, da brauchst du die Zahl nicht. Sprich wenn sich das topic ändert, dann wird die bisherige flow Variable gelöscht und eine neue erstellt. Schau Dir erst mal den neuen Flow an:
und schau, ob Du den verstehst. Ansonsten schaun ich mir Deinen Flow gerne an - aber ich verstehe immer nicht, warum mit JS in NodeRed arbeitet - ich rate Dir immer, die function Nodes wenn möglich immer zu meiden. Für Deine dynamischen Datenpunkte solltest Du es nicht brauchen. Ich habe übrigens mal einen Flow gemacht, den Du Dir auch mal anschauen solltest.
-
@martybr sagte in Wert in dynamische Struktur im ioBroker ablegen:
@mickym
Ich habe hier noch ein Problem, die Zahl der Tage im Monat in eine globale Variable zu schreiben. Statt der 28 Tage aus der Funktion liefert mir der Change Node nur payload == 5
[ { "id": "f6ed836d74798c7f", "type": "inject", "z": "3ebdbbcf49e0ac40", "name": "", "props": [ { "p": "payload" }, { "p": "topic", "vt": "str" } ], "repeat": "", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "", "payloadType": "date", "x": 100, "y": 400, "wires": [ [ "a3434007e702fcdc" ] ] }, { "id": "7a09df47bef16411", "type": "function", "z": "3ebdbbcf49e0ac40", "name": "function 1", "func": "// Eingabe: msg.payload sollte ein Datum im Format 'YYYY-MM-DD' sein\nlet inputDate = new Date(msg.payload);\n\n// Hole den Monat und das Jahr\nlet month = inputDate.getMonth(); // 0-11\nlet year = inputDate.getFullYear();\n\n// Berechne die Anzahl der Tage im Monat\nlet daysInMonth = new Date(year, month + 1, 0).getDate();\n\n// Setze das Ergebnis in msg.payload\nmsg.payload = daysInMonth;\n\nreturn msg;", "outputs": 1, "timeout": 0, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 480, "y": 400, "wires": [ [ "599b66169127c12d", "185c42081279a5e0" ] ] }, { "id": "a3434007e702fcdc", "type": "change", "z": "3ebdbbcf49e0ac40", "name": "", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$moment().locale('de').format('YYYY.MM.DD')", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 290, "y": 400, "wires": [ [ "7a09df47bef16411" ] ] }, { "id": "d8d647f4ae028cb8", "type": "debug", "z": "3ebdbbcf49e0ac40", "name": "debug 182", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 670, "y": 320, "wires": [] }, { "id": "599b66169127c12d", "type": "change", "z": "3ebdbbcf49e0ac40", "name": "Monatstage", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "monatstage", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 650, "y": 400, "wires": [ [ "d8d647f4ae028cb8" ] ] }, { "id": "185c42081279a5e0", "type": "debug", "z": "3ebdbbcf49e0ac40", "name": "debug 183", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 590, "y": 480, "wires": [] } ]Das kann ich leider nicht nachvollziehen, bei mir funktioniert der Flow einwandfrei:
Ich schau trotzdem mal kurz, ob man das mit $moments direkt erledigen kann.
-
@mickym
Stimmt, bei mir liefert er nun die richtige Anzahl der Tage. -
@martybr sagte in Wert in dynamische Struktur im ioBroker ablegen:
@mickym
Stimmt, bei mir liefert er nun die richtige Anzahl der Tage.Ok - dann passt ja alles - ich bin dann erst mal weg - schau dann am Abend nochmal vorbei. Schau Dir mal den neuen Flow - für Deine Arrays und dynam. Datenpunkte derweil an.
-
@mickym
Es sieht alles gut aus. Ich werde mir das genau anschauen und danke dir für deine Hilfe. -
Ich habe den Flow für die Mittelwertbildung auf den Node aggregate umgestellt.
Die Delays dienen der richtigen Reihenfolge der drei Werte min, mean und max im Json. Das ganze wird in einem fortlaufenden Array unter Jahr.Monat abgelegt.Hier der Flow, der zumindest bei mir ohne Fehler erfolgreich läuft.
[ { "id": "ae673cf6cd8433a0", "type": "subflow", "name": "Datum in Topic", "info": "", "category": "", "in": [ { "x": 60, "y": 80, "wires": [ { "id": "2e1ea06b2e94bf1a" } ] } ], "out": [ { "x": 820, "y": 80, "wires": [ { "id": "fc37f5f9d2b0297b", "port": 0 } ] } ], "env": [ { "name": "basePath", "type": "str", "value": "Test1.Test2" } ], "meta": {}, "color": "#DDAA99" }, { "id": "2e1ea06b2e94bf1a", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "datum", "pt": "msg", "to": "$moment().locale('de').format('YYYY.MMMM')", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 230, "y": 80, "wires": [ [ "0e8de9437c3c420a" ] ] }, { "id": "0e8de9437c3c420a", "type": "change", "z": "ae673cf6cd8433a0", "name": "März zu Maerz", "rules": [ { "t": "change", "p": "datum", "pt": "msg", "from": "März", "fromt": "str", "to": "Maerz", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 440, "y": 80, "wires": [ [ "fc37f5f9d2b0297b" ] ] }, { "id": "fc37f5f9d2b0297b", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "\"0_userdata.0.\" & $env(\"basePath\") & \".\" & datum & \".\" & topic", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 660, "y": 80, "wires": [ [] ] }, { "id": "8c459eb88d1bf5f1", "type": "tab", "label": "Mittelwert", "disabled": false, "info": "", "env": [] }, { "id": "9b11db08a1cca5b3", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Mean", "topic": "mean", "intervalCount": "1", "intervalUnits": "d", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "mean", "x": 290, "y": 260, "wires": [ [ "0290eb1787934b73" ] ] }, { "id": "f33e1d253e22a2dd", "type": "ioBroker in", "z": "8c459eb88d1bf5f1", "name": "Aussentemperatur", "attrname": "payload", "topic": "mqtt.0.vitocal.outside_temperature", "payloadType": "value", "onlyack": "", "func": "all", "gap": "", "fireOnStart": "false", "outFormat": "MQTT", "x": 110, "y": 260, "wires": [ [ "5a18bba8160e8e94", "9b11db08a1cca5b3", "32753fd69085ce71" ] ] }, { "id": "5a18bba8160e8e94", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Min", "topic": "min", "intervalCount": "1", "intervalUnits": "d", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "min", "x": 290, "y": 200, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "32753fd69085ce71", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Max", "topic": "max", "intervalCount": "1", "intervalUnits": "d", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "max", "x": 290, "y": 320, "wires": [ [ "7a8c3b56e65b5059" ] ] }, { "id": "15a56c790ce29f8d", "type": "join", "z": "8c459eb88d1bf5f1", "name": "", "mode": "custom", "build": "object", "property": "payload", "propertyType": "msg", "key": "topic", "joiner": "\\n", "joinerType": "str", "accumulate": true, "timeout": "60", "count": "3", "reduceRight": false, "reduceExp": "", "reduceInit": "", "reduceInitType": "", "reduceFixup": "", "x": 670, "y": 200, "wires": [ [ "8ef8ee85844f2bb2" ] ] }, { "id": "8ef8ee85844f2bb2", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "meanTmp", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 840, "y": 200, "wires": [ [ "5d3e4f7dea0efe7c" ] ] }, { "id": "5d3e4f7dea0efe7c", "type": "subflow:ae673cf6cd8433a0", "z": "8c459eb88d1bf5f1", "name": "Datum in Topic", "env": [ { "name": "basePath", "value": "Heizung1.MonatsTabellen", "type": "str" } ], "x": 1040, "y": 200, "wires": [ [ "9aa634789fccf445" ] ] }, { "id": "e44c746b92947c39", "type": "ioBroker out", "z": "8c459eb88d1bf5f1", "name": "", "topic": "", "ack": "true", "autoCreate": "true", "stateName": "", "role": "", "payloadType": "", "readonly": "false", "stateUnit": "°C", "stateMin": "", "stateMax": "", "x": 2920, "y": 280, "wires": [] }, { "id": "0290eb1787934b73", "type": "delay", "z": "8c459eb88d1bf5f1", "name": "", "pauseType": "delay", "timeout": "5", "timeoutUnits": "seconds", "rate": "1", "nbRateUnits": "1", "rateUnits": "second", "randomFirst": "1", "randomLast": "5", "randomUnits": "seconds", "drop": false, "allowrate": false, "outputs": 1, "x": 460, "y": 260, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "7a8c3b56e65b5059", "type": "delay", "z": "8c459eb88d1bf5f1", "name": "", "pauseType": "delay", "timeout": "10", "timeoutUnits": "seconds", "rate": "1", "nbRateUnits": "1", "rateUnits": "second", "randomFirst": "1", "randomLast": "5", "randomUnits": "seconds", "drop": false, "allowrate": false, "outputs": 1, "x": 470, "y": 320, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "9aa634789fccf445", "type": "switch", "z": "8c459eb88d1bf5f1", "name": "topic geändert?", "property": "topic", "propertyType": "msg", "rules": [ { "t": "neq", "v": "", "vt": "prev" }, { "t": "eq", "v": "", "vt": "prev" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 1240, "y": 200, "wires": [ [ "c7fa49ea854690ed" ], [ "edaece611a7db6d5" ] ] }, { "id": "c7fa49ea854690ed", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload sichern und flow var löschen", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "payload_bak_mean", "tot": "msg" }, { "t": "delete", "p": "array_mean", "pt": "flow" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1530, "y": 180, "wires": [ [ "7fd2bba1daf6d9f3" ] ] }, { "id": "edaece611a7db6d5", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "array_bezug", "pt": "msg", "to": "array_bezug", "tot": "flow" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1490, "y": 280, "wires": [ [ "515ae9918126f535" ] ] }, { "id": "7fd2bba1daf6d9f3", "type": "ioBroker get", "z": "8c459eb88d1bf5f1", "name": "", "topic": "", "attrname": "payload", "payloadType": "value", "errOnInvalidState": "false", "x": 1800, "y": 180, "wires": [ [ "6e576a4e6d33f548" ] ] }, { "id": "6e576a4e6d33f548", "type": "switch", "z": "8c459eb88d1bf5f1", "name": "IoB read ?", "property": "payload", "propertyType": "msg", "rules": [ { "t": "null" }, { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 2010, "y": 180, "wires": [ [ "ba58ec451fbfa53e" ], [ "ae2e0346dd5f3824" ] ] }, { "id": "ba58ec451fbfa53e", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "[]", "tot": "json" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2250, "y": 160, "wires": [ [ "db03a4ed74093df5" ] ] }, { "id": "ae2e0346dd5f3824", "type": "json", "z": "8c459eb88d1bf5f1", "name": "", "property": "payload", "action": "", "pretty": false, "x": 2230, "y": 220, "wires": [ [ "db03a4ed74093df5" ] ] }, { "id": "db03a4ed74093df5", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload wiederherstellen", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "array_mean", "tot": "msg" }, { "t": "move", "p": "payload_bak_mean", "pt": "msg", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2490, "y": 160, "wires": [ [ "515ae9918126f535" ] ] }, { "id": "515ae9918126f535", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload anhängen und sichern", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$append(array_mean, payload)", "tot": "jsonata" }, { "t": "set", "p": "array_mean", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2510, "y": 280, "wires": [ [ "0427391d23dcb6ad" ] ] }, { "id": "0427391d23dcb6ad", "type": "json", "z": "8c459eb88d1bf5f1", "name": "", "property": "payload", "action": "", "pretty": false, "x": 2750, "y": 280, "wires": [ [ "e44c746b92947c39" ] ] } ] -
@mickym
Ich habe noch eine Frage zu dem u.a. Flow. Ich würde gerne den Payload min, mean und max
an die Tagesposition schieben.
Also das bedeutet heute (09.02.2025) die 9 Position, das das Element 8.
Man könnte doch mit einem Function Node den Codelet i ===global.monatstage
i = i-1msg.payload[i] = msg.payload[i].state
schreiben. Ich habe Monatstage als globale Variable definiert.
Mein Problem ist aber im Change node das append. Das widerspricht ja die Nutzung der Function Node.Hast du einen Tipp für mich?
EDIT:
Ich habe in der Doku gesehen, dass auch in der Change Node mit JSONata mit $sum(payload.state in die Elemente des Arrays geschrieben werden kann.
Array Mean:
[ { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": -4, "mean": 0.05, "max": 3.3 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 }, { "min": 0, "mean": 0, "max": 0 } ]code_tex[ { "id": "ae673cf6cd8433a0", "type": "subflow", "name": "Datum in Topic", "info": "", "category": "", "in": [ { "x": 60, "y": 80, "wires": [ { "id": "2e1ea06b2e94bf1a" } ] } ], "out": [ { "x": 820, "y": 80, "wires": [ { "id": "fc37f5f9d2b0297b", "port": 0 } ] } ], "env": [ { "name": "basePath", "type": "str", "value": "Test1.Test2" } ], "meta": {}, "color": "#DDAA99" }, { "id": "2e1ea06b2e94bf1a", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "datum", "pt": "msg", "to": "$moment().locale('de').format('YYYY.MMMM')", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 230, "y": 80, "wires": [ [ "0e8de9437c3c420a" ] ] }, { "id": "0e8de9437c3c420a", "type": "change", "z": "ae673cf6cd8433a0", "name": "März zu Maerz", "rules": [ { "t": "change", "p": "datum", "pt": "msg", "from": "März", "fromt": "str", "to": "Maerz", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 440, "y": 80, "wires": [ [ "fc37f5f9d2b0297b" ] ] }, { "id": "fc37f5f9d2b0297b", "type": "change", "z": "ae673cf6cd8433a0", "name": "", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "\"0_userdata.0.\" & $env(\"basePath\") & \".\" & datum & \".\" & topic", "tot": "jsonata" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 660, "y": 80, "wires": [ [] ] }, { "id": "9b11db08a1cca5b3", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Mean", "topic": "mean", "intervalCount": "1", "intervalUnits": "h", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "mean", "x": 290, "y": 260, "wires": [ [ "0290eb1787934b73" ] ] }, { "id": "f33e1d253e22a2dd", "type": "ioBroker in", "z": "8c459eb88d1bf5f1", "name": "Aussentemperatur", "attrname": "payload", "topic": "mqtt.0.vitocal.outside_temperature", "payloadType": "value", "onlyack": "", "func": "all", "gap": "", "fireOnStart": "false", "outFormat": "MQTT", "x": 110, "y": 260, "wires": [ [ "5a18bba8160e8e94", "9b11db08a1cca5b3", "32753fd69085ce71" ] ] }, { "id": "5a18bba8160e8e94", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Min", "topic": "min", "intervalCount": "1", "intervalUnits": "h", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "min", "x": 290, "y": 200, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "32753fd69085ce71", "type": "aggregator", "z": "8c459eb88d1bf5f1", "name": "Max", "topic": "max", "intervalCount": "1", "intervalUnits": "h", "submitIncompleteInterval": true, "submitPerTopic": false, "aggregationType": "max", "x": 290, "y": 320, "wires": [ [ "7a8c3b56e65b5059" ] ] }, { "id": "15a56c790ce29f8d", "type": "join", "z": "8c459eb88d1bf5f1", "name": "", "mode": "custom", "build": "object", "property": "payload", "propertyType": "msg", "key": "topic", "joiner": "\\n", "joinerType": "str", "accumulate": true, "timeout": "60", "count": "3", "reduceRight": false, "reduceExp": "", "reduceInit": "", "reduceInitType": "", "reduceFixup": "", "x": 670, "y": 200, "wires": [ [ "8ef8ee85844f2bb2" ] ] }, { "id": "8ef8ee85844f2bb2", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "topic", "pt": "msg", "to": "meanTmp", "tot": "str" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 840, "y": 200, "wires": [ [ "5d3e4f7dea0efe7c" ] ] }, { "id": "5d3e4f7dea0efe7c", "type": "subflow:ae673cf6cd8433a0", "z": "8c459eb88d1bf5f1", "name": "Datum in Topic", "env": [ { "name": "basePath", "value": "Heizung1.MonatsTabellen", "type": "str" } ], "x": 1040, "y": 200, "wires": [ [ "9aa634789fccf445" ] ] }, { "id": "e44c746b92947c39", "type": "ioBroker out", "z": "8c459eb88d1bf5f1", "name": "", "topic": "", "ack": "true", "autoCreate": "true", "stateName": "", "role": "", "payloadType": "", "readonly": "false", "stateUnit": "°C", "stateMin": "", "stateMax": "", "x": 2920, "y": 280, "wires": [] }, { "id": "0290eb1787934b73", "type": "delay", "z": "8c459eb88d1bf5f1", "name": "", "pauseType": "delay", "timeout": "5", "timeoutUnits": "seconds", "rate": "1", "nbRateUnits": "1", "rateUnits": "second", "randomFirst": "1", "randomLast": "5", "randomUnits": "seconds", "drop": false, "allowrate": false, "outputs": 1, "x": 460, "y": 260, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "7a8c3b56e65b5059", "type": "delay", "z": "8c459eb88d1bf5f1", "name": "", "pauseType": "delay", "timeout": "10", "timeoutUnits": "seconds", "rate": "1", "nbRateUnits": "1", "rateUnits": "second", "randomFirst": "1", "randomLast": "5", "randomUnits": "seconds", "drop": false, "allowrate": false, "outputs": 1, "x": 470, "y": 320, "wires": [ [ "15a56c790ce29f8d" ] ] }, { "id": "9aa634789fccf445", "type": "switch", "z": "8c459eb88d1bf5f1", "name": "topic geändert?", "property": "topic", "propertyType": "msg", "rules": [ { "t": "neq", "v": "", "vt": "prev" }, { "t": "eq", "v": "", "vt": "prev" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 1240, "y": 200, "wires": [ [ "c7fa49ea854690ed" ], [ "edaece611a7db6d5" ] ] }, { "id": "c7fa49ea854690ed", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload sichern und flow var löschen", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "payload_bak_mean", "tot": "msg" }, { "t": "delete", "p": "array_mean", "pt": "flow" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1530, "y": 180, "wires": [ [ "7fd2bba1daf6d9f3" ] ] }, { "id": "edaece611a7db6d5", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "array_bezug", "pt": "msg", "to": "array_bezug", "tot": "flow" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 1490, "y": 280, "wires": [ [ "515ae9918126f535" ] ] }, { "id": "7fd2bba1daf6d9f3", "type": "ioBroker get", "z": "8c459eb88d1bf5f1", "name": "", "topic": "", "attrname": "payload", "payloadType": "value", "errOnInvalidState": "false", "x": 1800, "y": 180, "wires": [ [ "6e576a4e6d33f548" ] ] }, { "id": "6e576a4e6d33f548", "type": "switch", "z": "8c459eb88d1bf5f1", "name": "IoB read ?", "property": "payload", "propertyType": "msg", "rules": [ { "t": "null" }, { "t": "nnull" } ], "checkall": "true", "repair": false, "outputs": 2, "x": 2010, "y": 180, "wires": [ [ "ba58ec451fbfa53e" ], [ "ae2e0346dd5f3824" ] ] }, { "id": "ba58ec451fbfa53e", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "[]", "tot": "json" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2250, "y": 160, "wires": [ [ "db03a4ed74093df5" ] ] }, { "id": "ae2e0346dd5f3824", "type": "json", "z": "8c459eb88d1bf5f1", "name": "", "property": "payload", "action": "", "pretty": false, "x": 2230, "y": 220, "wires": [ [ "db03a4ed74093df5" ] ] }, { "id": "db03a4ed74093df5", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload wiederherstellen", "rules": [ { "t": "move", "p": "payload", "pt": "msg", "to": "array_mean", "tot": "msg" }, { "t": "move", "p": "payload_bak_mean", "pt": "msg", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2490, "y": 160, "wires": [ [ "515ae9918126f535" ] ] }, { "id": "515ae9918126f535", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload anhängen und sichern", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$append(array_mean, payload)", "tot": "jsonata" }, { "t": "set", "p": "array_mean", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2510, "y": 280, "wires": [ [ "0427391d23dcb6ad" ] ] }, { "id": "0427391d23dcb6ad", "type": "json", "z": "8c459eb88d1bf5f1", "name": "", "property": "payload", "action": "", "pretty": false, "x": 2750, "y": 280, "wires": [ [ "e44c746b92947c39" ] ] }, { "id": "809efb6124c3639c", "type": "change", "z": "8c459eb88d1bf5f1", "name": "", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$moment().date()", "tot": "jsonata" }, { "t": "set", "p": "payload", "pt": "msg", "to": "monatstage", "tot": "global" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 290, "y": 460, "wires": [ [ "a27f09da64977051" ] ] }, { "id": "02c66f19b70ff804", "type": "inject", "z": "8c459eb88d1bf5f1", "name": "", "props": [ { "p": "payload" }, { "p": "topic", "vt": "str" } ], "repeat": "300", "crontab": "", "once": false, "onceDelay": 0.1, "topic": "", "payload": "", "payloadType": "date", "x": 110, "y": 460, "wires": [ [ "809efb6124c3639c" ] ] }, { "id": "a27f09da64977051", "type": "debug", "z": "8c459eb88d1bf5f1", "name": "Datum", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 470, "y": 460, "wires": [] }, { "id": "be82df1e7a1f3571", "type": "change", "z": "8c459eb88d1bf5f1", "name": "payload anhängen und sichern", "rules": [ { "t": "set", "p": "payload", "pt": "msg", "to": "$append(array_mean, payload)", "tot": "jsonata" }, { "t": "set", "p": "array_mean", "pt": "flow", "to": "payload", "tot": "msg" } ], "action": "", "property": "", "from": "", "to": "", "reg": false, "x": 2470, "y": 380, "wires": [ [] ] } ]t -
du brauchst keine monatstage etc. du hast doch ein Array und da bildest du einfach den durchschnitt der werte. das Array wid doch jeden monat neu geschrieben
-
@mickym
Ich dachte mir das nur als Fallback, wenn iobroker / Node-red mal steht und ein Tag übersprungen wird.So klappt es wunderbar und ich fuchse mich so langsam in die Materie ein.
-
@mickym
Ich sehe gerade den Read IOB Baustein. Liesst dieser die Anzahl der Elemente im Array ein? Ich sehe hier keine Einstellungen oder Code. -
@martybr aber gerade wenn ein Tag übersprungen wird, ist es doch sinnvoller den Durschnitt der real gemessenen Werte zu nehmen.
-
@mickym
In meinem Anwendungsfall setze ich die täglichen Temperaturen im Verhältnis zu den Heizungsverbräuchen, also mehr Stromverbrauch der Wärmepumpe bei niedrigeren Außentemperaturen.
Das dient daher zur Einschätzung der Effektivität der Wärmepumpe.Ich hoffe, ich habe hier meinen Ansatz erklären können
-
@martybr sagte in Wert in dynamische Struktur im ioBroker ablegen:
@mickym
In meinem Anwendungsfall setze ich die täglichen Temperaturen im Verhältnis zu den Heizungsverbräuchen, also mehr Stromverbrauch der Wärmepumpe bei niedrigeren Außentemperaturen.
Das dient daher zur Einschätzung der Effektivität der Wärmepumpe.Ich hoffe, ich habe hier meinen Ansatz erklären können
na eben, dann ist es doch sinnvoller, wenn deine Arrays sich aus Tageswerten zusammensetzt, davon den Durchschnitt zu nehmen, als durch eine fixe theoretische Anzahl an Tagen. Sprich Dein Array enthält nur 26 Werte im Februar- dann ist es doch sinnvoller den Durchschnitt aus 26 Werten zu nehmen, als die Summe durch 28 zu teilen.
-
ja aner mach wie du denkst. ja mit Jsonata kannst du Durchnitt, Summen etc. über Arrays bilden.
am einfachsten ist es dann wenn du das Array in einen Datenpunkt schreibst auch gleich die aggregierten Werte in entsprechende Datenpunkte zu schreiben
-
@mickym
Kannst du mir die Syntax nennen? Wie schreibe ich mit JSONata in ein Element des Array?
Ich mache mich dann an die Arbeit.
Die täglichen Temperaturwerte habe ich ja im Flow. Ich muss sie dann mit save payload.state [i] an die richtige Stelle schreiben.
