Gelöst: Wert in dynamische Struktur im ioBroker ablegen
-
@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. -
@martybr na wenn du ein Array in deiner payload bereits hast, dann halt payload[index]
das Element muss aber schon existieren
-
@martybr sagte in Wert in dynamische Struktur im ioBroker ablegen:
Die täglichen Temperaturwerte habe ich ja im Flow. Ich muss sie dann mit save payload.state [i] an die richtige Stelle schreiben.
Warum das denn? - Die werden doch jeden Tag einfach hinten angehängt
-
@mickym
Im Normalfall ist das die optimale Lösung. Ich habe den Fall betrachtet, wenn das System Nachts steht und somit der eine Wert nicht generiert wird. In der nächsten Nacht wird dann ein neuer Wert an die Position des ausgefallenen geschrieben. Das ist nicht Systemkritisch, stört mich einfach, weil der Wert für den entsprechenden Tag nicht stimmt.Das scheint aber ein diffiziles Problem zu sein. Aktuell bekomme ich nur Fehler.
-
@martybr Wie gesagt - ich würde die Position eines Arrays nicht mit einem bestimmten Tag verknüpfen. Sonst hast Du Lücken und das macht alles kompliziert
-
@mickym
Ich habe aber ansonsten das Problem, dass ich die Temperaturwerte nicht mit den Heizungswerten verknüpfen kann. Auch die Heizungswerte laufen in Arrays Tagesgenau ein.
Leider bisher aber in Javascript. Ich versuche ja mit deiner Hilfe die "Programme" in Node-Red umzusetzen.
Ich habe hier schöne Grafiken, die diese Werte Temperatur Tag x mit dem Energiewert Tag x anzeigen.
Ich halte die Tagesgenaue Speicherung zu absolut notwendig. Aktuell läuft es mit dem append. Ein Problem tritt ja nur bei einem Serverausfall auf.
