Hello,
I am in the process of helping my dad set up 2 GEM monitors and a ECM-1240 (one GEM in the main 200A panel, one GEM in a 100A sub panel, and the ECM in a 100A sub panel).
I have the ECM set up and recording to a SQL database every second.
The problem I am having is I need the GEM to do the same. I also need some way of accessing and processing this data in SQL to make nice graphs for my dad. I would like to be able to hold on to data for up to 2 years for comparison purposes (year to year), if that is possible. The SQL server I have set up has 80GB of drive space.
I am not much of a programmer, I work mostly with networking (Cisco). Any help anyone can give would be greatly appreciated!
Whole house monitoring project
-
- Posts: 11
- Joined: Sat Dec 27, 2014 6:12 pm
-
- Site Admin
- Posts: 4266
- Joined: Fri Jun 04, 2010 9:39 am
Re: Whole house monitoring project
Hello,Hikyuuri wrote:Hello,
I am in the process of helping my dad set up 2 GEM monitors and a ECM-1240 (one GEM in the main 200A panel, one GEM in a 100A sub panel, and the ECM in a 100A sub panel).
I have the ECM set up and recording to a SQL database every second.
The problem I am having is I need the GEM to do the same. I also need some way of accessing and processing this data in SQL to make nice graphs for my dad. I would like to be able to hold on to data for up to 2 years for comparison purposes (year to year), if that is possible. The SQL server I have set up has 80GB of drive space.
I am not much of a programmer, I work mostly with networking (Cisco). Any help anyone can give would be greatly appreciated!
Have you looked into using BTMon.py (http://lancet.mit.edu/mwall/projects/power/)? It can feed multiple different SQL database types, integrate with a few dashboards, etc.
Ben
Brultech Research Inc.
E: ben(at)brultech.com
Brultech Research Inc.
E: ben(at)brultech.com