A first experimental version of a Google Spreadsheet plugin is now released in it's early stages. It has a dependency to an external plugin (gspread), so not very likely that it will be included in Automagically's main trunk.
It takes the following (self-explanatory) settings: It can successfully be used in combination with the Wireless Energy Meter Plugin Version 0.6 just provided in this post: http://www.telldus.com/forum/viewtopic. ... =15#p25178
Just add a transform as per below picture: If you need a spreadsheet to work with, you can you can use this template:
https://docs.google.com/spreadsheet/ccc ... Gc&newcopy
Follow these steps after having updated to version 0.6 of the Wireless Energy Meter, as per instruction here: http://www.telldus.com/forum/viewtopic. ... =15#p25178
Code: Select all
$ sudo apt-get install wget
$ sudo apt-get install unzip
$ sudo pip install gspread
$ sudo service automagically stop
$ cd ~/downloads/
$ wget http://www.telldus.com/forum/download/file.php?id=439 -O googlespread.zip
$ unzip googlespread.zip
$ cp ~/download/googlespread.py ~/source/automagically/site/plugins/.
$ sudo service automagically start
Be careful with this, the data can quickly grow out of proportions and I don't know how Google Spreadsheet behaves.
Feel free to review the code and propose changes. For now, I'm satisfied with what it does; but someone else might want something more/something else.
Oh, by the way. Send "googlespread,addrow,Meaning,Of,Life,42" as a signal to try it out, before connecting it wo Wireless Energy Monitor. The more arguments in the list, the more will be written to the spreadsheet.
/Marcus
ps. The external plugin can be found here: https://github.com/burnash/gspread