Hi again,
I've followed your guide (hoping am doing it in the right way).
This is not allowing me to upload the json file. So I'll paste that here.
[
{
"id": "6fcf1b94141223d4",
"type": "inject",
"z": "05a3e40a24ac33e4",
"name": "temp",
"props": [
{
"p": "payload"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 310,
"y": 520,
"wires": [
[
"d455797331e7e193",
"fcbf31eb7b30634e",
"e09c718f76df8566",
"649d872205dbacc4"
]
]
},
{
"id": "d455797331e7e193",
"type": "ppTHERMO",
"z": "05a3e40a24ac33e4",
"config_plate": "7cb7053c56f101da",
"name": "Tem.1",
"channel": "1",
"scale": "c",
"tc_type": "k",
"x": 530,
"y": 520,
"wires": [
[
"bfe25697273883b3"
]
]
},
{
"id": "fcbf31eb7b30634e",
"type": "ppTHERMO",
"z": "05a3e40a24ac33e4",
"config_plate": "7cb7053c56f101da",
"name": "Tem.2",
"channel": "2",
"scale": "c",
"tc_type": "k",
"x": 530,
"y": 580,
"wires": [
[
"2aece502dae61a40"
]
]
},
{
"id": "e09c718f76df8566",
"type": "ppTHERMO",
"z": "05a3e40a24ac33e4",
"config_plate": "7cb7053c56f101da",
"name": "Tem.3",
"channel": "3",
"scale": "c",
"tc_type": "k",
"x": 530,
"y": 640,
"wires": [
[
"54440b3e54e98fe8"
]
]
},
{
"id": "54440b3e54e98fe8",
"type": "change",
"z": "05a3e40a24ac33e4",
"name": "Tem3",
"rules": [
{
"t": "set",
"p": "queryParameters.sensor_id",
"pt": "msg",
"to": "3",
"tot": "num"
},
{
"t": "set",
"p": "queryParameters.value",
"pt": "msg",
"to": "payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 730,
"y": 640,
"wires": [
[
"fadebb7369031b70",
"623cfe00b8c4c581"
]
]
},
{
"id": "2aece502dae61a40",
"type": "change",
"z": "05a3e40a24ac33e4",
"name": "Tem2",
"rules": [
{
"t": "set",
"p": "queryParameters.sensor_id",
"pt": "msg",
"to": "2",
"tot": "num"
},
{
"t": "set",
"p": "queryParameters.value",
"pt": "msg",
"to": "payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 730,
"y": 580,
"wires": [
[
"fadebb7369031b70",
"d3859e23f7ec49cb"
]
]
},
{
"id": "bfe25697273883b3",
"type": "change",
"z": "05a3e40a24ac33e4",
"name": "Tem1",
"rules": [
{
"t": "set",
"p": "queryParameters.sensor_id",
"pt": "msg",
"to": "1",
"tot": "num"
},
{
"t": "set",
"p": "queryParameters.value",
"pt": "msg",
"to": "payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 730,
"y": 520,
"wires": [
[
"fadebb7369031b70",
"195a1dcc565e0168"
]
]
},
{
"id": "fadebb7369031b70",
"type": "postgresql",
"z": "05a3e40a24ac33e4",
"name": "data",
"query": "INSERT INTO sensor_data (sensor_id,value)\nVALUES ($sensor_id,$value);",
"postgreSQLConfig": "c74e67cc43a6d4d2",
"split": false,
"rowsPerMsg": 1,
"outputs": 1,
"x": 1010,
"y": 440,
"wires": [
[
"587ed105ddf94980"
]
]
},
{
"id": "7cb7053c56f101da",
"type": "pi_plate",
"model": "THERMOplate",
"address": "0"
},
{
"id": "c74e67cc43a6d4d2",
"type": "postgreSQLConfig",
"name": "",
"host": "",
"hostFieldType": "str",
"port": "",
"portFieldType": "num",
"database": "",
"databaseFieldType": "str",
"ssl": "false",
"sslFieldType": "bool",
"applicationName": "",
"applicationNameType": "str",
"max": "10",
"maxFieldType": "num",
"idle": "1000",
"idleFieldType": "num",
"connectionTimeout": "10000",
"connectionTimeoutFieldType": "num",
"user": "",
"userFieldType": "str",
"password": "",
"passwordFieldType": "str"
}
]
and the psql table. And I am getting this error
can you please guide me through this.
Thank You!