So building on my smarterproject, Andrew Potter has released pge-to-google-powermeter, which takes the PG&E data and uploads it to Google Power meter. This is a really cool development, as Google Powermeter is a much more intuitive interface for the data.

I’ve set it up to upload my personal energy data and I am going to try it out for a bit. If everything runs smoothly then I’ll work on simplifying it for others.

One annoying thing to point out is that PG&E seems to have a two day lag in retrieving their data. So the most recent data that you can access is from two days ago.

For the more adventrous here are the steps currently required below:

  1. git clone git://github.com/mcolyer/smartermeter.git
  2. cd smartermeter
  3. bundle install (gem install bundler, if you don’t have it)
  4. bundle exec ruby bin/run.rb PGE_USERNAME PGE_PASSWORD > data.csv
  5. git clone git://gitorious.org/pge-to-google-powermeter/pge-to-google-powermeter.git
  6. cd pge-to-google-powermeter
  7. Download and extract the latest python api from http://code.google.com/p/google-powermeter-api-client/downloads/list directly into (not in another folder) pge-to-google-powermeter.
  8. Then create a “device” by visiting this address https://www.google.com/powermeter/device/activate?mfg=Acme&model=Meter&did=123&dvars=1
  9. Copy the authinfo and save it into a file called authinfo in the pge-to-powermeter directory, we’ll be coming back to this so don’t close this window.
  10. Open the file and copy out the token, it will not be referred to as TOKEN. Then copy out the path variable, append a .d1 to the end and it will now be called VAR.
  11. Run python pge2google.py --token TOKEN --variable VAR ../smartermeter/data.csv
  12. Now refresh the page where you created the powermeter at google. It should say it has received data.