I need some database input

Notice: Page may contain affiliate links for which we may earn a small commission through services like Amazon Affiliates or Skimlinks.

S-F

Member
Feb 9, 2011
148
5
18
I have a home automation system and I'm starting to log everything it does. I'm planning on putting this all in some kind of database somehow. Here's the rub. I am not a programmer. So I need to know where to start and if this is even a reasonable ambition. Is this going to be something I'm going to be able to accomplish without devoting thousands of hours and years of study?

My goals:

I would like to be able to have a database that can record all of the data produced by my home automation system. I would also like to be able to manually make entries. Like "Joe visited yesterday from 5:30 PM to 9:15 PM. I'd also like to be able to query and add information in a natural language fashion. I ultimately would like something like this:

http://blog.abodit.com/2011/09/remem...-term-project/

Does anyone have any insight into how I could go about this or how feasible it is?
 

dba

Moderator
Feb 20, 2012
1,477
184
63
San Francisco Bay Area, California, USA
My guess is that you'll need to start learning a bit of programming if you are going to take on such a project. It's easier than you think.

Above and beyond that, your goals are so broad and your options so numerous that it's difficult to provide any useful advice.
 

MiniKnight

Well-Known Member
Mar 30, 2012
3,072
973
113
NYC
I would start by just logging entries in a DB or even a text file. Get a good dataset. Then figure out what to do with it as you learn.
 

Salami

New Member
Oct 12, 2012
31
1
0
1) What data specifically does your automation system create? CSV files, something else?

2) Are you looking to run this on Windows?

This will not take you thousands of hours. I think you are looking at about a 20 hour project if the automation output is easy to work with.
 

mackle

Active Member
Nov 13, 2013
221
40
28
If you're not a programmer I'd expect it to take a bit longer than 20 hours. Not thousands, but there is a bit of a learning curve and searching for solutions (for example at stackoverflow) can be time consuming. Years ago now I set up a logging script to parse information about my computer's stats, store them (in CSV and mysql) and display them on a website. A SCADA, but I never got to the control stage... :( Like many projects, the more I worked on it, the more cool features I realised I could incorporate and achieve. And the last version I worked on looked little like my initial approach. But I also learnt a heap and to this day still refer to my code.

I'd definitely recommend starting out with a csv log file and mysql database from the start, and have them running side by side. When I started out with my logging I was able to do everything in a shell script that was set to cron-job, but depending on the automation software output you may need to look at using a python-type software...

It'd be good to split the task into at least four different components - how you can 'collate' the data, how you can 'process' the data, how you can 'store' the data and then how you 'display' your data. What I'd then do is look at incrementally building on the structure - start with one variable, like 'door status', and get that working from collation to storing, and then work from there.

Like dba says, if you want much more than that, more info would be needed for more useful advice.
 

S-F

Member
Feb 9, 2011
148
5
18
Great! Thanks for all the ideas guys!
I'm a bit busy right now but I'll get back to this in more detail later this evening.
 

TallGraham

Member
Apr 28, 2013
143
23
18
Hastings, England
Sounds like a nice little project and nothing too complicated, if you have done programming before. If you haven't then it is an ideal place to start as well. It will just take you longer and there will obviously be a learning curve.

I have been programming SQL databases for over 10 years. I have written many systems including order processing, call centre crm databases, audit process systems. Some of these dealt with 100's of tables and millions and millions of rows of data. Either way though don't be fooled by people who make out it is a dark art that requires geniuses to do it. I don't want to belittle people who do this work, but like anything if you take a logical approach then it isn't that complicated.

Start simple, and go from there. The first thing I would suggest is to make a simple list of what it is you want to store. This will be your data table structure. Then learn about the basic data types that you can give each column. Primary keys are a very important thing to read about and learn when you start with databases. Don't be scared though this stuff is very straight forward when you do it. When you start implementing things you will be like "Is that it!" :)

When it comes down to it most SQL is really just four commands. SELECT, INSERT, UPDATE, DELETE. There is quite a lot of different syntax that goes with them though that can be used.

My advice is:

-Take it slow and steady
-Don't try and do too much straight away
-Don't get disappointed if it doesn't work properly to start with, we all make mistakes
-Use the internet to help you.

This is a great website full of tutorials and references. I use it all the time when teaching people database stuff.

W3Schools Online Web Tutorials

Good luck :)
 
Last edited:

S-F

Member
Feb 9, 2011
148
5
18
So I currently am using a home automation platform which can give me cvs log information. I'm working on getting this sent to a folder on my file server (WHS 2011 with plenty of horse power and storage). The information looks like so:

Code:
[TABLE="class: google-visualization-table-table, width: 986"]
[TR="class: google-visualization-table-tr-head"]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]# [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Date/Time [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Class [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Device No. [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Device Name [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Variable [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Value [/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]44[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 12:18:22.787[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]43[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 12:18:07.198[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]42[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 12:13:57.200[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]41[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 12:13:42.181[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]40[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 08:20:00.251[/TD]
[TD="class: google-visualization-table-td"]K[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]23[/TD]
[TD="class: google-visualization-table-td"]The Thermostat[/TD]
[TD="class: google-visualization-table-td"]CurrentSetpoint[/TD]
[TD="class: google-visualization-table-td"]62[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]39[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 08:18:43.383[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 08:18:28.180[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]Colin Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]37[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:52:15.231[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]8[/TD]
[TD="class: google-visualization-table-td"]The Kitchen Chandelier[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]36[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:49:50.174[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]Deb Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:49:25.624[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]Deb Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]34[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:48:20.174[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]Deb Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]33[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:47:55.570[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]Deb Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]32[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:47:14.180[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]35[/TD]
[TD="class: google-visualization-table-td"]Deb Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]31[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:45:00.672[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]30[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:40:46.051[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]29[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:33:15.109[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]28[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:31:55.611[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]27[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:28:13.291[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]26[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:28:00.162[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]25[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:27:59.751[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]24[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:27:05.358[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]23[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:26:49.189[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]22[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:26:05.181[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]21[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 07:19:27.461[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]20[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:53:35.289[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]19[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:51:34.989[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]18[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:50:35.248[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]17[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:46:00.479[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:44:30.008[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]15[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:43:57.909[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]14[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:29:26.518[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]13[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:26:28.458[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]12[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:21:13.478[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]16[/TD]
[TD="class: google-visualization-table-td"]The Master Bedroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]11[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:15:00.249[/TD]
[TD="class: google-visualization-table-td"]K[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]23[/TD]
[TD="class: google-visualization-table-td"]The Thermostat[/TD]
[TD="class: google-visualization-table-td"]CurrentSetpoint[/TD]
[TD="class: google-visualization-table-td"]70[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:10:15.239[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]8[/TD]
[TD="class: google-visualization-table-td"]The Kitchen Chandelier[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]9[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 06:08:38.979[/TD]
[TD="class: google-visualization-table-td"]X[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]10[/TD]
[TD="class: google-visualization-table-td"]The Bathroom Light[/TD]
[TD="class: google-visualization-table-td"]Status[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]8[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 05:47:53.588[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]7[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 05:47:37.197[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]6[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 05:47:12.734[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]5[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 05:46:56.200[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]4[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 05:30:00.319[/TD]
[TD="class: google-visualization-table-td"]K[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]23[/TD]
[TD="class: google-visualization-table-td"]The Thermostat[/TD]
[TD="class: google-visualization-table-td"]CurrentSetpoint[/TD]
[TD="class: google-visualization-table-td"]67[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]3[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 02:33:51.364[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]1[/TD]
[/TR]
[TR="class: google-visualization-table-tr-even"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]2[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 02:31:29.191[/TD]
[TD="class: google-visualization-table-td"]S[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]38[/TD]
[TD="class: google-visualization-table-td"]Aurora Cell Phone Sensor[/TD]
[TD="class: google-visualization-table-td"]Tripped[/TD]
[TD="class: google-visualization-table-td"]0[/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd"]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]1[/TD]
[TD="class: google-visualization-table-td"]2014-01-17, 02:31:20.888[/TD]
[TD="class: google-visualization-table-td"]E[/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number"]0[/TD]
[TD="class: google-visualization-table-td"][/TD]
[TD="class: google-visualization-table-td"]Vera[/TD]
[TD="class: google-visualization-table-td"]RESTART[/TD]
[/TR]
[/TABLE]

[TABLE="class: google-visualization-table-table, width: 986"]
[TR="class: google-visualization-table-tr-head"]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]# [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Date/Time [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Class [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Device No. [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Device Name [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Variable [/TD]
[TD="class: google-visualization-table-th gradient google-visualization-table-sorthdr"]Value [/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-even, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[TR="class: google-visualization-table-tr-odd, bgcolor: transparent"]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td google-visualization-table-td-number, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[TD="class: google-visualization-table-td, bgcolor: transparent"][/TD]
[/TR]
[/TABLE]
I'm going to be moving to a different platform though in 6-8 months which uses SQL as it's underlying DB so I may be able to just use this.

I also would like the ability to add my own information. For example, I'd like to be able to log certain activities I do, like telling it when I did some work on my car or payed a bill. I couldn't insert this information into the DB for the future system but maybe I could have a seperate table for that information?

@TallGraham, Thanks for the link to W3Schools! That's the kind of thing I need.

Does anyone have any advice on where I should look and what I should look for regarding a convenient way to add my additional information? Also how about a natural language way to query the DB?

Thanks everyone! If there is any more information I can give that will help you all help me please let me know!
 
Last edited:

Mike

Member
May 29, 2012
482
16
18
EU
Look up a few of the scripting languages out there and watch a few good youtube tutorials to get a feel for it. Then just go write a few simple programs along with those tutorials and start to deviate from that. After a few tries you will feel confident enough to look up a few tutorials more or less doing parts of what you want the whole thing to do. I would start with something like Python in combination with (if you really have to) sqlite.
 

S-F

Member
Feb 9, 2011
148
5
18
I'm currently using Micasaverde Vera. I will be switching to HomeSeer once their new software has had some time to mature.
 

dba

Moderator
Feb 20, 2012
1,477
184
63
San Francisco Bay Area, California, USA
since you asked about an easy way to stuff log-style information into a database, I have to recommend the open source product Kettle. It's a graphical ETL (extract, transform, load) tool that has pre-built connectors to just about every data source, and is very easy to learn. You can, for example, build a "Transformation" that polls a folder for log files, reads the files that it finds, parses each file into records, does basically anything you need with the data, and then stuffs the results into one or more databases.

The fact that the tool is graphical means that creating Transformations is surprisingly easy. It also means that the results are "self documenting" - which means that they'll be easy to understand when you revisit them in six months.