@tekka Wow cool that's what I've been looking for! Thanks!
Justin Lim
@Justin Lim
Best posts made by Justin Lim
Latest posts made by Justin Lim
-
RE: Parsing the sensor data received by gateway and storing in DB
-
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!
-
RE: Windows GUI/Controller for MySensors
@tekka This GUI is great help especially for beginners like me who don't understand what the serial messages mean! You extract all the information so well and so beautifully.
Hope its not too much to ask, but may I take a look at the source code? Because I need to know the method you used to extract the messages, as well as tying the data to the proper fields. I somehow need to push all of these data to the proper fields in my database and I'm stuck at deciphering the messages being received. Thanks in advance and cheers!