Parsing the sensor data received by gateway and storing in DB
-
I have received these lines of data in my serial gateway
0;0;3;0;9;read: 1-1-0 s=2,c=1,t=16,pt=0,l=1:0
1;2;1;0;16;0
0;0;3;0;9;read: 1-1-0 s=0,c=1,t=4,pt=7,l=5:1007
1;0;1;0;4;1007
0;0;3;0;9;read: 1-1-0 s=1,c=1,t=0,pt=7,l=5:31.1
1;1;1;0;0;31.1I would like to ask, how do I get these values into a variable, parse it and then store it into my database?
I have an idea of using the gateway as a Web Client, and run a GET request towards a PHP file on my server. The file will parse all the data being sent and log it in the database, but now I'm stuck at categorizing the values into its respective fields.
Any help is appreciated. Thanks in advance!
-
I have received these lines of data in my serial gateway
0;0;3;0;9;read: 1-1-0 s=2,c=1,t=16,pt=0,l=1:0
1;2;1;0;16;0
0;0;3;0;9;read: 1-1-0 s=0,c=1,t=4,pt=7,l=5:1007
1;0;1;0;4;1007
0;0;3;0;9;read: 1-1-0 s=1,c=1,t=0,pt=7,l=5:31.1
1;1;1;0;0;31.1I would like to ask, how do I get these values into a variable, parse it and then store it into my database?
I have an idea of using the gateway as a Web Client, and run a GET request towards a PHP file on my server. The file will parse all the data being sent and log it in the database, but now I'm stuck at categorizing the values into its respective fields.
Any help is appreciated. Thanks in advance!
@Justin-Lim A good starting point is the serial protocol. There you will find all information you need.
-
@tekka Wow cool that's what I've been looking for! Thanks!
