Graph return data from tdtool-with-sensors.py

Moderator: Telldus

Post Reply
kamsvag
Posts: 63
Joined: Thu Jan 18, 2018 11:08 am

Graph return data from tdtool-with-sensors.py

Post by kamsvag » Thu Jan 18, 2018 11:08 am

Background;
I use a Tellstick NET for homeAutomation using live.telldus.com and controlling it all from a windows 8.1 unit using tdtool-with-sensors.py

To gather data from my sensors I've setup a scheduled task that runs a batchscript with the tdtool piped using >> to append new data to a loggfile.

So now I have this logfile that looks like following;

Code: Select all

Location	Unit	Value	Time
Garaget	temp	15.9	2015-02-22 12:16:59
Garaget	humidity	48	2015-02-22 12:16:59
Garaget	temp	15.9	2015-02-22 12:26:59
Garaget	humidity	46	2015-02-22 12:26:59
Garaget	temp	16.0	2015-02-22 12:37:59
Garaget	humidity	46	2015-02-22 12:37:59
Garaget	temp	16.0	2015-02-22 12:58:59
Garaget	humidity	48	2015-02-22 12:58:59
Garaget	temp	15.9	2015-02-22 13:08:59
Garaget	humidity	49	2015-02-22 13:08:59
Garaget	temp	16.3	2015-02-22 14:31:59
Garaget	humidity	48	2015-02-22 14:31:59
Garaget	temp	13.7	2015-02-23 14:20:58
Garaget	humidity	61	2015-02-23 14:20:58
Now I want to produce a automated graph using this data so I can easily spot variations and patterns in my sensors.
Where do I go from here. I can adjust the date/time to Unix time stamp if that helps.

I'd prefer to get the graph presented in web gui so I can easily browse it from where ever.

?

pglpgl
Posts: 3
Joined: Thu Jan 18, 2018 11:08 am

Re: Graph return data from tdtool-with-sensors.py

Post by pglpgl » Thu Jan 18, 2018 11:08 am

1. webhosting with databases + PHP + FTP
2. copy the values with ftp
3. Save values to the database
4. graphs for use https://developers.google.com/chart/

example http://teplota.moxo.cz/

Post Reply