Google Spreadsheet Plugin Version 0.1 - ALPHA

http://automagucally.weebly.com

Moderators: davka003, Telldus

Post Reply
KHolm
Posts: 163
Joined: Thu Jan 18, 2018 11:08 am

Google Spreadsheet Plugin Version 0.1 - ALPHA

Post by KHolm » Thu Jan 18, 2018 11:08 am

Hi,

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:
googlespread.JPG
googlespread.JPG (21.19 KiB) Viewed 4291 times


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:
wem_to_googlespread.JPG
wem_to_googlespread.JPG (32.61 KiB) Viewed 4291 times


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.

/Marcus
ps. The external plugin can be found here: https://github.com/burnash/gspread
Attachments
googlespread_ver_0.1.zip
(1.98 KiB) Downloaded 167 times
Last edited by KHolm on Tue Mar 04, 2014 10:09 pm, edited 1 time in total.

KHolm
Posts: 163
Joined: Thu Jan 18, 2018 11:08 am

Re: Google Spreadsheet Plugin Version 0.1 - ALPHA

Post by KHolm » Thu Jan 18, 2018 11:08 am

KHolm wrote:The result will look like....(see next post, I'm limited to 3 attachments per post by forum admin).

The next post with the screenshot from Google Spreadsheets:
google_automagically.JPG
google_automagically.JPG (49.6 KiB) Viewed 4290 times


/Marcus

Post Reply