HI all,
I am have been using S7 out node to pass data to my PLC Tags. I want to send data in the array in one go but it doesn't takes and showing error as 'Data for item of type 'INT' must be a number'. In the details section of S7 out node it is mentioned as 'It is possible to write to multiple variables at once, by setting both msg.variable
and msg.payload
to arrays containing the variable names and their values, respectively. Note that they may not be written in the same write cycle to the PLC, depending on the amount of variables to be written.' Is anyone having some examples for that.
[
{
"id": "2c3c65980f08155d",
"type": "tab",
"label": "Line_Config_CL_TRIAL",
"disabled": false,
"info": "",
"env": []
},
{
"id": "4a4fbbca7eea7e79",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Vacuum1",
"name": "",
"x": 1360,
"y": 160,
"wires": []
},
{
"id": "f293b1064048e0d3",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "PreVac",
"name": "",
"x": 1360,
"y": 100,
"wires": []
},
{
"id": "218c4cd7ac3d6fc8",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Prevac_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 100,
"wires": [
[
"f293b1064048e0d3"
]
]
},
{
"id": "115d09206be0e99f",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Vacuum1_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 160,
"wires": [
[
"4a4fbbca7eea7e79"
]
]
},
{
"id": "536b1bb63ec0215e",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = msg.payload[0].C;\nvar Z = flow.get('Z') || \"FALSE\";\nif (X == 1){\n msg.VC_Found = true\n flow.set('Z',msg.VC_Found);\n}\nelse {\n msg.VC_Found = false\n flow.set('Z',msg.VC_Found);\n}\nvar Y = msg.VC_Found;\nmsg.payload = Y;\n//msg.Z = Z;\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 560,
"y": 680,
"wires": [
[
"0d4d1dceeec6a99a"
]
]
},
{
"id": "b92042be62772233",
"type": "s7 in",
"z": "2c3c65980f08155d",
"endpoint": "738faa0edbcf8dbf",
"mode": "single",
"variable": "VC_READ1",
"diff": false,
"name": "",
"x": 70,
"y": 780,
"wires": [
[]
]
},
{
"id": "3622e5b21d30f0a8",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "msg.VC = msg.payload.VC_READ1;\nvar VC1 = \"'\"+msg.VC+\"'\";\n//var VC = msg.payload.VC_READ;\n//VC ='21672038000R';\nmsg.payload = \"SELECT * FROM [LINE_CONFIGURATOR_V1].[dbo].[CINETIC_CL] Where VC_NUMBER ='\"+msg.payload+\"' and ACTIVE_STATUS='TRUE'\";\n//msg.payload= \"SELECT * FROM [LINE_CONFIGURATOR_L3].[dbo].[CINETIC_CL] WHERE VC_NUMBER=\"+VC1+\"and EQUIPMENT_ID = 4028774\";\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 240,
"y": 780,
"wires": [
[
"9c78d088f703d4e9"
]
]
},
{
"id": "b7c06f30f3f530d1",
"type": "MSSQL",
"z": "2c3c65980f08155d",
"mssqlCN": "c99f144d8449e5df",
"name": "",
"outField": "payload",
"returnType": 0,
"throwErrors": 1,
"query": "",
"modeOpt": "queryMode",
"modeOptType": "query",
"queryOpt": "payload",
"queryOptType": "editor",
"paramsOpt": "queryParams",
"paramsOptType": "none",
"rows": "rows",
"rowsType": "msg",
"parseMustache": true,
"params": [],
"x": 540,
"y": 780,
"wires": [
[
"59aa9bea4e651261",
"683c83b510b22087"
]
]
},
{
"id": "683c83b510b22087",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var A = flow.get('Z') ;\nif (A == true){\nmsg.Prevac_T = msg.payload[0].Prevac_Time;\nmsg.Vacuum1_T = msg.payload[0].Vacuum1_Time;\nmsg.Vacuum_Check_T = msg.payload[0].Vacuum_Check_Time;\nmsg.Vacuum2_T = msg.payload[0].Vacuum2_Time;\nmsg.Radiator_Fill_T = msg.payload[0].Filling_Time;\nmsg.Levelling1_T = msg.payload[0].Levelling1_Time;\nmsg.Levelling2_T = msg.payload[0].Levelling2_Time;\nmsg.Cleaning_T = msg.payload[0].Cleaning_Time;\nmsg.Pressurization_T = msg.payload[0].Pressurization_Time;\nmsg.Stabilization_T = msg.payload[0].Stabilization_Time;\nmsg.Pressure_Test_T = msg.payload[0].Pressure_Test_Time;\nmsg.Release_To_Atmos_T = msg.payload[0].Release_To_Atmosphere;\n\nmsg.Bypass_Press = msg.payload[0].Bypass_Pressure;\nmsg.Major_Leak_Vac_Thress = msg.payload[0].Major_Leak_Vac_Thresshold;\nmsg.Minor_Leak_Vac_Thress = msg.payload[0].Minor_Leak_Vac_Thresshold;\nmsg.Filling_Vol = msg.payload[0].TARGET;\nmsg.Thresshold_Filling_Press = msg.payload[0].Thresshold_Filling_Pressure;\nmsg.High_Pressure_Sett = msg.payload[0].High_Pressure_Setting;\nmsg.Rising_on_Pressure_Sett = msg.payload[0].Rising_on_Pressure_Setting;\nmsg.Delta_Major_Leak = msg.payload[0].Delta_Major_Leak;\nmsg.Delta_Minor_Leak = msg.payload[0].Delta_Minor_Leak;\nmsg.Thress_Relase_To_Atmosphere = msg.payload[0].Thresshold_Relase_To_Atmosphere;\nmsg.Bypass_Vol = msg.payload[0].Bypass_Volume;\n}\nelse {\nmsg.Prevac_T = 0;\nmsg.Vacuum1_T = 0;msg.Vacuum_Check_T = 0;\nmsg.Vacuum2_T = 0;\nmsg.Radiator_Fill_T = 0;\nmsg.Levelling1_T = 0;\nmsg.Levelling2_T = 0;\nmsg.Cleaning_T = 0;\nmsg.Pressurization_T = 0;\nmsg.Stabilization_T = 0;\nmsg.Pressure_Test_T = 0;\nmsg.Release_To_Atmos_T = 0;\nmsg.Bypass_Press = 0;\nmsg.Major_Leak_Vac_Thress = 0;\nmsg.Minor_Leak_Vac_Thress = 0;\nmsg.Filling_Vol = 0;\nmsg.Thresshold_Filling_Press = 0;\nmsg.High_Pressure_Sett = 0;\nmsg.Rising_on_Pressure_Sett = 0;\nmsg.Delta_Major_Leak = 0;\nmsg.Delta_Minor_Leak = 0;\nmsg.Thress_Relase_To_Atmosphere = 0;\nmsg.Bypass_Vol = 0;\n}\nmsg.Y = A;\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 740,
"y": 780,
"wires": [
[
"218c4cd7ac3d6fc8",
"115d09206be0e99f",
"7c1899b265e92478",
"03402df7f80aad5a",
"0f799c75452889fd",
"5a3ba4d4a4e95fc1",
"804afc02ac1ec291",
"49fa734a0e36884f",
"93ae7b8751a67302",
"07af0fe97d144bd0",
"f4b8a8d9c027c824",
"f465e5f4961b3372",
"b6e9cc643dbb2e98",
"b36cae50052a9649",
"0a1865085a7a4e4b",
"1b379945eaf99e4c",
"8495704a64d3d31f",
"baee5c6b318e2323",
"8ce864de234336fb",
"1a2b35f1e5188705",
"4712ddc965fd2bb7",
"768397b7354bd4d9",
"26669af38719924a"
]
]
},
{
"id": "7c1899b265e92478",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Vacuum_Check_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 220,
"wires": [
[
"b854d406d01c7fca"
]
]
},
{
"id": "b854d406d01c7fca",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Vacuum_Check",
"name": "",
"x": 1380,
"y": 220,
"wires": []
},
{
"id": "03402df7f80aad5a",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Vacuum2_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 280,
"wires": [
[
"152ef3edb1199d44"
]
]
},
{
"id": "152ef3edb1199d44",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Vacuum2",
"name": "",
"x": 1360,
"y": 280,
"wires": []
},
{
"id": "0f799c75452889fd",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Radiator_Fill_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 340,
"wires": [
[
"646f59bf3316496e"
]
]
},
{
"id": "646f59bf3316496e",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Radiator_Fill_Time",
"name": "",
"x": 1390,
"y": 340,
"wires": []
},
{
"id": "5a3ba4d4a4e95fc1",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Levelling1_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 400,
"wires": [
[
"c04ea5f290cf0a1c"
]
]
},
{
"id": "c04ea5f290cf0a1c",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Levelling1_Time",
"name": "",
"x": 1380,
"y": 400,
"wires": []
},
{
"id": "804afc02ac1ec291",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Levelling2_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 460,
"wires": [
[
"f563c81422164f3a"
]
]
},
{
"id": "f563c81422164f3a",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Levelling2_Time",
"name": "",
"x": 1380,
"y": 460,
"wires": []
},
{
"id": "49fa734a0e36884f",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Cleaning_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 520,
"wires": [
[
"09fc2ee0dfe13458"
]
]
},
{
"id": "09fc2ee0dfe13458",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Cleaning_Time",
"name": "",
"x": 1380,
"y": 520,
"wires": []
},
{
"id": "93ae7b8751a67302",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Pressurization_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 580,
"wires": [
[
"4939bfa6bb929bef"
]
]
},
{
"id": "4939bfa6bb929bef",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Pressureziation_Time",
"name": "",
"x": 1400,
"y": 580,
"wires": []
},
{
"id": "07af0fe97d144bd0",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Stabilization_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 640,
"wires": [
[
"2494b33a4de4a0be"
]
]
},
{
"id": "2494b33a4de4a0be",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Stablization_Time",
"name": "",
"x": 1390,
"y": 640,
"wires": []
},
{
"id": "f4b8a8d9c027c824",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Pressure_Test_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 700,
"wires": [
[
"9a24345c2124a628"
]
]
},
{
"id": "9a24345c2124a628",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Pressure_Test_Time",
"name": "",
"x": 1400,
"y": 700,
"wires": []
},
{
"id": "f465e5f4961b3372",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Release_To_Atmos_T);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 760,
"wires": [
[
"63525c0cb621229a"
]
]
},
{
"id": "63525c0cb621229a",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Relase_To_Atnosphere_Time",
"name": "",
"x": 1430,
"y": 760,
"wires": []
},
{
"id": "b6e9cc643dbb2e98",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Bypass_Press);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 820,
"wires": [
[
"a1c2637513bcd25a"
]
]
},
{
"id": "a1c2637513bcd25a",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Bypass_Press",
"name": "",
"x": 1400,
"y": 820,
"wires": []
},
{
"id": "b36cae50052a9649",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Major_Leak_Vac_Thress);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 880,
"wires": [
[
"a2213692848754c9"
]
]
},
{
"id": "a2213692848754c9",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Major_Leak",
"name": "",
"x": 1400,
"y": 880,
"wires": []
},
{
"id": "0a1865085a7a4e4b",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Minor_Leak_Vac_Thress);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 940,
"wires": [
[
"3398748315292e50"
]
]
},
{
"id": "3398748315292e50",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Minor_Leak",
"name": "",
"x": 1400,
"y": 940,
"wires": []
},
{
"id": "1b379945eaf99e4c",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Filling_Vol);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1000,
"wires": [
[
"0bcc4196985c0eb7"
]
]
},
{
"id": "0bcc4196985c0eb7",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Volume",
"name": "",
"x": 1380,
"y": 1000,
"wires": []
},
{
"id": "8495704a64d3d31f",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Thresshold_Filling_Press);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1060,
"wires": [
[
"ac93b58e1182bb88"
]
]
},
{
"id": "ac93b58e1182bb88",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Fill_Press",
"name": "",
"x": 1390,
"y": 1060,
"wires": []
},
{
"id": "baee5c6b318e2323",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.High_Pressure_Sett);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1120,
"wires": [
[
"cdbeffa13c0564c2"
]
]
},
{
"id": "cdbeffa13c0564c2",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_High_press",
"name": "",
"x": 1390,
"y": 1120,
"wires": []
},
{
"id": "8ce864de234336fb",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Rising_on_Pressure_Sett);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1180,
"wires": [
[
"197534469d89658b"
]
]
},
{
"id": "197534469d89658b",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Rising_Press",
"name": "",
"x": 1400,
"y": 1180,
"wires": []
},
{
"id": "1a2b35f1e5188705",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Delta_Major_Leak);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1240,
"wires": [
[
"7dc23a90f2e94073"
]
]
},
{
"id": "7dc23a90f2e94073",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Delta_Major_Leak",
"name": "",
"x": 1420,
"y": 1240,
"wires": []
},
{
"id": "4712ddc965fd2bb7",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Delta_Minor_Leak);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1300,
"wires": [
[
"f751fb934d8903d6"
]
]
},
{
"id": "f751fb934d8903d6",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Delta_Minor_Leak",
"name": "",
"x": 1420,
"y": 1300,
"wires": []
},
{
"id": "768397b7354bd4d9",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Thress_Relase_To_Atmosphere);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1360,
"wires": [
[
"d9aa5fb84d2da8b7"
]
]
},
{
"id": "d9aa5fb84d2da8b7",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Thress_Release_Atmos",
"name": "",
"x": 1410,
"y": 1360,
"wires": []
},
{
"id": "26669af38719924a",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "var X = Number(msg.Bypass_Vol);\nmsg.payload = X;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 1160,
"y": 1420,
"wires": [
[
"1d4961f52a63a2f4"
]
]
},
{
"id": "1d4961f52a63a2f4",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "Bypass_Volume",
"name": "",
"x": 1380,
"y": 1420,
"wires": []
},
{
"id": "5fc2c53ae8b09ed9",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "msg.payload = \"SELECT Count(*) as C FROM [dbo].[CINETIC_CL] Where VC_NUMBER='\" + msg.payload +\"' and ACTIVE_STATUS='TRUE'\";\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 220,
"y": 680,
"wires": [
[
"b2bc830db1f6c33b"
]
]
},
{
"id": "9c78d088f703d4e9",
"type": "delay",
"z": "2c3c65980f08155d",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"allowrate": false,
"outputs": 1,
"x": 380,
"y": 780,
"wires": [
[
"b7c06f30f3f530d1"
]
]
},
{
"id": "b2bc830db1f6c33b",
"type": "MSSQL",
"z": "2c3c65980f08155d",
"mssqlCN": "c99f144d8449e5df",
"name": "",
"outField": "payload",
"returnType": 0,
"throwErrors": 1,
"query": "",
"modeOpt": "queryMode",
"modeOptType": "query",
"queryOpt": "payload",
"queryOptType": "editor",
"paramsOpt": "queryParams",
"paramsOptType": "none",
"rows": "rows",
"rowsType": "msg",
"parseMustache": true,
"params": [],
"x": 380,
"y": 680,
"wires": [
[
"536b1bb63ec0215e"
]
]
},
{
"id": "0d4d1dceeec6a99a",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "9e3077e4477f17fd",
"variable": "VC_FOUND",
"name": "",
"x": 770,
"y": 680,
"wires": []
},
{
"id": "f72d1c17f63c9d4a",
"type": "inject",
"z": "2c3c65980f08155d",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "51630139000R",
"payloadType": "str",
"x": 200,
"y": 580,
"wires": [
[
"5fc2c53ae8b09ed9",
"3622e5b21d30f0a8"
]
]
},
{
"id": "f89e5a3077b40348",
"type": "s7 out",
"z": "2c3c65980f08155d",
"endpoint": "c82a032992b64776",
"variable": "DB500,INT2.3",
"name": "",
"x": 820,
"y": 540,
"wires": []
},
{
"id": "59aa9bea4e651261",
"type": "function",
"z": "2c3c65980f08155d",
"name": "",
"func": "\nvar B = Number(10);\nvar C = Number(11);\nvar D = Number(12);\nlet newmsg = [[{\n \"Prevac_T\": B,\n},\n{\n \"Vacuum1_T\": C,\n},\n{\n \"Vacuum_Check_T\": D,\n}, \n]]\nmsg.payload = newmsg;\nreturn msg;\n",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 620,
"y": 540,
"wires": [
[
"f89e5a3077b40348"
]
]
},
{
"id": "9e3077e4477f17fd",
"type": "s7 endpoint",
"transport": "iso-on-tcp",
"address": "192.168.0.9",
"port": "102",
"rack": "0",
"slot": "2",
"localtsaphi": "01",
"localtsaplo": "00",
"remotetsaphi": "01",
"remotetsaplo": "00",
"connmode": "rack-slot",
"adapter": "",
"busaddr": "2",
"cycletime": "1000",
"timeout": "2000",
"name": "CINETIC_CL_CONFIG",
"vartable": [
{
"addr": "DB460,INT2",
"name": "PreVac"
},
{
"addr": "DB460,INT4",
"name": "Vacuum1"
},
{
"addr": "DB460,INT6",
"name": "Vacuum_Check"
},
{
"addr": "DB460,INT8",
"name": "Vacuum2"
},
{
"addr": "DB460,INT10",
"name": "Radiator_Fill_Time"
},
{
"addr": "DB460,INT12",
"name": "Levelling1_Time"
},
{
"addr": "DB460,INT14",
"name": "Levelling2_Time"
},
{
"addr": "DB460,INT16",
"name": "Cleaning_Time"
},
{
"addr": "DB460,INT18",
"name": "Pressureziation_Time"
},
{
"addr": "DB460,INT20",
"name": "Stablization_Time"
},
{
"addr": "DB460,INT22",
"name": "Pressure_Test_Time"
},
{
"addr": "DB460,INT24",
"name": "Relase_To_Atnosphere_Time"
},
{
"addr": "DB460,INT28",
"name": "Thress_Bypass_Press"
},
{
"addr": "DB460,INT30",
"name": "Thress_Major_Leak"
},
{
"addr": "DB460,INT32",
"name": "Thress_Minor_Leak"
},
{
"addr": "DB460,INT34",
"name": "Thress_Volume"
},
{
"addr": "DB460,INT36",
"name": "Thress_Fill_Press"
},
{
"addr": "DB460,INT38",
"name": "Thress_High_press"
},
{
"addr": "DB460,INT40",
"name": "Thress_Rising_Press"
},
{
"addr": "DB460,INT42",
"name": "Thress_Delta_Major_Leak"
},
{
"addr": "DB460,INT44",
"name": "Thress_Delta_Minor_Leak"
},
{
"addr": "DB460,INT46",
"name": "Thress_Release_Atmos"
},
{
"addr": "DB460,INT48",
"name": "Bypass_Volume"
},
{
"addr": "DB460,X50.0",
"name": "VC_FOUND"
}
]
},
{
"id": "738faa0edbcf8dbf",
"type": "s7 endpoint",
"transport": "iso-on-tcp",
"address": "192.168.0.9",
"port": "102",
"rack": "0",
"slot": "2",
"localtsaphi": "01",
"localtsaplo": "00",
"remotetsaphi": "01",
"remotetsaplo": "00",
"connmode": "rack-slot",
"adapter": "",
"busaddr": "2",
"cycletime": "1000",
"timeout": "2000",
"name": "CINETIC_CL",
"vartable": [
{
"addr": "DB51,S24.12",
"name": "VC_READ1"
}
]
},
{
"id": "c99f144d8449e5df",
"type": "MSSQL-CN",
"tdsVersion": "7_4",
"name": "L3_CONFIG",
"server": "172.27.198.58",
"port": "1433",
"encyption": false,
"trustServerCertificate": false,
"database": "LINE_CONFIGURATOR_V1",
"useUTC": true,
"connectTimeout": "15000",
"requestTimeout": "15000",
"cancelTimeout": "5000",
"pool": "1",
"parseJSON": false,
"enableArithAbort": true
},
{
"id": "c82a032992b64776",
"type": "s7 endpoint",
"transport": "iso-on-tcp",
"address": "192.168.0.9",
"port": "102",
"rack": "0",
"slot": "2",
"localtsaphi": "01",
"localtsaplo": "00",
"remotetsaphi": "01",
"remotetsaplo": "00",
"connmode": "rack-slot",
"adapter": "",
"busaddr": "2",
"cycletime": "1000",
"timeout": "2000",
"name": "",
"vartable": [
{
"addr": "DB500,INT2.3",
"name": "DB500,INT2.3"
}
]
}
]