Writing data to Indluxdb batch node

General
1

Hi all
please help with my data format problem. i am pulling data from modbus tcp then splitting data in to seperate flows. then i give it a topic and scale the number afterwards. i now need to join all flows and send to a influx 2.0 db. my problem is joining the data and formatting it correctly for the influxdb.

I can send data to influx with the single write node , this all works well even to the cloud .
when combing data i get array of objects however the data format is not correct for influx.

I would like to write around 100 data points with one time stamp and in one transfer. dont want to make the server angry with to many small packets of data. if anyone out there could help with a simple solution that i can build on i will be much app

[{"id":"d8f0114a.1c792","type":"tab","label":"Flow 3","disabled":false,"info":""},{"id":"160a1c6e.3a0be4","type":"function","z":"d8f0114a.1c792","name":"","func":"var msg65 = msg.payload.map(function (p) {\n    return {payload: p};\n});\nreturn msg65;","outputs":65,"noerr":0,"x":330,"y":510,"wires":[["9b89d9c9.a96ce8"],["2fc6b7bb.ad65d8"],["8b23987f.4e34a8"],["508111e9.7857e"],["aa3ad2e3.86329"],["199f61c7.30200e"],["6f1313b9.fedf7c"],["fdc88516.8bcfd8"],["2c5c857d.e2587a"],["dd80c418.4bd898"],["fc6e781b.6814c8"],["2f05bc1e.a71be4"],["62b2a564.4f5f0c"],["692fdc49.c89804"],["e94653c5.cd182"],["5cc0a9b9.f60bc8"],["ea9dd6be.4c4e48"],["a8d5ca3d.690688"],["9af6bfb1.e20db"],["f17af986.c1af78"],["20cfc897.66a6e8"],["df9c7e1c.72b33"],["4cc39f67.d3e94"],["22addb64.c23964"],["c4ed2355.41b3b"],["565c4560.e3403c"],["6ba5e7f2.bdeb28"],["9af8db4e.67d598"],["1517de1.1722222"],["d89b4486.8cc4a8"],["df6af94.d473f08"],["c3c99bf.41e8e68"],["432db086.8bdee"],["28f7c4d0.a49d0c"],["43655e52.3ada9"],["28080d3.21de9f2"],["60564244.07221c"],["21a25087.c7a47"],["6c16a8f.63f0058"],["a991911e.3bdfb"],["8f8e3a42.2d9e68"],["cc6b8dd5.1bffb"],["de3f113b.d6cfc"],["ce77f9b8.786098"],["d0f85181.9069d"],["556d2298.6f9e8c"],["9a130b.1dab6cf8"],["975aa785.c41f18"],["74c2722.1264a8c"],["2fa00380.3df79c"],["a368eb17.664d78"],["c0676a99.9f2208"],["20330c87.594664"],["93aa80e8.69833"],["7b3b4d91.c9f4e4"],["d595967a.32c918"],["1416b60.de8e34a"],["794b215b.c621"],["7270c415.82f34c"],["f62bcffa.2a329"],[],[],[],[],[]]},{"id":"69218150.4eb4a","type":"modbus-read","z":"d8f0114a.1c792","name":"venus gx 1","topic":"","showStatusActivities":false,"logIOActivities":false,"showErrors":false,"unitid":"242","dataType":"HoldingRegister","adr":"3","quantity":"60","rate":"2","rateUnit":"s","delayOnStart":false,"startDelayTime":"","server":"c4c35281.d3b17","useIOFile":false,"ioFile":"","useIOForPayload":false,"emptyMsgOnFail":false,"x":120,"y":515,"wires":[["160a1c6e.3a0be4"],[]]},{"id":"9b89d9c9.a96ce8","type":"change","z":"d8f0114a.1c792","name":"VIN1","rules":[{"t":"set","p":"topic","pt":"msg","to":"ACIN1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":80,"wires":[["f148c651.13def8"]]},{"id":"2fc6b7bb.ad65d8","type":"change","z":"d8f0114a.1c792","name":"VIN2","rules":[{"t":"set","p":"topic","pt":"msg","to":"ACIN2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":100,"wires":[["1ec3726f.03055e"]]},{"id":"8b23987f.4e34a8","type":"change","z":"d8f0114a.1c792","name":"VIN3","rules":[{"t":"set","p":"topic","pt":"msg","to":"ACIN3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":110,"wires":[["5d3ce566.11104c"]]},{"id":"508111e9.7857e","type":"change","z":"d8f0114a.1c792","name":"IIN1","rules":[{"t":"set","p":"topic","pt":"msg","to":"IIN1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":125,"wires":[["23278068.8668d"]]},{"id":"aa3ad2e3.86329","type":"change","z":"d8f0114a.1c792","name":"IIN2","rules":[{"t":"set","p":"topic","pt":"msg","to":"IIN2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":145,"wires":[["fc561209.f84c6"]]},{"id":"199f61c7.30200e","type":"change","z":"d8f0114a.1c792","name":"IIN3","rules":[{"t":"set","p":"topic","pt":"msg","to":"IIN3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":155,"wires":[["b5101cd5.0eb25"]]},{"id":"6f1313b9.fedf7c","type":"change","z":"d8f0114a.1c792","name":"FIN1","rules":[{"t":"set","p":"topic","pt":"msg","to":"FIN1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":165,"wires":[["c41f1280.c497e"]]},{"id":"fdc88516.8bcfd8","type":"change","z":"d8f0114a.1c792","name":"FIN2","rules":[{"t":"set","p":"topic","pt":"msg","to":"FIN2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":185,"wires":[["2e008639.3a844a"]]},{"id":"2c5c857d.e2587a","type":"change","z":"d8f0114a.1c792","name":"FIN3","rules":[{"t":"set","p":"topic","pt":"msg","to":"FIN3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":195,"wires":[["4e238749.2aaa58"]]},{"id":"dd80c418.4bd898","type":"change","z":"d8f0114a.1c792","name":"PIN1","rules":[{"t":"set","p":"topic","pt":"msg","to":"PIN1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":205,"wires":[["c1b68d12.1f97f"]]},{"id":"fc6e781b.6814c8","type":"change","z":"d8f0114a.1c792","name":"PIN2","rules":[{"t":"set","p":"topic","pt":"msg","to":"PIN2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":225,"wires":[["8a1315fd.e16998"]]},{"id":"2f05bc1e.a71be4","type":"change","z":"d8f0114a.1c792","name":"PIN3","rules":[{"t":"set","p":"topic","pt":"msg","to":"PIN3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":235,"wires":[["8cef418f.0909e"]]},{"id":"62b2a564.4f5f0c","type":"change","z":"d8f0114a.1c792","name":"VOUT1","rules":[{"t":"set","p":"topic","pt":"msg","to":"VOUT1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":510,"y":245,"wires":[["3020366e.88a24a"]]},{"id":"692fdc49.c89804","type":"change","z":"d8f0114a.1c792","name":"VOUT2","rules":[{"t":"set","p":"topic","pt":"msg","to":"VOUT2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":265,"wires":[["e0fbd0b8.88f69"]]},{"id":"e94653c5.cd182","type":"change","z":"d8f0114a.1c792","name":"VOUT3","rules":[{"t":"set","p":"topic","pt":"msg","to":"VOUT3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":275,"wires":[["a79eccee.e2e6"]]},{"id":"5cc0a9b9.f60bc8","type":"change","z":"d8f0114a.1c792","name":"IOUT1","rules":[{"t":"set","p":"topic","pt":"msg","to":"IOUT1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":285,"wires":[["73196e69.8589d"]]},{"id":"ea9dd6be.4c4e48","type":"change","z":"d8f0114a.1c792","name":"IOUT2","rules":[{"t":"set","p":"topic","pt":"msg","to":"IOUT2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":305,"wires":[["9142808b.f94e2"]]},{"id":"a8d5ca3d.690688","type":"change","z":"d8f0114a.1c792","name":"IOUT3","rules":[{"t":"set","p":"topic","pt":"msg","to":"IOUT3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":315,"wires":[["b9e5ecb7.c300c"]]},{"id":"9af6bfb1.e20db","type":"change","z":"d8f0114a.1c792","name":"FOUT","rules":[{"t":"set","p":"topic","pt":"msg","to":"FOUT","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":320,"wires":[[]]},{"id":"f17af986.c1af78","type":"change","z":"d8f0114a.1c792","name":"AICL","rules":[{"t":"set","p":"topic","pt":"msg","to":"AICL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":340,"wires":[[]]},{"id":"20cfc897.66a6e8","type":"change","z":"d8f0114a.1c792","name":"POUT1","rules":[{"t":"set","p":"topic","pt":"msg","to":"POUT1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":350,"wires":[["62892e94.fa247"]]},{"id":"df9c7e1c.72b33","type":"change","z":"d8f0114a.1c792","name":"POUT2","rules":[{"t":"set","p":"topic","pt":"msg","to":"POUT2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":510,"y":360,"wires":[["8a044ca3.47c2"]]},{"id":"4cc39f67.d3e94","type":"change","z":"d8f0114a.1c792","name":"POUT3","rules":[{"t":"set","p":"topic","pt":"msg","to":"POUT3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":380,"wires":[["a63c7e9d.bc951"]]},{"id":"22addb64.c23964","type":"change","z":"d8f0114a.1c792","name":"BATTV","rules":[{"t":"set","p":"topic","pt":"msg","to":"BATTV","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":390,"wires":[["1aeab594.22957a"]]},{"id":"c4ed2355.41b3b","type":"change","z":"d8f0114a.1c792","name":"BATTI","rules":[{"t":"set","p":"topic","pt":"msg","to":"BATTI","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":400,"wires":[["deed4d62.c06dd"]]},{"id":"565c4560.e3403c","type":"change","z":"d8f0114a.1c792","name":"PC","rules":[{"t":"set","p":"topic","pt":"msg","to":"PC","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":420,"wires":[[]]},{"id":"6ba5e7f2.bdeb28","type":"change","z":"d8f0114a.1c792","name":"AI","rules":[{"t":"set","p":"topic","pt":"msg","to":"AI","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":430,"wires":[[]]},{"id":"9af8db4e.67d598","type":"change","z":"d8f0114a.1c792","name":"SOC","rules":[{"t":"set","p":"topic","pt":"msg","to":"SOC","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":495,"y":440,"wires":[["754862b3.6b450c"]]},{"id":"1517de1.1722222","type":"change","z":"d8f0114a.1c792","name":"BS","rules":[{"t":"set","p":"topic","pt":"msg","to":"BS","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":455,"wires":[[]]},{"id":"d89b4486.8cc4a8","type":"change","z":"d8f0114a.1c792","name":"BE","rules":[{"t":"set","p":"topic","pt":"msg","to":"BE","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":465,"wires":[[]]},{"id":"f148c651.13def8","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1035,"y":80,"wires":[["655c904d.e0f0c","32b5d90b.996916"]]},{"id":"1ec3726f.03055e","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1215,"y":95,"wires":[["db8bbf0c.70bcf"]]},{"id":"5d3ce566.11104c","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1380,"y":110,"wires":[[]]},{"id":"655c904d.e0f0c","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"ACIN1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1570,"y":80,"wires":[]},{"id":"db8bbf0c.70bcf","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"ACIN2","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1730,"y":95,"wires":[]},{"id":"23278068.8668d","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1050,"y":125,"wires":[["c56233b7.b1b7d","32b5d90b.996916"]]},{"id":"fc561209.f84c6","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1220,"y":145,"wires":[[]]},{"id":"b5101cd5.0eb25","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1400,"y":155,"wires":[[]]},{"id":"c1b68d12.1f97f","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1045,"y":205,"wires":[["639c5cf5.43e8c4","32b5d90b.996916"]]},{"id":"8a1315fd.e16998","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1225,"y":225,"wires":[[]]},{"id":"8cef418f.0909e","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1385,"y":240,"wires":[[]]},{"id":"3020366e.88a24a","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1035,"y":245,"wires":[["35e6b126.fb334e","32b5d90b.996916"]]},{"id":"e0fbd0b8.88f69","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1215,"y":265,"wires":[[]]},{"id":"a79eccee.e2e6","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1375,"y":275,"wires":[[]]},{"id":"73196e69.8589d","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1055,"y":285,"wires":[["ac3767f4.ef0ab8","32b5d90b.996916"]]},{"id":"9142808b.f94e2","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1230,"y":310,"wires":[[]]},{"id":"b9e5ecb7.c300c","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"scale","round":false,"property":"payload","name":"","x":1405,"y":320,"wires":[[]]},{"id":"62892e94.fa247","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1045,"y":350,"wires":[["c97b9ea1.8a8dc","32b5d90b.996916"]]},{"id":"8a044ca3.47c2","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1230,"y":365,"wires":[[]]},{"id":"a63c7e9d.bc951","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655350","action":"scale","round":false,"property":"payload","name":"","x":1390,"y":380,"wires":[[]]},{"id":"754862b3.6b450c","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"6553.5","action":"scale","round":false,"property":"payload","name":"","x":1035,"y":440,"wires":[[]]},{"id":"1aeab594.22957a","type":"range","z":"d8f0114a.1c792","minin":"0","maxin":"65535","minout":"0","maxout":"655.35","action":"scale","round":false,"property":"payload","name":"","x":1035,"y":390,"wires":[["823eedcf.620d2","32b5d90b.996916"]]},{"id":"deed4d62.c06dd","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-3276.8","maxout":"3276.7","action":"roll","round":true,"property":"payload","name":"","x":1225,"y":405,"wires":[[]]},{"id":"df6af94.d473f08","type":"change","z":"d8f0114a.1c792","name":"SWITCH","rules":[{"t":"set","p":"topic","pt":"msg","to":"SWITCH","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":510,"y":475,"wires":[[]]},{"id":"c3c99bf.41e8e68","type":"change","z":"d8f0114a.1c792","name":"TEMP AL","rules":[{"t":"set","p":"topic","pt":"msg","to":"TEMP AL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":490,"wires":[[]]},{"id":"432db086.8bdee","type":"change","z":"d8f0114a.1c792","name":"BATT AL","rules":[{"t":"set","p":"topic","pt":"msg","to":"LOW B AL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":500,"wires":[[]]},{"id":"28f7c4d0.a49d0c","type":"change","z":"d8f0114a.1c792","name":"OL AL","rules":[{"t":"set","p":"topic","pt":"msg","to":"OL AL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":515,"wires":[[]]},{"id":"43655e52.3ada9","type":"change","z":"d8f0114a.1c792","name":"ESSPS1","rules":[{"t":"set","p":"topic","pt":"msg","to":"ESSPS1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":530,"wires":[[]]},{"id":"28080d3.21de9f2","type":"change","z":"d8f0114a.1c792","name":"ESSDC","rules":[{"t":"set","p":"topic","pt":"msg","to":"ESSDC","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":540,"wires":[[]]},{"id":"60564244.07221c","type":"change","z":"d8f0114a.1c792","name":"ESSDF","rules":[{"t":"set","p":"topic","pt":"msg","to":"ESSDF","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1020,"y":555,"wires":[[]]},{"id":"21a25087.c7a47","type":"change","z":"d8f0114a.1c792","name":"ESSPS2","rules":[{"t":"set","p":"topic","pt":"msg","to":"ESSPS2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":510,"y":570,"wires":[[]]},{"id":"6c16a8f.63f0058","type":"change","z":"d8f0114a.1c792","name":"ESSPS3","rules":[{"t":"set","p":"topic","pt":"msg","to":"ESSPS3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":575,"wires":[[]]},{"id":"a991911e.3bdfb","type":"change","z":"d8f0114a.1c792","name":"TS AL","rules":[{"t":"set","p":"topic","pt":"msg","to":"TS AL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":590,"wires":[[]]},{"id":"8f8e3a42.2d9e68","type":"change","z":"d8f0114a.1c792","name":"VS AL","rules":[{"t":"set","p":"topic","pt":"msg","to":"VS AL","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1010,"y":603,"wires":[[]]},{"id":"cc6b8dd5.1bffb","type":"change","z":"d8f0114a.1c792","name":"TALL1","rules":[{"t":"set","p":"topic","pt":"msg","to":"TALL1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":620,"wires":[[]]},{"id":"de3f113b.d6cfc","type":"change","z":"d8f0114a.1c792","name":"LBAL1","rules":[{"t":"set","p":"topic","pt":"msg","to":"LBAL1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":632,"wires":[[]]},{"id":"ce77f9b8.786098","type":"change","z":"d8f0114a.1c792","name":"OLAL1","rules":[{"t":"set","p":"topic","pt":"msg","to":"OLAL1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":645,"wires":[[]]},{"id":"d0f85181.9069d","type":"change","z":"d8f0114a.1c792","name":"RAL1","rules":[{"t":"set","p":"topic","pt":"msg","to":"RAL1","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1010,"y":659,"wires":[[]]},{"id":"556d2298.6f9e8c","type":"change","z":"d8f0114a.1c792","name":"TALL2","rules":[{"t":"set","p":"topic","pt":"msg","to":"TALL2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":675,"wires":[[]]},{"id":"9a130b.1dab6cf8","type":"change","z":"d8f0114a.1c792","name":"LBAL2","rules":[{"t":"set","p":"topic","pt":"msg","to":"LBAL2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":687,"wires":[[]]},{"id":"975aa785.c41f18","type":"change","z":"d8f0114a.1c792","name":"OLAL2","rules":[{"t":"set","p":"topic","pt":"msg","to":"OLAL2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":700,"wires":[[]]},{"id":"74c2722.1264a8c","type":"change","z":"d8f0114a.1c792","name":"RAL2","rules":[{"t":"set","p":"topic","pt":"msg","to":"RAL2","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1010,"y":714,"wires":[[]]},{"id":"2fa00380.3df79c","type":"change","z":"d8f0114a.1c792","name":"TALL3","rules":[{"t":"set","p":"topic","pt":"msg","to":"TALL3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":725,"wires":[[]]},{"id":"a368eb17.664d78","type":"change","z":"d8f0114a.1c792","name":"LBAL3","rules":[{"t":"set","p":"topic","pt":"msg","to":"LBAL3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":737,"wires":[[]]},{"id":"c0676a99.9f2208","type":"change","z":"d8f0114a.1c792","name":"OLAL3","rules":[{"t":"set","p":"topic","pt":"msg","to":"OLAL3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":850,"y":750,"wires":[[]]},{"id":"20330c87.594664","type":"change","z":"d8f0114a.1c792","name":"RAL3","rules":[{"t":"set","p":"topic","pt":"msg","to":"RAL3","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1010,"y":764,"wires":[[]]},{"id":"93aa80e8.69833","type":"change","z":"d8f0114a.1c792","name":"DPVINV","rules":[{"t":"set","p":"topic","pt":"msg","to":"DPVINV","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":510,"y":775,"wires":[[]]},{"id":"7b3b4d91.c9f4e4","type":"change","z":"d8f0114a.1c792","name":"BMSAC","rules":[{"t":"set","p":"topic","pt":"msg","to":"BMSAC","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":680,"y":787,"wires":[[]]},{"id":"d595967a.32c918","type":"change","z":"d8f0114a.1c792","name":"BMSAD","rules":[{"t":"set","p":"topic","pt":"msg","to":"BMSAD","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":835,"y":800,"wires":[[]]},{"id":"1416b60.de8e34a","type":"change","z":"d8f0114a.1c792","name":"BMSE","rules":[{"t":"set","p":"topic","pt":"msg","to":"BMSE","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":1010,"y":814,"wires":[[]]},{"id":"794b215b.c621","type":"change","z":"d8f0114a.1c792","name":"BMSE","rules":[{"t":"set","p":"topic","pt":"msg","to":"BMSE","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":500,"y":825,"wires":[[]]},{"id":"7270c415.82f34c","type":"change","z":"d8f0114a.1c792","name":"BATTT","rules":[{"t":"set","p":"topic","pt":"msg","to":"BATTT","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":670,"y":837,"wires":[[]]},{"id":"f62bcffa.2a329","type":"change","z":"d8f0114a.1c792","name":"RST","rules":[{"t":"set","p":"topic","pt":"msg","to":"RST","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":840,"y":860,"wires":[[]]},{"id":"c41f1280.c497e","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-327.68","maxout":"327.67","action":"scale","round":false,"property":"payload","name":"","x":1055,"y":170,"wires":[["32b5d90b.996916"]]},{"id":"2e008639.3a844a","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-327.68","maxout":"327.67","action":"scale","round":false,"property":"payload","name":"","x":1230,"y":180,"wires":[[]]},{"id":"4e238749.2aaa58","type":"range","z":"d8f0114a.1c792","minin":"-32768","maxin":"32767","minout":"-327.68","maxout":"327.67","action":"scale","round":false,"property":"payload","name":"","x":1410,"y":190,"wires":[[]]},{"id":"c56233b7.b1b7d","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"IIN1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1590,"y":140,"wires":[]},{"id":"639c5cf5.43e8c4","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"PIN1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1590,"y":200,"wires":[]},{"id":"35e6b126.fb334e","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"VOUT1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1590,"y":240,"wires":[]},{"id":"ac3767f4.ef0ab8","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"IOUT1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1590,"y":280,"wires":[]},{"id":"c97b9ea1.8a8dc","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"POUT1","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1610,"y":340,"wires":[]},{"id":"823eedcf.620d2","type":"influxdb out","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","name":"VENUS001","measurement":"BATTV","precision":"s","retentionPolicy":"","database":"","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":1590,"y":380,"wires":[]},{"id":"fd1f0d73.ef76","type":"influxdb batch","z":"d8f0114a.1c792","influxdb":"25893928.5548b6","precision":"","retentionPolicy":"","name":"","database":"database","precisionV18FluxV20":"s","retentionPolicyV18Flux":"","org":"ammtech","bucket":"VENUS","x":2390,"y":360,"wires":[]},{"id":"32b5d90b.996916","type":"join","z":"d8f0114a.1c792","name":"","mode":"custom","build":"array","property":"","propertyType":"full","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"1","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":2010,"y":360,"wires":[["d9d58c3e.11f6e"]]},{"id":"d9d58c3e.11f6e","type":"debug","z":"d8f0114a.1c792","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":2170,"y":260,"wires":[]},{"id":"c4c35281.d3b17","type":"modbus-client","name":"venus gx 1","clienttype":"tcp","bufferCommands":true,"stateLogEnabled":false,"queueLogEnabled":false,"tcpHost":"192.168.0.40","tcpPort":"502","tcpType":"DEFAULT","serialPort":"/dev/ttyUSB","serialType":"RTU-BUFFERD","serialBaudrate":"9600","serialDatabits":"8","serialStopbits":"1","serialParity":"none","serialConnectionDelay":"100","unit_id":"242","commandDelay":"1","clientTimeout":"1000","reconnectOnTimeout":true,"reconnectTimeout":"2000","parallelUnitIdsAllowed":true},{"id":"25893928.5548b6","type":"influxdb","hostname":"localhost","port":"8086","protocol":"http","database":"VENUS001","name":"VENUSDB","usetls":false,"tls":"","influxdbVersion":"2.0","url":"https://island.ammtech.co.za:8086","rejectUnauthorized":false}]
2

Hi

I use the Stackhero InfluxDB v2 node which is significantly different to InfluxDB v1. You should be able to send as many data points as you like with a single time stamp. Have a look at the Github page for info

3

Change the Join node to use key/value pairs, that will get you nearer.

4

The core mqtt influx nodes do now handle Influx v2.

Edit: corrected above.

5

hi colin curently not using mqtt. i have tried all possible combinations of the join node . it appears that the message is missing data required by influx. i belive i need to convert the data but not sure how.
Capture1my data should look like this but it relally looks like this
Capture2. also notice in flux node gives errors with this config. an array is the only config that does not produce an error from the influx node . however no data entry in the database

6

Are you trying to write all the fields to one measurement? Since you are fetching them at one go it would be usual to send them to one measurement.

7

That was a typo in my earlier message, I have corrected it. I meant that the core influx nodes now handle v2 ok.

8

exactly . all the fields come from the same device. lets call it 60 variables that i need to alter and then send to influx for storage. i plan to have many devices out there so a location would be good aswell.

9

sorry must also mention that my data has topics and not fields not sure how to change this

10

If you are writing them to one measurement then you don't need to use the batch node. You just need to format the payload something like

{
  ACIN1: 220.799,
  IIN1: 3.7999
  ...
}

which is exactly what I would have expected to get out of the join node. However, I see that you also have told the join node to combine each Complete Message, that should be combine each msg.payload to create a key/value object. Try that and make sure it looks correct before sending it to influx.

11

I have to say, I think you are making life difficult by splitting it up and joining it back together again. If you use node-red-contrib-buffer-parser I think you can do most of what you want in there.

1 Like
12

hi colin
i totally agree but my problem is the numbers that come from the modbus device im reading are all raw numbers and need to be be scaled. also running grafana as a local visual and storage platform.

The main problem is modbus data from most devices does not have names and other data only address and int16 . Im sure this gets done all the time im just missing some thing.

Im open to any suggestions you have to offer Please.

13

Capture4
Capture4811Ă—549 28.8 KB

15

Is that coming from the influx batch node? As I said you don't need to use that, use the normal influx out node. If you still have a problem show us what is coming out of the join node and if it doesn't look right show us what is going in.

16

Capture5
Capture51175Ă—282 18.7 KB

the single write node works easily but imagine 500 data points per device x 10000 devices every 2 seconds need to do one transmission per device . way more efficient and less server load

17

That should write all 500 datapoints in one write using the Influx Out node, the batch node is not required for that. Do you mean you want to combine all the data from 10000 devices in one write? How are you going to fetch the values from 10000 devices?

18

no 10000 devices all over the show hopefully!! i was warned about not bogging down servers with to much traffic . i will also be reading from the same server

19

ill give it a bash and will revert .. super helpfull ! thank you

21

I still think you should be using the buffer parser node though. I believe that it will do the allocation of field names and the scaling for you so you should be able to get what you need direct from that node.

Going back to the original question though, how is your modbus read giving you undefined values?

1 Like
22

if we read modbus data from a plc or arduino for example. holding register 40000 and up contains an integer nothing else no meta data as such. i have to give it names , similar to a scada application.