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: viewtopic.php?f=25&t=4258&start=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: viewtopic.php?f=25&t=4258&start=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
The result will look like....(see next post, I'm limited to 3 attachements per post by forum admin).
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.
ps. The external plugin can be found here: https://github.com/burnash/gspread