myEnerSave Uploader for ECM-1240...

[Verohomie]

Hi All -

In response to Google PowerMeter going away, I modified existing Python code to POST data to myEnerSave. It has a simple GUI, works with both RS-232 and TCP/IP, and self installs.

Download the myEnerSave Uploader program from: http://www.greenhomegear.com/files/PC/ecm2es.zip This program is still in BETA. Please let me know if you find it useful. Also, if you have Python experience and would like to help add multi-ECM support please contact me.

The TCP/IP Port method typically connects to EngineG's client located in Forward Data > Home Automation Plugin > Custom > Client. Point the IP address to the PC running the program. Pick a non-used Port and enable. When the program starts, the built-in server connects with EngineG's client which passes binary energy data packets to the Uploader program.

The Serial method connects directly to the ECM-1240 - OR - via a great utility program that parallels RS-232 ports so data is available to many programs. The XPort utility can be found at: http://www.curioustech.net/downloads/xport150.zip

Brad Norman
brad )at( green home geardotcom
772-257-onethousand USA EST

[markmon]

http://www.greenhomegear.com/files/PC/ecm2es.zip is a dead link. Do we have a working link?

[Verohomie]

The latest is http://www.greenhomegear.com/files/pc/e ... a_v0.5.zip

Still need to add multi ECM support. Please email me if you have Python experience.

Thanks - brad )at( green home geardotcom

[dzrtrataz]

When I click the link. It comes up page not found.

Found a working link. http://www.greenhomegear.com/files/pc/

[Verohomie]

F****** wierd.

The URL link is broken BUT copy/paste to browser works???

http://www.greenhomegear.com/files/pc/e ... a_v0.5.zip

Wierd... Brad

[ben]

F****** wierd.

The URL link is broken BUT copy/paste to browser works???

http://www.greenhomegear.com/files/pc/e ... a_v0.5.zip

Wierd... Brad

That is strange, once downloaded it works also.

Might be a cache thing, have you restarted the web service in awhile?

[mwall]

There is an update to ecmread.py available here:

http://lancet.mit.edu/mwall/projects/power

This update supports any number ECM via both serial and ip, does more checks to filter out corrupt packets, and enables uploads to multiple services, not just a single one. PlotWatt is working now. Support for WattzOn, PlotWatt, PeoplePower, Eragy, and EnerSave is being tested now and should be available soon.

Many thanks to the previous authors of and contributors to ecmread - their work made this much easier.

[gadgetguru69]

mwall,
I know this is an old thread but was working with your code. I was wondering if you have tried pushing the data out to MSSql Express db. I have other stuff going into one from my other systems and would like to get this data into there also. Any help would be appreciated.

[mwall]

you should be able to configured and odbc source (on linux or windows), import the python pyodbc package, then create an ODBCProcessor using the MySQLProcessor or SqliteProcessor as a template. DatabaseProcessor defines the sql that writes data to the database. if you're on windows only, you could probably use native .net libraries in python, but you would still want to derive a MSSQLProcessor class from DatabaseProcessor.

if you want to collect data from a MSSQL database, let me know and i'll spend some time to refactor the DatabaseCollector so that it is not specific to MySQL.

please let me know how it goes. i should be able to help more once i've got the GEM compatibility finished.

m