maybe ive just been at it too long but i got to playing with this dosing system havent dialed it in so dont mind the delay intervals
cant figure out how to make it check the time coming in from time.csv and grogreen.csv
injected , tailed , csv , then i use a moment on one to take the seconds off and have them match, then join.
ouput seems right coming from both but they dont seem to allow grogreen.csv to use
SEE CODE POST #5
i think i got lost between the join node and using a switch node to compare the two csv values
could anyone suggest another route to compare the values the output from join is as follows
> {"/config/grogreen.csv":{"col1":"23.01.2022 16:07","col2":"ppm700","col3":"F","col4":1910,"col5":5.8,"col6":70},"/config/time.csv":{"col1":"23.01.2022 16:07"}}
i tried passing that thru a switch node to check that they were = and onto checks of the individual columns to be processed
it seems once they go thru the join node the switch doesnt accept / like the new path of
payload["/config/grogreen.csv"].col4
Hello Mikey,
Your flow cannot be imported.
When you post code please use the Preformatted Text icon
so the Forum keeps the correct formatting for the code
nevermind i got it,
i was trying to filter too much out on the end change nodes, set to payload and it functions as expected
[{"id":"7c8093e112804a45","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"3d8dc278e7a2a5b7","type":"tail-file","z":"7c8093e112804a45","filename":"/config/grogreen.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"my csv from above","x":290,"y":860,"wires":[["f54fe4d1babc2988"]]},{"id":"fbadbdea4a6246fa","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"BlueData","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":860,"wires":[["3d8dc278e7a2a5b7"]]},{"id":"f54fe4d1babc2988","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":860,"wires":[["ca7da7ce8ee7f876"]]},{"id":"e8b6675cece2b790","type":"switch","z":"7c8093e112804a45","name":"Below 5.4","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"lt","v":"5.4","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":960,"y":700,"wires":[["a8e3720248d1d7ad"]]},{"id":"a338a63c73a8a9b6","type":"switch","z":"7c8093e112804a45","name":"Above 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"gt","v":"6.2","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":980,"y":800,"wires":[["6e28f868fbef1981"]]},{"id":"a8e3720248d1d7ad","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 on","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.tyeb3d3b817c849d3947c5lf","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":700,"wires":[["e2374444c0e4ec29"]]},{"id":"b65aeaaaa837116a","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.tyeb3d3b817c849d3947c5lf","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":700,"wires":[["c89ea2389c80664f"]]},{"id":"e2374444c0e4ec29","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":700,"wires":[["b65aeaaaa837116a"]]},{"id":"516663d4a242d337","type":"switch","z":"7c8093e112804a45","name":"Between 5.4 - 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"btwn","v":"5.4","vt":"num","v2":"6.2","v2t":"num"}],"checkall":"true","repair":false,"outputs":1,"x":990,"y":760,"wires":[["6fab8f33ae97b205"]]},{"id":"e221a018eb156be8","type":"switch","z":"7c8093e112804a45","name":"Below 1300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"lt","v":"1300","vt":"str"}],"checkall":"true","repair":false,"outputs":1,"x":950,"y":1120,"wires":[["4f630cc4e0fd73b4","1a8ec483ecb2b575","6ac5e32941f13b5b","c3e4ae6ffe4d8eb5","f3468e510564d083","17b22c5c0901591e","e12f39669e9838b7"]]},{"id":"5a261aae7ee027f9","type":"switch","z":"7c8093e112804a45","name":"Above 1300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"btwn","v":"1300","vt":"num","v2":"2000","v2t":"num"}],"checkall":"true","repair":false,"outputs":1,"x":970,"y":1080,"wires":[["3e628c65f31d6bee"]]},{"id":"fa190306e8747576","type":"switch","z":"7c8093e112804a45","name":"Above 2300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2300","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":1010,"y":980,"wires":[["c713a83020298766"]]},{"id":"458d96ac7caf326f","type":"change","z":"7c8093e112804a45","name":"1121","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1121): Ppm's went below 1300, dosing system activated","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1590,"y":1120,"wires":[["e758886fed4e2b08"]]},{"id":"4f630cc4e0fd73b4","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1120,"wires":[["d56e53e370fb54d8"]]},{"id":"1a8ec483ecb2b575","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1180,"wires":[["eb37ae4531a8d01f"]]},{"id":"6ac5e32941f13b5b","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1240,"wires":[["c2e4c2b780e41f48"]]},{"id":"c3e4ae6ffe4d8eb5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1300,"wires":[["54b1ef740f636584"]]},{"id":"f3468e510564d083","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.100149114c","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1360,"wires":[["c040850a4159a174"]]},{"id":"17b22c5c0901591e","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001491155","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1420,"wires":[["607394373a4d70ed"]]},{"id":"e12f39669e9838b7","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.tyeb3c25dcabae058fe9p0hr","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1480,"wires":[["369564a4ad5d6386"]]},{"id":"c7b1855ad0e74a44","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1120,"wires":[["458d96ac7caf326f"]]},{"id":"562f90d9d01bf852","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1180,"wires":[["458d96ac7caf326f"]]},{"id":"28758d5c9cbb8e11","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1240,"wires":[["458d96ac7caf326f"]]},{"id":"37e8f70008508b87","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1300,"wires":[["458d96ac7caf326f"]]},{"id":"26d26ebb8a5cb333","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.100149114c","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1360,"wires":[["458d96ac7caf326f"]]},{"id":"6a576509891e8f3c","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001491155","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1420,"wires":[["458d96ac7caf326f"]]},{"id":"c84f2c455bcba1a5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.tyeb3c25dcabae058fe9p0hr","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1480,"wires":[["458d96ac7caf326f"]]},{"id":"d56e53e370fb54d8","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1120,"wires":[["c7b1855ad0e74a44"]]},{"id":"eb37ae4531a8d01f","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"6","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1180,"wires":[["562f90d9d01bf852"]]},{"id":"607394373a4d70ed","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1420,"wires":[["6a576509891e8f3c"]]},{"id":"c040850a4159a174","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1360,"wires":[["26d26ebb8a5cb333"]]},{"id":"54b1ef740f636584","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1300,"wires":[["37e8f70008508b87"]]},{"id":"369564a4ad5d6386","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1480,"wires":[["c84f2c455bcba1a5"]]},{"id":"c2e4c2b780e41f48","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"9","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1240,"wires":[["28758d5c9cbb8e11"]]},{"id":"ed8a95c95dc4b3f2","type":"switch","z":"7c8093e112804a45","name":"Above 2000 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2000","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":990,"y":1020,"wires":[["fd1d69b360c2b974"]]},{"id":"fd1d69b360c2b974","type":"api-call-service","z":"7c8093e112804a45","name":"STOP ALL","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1, switch.1001207d06_2, switch.1001207d06_3, switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1170,"y":1020,"wires":[["d46ad0cf150fafc4"]]},{"id":"21af0a14976f9476","type":"file","z":"7c8093e112804a45","name":"BlueLogs","filename":"/config/BlueLogs.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1540,"y":880,"wires":[["dc721b77684d5411"]]},{"id":"e758886fed4e2b08","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1410,"y":880,"wires":[["21af0a14976f9476"]]},{"id":"dc721b77684d5411","type":"debug","z":"7c8093e112804a45","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1690,"y":880,"wires":[]},{"id":"c89ea2389c80664f","type":"change","z":"7c8093e112804a45","name":"1133","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1133): Ph went under 5.4, doser has been activated. Check status ASAP","tot":"str","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":1470,"y":700,"wires":[["e758886fed4e2b08"]]},{"id":"d46ad0cf150fafc4","type":"change","z":"7c8093e112804a45","name":"1143","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1143) Error within system, pumps may need calibrating","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1020,"wires":[["e758886fed4e2b08"]]},{"id":"889d364795ba430d","type":"inject","z":"7c8093e112804a45","name":"BlueLab ripper","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"15","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":160,"y":740,"wires":[["b0969e83678e1fe8"]]},{"id":"09df4ae3e15bb55f","type":"file","z":"7c8093e112804a45","name":"Nf","filename":"/config/grogreen.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":470,"y":740,"wires":[[]]},{"id":"b0969e83678e1fe8","type":"tail-file","z":"7c8093e112804a45","filename":"/config/BlueLog/2022-01-23 154400.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"CSV HERE","x":330,"y":740,"wires":[["09df4ae3e15bb55f"]]},{"id":"5c2884d159f3323c","type":"debug","z":"7c8093e112804a45","name":"join","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":590,"y":580,"wires":[]},{"id":"3e628c65f31d6bee","type":"change","z":"7c8093e112804a45","name":"1122","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1122): Within Recommended Levels","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1080,"wires":[["e758886fed4e2b08"]]},{"id":"6fab8f33ae97b205","type":"change","z":"7c8093e112804a45","name":"1124","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1124): Conditions are Optimal","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":760,"wires":[["e758886fed4e2b08"]]},{"id":"9ec35ded97a42349","type":"change","z":"7c8093e112804a45","name":"1144","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1144): Pump or probe may need attention","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1350,"y":800,"wires":[["e758886fed4e2b08"]]},{"id":"c713a83020298766","type":"change","z":"7c8093e112804a45","name":"1666","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1666) Fucking all hell is breaking loose SHUT SHIT DOWN!)","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":980,"wires":[["e758886fed4e2b08"]]},{"id":"99e8ae0773c77d16","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":150,"y":800,"wires":[["0df7d0b6609d34a3"]]},{"id":"0df7d0b6609d34a3","type":"moment","z":"7c8093e112804a45","name":"","topic":"","input":"payload","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"","outputType":"msg","outTz":"America/New_York","x":340,"y":800,"wires":[["86aaa2a44fdc6ccd"]]},{"id":"86aaa2a44fdc6ccd","type":"file","z":"7c8093e112804a45","name":"","filename":"/config/time.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":540,"y":800,"wires":[[]]},{"id":"fb7497fed9316a95","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"time","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":920,"wires":[["f4fbc397d21f6223"]]},{"id":"f4fbc397d21f6223","type":"tail-file","z":"7c8093e112804a45","filename":"/config/time.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"","x":280,"y":920,"wires":[["d2596263d1174f94"]]},{"id":"ca7da7ce8ee7f876","type":"moment","z":"7c8093e112804a45","name":"d1","topic":"","input":"payload.col1","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"payload.col1","outputType":"msg","outTz":"America/New_York","x":570,"y":860,"wires":[["22f7754c31a33517"]]},{"id":"22f7754c31a33517","type":"join","z":"7c8093e112804a45","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":690,"y":880,"wires":[["12b1037a1a9d35f8","8244c1e6c3feaf9d","5c2884d159f3323c"]]},{"id":"d2596263d1174f94","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":920,"wires":[["22f7754c31a33517"]]},{"id":"8244c1e6c3feaf9d","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"eq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":860,"wires":[["a338a63c73a8a9b6","516663d4a242d337","e8b6675cece2b790","e221a018eb156be8","5a261aae7ee027f9","ed8a95c95dc4b3f2","fa190306e8747576","e01d7ef03a4a7a1a"]]},{"id":"12b1037a1a9d35f8","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"neq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":900,"wires":[["2ab3fe0fb7747a69"]]},{"id":"2ab3fe0fb7747a69","type":"change","z":"7c8093e112804a45","name":"time check","rules":[{"t":"set","p":"payload","pt":"msg","to":"The Date or Time does not match","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":970,"y":900,"wires":[["e758886fed4e2b08"]]},{"id":"6e28f868fbef1981","type":"api-call-service","z":"7c8093e112804a45","name":"","server":"","version":3,"debugenabled":false,"service_domain":"","service":"","entityId":"","data":"","dataType":"jsonata","mergecontext":null,"mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":800,"wires":[["9ec35ded97a42349"]]},{"id":"e01d7ef03a4a7a1a","type":"debug","z":"7c8093e112804a45","name":"switch","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":810,"y":560,"wires":[]},{"id":"a52fadfc.d75d","type":"server","name":"Home Assistant","version":2,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true,"heartbeat":false,"heartbeatInterval":30}]
i think this is correct but if someone doesnt mind having a look at it i would greatly appreciate it.. i only just stumbled upon all this a few weeks ago and dove in head first
i think its all there
if not i think i figured out the code posting part, thanks @UnborN
[{"id":"7c8093e112804a45","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"3d8dc278e7a2a5b7","type":"tail-file","z":"7c8093e112804a45","filename":"/config/grogreen.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"my csv from above","x":290,"y":860,"wires":[["f54fe4d1babc2988"]]},{"id":"fbadbdea4a6246fa","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"BlueData","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":860,"wires":[["3d8dc278e7a2a5b7"]]},{"id":"f54fe4d1babc2988","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":860,"wires":[["ca7da7ce8ee7f876","e758886fed4e2b08"]]},{"id":"e8b6675cece2b790","type":"switch","z":"7c8093e112804a45","name":"Below 5.4","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"lt","v":"5.4","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":960,"y":700,"wires":[["a8e3720248d1d7ad"]]},{"id":"a338a63c73a8a9b6","type":"switch","z":"7c8093e112804a45","name":"Above 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"gt","v":"6.2","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":980,"y":800,"wires":[["6e28f868fbef1981"]]},{"id":"a8e3720248d1d7ad","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 on","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":700,"wires":[["e2374444c0e4ec29"]]},{"id":"b65aeaaaa837116a","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":700,"wires":[["c89ea2389c80664f"]]},{"id":"e2374444c0e4ec29","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":700,"wires":[["b65aeaaaa837116a"]]},{"id":"516663d4a242d337","type":"switch","z":"7c8093e112804a45","name":"Between 5.4 - 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"btwn","v":"5.4","vt":"num","v2":"6.2","v2t":"num"}],"checkall":"true","repair":false,"outputs":1,"x":990,"y":760,"wires":[["6fab8f33ae97b205"]]},{"id":"e221a018eb156be8","type":"switch","z":"7c8093e112804a45","name":"Below 1300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"lt","v":"1300","vt":"str"}],"checkall":"true","repair":false,"outputs":1,"x":950,"y":1120,"wires":[["4f630cc4e0fd73b4","1a8ec483ecb2b575","6ac5e32941f13b5b","c3e4ae6ffe4d8eb5","f3468e510564d083","17b22c5c0901591e","e12f39669e9838b7"]]},{"id":"5a261aae7ee027f9","type":"switch","z":"7c8093e112804a45","name":"Above 1300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"btwn","v":"1300","vt":"num","v2":"2000","v2t":"num"}],"checkall":"true","repair":false,"outputs":1,"x":970,"y":1080,"wires":[["3e628c65f31d6bee"]]},{"id":"fa190306e8747576","type":"switch","z":"7c8093e112804a45","name":"Above 2300 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2300","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":1010,"y":980,"wires":[["c713a83020298766"]]},{"id":"458d96ac7caf326f","type":"change","z":"7c8093e112804a45","name":"1121","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1121): Ppm's went below 1300, dosing system activated","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1590,"y":1120,"wires":[["e758886fed4e2b08"]]},{"id":"4f630cc4e0fd73b4","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1120,"wires":[["d56e53e370fb54d8"]]},{"id":"1a8ec483ecb2b575","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1180,"wires":[["eb37ae4531a8d01f"]]},{"id":"6ac5e32941f13b5b","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1240,"wires":[["c2e4c2b780e41f48"]]},{"id":"c3e4ae6ffe4d8eb5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1300,"wires":[["54b1ef740f636584"]]},{"id":"f3468e510564d083","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1360,"wires":[["c040850a4159a174"]]},{"id":"17b22c5c0901591e","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1420,"wires":[["607394373a4d70ed"]]},{"id":"e12f39669e9838b7","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":1480,"wires":[["369564a4ad5d6386"]]},{"id":"c7b1855ad0e74a44","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1120,"wires":[["458d96ac7caf326f"]]},{"id":"562f90d9d01bf852","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1180,"wires":[["458d96ac7caf326f"]]},{"id":"28758d5c9cbb8e11","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1240,"wires":[["458d96ac7caf326f"]]},{"id":"37e8f70008508b87","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1300,"wires":[["458d96ac7caf326f"]]},{"id":"26d26ebb8a5cb333","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1360,"wires":[["458d96ac7caf326f"]]},{"id":"6a576509891e8f3c","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1420,"wires":[["458d96ac7caf326f"]]},{"id":"c84f2c455bcba1a5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":1480,"wires":[["458d96ac7caf326f"]]},{"id":"d56e53e370fb54d8","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1120,"wires":[["c7b1855ad0e74a44"]]},{"id":"eb37ae4531a8d01f","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"6","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1180,"wires":[["562f90d9d01bf852"]]},{"id":"607394373a4d70ed","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1420,"wires":[["6a576509891e8f3c"]]},{"id":"c040850a4159a174","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1360,"wires":[["26d26ebb8a5cb333"]]},{"id":"54b1ef740f636584","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1300,"wires":[["37e8f70008508b87"]]},{"id":"369564a4ad5d6386","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1480,"wires":[["c84f2c455bcba1a5"]]},{"id":"c2e4c2b780e41f48","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"9","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":1240,"wires":[["28758d5c9cbb8e11"]]},{"id":"ed8a95c95dc4b3f2","type":"switch","z":"7c8093e112804a45","name":"Above 2000 Ppm","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2000","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":990,"y":1020,"wires":[["fd1d69b360c2b974"]]},{"id":"fd1d69b360c2b974","type":"api-call-service","z":"7c8093e112804a45","name":"STOP ALL","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1, switch.1001207d06_2, switch.1001207d06_3, switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1170,"y":1020,"wires":[["d46ad0cf150fafc4"]]},{"id":"21af0a14976f9476","type":"file","z":"7c8093e112804a45","name":"BlueLogs","filename":"/config/BlueLogs.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1540,"y":880,"wires":[["dc721b77684d5411"]]},{"id":"e758886fed4e2b08","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1410,"y":880,"wires":[["21af0a14976f9476"]]},{"id":"dc721b77684d5411","type":"debug","z":"7c8093e112804a45","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1690,"y":880,"wires":[]},{"id":"c89ea2389c80664f","type":"change","z":"7c8093e112804a45","name":"1133","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1133): Ph went under 5.4, doser has been activated. Check status ASAP","tot":"str","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":1470,"y":700,"wires":[["e758886fed4e2b08"]]},{"id":"d46ad0cf150fafc4","type":"change","z":"7c8093e112804a45","name":"1143","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1143) Error within system, pumps may need calibrating","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1020,"wires":[["e758886fed4e2b08"]]},{"id":"889d364795ba430d","type":"inject","z":"7c8093e112804a45","name":"BlueLab ripper","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"15","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":160,"y":740,"wires":[["b0969e83678e1fe8"]]},{"id":"09df4ae3e15bb55f","type":"file","z":"7c8093e112804a45","name":"Nf","filename":"/config/grogreen.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":470,"y":740,"wires":[[]]},{"id":"b0969e83678e1fe8","type":"tail-file","z":"7c8093e112804a45","filename":"/config/BlueLog/2022-01-23 154400.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"CSV HERE","x":330,"y":740,"wires":[["09df4ae3e15bb55f"]]},{"id":"3e628c65f31d6bee","type":"change","z":"7c8093e112804a45","name":"1122","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1122): Within Recommended Levels","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1080,"wires":[["e758886fed4e2b08"]]},{"id":"6fab8f33ae97b205","type":"change","z":"7c8093e112804a45","name":"1124","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1124): Conditions are Optimal","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":760,"wires":[["e758886fed4e2b08"]]},{"id":"9ec35ded97a42349","type":"change","z":"7c8093e112804a45","name":"1144","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1144): Pump or probe may need attention","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1350,"y":800,"wires":[["e758886fed4e2b08"]]},{"id":"c713a83020298766","type":"change","z":"7c8093e112804a45","name":"1666","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1666) Fucking all hell is breaking loose SHUT SHIT DOWN!)","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":980,"wires":[["e758886fed4e2b08"]]},{"id":"99e8ae0773c77d16","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":150,"y":800,"wires":[["0df7d0b6609d34a3"]]},{"id":"0df7d0b6609d34a3","type":"moment","z":"7c8093e112804a45","name":"","topic":"","input":"payload","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"","outputType":"msg","outTz":"America/New_York","x":340,"y":800,"wires":[["86aaa2a44fdc6ccd"]]},{"id":"86aaa2a44fdc6ccd","type":"file","z":"7c8093e112804a45","name":"","filename":"/config/time.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":540,"y":800,"wires":[[]]},{"id":"fb7497fed9316a95","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"time","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":920,"wires":[["f4fbc397d21f6223"]]},{"id":"f4fbc397d21f6223","type":"tail-file","z":"7c8093e112804a45","filename":"/config/time.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"","x":280,"y":920,"wires":[["d2596263d1174f94"]]},{"id":"ca7da7ce8ee7f876","type":"moment","z":"7c8093e112804a45","name":"d1","topic":"","input":"payload.col1","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"payload.col1","outputType":"msg","outTz":"America/New_York","x":570,"y":860,"wires":[["22f7754c31a33517"]]},{"id":"22f7754c31a33517","type":"join","z":"7c8093e112804a45","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":690,"y":880,"wires":[["12b1037a1a9d35f8","8244c1e6c3feaf9d"]]},{"id":"d2596263d1174f94","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":920,"wires":[["22f7754c31a33517"]]},{"id":"8244c1e6c3feaf9d","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"eq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":860,"wires":[["a338a63c73a8a9b6","516663d4a242d337","e8b6675cece2b790","e221a018eb156be8","5a261aae7ee027f9","ed8a95c95dc4b3f2","fa190306e8747576"]]},{"id":"12b1037a1a9d35f8","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"neq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":900,"wires":[["2ab3fe0fb7747a69"]]},{"id":"2ab3fe0fb7747a69","type":"change","z":"7c8093e112804a45","name":"time check","rules":[{"t":"set","p":"payload","pt":"msg","to":"The Date or Time does not match","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":970,"y":900,"wires":[["e758886fed4e2b08"]]},{"id":"6e28f868fbef1981","type":"api-call-service","z":"7c8093e112804a45","name":"","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1190,"y":800,"wires":[["9ec35ded97a42349"]]},{"id":"a52fadfc.d75d","type":"server","name":"Home Assistant","version":2,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true,"heartbeat":false,"heartbeatInterval":30}]
yes .. much better now .. its more clean .. especially when posting large flows
its little difficult to replicate the exact flow since parts of it depend on nodes that i dont have installed
some recommendations i can make is that you can merge some of the logic into a single node.
For example those Switch nodes that check the same property Ppm
msg.payload["/config/grogreen.csv"].col4
you could use one Switch node with multiple rules
the same for the these 3 Switch nodes .. the logic could be merged
are you saying it will run faster / more efficient with merging those into a single switch. how do you control output? put a debug node on and figure it out.. ill have a go with it thanks for the advice..
did you happen to see at the start where i tried to check against true current time?
did lower half to figure it out
[{"id":"7c8093e112804a45","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"3d8dc278e7a2a5b7","type":"tail-file","z":"7c8093e112804a45","filename":"/config/grogreen.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"my csv from above","x":290,"y":860,"wires":[["f54fe4d1babc2988"]]},{"id":"fbadbdea4a6246fa","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"BlueData","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":860,"wires":[["3d8dc278e7a2a5b7"]]},{"id":"f54fe4d1babc2988","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":860,"wires":[["ca7da7ce8ee7f876","e758886fed4e2b08"]]},{"id":"e8b6675cece2b790","type":"switch","z":"7c8093e112804a45","name":"Below 5.4","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"lt","v":"5.4","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":940,"y":700,"wires":[["a8e3720248d1d7ad"]]},{"id":"a338a63c73a8a9b6","type":"switch","z":"7c8093e112804a45","name":"Above 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"gt","v":"6.2","vt":"num"}],"checkall":"true","repair":false,"outputs":1,"x":980,"y":800,"wires":[["6e28f868fbef1981"]]},{"id":"a8e3720248d1d7ad","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 on","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1070,"y":700,"wires":[["e2374444c0e4ec29"]]},{"id":"b65aeaaaa837116a","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1330,"y":700,"wires":[["c89ea2389c80664f"]]},{"id":"e2374444c0e4ec29","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1200,"y":700,"wires":[["b65aeaaaa837116a"]]},{"id":"516663d4a242d337","type":"switch","z":"7c8093e112804a45","name":"Between 5.4 - 6.2","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"btwn","v":"5.4","vt":"num","v2":"6.2","v2t":"num"}],"checkall":"true","repair":false,"outputs":1,"x":990,"y":760,"wires":[["6fab8f33ae97b205"]]},{"id":"458d96ac7caf326f","type":"change","z":"7c8093e112804a45","name":"1121","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1121): Ppm's went below 1300, dosing system activated","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1570,"y":1120,"wires":[["e758886fed4e2b08"]]},{"id":"4f630cc4e0fd73b4","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1120,"wires":[["d56e53e370fb54d8"]]},{"id":"1a8ec483ecb2b575","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1180,"wires":[["eb37ae4531a8d01f"]]},{"id":"6ac5e32941f13b5b","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1240,"wires":[["c2e4c2b780e41f48"]]},{"id":"c3e4ae6ffe4d8eb5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1300,"wires":[["54b1ef740f636584"]]},{"id":"f3468e510564d083","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1360,"wires":[["c040850a4159a174"]]},{"id":"17b22c5c0901591e","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1420,"wires":[["607394373a4d70ed"]]},{"id":"e12f39669e9838b7","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1480,"wires":[["369564a4ad5d6386"]]},{"id":"c7b1855ad0e74a44","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1120,"wires":[["458d96ac7caf326f"]]},{"id":"562f90d9d01bf852","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1180,"wires":[["458d96ac7caf326f"]]},{"id":"28758d5c9cbb8e11","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1240,"wires":[["458d96ac7caf326f"]]},{"id":"37e8f70008508b87","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1300,"wires":[["458d96ac7caf326f"]]},{"id":"26d26ebb8a5cb333","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1360,"wires":[["458d96ac7caf326f"]]},{"id":"6a576509891e8f3c","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1420,"wires":[["458d96ac7caf326f"]]},{"id":"c84f2c455bcba1a5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1480,"wires":[["458d96ac7caf326f"]]},{"id":"d56e53e370fb54d8","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1120,"wires":[["c7b1855ad0e74a44"]]},{"id":"eb37ae4531a8d01f","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"6","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1180,"wires":[["562f90d9d01bf852"]]},{"id":"607394373a4d70ed","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1420,"wires":[["6a576509891e8f3c"]]},{"id":"c040850a4159a174","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1360,"wires":[["26d26ebb8a5cb333"]]},{"id":"54b1ef740f636584","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1300,"wires":[["37e8f70008508b87"]]},{"id":"369564a4ad5d6386","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1480,"wires":[["c84f2c455bcba1a5"]]},{"id":"c2e4c2b780e41f48","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"9","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1240,"wires":[["28758d5c9cbb8e11"]]},{"id":"fd1d69b360c2b974","type":"api-call-service","z":"7c8093e112804a45","name":"STOP ALL","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1, switch.1001207d06_2, switch.1001207d06_3, switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1170,"y":1020,"wires":[["d46ad0cf150fafc4"]]},{"id":"21af0a14976f9476","type":"file","z":"7c8093e112804a45","name":"BlueLogs","filename":"/config/BlueLogs.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1540,"y":880,"wires":[["dc721b77684d5411"]]},{"id":"e758886fed4e2b08","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1410,"y":880,"wires":[["21af0a14976f9476"]]},{"id":"dc721b77684d5411","type":"debug","z":"7c8093e112804a45","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1690,"y":880,"wires":[]},{"id":"c89ea2389c80664f","type":"change","z":"7c8093e112804a45","name":"1133","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1133): Ph went under 5.4, doser has been activated. Check status ASAP","tot":"str","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":1450,"y":700,"wires":[["e758886fed4e2b08"]]},{"id":"d46ad0cf150fafc4","type":"change","z":"7c8093e112804a45","name":"1143","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1143) Error within system, pumps may need calibrating","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1020,"wires":[["e758886fed4e2b08"]]},{"id":"889d364795ba430d","type":"inject","z":"7c8093e112804a45","name":"BlueLab ripper","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"15","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":160,"y":740,"wires":[["b0969e83678e1fe8"]]},{"id":"09df4ae3e15bb55f","type":"file","z":"7c8093e112804a45","name":"Nf","filename":"/config/grogreen.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":470,"y":740,"wires":[[]]},{"id":"b0969e83678e1fe8","type":"tail-file","z":"7c8093e112804a45","filename":"/config/BlueLog/2022-01-24 071200.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"CSV HERE","x":330,"y":740,"wires":[["09df4ae3e15bb55f"]]},{"id":"3e628c65f31d6bee","type":"change","z":"7c8093e112804a45","name":"1122","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1122): Within Recommended Levels","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":1080,"wires":[["e758886fed4e2b08"]]},{"id":"6fab8f33ae97b205","type":"change","z":"7c8093e112804a45","name":"1124","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1124): Conditions are Optimal","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":760,"wires":[["e758886fed4e2b08"]]},{"id":"9ec35ded97a42349","type":"change","z":"7c8093e112804a45","name":"1144","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1144): Pump or probe may need attention","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1350,"y":800,"wires":[["e758886fed4e2b08"]]},{"id":"c713a83020298766","type":"change","z":"7c8093e112804a45","name":"1666","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1666) Fucking all hell is breaking loose SHUT SHIT DOWN!)","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":980,"wires":[["e758886fed4e2b08"]]},{"id":"99e8ae0773c77d16","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":150,"y":800,"wires":[["0df7d0b6609d34a3"]]},{"id":"0df7d0b6609d34a3","type":"moment","z":"7c8093e112804a45","name":"","topic":"","input":"payload","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"","outputType":"msg","outTz":"America/New_York","x":340,"y":800,"wires":[["86aaa2a44fdc6ccd"]]},{"id":"86aaa2a44fdc6ccd","type":"file","z":"7c8093e112804a45","name":"","filename":"/config/time.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":540,"y":800,"wires":[[]]},{"id":"fb7497fed9316a95","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"time","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":920,"wires":[["f4fbc397d21f6223"]]},{"id":"f4fbc397d21f6223","type":"tail-file","z":"7c8093e112804a45","filename":"/config/time.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"","x":280,"y":920,"wires":[["d2596263d1174f94"]]},{"id":"ca7da7ce8ee7f876","type":"moment","z":"7c8093e112804a45","name":"d1","topic":"","input":"payload.col1","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"payload.col1","outputType":"msg","outTz":"America/New_York","x":570,"y":860,"wires":[["22f7754c31a33517"]]},{"id":"22f7754c31a33517","type":"join","z":"7c8093e112804a45","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":690,"y":880,"wires":[["12b1037a1a9d35f8","8244c1e6c3feaf9d"]]},{"id":"d2596263d1174f94","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":920,"wires":[["22f7754c31a33517"]]},{"id":"8244c1e6c3feaf9d","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"eq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":860,"wires":[["a338a63c73a8a9b6","516663d4a242d337","e8b6675cece2b790","d9d5bf159ede78cf"]]},{"id":"12b1037a1a9d35f8","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"neq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":900,"wires":[["2ab3fe0fb7747a69"]]},{"id":"2ab3fe0fb7747a69","type":"change","z":"7c8093e112804a45","name":"time check","rules":[{"t":"set","p":"payload","pt":"msg","to":"The Date or Time does not match","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":970,"y":900,"wires":[["e758886fed4e2b08"]]},{"id":"6e28f868fbef1981","type":"api-call-service","z":"7c8093e112804a45","name":"","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1190,"y":800,"wires":[["9ec35ded97a42349"]]},{"id":"d9d5bf159ede78cf","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2300","vt":"num"},{"t":"gt","v":"2000","vt":"str"},{"t":"btwn","v":"1300","vt":"num","v2":"2000","v2t":"num"},{"t":"lt","v":"1300","vt":"num"}],"checkall":"true","repair":false,"outputs":4,"x":950,"y":1020,"wires":[["c713a83020298766"],["fd1d69b360c2b974"],["3e628c65f31d6bee"],["4f630cc4e0fd73b4","1a8ec483ecb2b575","6ac5e32941f13b5b","c3e4ae6ffe4d8eb5","f3468e510564d083","17b22c5c0901591e","e12f39669e9838b7"]]},{"id":"a52fadfc.d75d","type":"server","name":"Home Assistant","version":2,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true,"heartbeat":false,"heartbeatInterval":30}]
i dont think its going to affect speed .. but its less nodes and less clatter on the Flow
you mean here ? where you do the comparison after the conversion of the date with the Moment node ?
yes .. it looks correct .. if it works it works 
(but then again we dont know whats coming out of those csv nodes)
[{"id":"7c8093e112804a45","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"3d8dc278e7a2a5b7","type":"tail-file","z":"7c8093e112804a45","filename":"/config/grogreen.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"my csv from above","x":290,"y":860,"wires":[["f54fe4d1babc2988"]]},{"id":"fbadbdea4a6246fa","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"BlueData","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":860,"wires":[["3d8dc278e7a2a5b7"]]},{"id":"f54fe4d1babc2988","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":860,"wires":[["ca7da7ce8ee7f876","e758886fed4e2b08"]]},{"id":"a8e3720248d1d7ad","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 on","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1070,"y":680,"wires":[["e2374444c0e4ec29"]]},{"id":"b65aeaaaa837116a","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1330,"y":680,"wires":[["c89ea2389c80664f"]]},{"id":"e2374444c0e4ec29","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1200,"y":680,"wires":[["b65aeaaaa837116a"]]},{"id":"458d96ac7caf326f","type":"change","z":"7c8093e112804a45","name":"1121","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1121): Ppm's went below 1300, dosing system activated","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1570,"y":1120,"wires":[["e758886fed4e2b08"]]},{"id":"4f630cc4e0fd73b4","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1120,"wires":[["d56e53e370fb54d8"]]},{"id":"1a8ec483ecb2b575","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1180,"wires":[["eb37ae4531a8d01f"]]},{"id":"6ac5e32941f13b5b","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1240,"wires":[["c2e4c2b780e41f48"]]},{"id":"c3e4ae6ffe4d8eb5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1300,"wires":[["54b1ef740f636584"]]},{"id":"f3468e510564d083","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1360,"wires":[["c040850a4159a174"]]},{"id":"17b22c5c0901591e","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1420,"wires":[["607394373a4d70ed"]]},{"id":"e12f39669e9838b7","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1130,"y":1480,"wires":[["369564a4ad5d6386"]]},{"id":"c7b1855ad0e74a44","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1120,"wires":[["458d96ac7caf326f"]]},{"id":"562f90d9d01bf852","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1180,"wires":[["458d96ac7caf326f"]]},{"id":"28758d5c9cbb8e11","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1240,"wires":[["458d96ac7caf326f"]]},{"id":"37e8f70008508b87","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1300,"wires":[["458d96ac7caf326f"]]},{"id":"26d26ebb8a5cb333","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1360,"wires":[["458d96ac7caf326f"]]},{"id":"6a576509891e8f3c","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1420,"wires":[["458d96ac7caf326f"]]},{"id":"c84f2c455bcba1a5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":1480,"wires":[["458d96ac7caf326f"]]},{"id":"d56e53e370fb54d8","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1120,"wires":[["c7b1855ad0e74a44"]]},{"id":"eb37ae4531a8d01f","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"6","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1180,"wires":[["562f90d9d01bf852"]]},{"id":"607394373a4d70ed","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1420,"wires":[["6a576509891e8f3c"]]},{"id":"c040850a4159a174","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1360,"wires":[["26d26ebb8a5cb333"]]},{"id":"54b1ef740f636584","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1300,"wires":[["37e8f70008508b87"]]},{"id":"369564a4ad5d6386","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1480,"wires":[["c84f2c455bcba1a5"]]},{"id":"c2e4c2b780e41f48","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"9","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1260,"y":1240,"wires":[["28758d5c9cbb8e11"]]},{"id":"fd1d69b360c2b974","type":"api-call-service","z":"7c8093e112804a45","name":"STOP ALL","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1, switch.1001207d06_2, switch.1001207d06_3, switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1170,"y":1020,"wires":[["d46ad0cf150fafc4"]]},{"id":"21af0a14976f9476","type":"file","z":"7c8093e112804a45","name":"BlueLogs","filename":"/config/BlueLogs.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1540,"y":880,"wires":[["dc721b77684d5411"]]},{"id":"e758886fed4e2b08","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1410,"y":880,"wires":[["21af0a14976f9476"]]},{"id":"dc721b77684d5411","type":"debug","z":"7c8093e112804a45","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1690,"y":880,"wires":[]},{"id":"c89ea2389c80664f","type":"change","z":"7c8093e112804a45","name":"1133","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1133): Ph went under 5.4, doser has been activated. Check status ASAP","tot":"str","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":1450,"y":680,"wires":[["e758886fed4e2b08"]]},{"id":"d46ad0cf150fafc4","type":"change","z":"7c8093e112804a45","name":"1143","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1143) Error within system, pumps may need calibrating","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":1020,"wires":[["e758886fed4e2b08"]]},{"id":"889d364795ba430d","type":"inject","z":"7c8093e112804a45","name":"BlueLab ripper","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"15","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":160,"y":740,"wires":[["b0969e83678e1fe8"]]},{"id":"09df4ae3e15bb55f","type":"file","z":"7c8093e112804a45","name":"Nf","filename":"/config/grogreen.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":470,"y":740,"wires":[[]]},{"id":"b0969e83678e1fe8","type":"tail-file","z":"7c8093e112804a45","filename":"/config/BlueLog/2022-01-24 071200.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"CSV HERE","x":330,"y":740,"wires":[["09df4ae3e15bb55f"]]},{"id":"3e628c65f31d6bee","type":"change","z":"7c8093e112804a45","name":"1122","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1122): Within Recommended Levels","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":1080,"wires":[["e758886fed4e2b08"]]},{"id":"6fab8f33ae97b205","type":"change","z":"7c8093e112804a45","name":"1124","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1124): Conditions are Optimal","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1290,"y":740,"wires":[["e758886fed4e2b08"]]},{"id":"9ec35ded97a42349","type":"change","z":"7c8093e112804a45","name":"1144","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1144): Pump or probe may need attention","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1350,"y":780,"wires":[["e758886fed4e2b08"]]},{"id":"c713a83020298766","type":"change","z":"7c8093e112804a45","name":"1666","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1666) Fucking all hell is breaking loose SHUT SHIT DOWN!)","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1310,"y":980,"wires":[["e758886fed4e2b08"]]},{"id":"99e8ae0773c77d16","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":150,"y":800,"wires":[["0df7d0b6609d34a3"]]},{"id":"0df7d0b6609d34a3","type":"moment","z":"7c8093e112804a45","name":"","topic":"","input":"payload","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"","outputType":"msg","outTz":"America/New_York","x":340,"y":800,"wires":[["86aaa2a44fdc6ccd"]]},{"id":"86aaa2a44fdc6ccd","type":"file","z":"7c8093e112804a45","name":"","filename":"/config/time.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":540,"y":800,"wires":[[]]},{"id":"fb7497fed9316a95","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"time","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":920,"wires":[["f4fbc397d21f6223"]]},{"id":"f4fbc397d21f6223","type":"tail-file","z":"7c8093e112804a45","filename":"/config/time.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"","x":280,"y":920,"wires":[["d2596263d1174f94"]]},{"id":"ca7da7ce8ee7f876","type":"moment","z":"7c8093e112804a45","name":"d1","topic":"","input":"payload.col1","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"payload.col1","outputType":"msg","outTz":"America/New_York","x":570,"y":860,"wires":[["22f7754c31a33517"]]},{"id":"22f7754c31a33517","type":"join","z":"7c8093e112804a45","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":690,"y":880,"wires":[["12b1037a1a9d35f8","8244c1e6c3feaf9d"]]},{"id":"d2596263d1174f94","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":920,"wires":[["22f7754c31a33517"]]},{"id":"8244c1e6c3feaf9d","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"eq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":860,"wires":[["d9d5bf159ede78cf","095002630166781f"]]},{"id":"12b1037a1a9d35f8","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"neq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":900,"wires":[["2ab3fe0fb7747a69"]]},{"id":"2ab3fe0fb7747a69","type":"change","z":"7c8093e112804a45","name":"time check","rules":[{"t":"set","p":"payload","pt":"msg","to":"The Date or Time does not match","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":970,"y":900,"wires":[["e758886fed4e2b08"]]},{"id":"6e28f868fbef1981","type":"api-call-service","z":"7c8093e112804a45","name":"","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1190,"y":780,"wires":[["9ec35ded97a42349"]]},{"id":"d9d5bf159ede78cf","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2300","vt":"num"},{"t":"gt","v":"2000","vt":"str"},{"t":"btwn","v":"1300","vt":"num","v2":"2000","v2t":"num"},{"t":"lt","v":"1300","vt":"num"}],"checkall":"true","repair":false,"outputs":4,"x":950,"y":1020,"wires":[["c713a83020298766"],["fd1d69b360c2b974"],["3e628c65f31d6bee"],["4f630cc4e0fd73b4","1a8ec483ecb2b575","6ac5e32941f13b5b","c3e4ae6ffe4d8eb5","f3468e510564d083","17b22c5c0901591e","e12f39669e9838b7"]]},{"id":"095002630166781f","type":"switch","z":"7c8093e112804a45","name":"","property":"payload","propertyType":"msg","rules":[{"t":"lt","v":"5.4","vt":"str"},{"t":"btwn","v":"5.4","vt":"num","v2":"6.2","v2t":"num"},{"t":"gt","v":"6.2","vt":"num"}],"checkall":"true","repair":false,"outputs":3,"x":950,"y":740,"wires":[["a8e3720248d1d7ad"],["6fab8f33ae97b205"],["6e28f868fbef1981"]]},{"id":"a52fadfc.d75d","type":"server","name":"Home Assistant","version":2,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true,"heartbeat":false,"heartbeatInterval":30}]
switched
dont mind the upper switch i forgot to add correct payload
[{"id":"7c8093e112804a45","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"3d8dc278e7a2a5b7","type":"tail-file","z":"7c8093e112804a45","filename":"/config/grogreen.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"my csv from above","x":290,"y":860,"wires":[["f54fe4d1babc2988"]]},{"id":"fbadbdea4a6246fa","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"BlueData","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":860,"wires":[["3d8dc278e7a2a5b7"]]},{"id":"f54fe4d1babc2988","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":860,"wires":[["ca7da7ce8ee7f876","e758886fed4e2b08"]]},{"id":"a8e3720248d1d7ad","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 on","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1150,"y":700,"wires":[["e2374444c0e4ec29"]]},{"id":"b65aeaaaa837116a","type":"api-call-service","z":"7c8093e112804a45","name":"ch8 off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":700,"wires":[["c89ea2389c80664f"]]},{"id":"e2374444c0e4ec29","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1280,"y":700,"wires":[["b65aeaaaa837116a"]]},{"id":"458d96ac7caf326f","type":"change","z":"7c8093e112804a45","name":"1131","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1121): Ppm's went below 1300, dosing system activated","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":1000,"wires":[["e758886fed4e2b08"]]},{"id":"4f630cc4e0fd73b4","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1000,"wires":[["d56e53e370fb54d8"]]},{"id":"1a8ec483ecb2b575","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1060,"wires":[["eb37ae4531a8d01f"]]},{"id":"6ac5e32941f13b5b","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1120,"wires":[["c2e4c2b780e41f48"]]},{"id":"c3e4ae6ffe4d8eb5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1180,"wires":[["54b1ef740f636584"]]},{"id":"f3468e510564d083","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1240,"wires":[["c040850a4159a174"]]},{"id":"17b22c5c0901591e","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1300,"wires":[["607394373a4d70ed"]]},{"id":"e12f39669e9838b7","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_on","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1090,"y":1360,"wires":[["369564a4ad5d6386"]]},{"id":"c7b1855ad0e74a44","type":"api-call-service","z":"7c8093e112804a45","name":"ch1","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1000,"wires":[["458d96ac7caf326f"]]},{"id":"562f90d9d01bf852","type":"api-call-service","z":"7c8093e112804a45","name":"ch 2","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1060,"wires":[["458d96ac7caf326f"]]},{"id":"28758d5c9cbb8e11","type":"api-call-service","z":"7c8093e112804a45","name":"ch 3","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1120,"wires":[["458d96ac7caf326f"]]},{"id":"37e8f70008508b87","type":"api-call-service","z":"7c8093e112804a45","name":"ch 4","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1180,"wires":[["458d96ac7caf326f"]]},{"id":"26d26ebb8a5cb333","type":"api-call-service","z":"7c8093e112804a45","name":"ch 5","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_1","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1240,"wires":[["458d96ac7caf326f"]]},{"id":"6a576509891e8f3c","type":"api-call-service","z":"7c8093e112804a45","name":"ch 6","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_2","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1300,"wires":[["458d96ac7caf326f"]]},{"id":"c84f2c455bcba1a5","type":"api-call-service","z":"7c8093e112804a45","name":"ch 7","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_3","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1350,"y":1360,"wires":[["458d96ac7caf326f"]]},{"id":"d56e53e370fb54d8","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1000,"wires":[["c7b1855ad0e74a44"]]},{"id":"eb37ae4531a8d01f","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"6","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1060,"wires":[["562f90d9d01bf852"]]},{"id":"607394373a4d70ed","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1300,"wires":[["6a576509891e8f3c"]]},{"id":"c040850a4159a174","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1240,"wires":[["26d26ebb8a5cb333"]]},{"id":"54b1ef740f636584","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1180,"wires":[["37e8f70008508b87"]]},{"id":"369564a4ad5d6386","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"3","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1360,"wires":[["c84f2c455bcba1a5"]]},{"id":"c2e4c2b780e41f48","type":"delay","z":"7c8093e112804a45","name":"","pauseType":"delay","timeout":"9","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"allowrate":false,"outputs":1,"x":1220,"y":1120,"wires":[["28758d5c9cbb8e11"]]},{"id":"fd1d69b360c2b974","type":"api-call-service","z":"7c8093e112804a45","name":"STOP ALL","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.1001207d06_1, switch.1001207d06_2, switch.1001207d06_3, switch.1001207d06_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1390,"y":900,"wires":[["d46ad0cf150fafc4"]]},{"id":"21af0a14976f9476","type":"file","z":"7c8093e112804a45","name":"BlueLogs","filename":"/config/BlueLogs.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":1820,"y":860,"wires":[["dc721b77684d5411"]]},{"id":"e758886fed4e2b08","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":1690,"y":860,"wires":[["21af0a14976f9476"]]},{"id":"dc721b77684d5411","type":"debug","z":"7c8093e112804a45","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1970,"y":860,"wires":[]},{"id":"c89ea2389c80664f","type":"change","z":"7c8093e112804a45","name":"1133","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1133): Ph went under 5.4, doser has been activated. Check status ASAP","tot":"str","dc":true}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":700,"wires":[["e758886fed4e2b08"]]},{"id":"d46ad0cf150fafc4","type":"change","z":"7c8093e112804a45","name":"1141","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1143) Error within system, pumps may need calibrating","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":900,"wires":[["e758886fed4e2b08"]]},{"id":"889d364795ba430d","type":"inject","z":"7c8093e112804a45","name":"BlueLab ripper","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"15","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":160,"y":740,"wires":[["b0969e83678e1fe8"]]},{"id":"09df4ae3e15bb55f","type":"file","z":"7c8093e112804a45","name":"Nf","filename":"/config/grogreen.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":470,"y":740,"wires":[[]]},{"id":"b0969e83678e1fe8","type":"tail-file","z":"7c8093e112804a45","filename":"/config/BlueLog/2022-01-24 071200.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"CSV HERE","x":330,"y":740,"wires":[["09df4ae3e15bb55f"]]},{"id":"3e628c65f31d6bee","type":"change","z":"7c8093e112804a45","name":"1122","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg (1122): Within Recommended Levels","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":960,"wires":[["e758886fed4e2b08"]]},{"id":"6fab8f33ae97b205","type":"change","z":"7c8093e112804a45","name":"1124","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1124): Conditions are Optimal","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":760,"wires":[["e758886fed4e2b08"]]},{"id":"9ec35ded97a42349","type":"change","z":"7c8093e112804a45","name":"1143","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1144): Pump or probe may need attention","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":800,"wires":[["e758886fed4e2b08"]]},{"id":"c713a83020298766","type":"change","z":"7c8093e112804a45","name":"1666","rules":[{"t":"set","p":"payload","pt":"msg","to":"System Msg(1666) Fucking all hell is breaking loose SHUT SHIT DOWN!)","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1530,"y":860,"wires":[["e758886fed4e2b08"]]},{"id":"99e8ae0773c77d16","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payloadType":"date","x":150,"y":800,"wires":[["0df7d0b6609d34a3"]]},{"id":"0df7d0b6609d34a3","type":"moment","z":"7c8093e112804a45","name":"","topic":"","input":"payload","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"","outputType":"msg","outTz":"America/New_York","x":340,"y":800,"wires":[["86aaa2a44fdc6ccd"]]},{"id":"86aaa2a44fdc6ccd","type":"file","z":"7c8093e112804a45","name":"","filename":"/config/time.csv","appendNewline":true,"createDir":true,"overwriteFile":"false","encoding":"none","x":540,"y":800,"wires":[[]]},{"id":"fb7497fed9316a95","type":"inject","z":"7c8093e112804a45","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"time","payload":"{ \"topic\": \"tail-file-start\" }","payloadType":"json","x":130,"y":920,"wires":[["f4fbc397d21f6223"]]},{"id":"f4fbc397d21f6223","type":"tail-file","z":"7c8093e112804a45","filename":"/config/time.csv","createFile":false,"mode":"","encoding":"utf-8","split":true,"separator":"","fromBeginning":false,"flushAtEOF":false,"rememberLast":true,"limitSize":true,"maxBytes":"","skipBlank":true,"useTrim":true,"sendError":false,"interval":"","name":"","x":280,"y":920,"wires":[["d2596263d1174f94"]]},{"id":"ca7da7ce8ee7f876","type":"moment","z":"7c8093e112804a45","name":"d1","topic":"","input":"payload.col1","inputType":"msg","inTz":"America/New_York","adjAmount":0,"adjType":"days","adjDir":"add","format":"DD.MM.YYYY HH:mm","locale":"C","output":"payload.col1","outputType":"msg","outTz":"America/New_York","x":570,"y":860,"wires":[["22f7754c31a33517"]]},{"id":"22f7754c31a33517","type":"join","z":"7c8093e112804a45","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":690,"y":880,"wires":[["12b1037a1a9d35f8","8244c1e6c3feaf9d"]]},{"id":"d2596263d1174f94","type":"csv","z":"7c8093e112804a45","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":920,"wires":[["22f7754c31a33517"]]},{"id":"8244c1e6c3feaf9d","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"eq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":860,"wires":[["d9d5bf159ede78cf","095002630166781f"]]},{"id":"12b1037a1a9d35f8","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col1","propertyType":"msg","rules":[{"t":"neq","v":"payload[\"/config/time.csv\"].col1","vt":"msg"}],"checkall":"true","repair":false,"outputs":1,"x":810,"y":900,"wires":[["2ab3fe0fb7747a69"]]},{"id":"2ab3fe0fb7747a69","type":"change","z":"7c8093e112804a45","name":"time check","rules":[{"t":"set","p":"payload","pt":"msg","to":"The Date or Time does not match","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":950,"y":860,"wires":[["e758886fed4e2b08"]]},{"id":"6e28f868fbef1981","type":"api-call-service","z":"7c8093e112804a45","name":"ch8/off","server":"a52fadfc.d75d","version":3,"debugenabled":false,"service_domain":"switch","service":"turn_off","entityId":"switch.10013b653f_4","data":"","dataType":"jsonata","mergecontext":"","mustacheAltTags":false,"outputProperties":[],"queue":"none","x":1410,"y":800,"wires":[["9ec35ded97a42349"]]},{"id":"d9d5bf159ede78cf","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col4","propertyType":"msg","rules":[{"t":"gt","v":"2300","vt":"num"},{"t":"gt","v":"2000","vt":"str"},{"t":"btwn","v":"1300","vt":"num","v2":"2000","v2t":"num"},{"t":"lt","v":"1300","vt":"num"}],"checkall":"true","repair":false,"outputs":4,"x":970,"y":920,"wires":[["c713a83020298766"],["fd1d69b360c2b974"],["3e628c65f31d6bee"],["4f630cc4e0fd73b4","1a8ec483ecb2b575","6ac5e32941f13b5b","c3e4ae6ffe4d8eb5","f3468e510564d083","17b22c5c0901591e","e12f39669e9838b7"]]},{"id":"095002630166781f","type":"switch","z":"7c8093e112804a45","name":"","property":"payload[\"/config/grogreen.csv\"].col5","propertyType":"msg","rules":[{"t":"lt","v":"5.4","vt":"str"},{"t":"btwn","v":"5.4","vt":"num","v2":"6.2","v2t":"num"},{"t":"gt","v":"6.2","vt":"num"}],"checkall":"true","repair":false,"outputs":3,"x":970,"y":760,"wires":[["a8e3720248d1d7ad"],["6fab8f33ae97b205"],["6e28f868fbef1981"]]},{"id":"a52fadfc.d75d","type":"server","name":"Home Assistant","version":2,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true,"heartbeat":false,"heartbeatInterval":30}]
edited flow from above with corrected payloads
edited again .. cleaned up the file.
@UnborN is there anyway to tail a unkown csv file? i tried using *.csv but i got cannot open for reading: no such file
I dont know havent tried it
but look into the Watch node that monitors a whole folder for file changes
(it should be part of the core node so no need to install it)
and wire the filename of the changed file from Watch node to Tails
so Tails gets the msg.filename dynamically
[EDIT]
After further testing the combination of Watch and Tail node wont work
Try the Watch and Read File node instead
Example Flow:
[{"id":"43f69707a940d2ef","type":"watch","z":"54efb553244c241f","name":"","files":"c:\\share","recursive":"","x":220,"y":980,"wires":[["1ed8acbe635eefba","4460d3c51c0af5ff"]]},{"id":"7a38b73913d62891","type":"debug","z":"54efb553244c241f","name":"4","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1070,"y":980,"wires":[]},{"id":"1ed8acbe635eefba","type":"debug","z":"54efb553244c241f","name":"1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":310,"y":920,"wires":[]},{"id":"4460d3c51c0af5ff","type":"change","z":"54efb553244c241f","name":"","rules":[{"t":"set","p":"filename","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":980,"wires":[["42d164f1fb86547c"]]},{"id":"42d164f1fb86547c","type":"file in","z":"54efb553244c241f","name":"","filename":"","format":"lines","chunk":false,"sendError":false,"encoding":"none","allProps":false,"x":590,"y":980,"wires":[["5cca3c4f2527f79c","52ab3a58f75c59ac"]]},{"id":"1443d936eed17c02","type":"function","z":"54efb553244c241f","name":"last line","func":"let lines = msg.payload\nmsg.payload = lines[lines.length - 1]\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":880,"y":980,"wires":[["7a38b73913d62891"]]},{"id":"a1ba19e0bfbe1204","type":"debug","z":"54efb553244c241f","name":"3","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":850,"y":920,"wires":[]},{"id":"5cca3c4f2527f79c","type":"join","z":"54efb553244c241f","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":730,"y":980,"wires":[["1443d936eed17c02","a1ba19e0bfbe1204"]]},{"id":"52ab3a58f75c59ac","type":"debug","z":"54efb553244c241f","name":"2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":630,"y":920,"wires":[]}]
Sorry I’ll try this later, had to go in the field
dunno why i qouted that gimme a minute actually im stoned and just noticed you have 4 debug nodes running...
it works to know the file is being written to, it returns all data in file instead of just tailing last line tho
.. yea i left the numbered debug nodes to check what msg in produced at every step of the flow
you can click on the icon at the end of the node to disable its output.
if you double click the last debug node (4) and set it to
you'll see that the information of the filename (msg.filename) is there if you want to use it
the last debug node give you the last line
thats what the Function node before it does .. picks up the last line ( similar to what Tail does )
[{"id":"01da2cea006f786f","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"bfc1e2e2fb418c7d","type":"file","z":"01da2cea006f786f","name":"Nf","filename":"/config/growgreen.csv","appendNewline":false,"createDir":true,"overwriteFile":"false","encoding":"none","x":1310,"y":120,"wires":[["fa28c6c6c1a62482"]]},{"id":"fa28c6c6c1a62482","type":"debug","z":"01da2cea006f786f","name":"file","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1450,"y":120,"wires":[]},{"id":"43f69707a940d2ef","type":"watch","z":"01da2cea006f786f","name":"","files":"/config/BlueLog/","recursive":"","x":800,"y":120,"wires":[["4460d3c51c0af5ff"]]},{"id":"4460d3c51c0af5ff","type":"change","z":"01da2cea006f786f","name":"","rules":[{"t":"set","p":"filename","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":990,"y":120,"wires":[["fff3dc24acddee6a"]]},{"id":"a1ba19e0bfbe1204","type":"debug","z":"01da2cea006f786f","name":"3","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":1290,"y":40,"wires":[]},{"id":"fff3dc24acddee6a","type":"file in","z":"01da2cea006f786f","name":"","filename":"","format":"utf8","chunk":false,"sendError":false,"encoding":"none","allProps":false,"x":1160,"y":120,"wires":[["a1ba19e0bfbe1204","bfc1e2e2fb418c7d"]]}]
this works just not well, couldnt get yours to work the function was returning blank
ok .. but what does that do ..
you monitor a folder with Watch
you read the changed file .. and append the whole file to growgreen.csv
(this method will increment the size of that file pretty fast)
after that ? you will use the Tail node on that new csv and get its last line ?
it could work but is it needed ?
how many files you need to monitor .. why not simple do multiple Tail nodes for each file ?
i wanted to find the file of unkown using watch, id like to tail that file but not sure how to insert it into the line without causing issues, this seem to work without causing problems. this way i could allow the original to do exactly the same and just make a new file using the unknown file
id like to just tail it and not have the file get huge so fast but ill keep playing with it
holy smokes so the last line code function just needed to be changed from 1 to 2 so it didnt scoop that final line which is blank...it works and can be input so we dont need 8 files
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy