[
{
"id": "483c86f14f89b7c7",
"type": "inject",
"z": "5573435263570348",
"name": "Start (5min)",
"props": [
{
"p": "payload"
}
],
"repeat": "300",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 110,
"y": 40,
"wires": [
[
"a5b08f60bde64ee9",
"d96f0a6714957359",
"122c34ec6f4066a4",
"278ae359984bcc88",
"6997f62784575bbc",
"2511adce373beaf4",
"48fe6df5fc594e1a"
]
]
},
{
"id": "a5b08f60bde64ee9",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Outdoor temperature (BT1)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "1",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 180,
"y": 140,
"wires": [
[
"830b56e8f41dd702"
],
[
"454ac99b9ba9cb43"
]
]
},
{
"id": "d96f0a6714957359",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Brine in (BT10)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "10",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 140,
"y": 180,
"wires": [
[],
[
"ca9a6c58c0de694f"
]
]
},
{
"id": "122c34ec6f4066a4",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Brine out (BT11)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "11",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 140,
"y": 220,
"wires": [
[],
[
"de29bc81e95afccc"
]
]
},
{
"id": "454ac99b9ba9cb43",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Parse BT1",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "BT1",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/10",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 470,
"y": 140,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "ca9a6c58c0de694f",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Parse BT10",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "BT10",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/10",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 470,
"y": 180,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "de29bc81e95afccc",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Parse BT11",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "BT11",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/10",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 470,
"y": 220,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "278ae359984bcc88",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Hot water top (BT7)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "8",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 150,
"y": 260,
"wires": [
[],
[
"e26f5a6a0e684e6e"
]
]
},
{
"id": "6997f62784575bbc",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Hot water charging (BT6)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "9",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 170,
"y": 300,
"wires": [
[],
[
"42dbf00fab9bd43d"
]
]
},
{
"id": "48fe6df5fc594e1a",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Heating medium pump speed (GP1)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "1102",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 210,
"y": 380,
"wires": [
[],
[
"d159ad50be54ac76"
]
]
},
{
"id": "2511adce373beaf4",
"type": "modbus-getter",
"z": "5573435263570348",
"name": "Brine pump speed (GP2)",
"showStatusActivities": false,
"showErrors": false,
"logIOActivities": false,
"unitid": "1",
"dataType": "InputRegister",
"adr": "1104",
"quantity": "1",
"server": "5b6855b757688e02",
"useIOFile": false,
"ioFile": "",
"useIOForPayload": false,
"emptyMsgOnFail": false,
"keepMsgProperties": false,
"x": 170,
"y": 340,
"wires": [
[],
[
"2cfe94c2db8487bd"
]
]
},
{
"id": "e26f5a6a0e684e6e",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Hot water top (BT7)",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "BT7",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/10",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 490,
"y": 260,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "42dbf00fab9bd43d",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Hot water charging (BT6)",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "BT6",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/10",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 510,
"y": 300,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "2cfe94c2db8487bd",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Brine pump speed (GP2)",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "GP2",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/1",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 510,
"y": 340,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "d159ad50be54ac76",
"type": "buffer-parser",
"z": "5573435263570348",
"name": "Heating medium pump speed (GP1)",
"data": "payload.buffer",
"dataType": "msg",
"specification": "spec",
"specificationType": "ui",
"items": [
{
"type": "int16be",
"name": "GP1",
"offset": 0,
"length": 1,
"offsetbit": 0,
"scale": "/1",
"mask": ""
}
],
"swap1": "",
"swap2": "",
"swap3": "",
"swap1Type": "swap",
"swap2Type": "swap",
"swap3Type": "swap",
"msgProperty": "payload",
"msgPropertyType": "str",
"resultType": "object",
"resultTypeType": "return",
"multipleResult": false,
"fanOutMultipleResult": false,
"setTopic": true,
"outputs": 1,
"x": 550,
"y": 380,
"wires": [
[
"cc7ba7f2a8c834ec"
]
]
},
{
"id": "e39f0529532d2f49",
"type": "MSSQL",
"z": "5573435263570348",
"mssqlCN": "9d74c3ddb1dc754c",
"name": "MesswerteDB_Heatpump",
"outField": "payload",
"returnType": "0",
"throwErrors": 1,
"query": "INSERT INTO [dbo].[Heatpump] (datetime, BT1, BT10, BT11, BT7, BT6, GP2, GP1) VALUES (@timestamp, '{{{payload.0.BT1.value}}}', '{{{payload.1.BT10.value}}}', '{{{payload.2.BT11.value}}}', '{{{payload.3.BT7.value}}}', '{{{payload.4.BT6.value}}}', '{{{payload.5.GP2.value}}}', '{{{payload.6.GP1.value}}}')",
"modeOpt": "queryMode",
"modeOptType": "query",
"queryOpt": "payload",
"queryOptType": "editor",
"paramsOpt": "",
"paramsOptType": "editor",
"rows": "rows",
"rowsType": "msg",
"params": [
{
"output": false,
"name": "timestamp",
"type": "DateTime",
"valueType": "datetime",
"value": "0",
"options": {
"nullable": true,
"primary": false,
"identity": false,
"readOnly": false
}
}
],
"x": 1030,
"y": 260,
"wires": [
[
"73dfb63fe35f5fa9"
]
]
},
{
"id": "cc7ba7f2a8c834ec",
"type": "join",
"z": "5573435263570348",
"name": "Join Parse Values",
"mode": "custom",
"build": "array",
"property": "payload",
"propertyType": "msg",
"key": "topic",
"joiner": "\\n",
"joinerType": "str",
"accumulate": false,
"timeout": "",
"count": "7",
"reduceRight": false,
"reduceExp": "",
"reduceInit": "",
"reduceInitType": "num",
"reduceFixup": "",
"x": 790,
"y": 260,
"wires": [
[
"e39f0529532d2f49",
"e3d7d4b88449898a"
]
]
},
{
"id": "73dfb63fe35f5fa9",
"type": "debug",
"z": "5573435263570348",
"name": "Output Join Values",
"active": false,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 1270,
"y": 260,
"wires": []
},
{
"id": "830b56e8f41dd702",
"type": "debug",
"z": "5573435263570348",
"name": "debug 1",
"active": false,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 460,
"y": 100,
"wires": []
},
{
"id": "e3d7d4b88449898a",
"type": "debug",
"z": "5573435263570348",
"name": "debug 2",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 980,
"y": 200,
"wires": []
},
{
"id": "5b6855b757688e02",
"type": "modbus-client",
"name": "Nibe S1255-6PC",
"clienttype": "tcp",
"bufferCommands": true,
"stateLogEnabled": false,
"queueLogEnabled": false,
"failureLogEnabled": true,
"tcpHost": "10.80.10.4",
"tcpPort": "502",
"tcpType": "DEFAULT",
"serialPort": "/dev/ttyUSB",
"serialType": "RTU-BUFFERD",
"serialBaudrate": "9600",
"serialDatabits": "8",
"serialStopbits": "1",
"serialParity": "none",
"serialConnectionDelay": "100",
"serialAsciiResponseStartDelimiter": "0x3A",
"unit_id": "1",
"commandDelay": "1",
"clientTimeout": "1000",
"reconnectOnTimeout": true,
"reconnectTimeout": "2000",
"parallelUnitIdsAllowed": true
},
{
"id": "9d74c3ddb1dc754c",
"type": "MSSQL-CN",
"tdsVersion": "7_4",
"name": "intra-mssql",
"server": "172.46.100.23",
"port": "1433",
"encyption": false,
"trustServerCertificate": false,
"database": "MesswerteDB",
"useUTC": false,
"connectTimeout": "15000",
"requestTimeout": "15000",
"cancelTimeout": "5000",
"pool": "5",
"parseJSON": false,
"enableArithAbort": true,
"credentials": {}
}
]