Re: windmill blades turning?

2014-10-17 Thread Nicholas Clark
On Wed, Oct 15, 2014 at 07:52:37PM +0100, Steve Mynott wrote:
 On 15 October 2014 15:09, Nicholas Clark n...@ccl4.org wrote:
  On Tue, Oct 14, 2014 at 08:44:54AM +0100, Sue Spence wrote:
  This message took an hour to arrive, as opposed to 3-4 hours. So some
  progress has been made.
 
  I approve of this tilting at windmills, and would welcome the opportunity
  to buy Steve appropriate beer* once he considers the job done.
 
  Nicholas Clark
 
  * or malt, or whatever. Although I hope that it's malt by choice, not by
desperation.
 
 Single Malt not Malt beer!

I wasn't really aware of what malt beer is. Having now looked it up, most
definately, malt whiske?y.

Although a pint of scotch is always an option, in the right parts of the
world.

Nicholas Clark


Re: windmill blades turning?

2014-10-17 Thread James Laver
On 17 Oct 2014, at 09:02, Nicholas Clark n...@ccl4.org wrote:

 Single Malt not Malt beer!
 
 I wasn't really aware of what malt beer is. Having now looked it up, most
 definately, malt whiske?y.

When I lived in Shepherd’s Bush, it was everywhere. I think I’ve only ever seen 
one person with a bottle, mind.

 Although a pint of scotch is always an option, in the right parts of the
 world.

I believe lathos described it as a london.pm drinking game called “have a shot 
every time you have a shot”.

James


Re: google spreadsheet API login woes

2014-10-17 Thread Bob MacCallum
Thanks Steve and Simon,

It looks like the days of running a simple script against Google services
authorised by just username and password are long gone.

The beauty of my spreadsheet file grabber was that anyone could use it
without registering API keys etc and also that it only took half an hour to
write!



On Thu, Oct 16, 2014 at 6:28 PM, Steve Mynott steve.myn...@gmail.com
wrote:

 On 16 October 2014 16:59, Simon Wistow si...@thegestalt.org wrote:
  On Thu, Oct 16, 2014 at 12:35:18PM +0100, Bob MacCallum said:
  It's stopped working recently (can't say exactly when) - and I don't
 know
  my AuthSub from my OAuth from my elbow.
 
  I've tried
 
  my $auth = Net::Google::AuthSub-new;
  my $res  = $auth-login($user, $pass);
 
  I wrote Net::Google::AuthSub but I haven't used it for years and so it
  may be very, very out of date.

 It didn't seem to work when I tried it a few weeks back despite
 Google's claims of AuthSub being still supported until next year.
 They probably changed something.  It's all very geared to their own
 API libs not 3rd party ones for unsupported languages like Perl.
 AuthSub is deprecated in favour of OAuth (which is pretty dreadful as
 demonstrated by the YAPC::EU Oauth Dance).

 I successfully accessed Google Calendar last month with a lot of
 difficulty by doing the following:

 Google::API::Client via  git clone
 https://github.com/comewalk/google-api-perl-client.git

 Used https://console.developers.google.com/project  (different to the
 similarly named Google Play one!)

 Note this does not work and doesn't give any warnings of not working
 in a Firefox type browser I had to use Chrome.

 I had to google several errors on stackoverflow (and noticed assorted
 whines) to get the exact workflow in the dev console correct.

 APIs  Auth

 1. Google Calender ON

 2. CredCreate new client ID Installed Application

 3. Also enter Email Address and minimal details in Consent Screen

 $ cd google-api-perl-client/eg

 edit client_secrets.json with your client_id

 $ cd calendar

 $ perl -I ../lib/ calendarlist.pl

 Click on URI generated (I again had problems with Firefox and had to
 use Chrome in order to copy and paste)

 copy auth token back to command line

 (this token is saved in the json and next time you run you aren't
 prompted with url).

 I was then able to access Google Calendar.

 It's sure to time out and you probably have to refresh it.

 I'd probably avoid Google Services after this experience unless I was
 being paid to do it.  It's aimed at professional phone app devs not
 hobbyist use.

 I suspect it changes quite frequently too.

 S