Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Prothero@earthlearning via use-livecode]

Ben,
I’d find a sample stack to be useful. I’ll leave details of what constitutes a 
“library” to others. There are some best practices, tho. What I see is usually 
a text stack with that main handlers with a sample stack that demos basic calls.

That said, if you don’t have the time to get into the niceties, whatever you 
have would be useful.

Best,
Bill

William Prothero
http://es.earthednet.org

> On Jul 27, 2020, at 10:53 AM, Ben Rubinstein via use-livecode 
>  wrote:
> 
> Hi Bill (and Neville)
> 
> Happy to post it - I'll try to do a bit of cleanup and commenting first. 
> (Honestly I think it's probably just going to be an email to the list.) Afore 
> I do, I had this question:
> 
>> (I say library - currently it's a button I copy and paste to stacks where I
>> need it, and "insert the script of". I've completely lost track of how real
>> "libraries" should be packaged. Where should I look?)
> What is the currently approved method for a "library"?
> 
> TIA,
> 
> Ben
> 
>> On 22/07/2020 20:04, Prothero@earthlearning via use-livecode wrote:
>> Ben,
>> Any chance of posting a demo stack somewhere? It sounds very useful.
>> Thanks,
>> Bill
>> William Prothero
>> http://es.earthednet.org
 On Jul 22, 2020, at 10:13 AM, Ben Rubinstein via use-livecode 
  wrote:
>>> 
>>> Ah, shame. It turned out it was (IIUC) just a change in the way Google did 
>>> their tokens which exposed a bug, now fixed, in how LC did OAuth - nothing 
>>> to do with the general API changing.
>>> 
>>> At any rate, I do have a very basic library which I use to read and write 
>>> Google sheets, in case it's of use to anyone.
>>> 
>>> (I say library - currently it's a button I copy and paste to stacks where I 
>>> need it, and "insert the script of". I've completely lost track of how real 
>>> "libraries" should be packaged. Where should I look?)
>>> 
>>> Ben
>>> 
 On 21/07/2020 14:49, Mike Kerner wrote:
 I got impatient/spooked so we went another direction.  I think we're going 
 to use other tools.
 On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode 
 mailto:use-livecode@lists.runrev.com>> 
 wrote:
Hi Mike,
Brian Milby put me on to the solution for the OAuth problem:
 > Check out bug 22557 / PR 7381.
 > Line 247 of oath2.livecodescript need urlEncode removed
Are you still interested in this, or are you covered now?
regards,
Ben
On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
 > Hi Mike,
 >
 > I haven't forgotten, but finally found time to take a look today and
started
 > writing minimal comments, and thought I should at least test it - 
 for some
 > reason the authorisation isn't working. For whatever reason, the 
 call to
 > OAuth2 results in the error "Malformed auth code." So I can't get to
test what
 > I'm sending.
 >
 > I'm unclear whether I've done something strange or wrong, or whether
Google
 > has changed something that breaks LC's implementation. I've come 
 across
 > references which suggest that, but they date back to last year, and I
believe
 > I've used this stack in January. (I also tried using LC 9.0.4 with 
 the
same
 > result.)
 >
 > I will try to get back to this. In the meantime, have you - or 
 anyone -
found
 > issues recently with OAuth2, in particular against any of the Google 
 APIs?
 >
 > Ben
 >
 >
 > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
 >> it might help us get started.  i'm going to probably put out an rfq 
 to
wrap
 >> the v4 rest api, because we're going to have to come to a solution, 
 either
 >> using lc or some other tool.
 >>
 >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
 >> use-livecode@lists.runrev.com 
 >
wrote:
 >>
 >>> Mike,
 >>>
 >>> Very happy to share what I've got, but it's really not much - just 
 a very
 >>> thin
 >>> wrapper round Google's API - and it's undocumented, mostly rough 
 code -
 >>> copied
 >>> from one stack to the next, usually done in a tearing hurry!
 >>>
 >>> I'll try to pull something together, but please promise not to 
 judge
me...
 >>>
 >>> Ben
 >>>
 >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
  Ben,
  would you send me what you've got?  I was considering paying 
 someone to
  wrap the entire v4 api and dropping mergGoogle, so any head start 
 would
 >>> be
  useful.  LC wants tribute to do the work (which is a little
disappointing
 

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

Hi Bill (and Neville)

Happy to post it - I'll try to do a bit of cleanup and commenting first. 
(Honestly I think it's probably just going to be an email to the list.) Afore 
I do, I had this question:



(I say library - currently it's a button I copy and paste to stacks where I
need it, and "insert the script of". I've completely lost track of how real
"libraries" should be packaged. Where should I look?)

What is the currently approved method for a "library"?

TIA,

Ben

On 22/07/2020 20:04, Prothero@earthlearning via use-livecode wrote:

Ben,
Any chance of posting a demo stack somewhere? It sounds very useful.
Thanks,
Bill

William Prothero
http://es.earthednet.org


On Jul 22, 2020, at 10:13 AM, Ben Rubinstein via use-livecode 
 wrote:

Ah, shame. It turned out it was (IIUC) just a change in the way Google did 
their tokens which exposed a bug, now fixed, in how LC did OAuth - nothing to 
do with the general API changing.

At any rate, I do have a very basic library which I use to read and write 
Google sheets, in case it's of use to anyone.

(I say library - currently it's a button I copy and paste to stacks where I need it, and 
"insert the script of". I've completely lost track of how real "libraries" 
should be packaged. Where should I look?)

Ben


On 21/07/2020 14:49, Mike Kerner wrote:
I got impatient/spooked so we went another direction.  I think we're going to 
use other tools.
On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:
Hi Mike,
Brian Milby put me on to the solution for the OAuth problem:
 > Check out bug 22557 / PR 7381.
 > Line 247 of oath2.livecodescript need urlEncode removed
Are you still interested in this, or are you covered now?
regards,
Ben
On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
 > Hi Mike,
 >
 > I haven't forgotten, but finally found time to take a look today and
started
 > writing minimal comments, and thought I should at least test it - for 
some
 > reason the authorisation isn't working. For whatever reason, the call to
 > OAuth2 results in the error "Malformed auth code." So I can't get to
test what
 > I'm sending.
 >
 > I'm unclear whether I've done something strange or wrong, or whether
Google
 > has changed something that breaks LC's implementation. I've come across
 > references which suggest that, but they date back to last year, and I
believe
 > I've used this stack in January. (I also tried using LC 9.0.4 with the
same
 > result.)
 >
 > I will try to get back to this. In the meantime, have you - or anyone -
found
 > issues recently with OAuth2, in particular against any of the Google 
APIs?
 >
 > Ben
 >
 >
 > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
 >> it might help us get started.  i'm going to probably put out an rfq to
wrap
 >> the v4 rest api, because we're going to have to come to a solution, 
either
 >> using lc or some other tool.
 >>
 >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
 >> use-livecode@lists.runrev.com >
wrote:
 >>
 >>> Mike,
 >>>
 >>> Very happy to share what I've got, but it's really not much - just a 
very
 >>> thin
 >>> wrapper round Google's API - and it's undocumented, mostly rough code -
 >>> copied
 >>> from one stack to the next, usually done in a tearing hurry!
 >>>
 >>> I'll try to pull something together, but please promise not to judge
me...
 >>>
 >>> Ben
 >>>
 >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
  Ben,
  would you send me what you've got?  I was considering paying someone 
to
  wrap the entire v4 api and dropping mergGoogle, so any head start 
would
 >>> be
  useful.  LC wants tribute to do the work (which is a little
disappointing
  since we financed the original external, so we sort-of hoped that it
 >>> would
  become a thing, and it would get updated as required, but crap 
happens).
 
  On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
  use-livecode@lists.runrev.com
> wrote:
 
 > On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
 >> is anyone using anything besides mergGoogle to work with google
sheets?
 >> care to share, if you are?
 >
 > I'm just using the Google Sheets API directly from LiveCode - just
 >>> pushing
 > JSON back and forth. The API is limited, but what's there is very 
easy
 >>> to
 > work
 > with - much better than manipulating xlsx files.
 >
 > I started using it to get data from clients, and then processing data
 >>> and
 > pushing it back 

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Prothero@earthlearning via use-livecode]

Ben,
Any chance of posting a demo stack somewhere? It sounds very useful.
Thanks,
Bill

William Prothero
http://es.earthednet.org

> On Jul 22, 2020, at 10:13 AM, Ben Rubinstein via use-livecode 
>  wrote:
> 
> Ah, shame. It turned out it was (IIUC) just a change in the way Google did 
> their tokens which exposed a bug, now fixed, in how LC did OAuth - nothing to 
> do with the general API changing.
> 
> At any rate, I do have a very basic library which I use to read and write 
> Google sheets, in case it's of use to anyone.
> 
> (I say library - currently it's a button I copy and paste to stacks where I 
> need it, and "insert the script of". I've completely lost track of how real 
> "libraries" should be packaged. Where should I look?)
> 
> Ben
> 
>> On 21/07/2020 14:49, Mike Kerner wrote:
>> I got impatient/spooked so we went another direction.  I think we're going 
>> to use other tools.
>> On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode 
>> mailto:use-livecode@lists.runrev.com>> wrote:
>>Hi Mike,
>>Brian Milby put me on to the solution for the OAuth problem:
>> > Check out bug 22557 / PR 7381.
>> > Line 247 of oath2.livecodescript need urlEncode removed
>>Are you still interested in this, or are you covered now?
>>regards,
>>Ben
>>On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
>> > Hi Mike,
>> >
>> > I haven't forgotten, but finally found time to take a look today and
>>started
>> > writing minimal comments, and thought I should at least test it - for 
>> some
>> > reason the authorisation isn't working. For whatever reason, the call 
>> to
>> > OAuth2 results in the error "Malformed auth code." So I can't get to
>>test what
>> > I'm sending.
>> >
>> > I'm unclear whether I've done something strange or wrong, or whether
>>Google
>> > has changed something that breaks LC's implementation. I've come across
>> > references which suggest that, but they date back to last year, and I
>>believe
>> > I've used this stack in January. (I also tried using LC 9.0.4 with the
>>same
>> > result.)
>> >
>> > I will try to get back to this. In the meantime, have you - or anyone -
>>found
>> > issues recently with OAuth2, in particular against any of the Google 
>> APIs?
>> >
>> > Ben
>> >
>> >
>> > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
>> >> it might help us get started.  i'm going to probably put out an rfq to
>>wrap
>> >> the v4 rest api, because we're going to have to come to a solution, 
>> either
>> >> using lc or some other tool.
>> >>
>> >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
>> >> use-livecode@lists.runrev.com >
>>wrote:
>> >>
>> >>> Mike,
>> >>>
>> >>> Very happy to share what I've got, but it's really not much - just a 
>> very
>> >>> thin
>> >>> wrapper round Google's API - and it's undocumented, mostly rough 
>> code -
>> >>> copied
>> >>> from one stack to the next, usually done in a tearing hurry!
>> >>>
>> >>> I'll try to pull something together, but please promise not to judge
>>me...
>> >>>
>> >>> Ben
>> >>>
>> >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
>>  Ben,
>>  would you send me what you've got?  I was considering paying 
>> someone to
>>  wrap the entire v4 api and dropping mergGoogle, so any head start 
>> would
>> >>> be
>>  useful.  LC wants tribute to do the work (which is a little
>>disappointing
>>  since we financed the original external, so we sort-of hoped that it
>> >>> would
>>  become a thing, and it would get updated as required, but crap 
>> happens).
>> 
>>  On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
>>  use-livecode@lists.runrev.com
>>> wrote:
>> 
>> > On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
>> >> is anyone using anything besides mergGoogle to work with google
>>sheets?
>> >> care to share, if you are?
>> >
>> > I'm just using the Google Sheets API directly from LiveCode - just
>> >>> pushing
>> > JSON back and forth. The API is limited, but what's there is very 
>> easy
>> >>> to
>> > work
>> > with - much better than manipulating xlsx files.
>> >
>> > I started using it to get data from clients, and then processing 
>> data
>> >>> and
>> > pushing it back into the sheets. I've also used on some 
>> experimental
>> >>> image
>> > processing, where I found that pushing the results of LiveCode
>>functions
>> > into
>> > a google sheet immediately gave me an nice interface in which to 
>> review
>> > the
>>   

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

Ah, shame. It turned out it was (IIUC) just a change in the way Google did 
their tokens which exposed a bug, now fixed, in how LC did OAuth - nothing to 
do with the general API changing.


At any rate, I do have a very basic library which I use to read and write 
Google sheets, in case it's of use to anyone.


(I say library - currently it's a button I copy and paste to stacks where I 
need it, and "insert the script of". I've completely lost track of how real 
"libraries" should be packaged. Where should I look?)


Ben

On 21/07/2020 14:49, Mike Kerner wrote:
I got impatient/spooked so we went another direction.  I think we're going to 
use other tools.


On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode 
mailto:use-livecode@lists.runrev.com>> wrote:


Hi Mike,

Brian Milby put me on to the solution for the OAuth problem:
 > Check out bug 22557 / PR 7381.
 > Line 247 of oath2.livecodescript need urlEncode removed

Are you still interested in this, or are you covered now?

regards,

Ben

On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
 > Hi Mike,
 >
 > I haven't forgotten, but finally found time to take a look today and
started
 > writing minimal comments, and thought I should at least test it - for 
some
 > reason the authorisation isn't working. For whatever reason, the call to
 > OAuth2 results in the error "Malformed auth code." So I can't get to
test what
 > I'm sending.
 >
 > I'm unclear whether I've done something strange or wrong, or whether
Google
 > has changed something that breaks LC's implementation. I've come across
 > references which suggest that, but they date back to last year, and I
believe
 > I've used this stack in January. (I also tried using LC 9.0.4 with the
same
 > result.)
 >
 > I will try to get back to this. In the meantime, have you - or anyone -
found
 > issues recently with OAuth2, in particular against any of the Google 
APIs?
 >
 > Ben
 >
 >
 > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
 >> it might help us get started.  i'm going to probably put out an rfq to
wrap
 >> the v4 rest api, because we're going to have to come to a solution, 
either
 >> using lc or some other tool.
 >>
 >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
 >> use-livecode@lists.runrev.com >
wrote:
 >>
 >>> Mike,
 >>>
 >>> Very happy to share what I've got, but it's really not much - just a 
very
 >>> thin
 >>> wrapper round Google's API - and it's undocumented, mostly rough code -
 >>> copied
 >>> from one stack to the next, usually done in a tearing hurry!
 >>>
 >>> I'll try to pull something together, but please promise not to judge
me...
 >>>
 >>> Ben
 >>>
 >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
  Ben,
  would you send me what you've got?  I was considering paying someone 
to
  wrap the entire v4 api and dropping mergGoogle, so any head start 
would
 >>> be
  useful.  LC wants tribute to do the work (which is a little
disappointing
  since we financed the original external, so we sort-of hoped that it
 >>> would
  become a thing, and it would get updated as required, but crap 
happens).
 
  On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
  use-livecode@lists.runrev.com
> wrote:
 
 > On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
 >> is anyone using anything besides mergGoogle to work with google
sheets?
 >> care to share, if you are?
 >
 > I'm just using the Google Sheets API directly from LiveCode - just
 >>> pushing
 > JSON back and forth. The API is limited, but what's there is very 
easy
 >>> to
 > work
 > with - much better than manipulating xlsx files.
 >
 > I started using it to get data from clients, and then processing data
 >>> and
 > pushing it back into the sheets. I've also used on some experimental
 >>> image
 > processing, where I found that pushing the results of LiveCode
functions
 > into
 > a google sheet immediately gave me an nice interface in which to 
review
 > the
 > data, and then I could also use the spreadsheet functions to do
 >>> evaluation
 > and
 > testing.
 >
 > Ben
 >
 > 
 >
 > ___
 > use-livecode mailing list
 > use-livecode@lists.runrev.com 
 > Please visit this url to subscribe, unsubscribe and manage your
subscription
 > preferences:
 > 

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[JeeJeeStudio via use-livecode]

I once did that, to read out the values on a sheet. But I can't remember if
I used OAuth2 for that.

Op di 21 jul. 2020 15:51 schreef Mike Kerner via use-livecode <
use-livecode@lists.runrev.com>:

> I got impatient/spooked so we went another direction.  I think we're going
> to use other tools.
>
> On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > Hi Mike,
> >
> > Brian Milby put me on to the solution for the OAuth problem:
> > > Check out bug 22557 / PR 7381.
> > > Line 247 of oath2.livecodescript need urlEncode removed
> >
> > Are you still interested in this, or are you covered now?
> >
> > regards,
> >
> > Ben
> >
> > On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
> > > Hi Mike,
> > >
> > > I haven't forgotten, but finally found time to take a look today and
> > started
> > > writing minimal comments, and thought I should at least test it - for
> > some
> > > reason the authorisation isn't working. For whatever reason, the call
> to
> > > OAuth2 results in the error "Malformed auth code." So I can't get to
> > test what
> > > I'm sending.
> > >
> > > I'm unclear whether I've done something strange or wrong, or whether
> > Google
> > > has changed something that breaks LC's implementation. I've come across
> > > references which suggest that, but they date back to last year, and I
> > believe
> > > I've used this stack in January. (I also tried using LC 9.0.4 with the
> > same
> > > result.)
> > >
> > > I will try to get back to this. In the meantime, have you - or anyone -
> > found
> > > issues recently with OAuth2, in particular against any of the Google
> > APIs?
> > >
> > > Ben
> > >
> > >
> > > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
> > >> it might help us get started.  i'm going to probably put out an rfq to
> > wrap
> > >> the v4 rest api, because we're going to have to come to a solution,
> > either
> > >> using lc or some other tool.
> > >>
> > >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
> > >> use-livecode@lists.runrev.com> wrote:
> > >>
> > >>> Mike,
> > >>>
> > >>> Very happy to share what I've got, but it's really not much - just a
> > very
> > >>> thin
> > >>> wrapper round Google's API - and it's undocumented, mostly rough
> code -
> > >>> copied
> > >>> from one stack to the next, usually done in a tearing hurry!
> > >>>
> > >>> I'll try to pull something together, but please promise not to judge
> > me...
> > >>>
> > >>> Ben
> > >>>
> > >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
> >  Ben,
> >  would you send me what you've got?  I was considering paying someone
> > to
> >  wrap the entire v4 api and dropping mergGoogle, so any head start
> > would
> > >>> be
> >  useful.  LC wants tribute to do the work (which is a little
> > disappointing
> >  since we financed the original external, so we sort-of hoped that it
> > >>> would
> >  become a thing, and it would get updated as required, but crap
> > happens).
> > 
> >  On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
> >  use-livecode@lists.runrev.com> wrote:
> > 
> > > On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
> > >> is anyone using anything besides mergGoogle to work with google
> > sheets?
> > >> care to share, if you are?
> > >
> > > I'm just using the Google Sheets API directly from LiveCode - just
> > >>> pushing
> > > JSON back and forth. The API is limited, but what's there is very
> > easy
> > >>> to
> > > work
> > > with - much better than manipulating xlsx files.
> > >
> > > I started using it to get data from clients, and then processing
> data
> > >>> and
> > > pushing it back into the sheets. I've also used on some
> experimental
> > >>> image
> > > processing, where I found that pushing the results of LiveCode
> > functions
> > > into
> > > a google sheet immediately gave me an nice interface in which to
> > review
> > > the
> > > data, and then I could also use the spreadsheet functions to do
> > >>> evaluation
> > > and
> > > testing.
> > >
> > > Ben
> > >
> > > 
> > >
> > > ___
> > > use-livecode mailing list
> > > use-livecode@lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > subscription
> > > preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>and did a little 

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

I got impatient/spooked so we went another direction.  I think we're going
to use other tools.

On Thu, Jul 16, 2020 at 10:00 AM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi Mike,
>
> Brian Milby put me on to the solution for the OAuth problem:
> > Check out bug 22557 / PR 7381.
> > Line 247 of oath2.livecodescript need urlEncode removed
>
> Are you still interested in this, or are you covered now?
>
> regards,
>
> Ben
>
> On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:
> > Hi Mike,
> >
> > I haven't forgotten, but finally found time to take a look today and
> started
> > writing minimal comments, and thought I should at least test it - for
> some
> > reason the authorisation isn't working. For whatever reason, the call to
> > OAuth2 results in the error "Malformed auth code." So I can't get to
> test what
> > I'm sending.
> >
> > I'm unclear whether I've done something strange or wrong, or whether
> Google
> > has changed something that breaks LC's implementation. I've come across
> > references which suggest that, but they date back to last year, and I
> believe
> > I've used this stack in January. (I also tried using LC 9.0.4 with the
> same
> > result.)
> >
> > I will try to get back to this. In the meantime, have you - or anyone -
> found
> > issues recently with OAuth2, in particular against any of the Google
> APIs?
> >
> > Ben
> >
> >
> > On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
> >> it might help us get started.  i'm going to probably put out an rfq to
> wrap
> >> the v4 rest api, because we're going to have to come to a solution,
> either
> >> using lc or some other tool.
> >>
> >> On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
> >> use-livecode@lists.runrev.com> wrote:
> >>
> >>> Mike,
> >>>
> >>> Very happy to share what I've got, but it's really not much - just a
> very
> >>> thin
> >>> wrapper round Google's API - and it's undocumented, mostly rough code -
> >>> copied
> >>> from one stack to the next, usually done in a tearing hurry!
> >>>
> >>> I'll try to pull something together, but please promise not to judge
> me...
> >>>
> >>> Ben
> >>>
> >>> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
>  Ben,
>  would you send me what you've got?  I was considering paying someone
> to
>  wrap the entire v4 api and dropping mergGoogle, so any head start
> would
> >>> be
>  useful.  LC wants tribute to do the work (which is a little
> disappointing
>  since we financed the original external, so we sort-of hoped that it
> >>> would
>  become a thing, and it would get updated as required, but crap
> happens).
> 
>  On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
>  use-livecode@lists.runrev.com> wrote:
> 
> > On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
> >> is anyone using anything besides mergGoogle to work with google
> sheets?
> >> care to share, if you are?
> >
> > I'm just using the Google Sheets API directly from LiveCode - just
> >>> pushing
> > JSON back and forth. The API is limited, but what's there is very
> easy
> >>> to
> > work
> > with - much better than manipulating xlsx files.
> >
> > I started using it to get data from clients, and then processing data
> >>> and
> > pushing it back into the sheets. I've also used on some experimental
> >>> image
> > processing, where I found that pushing the results of LiveCode
> functions
> > into
> > a google sheet immediately gave me an nice interface in which to
> review
> > the
> > data, and then I could also use the spreadsheet functions to do
> >>> evaluation
> > and
> > testing.
> >
> > Ben
> >
> > 
> >
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription
> > preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

Hi Mike,

Brian Milby put me on to the solution for the OAuth problem:

Check out bug 22557 / PR 7381.
Line 247 of oath2.livecodescript need urlEncode removed


Are you still interested in this, or are you covered now?

regards,

Ben

On 11/03/2020 20:45, Ben Rubinstein via use-livecode wrote:

Hi Mike,

I haven't forgotten, but finally found time to take a look today and started 
writing minimal comments, and thought I should at least test it - for some 
reason the authorisation isn't working. For whatever reason, the call to 
OAuth2 results in the error "Malformed auth code." So I can't get to test what 
I'm sending.


I'm unclear whether I've done something strange or wrong, or whether Google 
has changed something that breaks LC's implementation. I've come across 
references which suggest that, but they date back to last year, and I believe 
I've used this stack in January. (I also tried using LC 9.0.4 with the same 
result.)


I will try to get back to this. In the meantime, have you - or anyone - found 
issues recently with OAuth2, in particular against any of the Google APIs?


Ben


On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:

it might help us get started.  i'm going to probably put out an rfq to wrap
the v4 rest api, because we're going to have to come to a solution, either
using lc or some other tool.

On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


Mike,

Very happy to share what I've got, but it's really not much - just a very
thin
wrapper round Google's API - and it's undocumented, mostly rough code -
copied
from one stack to the next, usually done in a tearing hurry!

I'll try to pull something together, but please promise not to judge me...

Ben

On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:

Ben,
would you send me what you've got?  I was considering paying someone to
wrap the entire v4 api and dropping mergGoogle, so any head start would

be

useful.  LC wants tribute to do the work (which is a little disappointing
since we financed the original external, so we sort-of hoped that it

would

become a thing, and it would get updated as required, but crap happens).

On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:

is anyone using anything besides mergGoogle to work with google sheets?
care to share, if you are?


I'm just using the Google Sheets API directly from LiveCode - just

pushing

JSON back and forth. The API is limited, but what's there is very easy

to

work
with - much better than manipulating xlsx files.

I started using it to get data from clients, and then processing data

and

pushing it back into the sheets. I've also used on some experimental

image

processing, where I found that pushing the results of LiveCode functions
into
a google sheet immediately gave me an nice interface in which to review
the
data, and then I could also use the spreadsheet functions to do

evaluation

and
testing.

Ben




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:

http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[R.H. via use-livecode]

@Matthias: "i found a forum post from mimu which included also a
GoogleCalendarTest stack.  http://forums.livecode.com/viewtopic.php?t=31840;

Yes, correct. Thanks for the hint! This is the one I am using. The scripts
are very good and allow to expand the idea of connecting to Google
Services. It needs some work first understanding the scripts. The main one
is in the card, but well documented.

Again, I think it would be more than helpful for all LC users and the
visibility of LiveCode on the market if there is something  "out of the
box" to connect to all kinds of OAuth2 main services since integration
becomes a major subject. I am not sure I can do this (giving time
constraints, otherwise I would). We will see...

Roland
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[matthias rebbe via use-livecode]

Roland,

i found a forum post from mimu which included also a GoogleCalendarTest stack.

http://forums.livecode.com/viewtopic.php?t=31840

Is that the one you are referring to?

Matthias



> Am 13.03.2020 um 14:00 schrieb R.H. via use-livecode 
> :
> 
> If this would help...
> 
> I am using OAuth2 with the Google Calendar with a stack that was originally
> developed by Denver77 and had been posted the stack "GoogleCalendarTest" to
> the Forum in 2018. It explains clearly how to use Google's oAuthClient and
> actually, I was able to receive the client id, the client secret and use
> Google's OAuth2 protocol.
> 
> Similar, it should work for Google Sheets, Contacts, GMail, etc.
> 
> And it works very well up to date. Only, the token needed to be renewed,
> and Google requires that the user logs in passing all the authentication
> and permission tests if the app has not been registered with Google. A
> Google account is required
> 
> I will ask permission to post this LiveCode Calendar
> "GoogeCalendarTest.livecode" solution again. Or is it still somewhere? I
> could not find on the Forum and other places. I made some changes to it.
> 
> Otherwise, I would try to recreate it if there is a need and also try to
> test it with Google sheets (which I am also using as some clients require
> them).
> 
> Using any Google apps, some basic JavaScript knowledge is usually helpful
> since Google Apps Script (based on JavaScript) is the predominant user
> language working with Google apps and it will have to be used in most cases
> if server work is needed. Google App Script is not client-side.
> 
> https://developers.google.com/apps-script/overview
> 
> Sure, I think, we should develop specialized LC OAuth2 libraries to access
> the apps of the big players and make them available for
> 
> - Google
> - Microsoft
> - Apple
> - Amazon
> - etc.
> 
> in a straight-forward way, or at least a step-by-step instruction how to
> use their products with LC -- which also needs constant monitoring and
> updating for changes such big players introduce from time to time.
> 
> Which end user in the corporate world does not work with GMail, GMail
> contacts, Microsoft Outlook, etc? At least these are standards in the
> corporate world and could increase the attractiveness of LC very much if LC
> would offer help for specialized tasks using such apps as their base.
> 
> Roland
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[R.H. via use-livecode]

If this would help...

I am using OAuth2 with the Google Calendar with a stack that was originally
developed by Denver77 and had been posted the stack "GoogleCalendarTest" to
the Forum in 2018. It explains clearly how to use Google's oAuthClient and
actually, I was able to receive the client id, the client secret and use
Google's OAuth2 protocol.

Similar, it should work for Google Sheets, Contacts, GMail, etc.

And it works very well up to date. Only, the token needed to be renewed,
and Google requires that the user logs in passing all the authentication
and permission tests if the app has not been registered with Google. A
Google account is required

I will ask permission to post this LiveCode Calendar
"GoogeCalendarTest.livecode" solution again. Or is it still somewhere? I
could not find on the Forum and other places. I made some changes to it.

Otherwise, I would try to recreate it if there is a need and also try to
test it with Google sheets (which I am also using as some clients require
them).

Using any Google apps, some basic JavaScript knowledge is usually helpful
since Google Apps Script (based on JavaScript) is the predominant user
language working with Google apps and it will have to be used in most cases
if server work is needed. Google App Script is not client-side.

https://developers.google.com/apps-script/overview

Sure, I think, we should develop specialized LC OAuth2 libraries to access
the apps of the big players and make them available for

- Google
- Microsoft
- Apple
- Amazon
- etc.

in a straight-forward way, or at least a step-by-step instruction how to
use their products with LC -- which also needs constant monitoring and
updating for changes such big players introduce from time to time.

Which end user in the corporate world does not work with GMail, GMail
contacts, Microsoft Outlook, etc? At least these are standards in the
corporate world and could increase the attractiveness of LC very much if LC
would offer help for specialized tasks using such apps as their base.

Roland
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

interesting.  i didn't realize the oauth routines were in an lcs library.
it's only 423 lines, and a lot of that is documentation.

On Thu, Mar 12, 2020 at 4:08 PM Ralph DiMola via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I have another type of slowdown on Win 10 that I can't get an exact recipe
> for because it doesn't happen every time. Open up the stack and everything
> is fast then open up the SE make some changes (no testing breakpoints used)
> and the card renders and then LC hangs for 10 to 40 seconds(not
> responding).
> The time it hangs is directly proportional to the amount of stuff on the
> card. When I tried to debug I did F11s until I reached the last "pass
> opencard" the one I guess goes to the engine. Everything is fast up to that
> point. Type an F11 and then LC hangs for 30 seconds before it comes back to
> life. Close the SE and it's fast again. Not as fast as a fresh open but
> fast
> enough to put the app through its paces. Maybe related to your problem?
>
> Even if we can't get a recipe for all of these issues maybe all of them put
> together will ring a bell at LC central?
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdim...@evergreeninfo.net
>
> -Original Message-
> From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On
> Behalf
> Of Richard Gaskin via use-livecode
> Sent: Thursday, March 12, 2020 2:47 PM
> To: use-livecode@lists.runrev.com
> Cc: Richard Gaskin
> Subject: Re: OAuth2 was Re: google sheets - anybody doing anything besides
> mergGoogle
>
> J. Landman Gay wrote:
>  > I wonder if the crashes are a problem with a different OS (I'm  > on
> Mac,) or something about your stack. I haven't had any debugging  > crashes
> since the fix was implemented.
> ...
>  > I know typing can be very slow on Windows but it  > isn't bad on Mac.
>
> I had an confounding experience last night along those lines:
>
> I have one project I normally run under Windows 10, and I'd found that each
> time an execution error is thrown it takes several seconds for the Script
> Editor to finally appear showing me the errant line.
>
> So I had a few spare minutes last night and figured I'd come up with a
> recipe to submit a bug report, and possibly even fix it if I could find a
> script bottleneck.
>
> No go.  In a fresh stack the SE opens almost immediately, pretty much as it
> does on my main Linux box and my Mac.
>
> So to diagnose this further I'm going to need to use my Flight Recorder
> tool
> (available in the Stacks section of LiveNet if interested), and log
> everything going on when the SE is trying to report a bug while my client's
> complex app is running.
>
> Because the issue isn't evident on Mac when working on the same client's
> project, I'm pretty sure there's something in the Win engine that could use
> some optimization.
>
> But given how it's only noticeable in certain projects and not others,
> pinning down the root cause has not been trivial.
>
> This doesn't have anything to do with typing per se, but does illustrate
> how
> difficult it can be to pin down bottlenecks, esp. when an issue shows up in
> one projects but not others.
>
> --
>   Richard Gaskin
>   Fourth World Systems
>   Software Design and Development for the Desktop, Mobile, and the Web
>   
>   ambassa...@fourthworld.comhttp://www.FourthWorld.com
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Ralph DiMola via use-livecode]

I have another type of slowdown on Win 10 that I can't get an exact recipe
for because it doesn't happen every time. Open up the stack and everything
is fast then open up the SE make some changes (no testing breakpoints used)
and the card renders and then LC hangs for 10 to 40 seconds(not responding).
The time it hangs is directly proportional to the amount of stuff on the
card. When I tried to debug I did F11s until I reached the last "pass
opencard" the one I guess goes to the engine. Everything is fast up to that
point. Type an F11 and then LC hangs for 30 seconds before it comes back to
life. Close the SE and it's fast again. Not as fast as a fresh open but fast
enough to put the app through its paces. Maybe related to your problem?

Even if we can't get a recipe for all of these issues maybe all of them put
together will ring a bell at LC central?

Ralph DiMola
IT Director
Evergreen Information Services
rdim...@evergreeninfo.net

-Original Message-
From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf
Of Richard Gaskin via use-livecode
Sent: Thursday, March 12, 2020 2:47 PM
To: use-livecode@lists.runrev.com
Cc: Richard Gaskin
Subject: Re: OAuth2 was Re: google sheets - anybody doing anything besides
mergGoogle

J. Landman Gay wrote:
 > I wonder if the crashes are a problem with a different OS (I'm  > on
Mac,) or something about your stack. I haven't had any debugging  > crashes
since the fix was implemented.
...
 > I know typing can be very slow on Windows but it  > isn't bad on Mac.

I had an confounding experience last night along those lines:

I have one project I normally run under Windows 10, and I'd found that each
time an execution error is thrown it takes several seconds for the Script
Editor to finally appear showing me the errant line.

So I had a few spare minutes last night and figured I'd come up with a
recipe to submit a bug report, and possibly even fix it if I could find a
script bottleneck.

No go.  In a fresh stack the SE opens almost immediately, pretty much as it
does on my main Linux box and my Mac.

So to diagnose this further I'm going to need to use my Flight Recorder tool
(available in the Stacks section of LiveNet if interested), and log
everything going on when the SE is trying to report a bug while my client's
complex app is running.

Because the issue isn't evident on Mac when working on the same client's
project, I'm pretty sure there's something in the Win engine that could use
some optimization.

But given how it's only noticeable in certain projects and not others,
pinning down the root cause has not been trivial.

This doesn't have anything to do with typing per se, but does illustrate how
difficult it can be to pin down bottlenecks, esp. when an issue shows up in
one projects but not others.

--
  Richard Gaskin
  Fourth World Systems
  Software Design and Development for the Desktop, Mobile, and the Web
  
  ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

J. Landman Gay wrote:
> I wonder if the crashes are a problem with a different OS (I'm
> on Mac,) or something about your stack. I haven't had any debugging
> crashes since the fix was implemented.
...
> I know typing can be very slow on Windows but it
> isn't bad on Mac.

I had an confounding experience last night along those lines:

I have one project I normally run under Windows 10, and I'd found that 
each time an execution error is thrown it takes several seconds for the 
Script Editor to finally appear showing me the errant line.


So I had a few spare minutes last night and figured I'd come up with a 
recipe to submit a bug report, and possibly even fix it if I could find 
a script bottleneck.


No go.  In a fresh stack the SE opens almost immediately, pretty much as 
it does on my main Linux box and my Mac.


So to diagnose this further I'm going to need to use my Flight Recorder 
tool (available in the Stacks section of LiveNet if interested), and log 
everything going on when the SE is trying to report a bug while my 
client's complex app is running.


Because the issue isn't evident on Mac when working on the same client's 
project, I'm pretty sure there's something in the Win engine that could 
use some optimization.


But given how it's only noticeable in certain projects and not others, 
pinning down the root cause has not been trivial.


This doesn't have anything to do with typing per se, but does illustrate 
how difficult it can be to pin down bottlenecks, esp. when an issue 
shows up in one projects but not others.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Bob Sneidar via use-livecode]

I also see the red dot misalignment (still using 9.5.1 rc 1). Since I use LC 
virtually every day to make changes and fixes to the app we use, I cannot 
really participate in DP's. 

Bob S


> On Mar 12, 2020, at 11:17 , J. Landman Gay via use-livecode 
>  wrote:
> 
> On 3/11/20 9:50 PM, Sean Cole (Pi) via use-livecode wrote:
>> 9.5.1 and 9.6 dp2 are still exhibiting breakpoint crashes. Not
>> as often as before but, still, there are occurrences. And for some very odd
>> reason an early sign it's going to become a problem I notice the line
>> numbers don't scroll with the script after I've run one with a breakpoint
>> that I've then stepped through - you know - so I can do my job and work out
>> where bugs are. When I see this I have to close the script editor and
>> reopen it to prevent it from crashing altogether - although sometimes it
>> gives no warning.
>> Next time I see it happening I'll do a screen recording so all can see it
>> in it's glory.
>> Counter to what Jacque says, it does not 'fix' itself. It persists until it
>> gives up. It still crashes occasionally.
> 
> I wonder if the crashes are a problem with a different OS (I'm on Mac,) or 
> something about your stack. I haven't had any debugging crashes since the fix 
> was implemented.
> 
> The misalignment of the script and the red dots was the issue I thought you 
> were talking about. I do see that. But if I begin to step through the script 
> (if debugging) it rights itself. Also, I just did a quick test and scrolling 
> didn't change the line numbers, so that may also point to a difference in the 
> OS the IDE is running on. I know typing can be very slow on Windows but it 
> isn't bad on Mac.
> 
> A recipe would be useful to the team.
> 
> -- 
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.com
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[J. Landman Gay via use-livecode]

On 3/11/20 9:50 PM, Sean Cole (Pi) via use-livecode wrote:

9.5.1 and 9.6 dp2 are still exhibiting breakpoint crashes. Not
as often as before but, still, there are occurrences. And for some very odd
reason an early sign it's going to become a problem I notice the line
numbers don't scroll with the script after I've run one with a breakpoint
that I've then stepped through - you know - so I can do my job and work out
where bugs are. When I see this I have to close the script editor and
reopen it to prevent it from crashing altogether - although sometimes it
gives no warning.

Next time I see it happening I'll do a screen recording so all can see it
in it's glory.

Counter to what Jacque says, it does not 'fix' itself. It persists until it
gives up. It still crashes occasionally.


I wonder if the crashes are a problem with a different OS (I'm on Mac,) or something about your 
stack. I haven't had any debugging crashes since the fix was implemented.


The misalignment of the script and the red dots was the issue I thought you were talking about. 
I do see that. But if I begin to step through the script (if debugging) it rights itself. Also, 
I just did a quick test and scrolling didn't change the line numbers, so that may also point to 
a difference in the OS the IDE is running on. I know typing can be very slow on Windows but it 
isn't bad on Mac.


A recipe would be useful to the team.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

monte has previously said that merggoogle is using a c-library.
the "need" for merggoogle is to not rewrite the existing code and/or write
a new library from scratch.  otherwise i wouldn't need to issue an rfq to
have someone write a library.  i could have it done for free.
or i would be overrun with offers from n00bs to write it because it's so
darn easy and i'm such a fool for paying money to have it done.
yay, i can't wait for the bidding war to begin.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

Sean Cole wrote:
> On Thu, 12 Mar 2020 at 00:17, Richard Gaskin via use-livecode <
> use-livecode at lists.runrev.com> wrote:
>
>> I had thought the problem at that time was that your app was using
>> Google's older auth method, before they switched to OAth2.
>
> Correct. But not the oAuth Lib directly anyway. What bothered me was
> oAuth had been added but not to the Google extension. Which was odd

See my other post on this from earlier today:
http://lists.runrev.com/pipermail/use-livecode/2020-March/258798.html

Hopefully Monte can chime in with details on that.


>> The Oath2 lib is in LC's Github repository:
>>
>> 
https://github.com/livecode/livecode/blob/develop/extensions/script-libraries/oauth2/oauth2.livecodescript

>>
>> So now I'm confused: is OAuth2 not working in LC 9.x?
>
> I don't rely on any third party stuff anymore as it's out of my
> control and have to wait an age before someone perhaps, maybe, some
> year, updates it.

Thank you for the clarification.  Since we haven't seen posts about LC's 
Oauth2 here and searches for both "oauth" and "oauth2" turn up no bug 
reports in the bug DB, it seems reasonable to assume it's working well.


I tend to keep third-party stuff to a minimum in deployments myself, 
esp. where source is not available. But the OAuth2 library is a part of 
the LC product, available in all editions and included in the Github 
repo for everyone to review.



>> I'm also confused about "near silence" - Mark Waddingham has posted
>> here three times this month, and it's only the 10th.  He's even
>> posted in the forums more frequently lately than I'm used to seeing.
>
> Do you mean wIth reference to progress, roadmap, where the updates are
> and how far along...? Or just in response to other specific questions
> and ramblings about an existing feature or somewhat?

I was replying to your comment.  What did you have in mind?


>> As for the breakpoints crasher, I'd thought that was addressed in
>> v9.1, no?
>
> Afraid not. 9.5.1 and 9.6 dp2 are still exhibiting breakpoint crashes.
> Not as often as before but, still, there are occurrences.

Thank you for confirming the breakpoint fixes in place now.

If you have a recipe or a bug ID number for the remaining issue I'd be 
happy to see what I can do to try to steward it through completion.


With many who had noted the earlier issues no longer seeing breakpoint 
crashes, the specific intersection of factors leading to any remaining 
ones may be difficult to pin down.  But like all crashers I've seen 
before, once we have a solid recipe the fix is usually quickly delivered.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

Mike Kerner wrote:

> 6. there doesn't seem to be any interest in updating merggoogle.

It'll be good to hear from Monte on this, but I'd guess the reason 
merGoogle isn't actively supported is because the meat of it is handling 
authentication, and the REST API itself if pretty straightforward.


Now that Google requires OAuth2 (they stopped supporting their earlier 
auth), and LC has the actively-supported OAuth2 library in all editions, 
there would seem little need for merGoogle, esp. since the OAuth2 lib 
works on all supported platforms.


Monte, is this correct?

--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

see the rfq i posted.  there are a variety of issues in merggoogle
1. mac/ios only
2. doesn't seem to work in newer versions of lc for some reason (works in
9.0.1, for instance, but not in 9.5.x)
3. google is going to shut off...something...that merggoogle is using in
september.  i don't know what that is, but i get emails from google telling
me that i'm using a deprecated api that is going to be nuked in six
months.  the only place that i could possibly be using that api is
merggoogle
4. we have had to include a lot of error trapping code because merggoogle
somehow gets out of step with google, which breaks the process, and it is
impossible to debug because of the way merggoogle works (you can't see all
the raw traffic).  so for example, we might say "load a worksheet", and
instead we will get a message that the list of spreadsheets is loaded.  the
problem with that is that there is no way to recover once that happens, and
you have to start over.  there are multiple bug reports on this particular
issue, but the workaround was a lot of workaround code to specifically
ensure that the sequence occurs as expected.
5. the rest api seems like it has more features
6. there doesn't seem to be any interest in updating merggoogle.

On Wed, Mar 11, 2020 at 4:46 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Hi Mike,
>
> I haven't forgotten, but finally found time to take a look today and
> started
> writing minimal comments, and thought I should at least test it - for some
> reason the authorisation isn't working. For whatever reason, the call to
> OAuth2 results in the error "Malformed auth code." So I can't get to test
> what
> I'm sending.
>
> I'm unclear whether I've done something strange or wrong, or whether
> Google
> has changed something that breaks LC's implementation. I've come across
> references which suggest that, but they date back to last year, and I
> believe
> I've used this stack in January. (I also tried using LC 9.0.4 with the
> same
> result.)
>
> I will try to get back to this. In the meantime, have you - or anyone -
> found
> issues recently with OAuth2, in particular against any of the Google APIs?
>
> Ben
>
>
> On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:
> > it might help us get started.  i'm going to probably put out an rfq to
> wrap
> > the v4 rest api, because we're going to have to come to a solution,
> either
> > using lc or some other tool.
> >
> > On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> Mike,
> >>
> >> Very happy to share what I've got, but it's really not much - just a
> very
> >> thin
> >> wrapper round Google's API - and it's undocumented, mostly rough code -
> >> copied
> >> from one stack to the next, usually done in a tearing hurry!
> >>
> >> I'll try to pull something together, but please promise not to judge
> me...
> >>
> >> Ben
> >>
> >> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
> >>> Ben,
> >>> would you send me what you've got?  I was considering paying someone to
> >>> wrap the entire v4 api and dropping mergGoogle, so any head start would
> >> be
> >>> useful.  LC wants tribute to do the work (which is a little
> disappointing
> >>> since we financed the original external, so we sort-of hoped that it
> >> would
> >>> become a thing, and it would get updated as required, but crap
> happens).
> >>>
> >>> On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
> >>> use-livecode@lists.runrev.com> wrote:
> >>>
>  On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
> > is anyone using anything besides mergGoogle to work with google
> sheets?
> > care to share, if you are?
> 
>  I'm just using the Google Sheets API directly from LiveCode - just
> >> pushing
>  JSON back and forth. The API is limited, but what's there is very easy
> >> to
>  work
>  with - much better than manipulating xlsx files.
> 
>  I started using it to get data from clients, and then processing data
> >> and
>  pushing it back into the sheets. I've also used on some experimental
> >> image
>  processing, where I found that pushing the results of LiveCode
> functions
>  into
>  a google sheet immediately gave me an nice interface in which to
> review
>  the
>  data, and then I could also use the spreadsheet functions to do
> >> evaluation
>  and
>  testing.
> 
>  Ben
> 
>  
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Sean Cole (Pi) via use-livecode]

On Thu, 12 Mar 2020 at 00:17, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I had thought the problem at that time was that your app was using
> Google's older auth method, before they switched to OAth2.
>

Correct. But not the oAuth Lib directly anyway. What bothered me was oAuth
had been added but not to the Google extension. Which was odd

>
> The Oath2 lib is in LC's Github repository:
>
> https://github.com/livecode/livecode/blob/develop/extensions/script-libraries/oauth2/oauth2.livecodescript
>
> So now I'm confused: is OAuth2 not working in LC 9.x?
>

I don't rely on any third party stuff anymore as it's out of my control and
have to wait an age before someone perhaps, maybe, some year, updates it.

>
> I'm also confused about "near silence" - Mark Waddingham has posted here
> three times this month, and it's only the 10th.  He's even posted in the
> forums more frequently lately than I'm used to seeing.
>

Do you mean wIth reference to progress, roadmap, where the updates are and
how far along...? Or just in response to other specific questions and
ramblings about an existing feature or somewhat?

>
> As for the breakpoints crasher, I'd thought that was addressed in v9.1, no?
>

Afraid not. 9.5.1 and 9.6 dp2 are still exhibiting breakpoint crashes. Not
as often as before but, still, there are occurrences. And for some very odd
reason an early sign it's going to become a problem I notice the line
numbers don't scroll with the script after I've run one with a breakpoint
that I've then stepped through - you know - so I can do my job and work out
where bugs are. When I see this I have to close the script editor and
reopen it to prevent it from crashing altogether - although sometimes it
gives no warning.

Next time I see it happening I'll do a screen recording so all can see it
in it's glory.

Counter to what Jacque says, it does not 'fix' itself. It persists until it
gives up. It still crashes occasionally.

It's nice to hear they are 'on it' -- 9 / 6 / 3 months later!
(It hurts so much..!!)
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[J. Landman Gay via use-livecode]

The crasher was fixed. I think Sean is talking about how scrolling doesn't 
change the position of the red dots. That seems minor, since it fixes 
itself once any keyboard activity happens. Annoying maybe, but not 
critical. The bad bugs usually get fixed.


Panos said the team is aware of the new iOS requirements and they're on it.

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software | http://www.hyperactivesw.com
On March 11, 2020 7:19:34 PM Richard Gaskin via use-livecode 
 wrote:



As for the breakpoints crasher, I'd thought that was addressed in v9.1, no?




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

I had thought the problem at that time was that your app was using 
Google's older auth method, before they switched to OAth2.


The Oath2 lib is in LC's Github repository:
https://github.com/livecode/livecode/blob/develop/extensions/script-libraries/oauth2/oauth2.livecodescript

So now I'm confused: is OAuth2 not working in LC 9.x?


I'm also confused about "near silence" - Mark Waddingham has posted here 
three times this month, and it's only the 10th.  He's even posted in the 
forums more frequently lately than I'm used to seeing.


As for the breakpoints crasher, I'd thought that was addressed in v9.1, no?

--
 Richard Gaskin
 Fourth World Systems


Pi Digital wrote:
I had a major issue with oAuth when google first switched off the old credentials format which caused me to have a major breakdown and lost all of my clients as a result.  Merg had not been updated to reflect and prepare the the change so caused it to catastrophically breakdown on the very day (by coincidence) that it was needed for a live broadcast recording. Monte was able to fix it but too late for my clients or my mental well-being. 

Since that I have avoided using any third party resource that is code-locked or not open source. I can’t risk other people not updating LC. I’m just as worried about using LC as it is falling behind on so many OS requirements and issues and fixes are just not pulling through quick enough for practical customer reliability. 

There is near silence from LC in the last number of months. Worrying indeed. I’m guessing uptake for LC4FM is as low as I had predicted it would be, especially based on the forum discussions. Considering the number of issues I would predict new users to have there are practically no comments made at all. Or maybe they have been able to get into it with no issues at all because it is so perfectly coded ;). 

9.6 DP2 was announced on 18Dec2019. Script editor breakpoints and linenumbers are still screwed up and no one appears to be working on it. Promising! Still no RC or GM in sight. No word from LC what they are doing. Dead in the water? 


Sean Cole
Pi



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Sean Cole (Pi) via use-livecode]

Faith, I am told, is the 'Assured expectation of things not yet beheld'.
There is very little in the way of evidence or assurance to inspire faith.
Unless it's there and I'm looking in the wrong places. As I say, script
editor is still messed up and thats where ALL of our work gets done. I'm
tired of having to work with workarounds. And don't even get me started on
HTML5. No 'signs' of progress anywhere. Even pull requests are near
dull-to-silent

Sean Cole



On Wed, 11 Mar 2020 at 22:58, J. Landman Gay via use-livecode <
use-livecode@lists.runrev.com> wrote:

> On 3/11/20 5:06 PM, Pi Digital via use-livecode wrote:
> > I’m guessing uptake for LC4FM is as low as I had predicted it would be,
> especially based on the forum discussions.
>
> Forum participation is not a good indication of uptake, and I wouldn't
> venture a guess based on
> that. I don't think folks realize how valuable the FM project is for the
> rest of us. I know
> it's made my mobile projects much easier, lots of bugs have been addressed
> there, and Android
> is getting a lot of love these days.
>
> Oh ye of little faith. ;)
>
> --
> Jacqueline Landman Gay | jac...@hyperactivesw.com
> HyperActive Software   | http://www.hyperactivesw.com
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[J. Landman Gay via use-livecode]

On 3/11/20 5:06 PM, Pi Digital via use-livecode wrote:

I’m guessing uptake for LC4FM is as low as I had predicted it would be, 
especially based on the forum discussions.


Forum participation is not a good indication of uptake, and I wouldn't venture a guess based on 
that. I don't think folks realize how valuable the FM project is for the rest of us. I know 
it's made my mobile projects much easier, lots of bugs have been addressed there, and Android 
is getting a lot of love these days.


Oh ye of little faith. ;)

--
Jacqueline Landman Gay | jac...@hyperactivesw.com
HyperActive Software   | http://www.hyperactivesw.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Pi Digital via use-livecode]

I had a major issue with oAuth when google first switched off the old 
credentials format which caused me to have a major breakdown and lost all of my 
clients as a result.  Merg had not been updated to reflect and prepare the the 
change so caused it to catastrophically breakdown on the very day (by 
coincidence) that it was needed for a live broadcast recording. Monte was able 
to fix it but too late for my clients or my mental well-being. 

Since that I have avoided using any third party resource that is code-locked or 
not open source. I can’t risk other people not updating LC. I’m just as worried 
about using LC as it is falling behind on so many OS requirements and issues 
and fixes are just not pulling through quick enough for practical customer 
reliability. 

There is near silence from LC in the last number of months. Worrying indeed. 
I’m guessing uptake for LC4FM is as low as I had predicted it would be, 
especially based on the forum discussions. Considering the number of issues I 
would predict new users to have there are practically no comments made at all. 
Or maybe they have been able to get into it with no issues at all because it is 
so perfectly coded ;). 

9.6 DP2 was announced on 18Dec2019. Script editor breakpoints and linenumbers 
are still screwed up and no one appears to be working on it. Promising! Still 
no RC or GM in sight. No word from LC what they are doing. Dead in the water? 

Sean Cole
Pi

> On 11 Mar 2020, at 20:45, Ben Rubinstein via use-livecode 
>  wrote:
> 
> I will try to get back to this. In the meantime, have you - or anyone - found 
> issues recently with OAuth2, in particular against any of the Google APIs?
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

OAuth2 was Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

Hi Mike,

I haven't forgotten, but finally found time to take a look today and started 
writing minimal comments, and thought I should at least test it - for some 
reason the authorisation isn't working. For whatever reason, the call to 
OAuth2 results in the error "Malformed auth code." So I can't get to test what 
I'm sending.


I'm unclear whether I've done something strange or wrong, or whether Google 
has changed something that breaks LC's implementation. I've come across 
references which suggest that, but they date back to last year, and I believe 
I've used this stack in January. (I also tried using LC 9.0.4 with the same 
result.)


I will try to get back to this. In the meantime, have you - or anyone - found 
issues recently with OAuth2, in particular against any of the Google APIs?


Ben


On 08/03/2020 22:22, Mike Kerner via use-livecode wrote:

it might help us get started.  i'm going to probably put out an rfq to wrap
the v4 rest api, because we're going to have to come to a solution, either
using lc or some other tool.

On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


Mike,

Very happy to share what I've got, but it's really not much - just a very
thin
wrapper round Google's API - and it's undocumented, mostly rough code -
copied
from one stack to the next, usually done in a tearing hurry!

I'll try to pull something together, but please promise not to judge me...

Ben

On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:

Ben,
would you send me what you've got?  I was considering paying someone to
wrap the entire v4 api and dropping mergGoogle, so any head start would

be

useful.  LC wants tribute to do the work (which is a little disappointing
since we financed the original external, so we sort-of hoped that it

would

become a thing, and it would get updated as required, but crap happens).

On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:

is anyone using anything besides mergGoogle to work with google sheets?
care to share, if you are?


I'm just using the Google Sheets API directly from LiveCode - just

pushing

JSON back and forth. The API is limited, but what's there is very easy

to

work
with - much better than manipulating xlsx files.

I started using it to get data from clients, and then processing data

and

pushing it back into the sheets. I've also used on some experimental

image

processing, where I found that pushing the results of LiveCode functions
into
a google sheet immediately gave me an nice interface in which to review
the
data, and then I could also use the spreadsheet functions to do

evaluation

and
testing.

Ben




___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

it might help us get started.  i'm going to probably put out an rfq to wrap
the v4 rest api, because we're going to have to come to a solution, either
using lc or some other tool.

On Sun, Mar 8, 2020 at 6:01 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Mike,
>
> Very happy to share what I've got, but it's really not much - just a very
> thin
> wrapper round Google's API - and it's undocumented, mostly rough code -
> copied
> from one stack to the next, usually done in a tearing hurry!
>
> I'll try to pull something together, but please promise not to judge me...
>
> Ben
>
> On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:
> > Ben,
> > would you send me what you've got?  I was considering paying someone to
> > wrap the entire v4 api and dropping mergGoogle, so any head start would
> be
> > useful.  LC wants tribute to do the work (which is a little disappointing
> > since we financed the original external, so we sort-of hoped that it
> would
> > become a thing, and it would get updated as required, but crap happens).
> >
> > On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> >> On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
> >>> is anyone using anything besides mergGoogle to work with google sheets?
> >>> care to share, if you are?
> >>
> >> I'm just using the Google Sheets API directly from LiveCode - just
> pushing
> >> JSON back and forth. The API is limited, but what's there is very easy
> to
> >> work
> >> with - much better than manipulating xlsx files.
> >>
> >> I started using it to get data from clients, and then processing data
> and
> >> pushing it back into the sheets. I've also used on some experimental
> image
> >> processing, where I found that pushing the results of LiveCode functions
> >> into
> >> a google sheet immediately gave me an nice interface in which to review
> >> the
> >> data, and then I could also use the spreadsheet functions to do
> evaluation
> >> and
> >> testing.
> >>
> >> Ben
> >>
> >> ___
> >> use-livecode mailing list
> >> use-livecode@lists.runrev.com
> >> Please visit this url to subscribe, unsubscribe and manage your
> >> subscription preferences:
> >> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>
> >
> >
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

Mike,

Very happy to share what I've got, but it's really not much - just a very thin 
wrapper round Google's API - and it's undocumented, mostly rough code - copied 
from one stack to the next, usually done in a tearing hurry!


I'll try to pull something together, but please promise not to judge me...

Ben

On 06/03/2020 15:13, Mike Kerner via use-livecode wrote:

Ben,
would you send me what you've got?  I was considering paying someone to
wrap the entire v4 api and dropping mergGoogle, so any head start would be
useful.  LC wants tribute to do the work (which is a little disappointing
since we financed the original external, so we sort-of hoped that it would
become a thing, and it would get updated as required, but crap happens).

On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:


On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:

is anyone using anything besides mergGoogle to work with google sheets?
care to share, if you are?


I'm just using the Google Sheets API directly from LiveCode - just pushing
JSON back and forth. The API is limited, but what's there is very easy to
work
with - much better than manipulating xlsx files.

I started using it to get data from clients, and then processing data and
pushing it back into the sheets. I've also used on some experimental image
processing, where I found that pushing the results of LiveCode functions
into
a google sheet immediately gave me an nice interface in which to review
the
data, and then I could also use the spreadsheet functions to do evaluation
and
testing.

Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode






___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

Ben,
would you send me what you've got?  I was considering paying someone to
wrap the entire v4 api and dropping mergGoogle, so any head start would be
useful.  LC wants tribute to do the work (which is a little disappointing
since we financed the original external, so we sort-of hoped that it would
become a thing, and it would get updated as required, but crap happens).

On Thu, Mar 5, 2020 at 6:04 PM Ben Rubinstein via use-livecode <
use-livecode@lists.runrev.com> wrote:

> On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:
> > is anyone using anything besides mergGoogle to work with google sheets?
> > care to share, if you are?
>
> I'm just using the Google Sheets API directly from LiveCode - just pushing
> JSON back and forth. The API is limited, but what's there is very easy to
> work
> with - much better than manipulating xlsx files.
>
> I started using it to get data from clients, and then processing data and
> pushing it back into the sheets. I've also used on some experimental image
> processing, where I found that pushing the results of LiveCode functions
> into
> a google sheet immediately gave me an nice interface in which to review
> the
> data, and then I could also use the spreadsheet functions to do evaluation
> and
> testing.
>
> Ben
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Ben Rubinstein via use-livecode]

On 04/03/2020 20:37, Mike Kerner via use-livecode wrote:

is anyone using anything besides mergGoogle to work with google sheets?
care to share, if you are?


I'm just using the Google Sheets API directly from LiveCode - just pushing 
JSON back and forth. The API is limited, but what's there is very easy to work 
with - much better than manipulating xlsx files.


I started using it to get data from clients, and then processing data and 
pushing it back into the sheets. I've also used on some experimental image 
processing, where I found that pushing the results of LiveCode functions into 
a google sheet immediately gave me an nice interface in which to review the 
data, and then I could also use the spreadsheet functions to do evaluation and 
testing.


Ben

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Kaveh Bazargan via use-livecode]

I am only reading now, Richard. I would like to be able to write too, and
any hints appreciated. But currently people go to Google Sheets and update
data.

I realise Google Sheets is not a true database, but the attraction is that
everyone is familiar with them and are not intimidated.

On Thu, 5 Mar 2020 at 21:49, Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> And for writes?
> --
>   Richard Gaskin
>   Fourth World Systems
>
> Mike Kerner wrote:
> > ok, that's what i thought.
> >
> > On Thu, Mar 5, 2020 at 3:47 PM Kaveh Bazargan via use-livecode <
> > use-livecode at lists.runrev.com> wrote:
> >
> >> This is where I started, Mike:
> >>
> >>
> https://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
Kaveh Bazargan PhD
Director
River Valley Technologies  • Twitter
 • LinkedIn

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

And for writes?
--
 Richard Gaskin
 Fourth World Systems

Mike Kerner wrote:

ok, that's what i thought.

On Thu, Mar 5, 2020 at 3:47 PM Kaveh Bazargan via use-livecode <
use-livecode at lists.runrev.com> wrote:


This is where I started, Mike:

https://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

ok, that's what i thought.

On Thu, Mar 5, 2020 at 3:47 PM Kaveh Bazargan via use-livecode <
use-livecode@lists.runrev.com> wrote:

> This is where I started, Mike:
>
> https://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html
>
> Then I had to do a lot of work to get unicode imported properly. Somehow
> got it to work. :-)
>
> On Thu, 5 Mar 2020 at 19:58, Mike Kerner via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > @Kaveh
> > what are you using to connect to it?  are you using the sheets api or
> > something else?
> >
> > On Thu, Mar 5, 2020 at 2:34 PM Richard Gaskin via use-livecode <
> > use-livecode@lists.runrev.com> wrote:
> >
> > > Bob Sneidar wrote:
> > >  > And again, I must caution that any local folders set to sync with a
> > >  > nextCloud device, if you then uncheck a subfolder, it will REMOVE
> THE
> > >  > LOCAL SUBFOLDER! The NextCloud people figured that the NextCloud
> > >  > device must become the master, and your own local files the slave.
> > >
> > > Ah, but there's the rub: the concepts of "master" and "slave" do not
> > > apply to peer syncing systems.
> > >
> > > Whether the behavior is correct or not depends on the use-case.  Most
> > > other sync systems avoid the question altogether by completely
> > > disallowing subfolder control. So if you want the same, limit your use
> > > of the options Nextcloud provides - just don't change the checkbox for
> > > subfolders.
> > >
> > > If you do choose to fine-tune your settings for subfolders, for the
> last
> > > several years the implications for the choice are described when you
> > > click the checkbox, requiring confirmation. If that's not what you want
> > > for your use case, the easiest solution (with any sync system) is to
> > > just move the folder outside of the one you've designated for syncing.
> > >
> > > If this specific scenario is of interest, and simply moving the folder
> > > isn't an option, these discussions will lend insight into the
> > > seemingly-simple-but-really-quite-nuanced behavior:
> > >
> > >
> > >
> >
> https://help.nextcloud.com/t/unchecked-folders-will-be-removed-from-your-file-system/12335/18
> > >
> > > https://github.com/owncloud/client/issues/2502
> > >
> > > Sync is one of those things that seems simple on the surface, and
> > > usually is for most users, but there are enough edge cases that good
> > > sync is rare and good flexible sync even rarer.
> > >
> > > Having used Dropbox and Google Drive before moving my important stuff
> to
> > > Nextcloud, I've found not only more control over what gets synced and
> > > how, but also fewer conflict files than I used to see.
> > >
> > > All that said
> > >
> > >
> > > The real point of my post was to draw attention to the very useful
> > > WebDAV library bangkok posted from Matthias Rebbe:
> > >
> > >
> https://forums.livecode.com/viewtopic.php?f=11=32377=188319#p188099
> > >
> > >   You can :
> > >   -upload a file
> > >   -download a file
> > >   -create a folder
> > >   -delete a folder/file
> > >   -list the content of a folder (method PROPFIND)
> > >
> > > You can use this to talk to ANY server using the popular WebDAV
> standard.
> > >
> > > You can make custom workgroup solutions for a wide range of services,
> > > including PCloud and Google Drive, or with custom servers running the
> > > WebDAV modules available for Apache, Lightttpd, NginX, and more.
> > >
> > > The nice thing about also considering Nextcloud in the mix of platforms
> > > you might support with this library is that you have a ready audience
> of
> > > an estimated 250,000 installs, including many governments,
> universities,
> > > and both large and small businesses.  Extra bonus points that it has a
> > > nice UI for user management right in the box, and a thriving community
> > > of plugins extending it in new ways.
> > >
> > > I'm excited about what it's doing for my business today, and how I can
> > > lend that experience to helping other businesses with custom tools made
> > > in LiveCode tomorrow.
> > >
> > > WebDAV is kinda cool.  And thanks to Matthias' library, it's also fun.
> > >
> > > --
> > > Richard Gaskin
> > > Fourth World Systems
> > >
> > >
> > >
> > >  >> On Mar 4, 2020, at 22:58 , Richard Gaskin via use-livecode
> > >  wrote:
> > >  >>
> > >  >> Useful for Anyone to Know:
> > >  >> -
> > >  >> I've raved about Nextcloud here enough that I'll bet Mark Wieder's
> > > tired of it , so I'll try to not let me enthusiasm run away with me
> -
> > > I could go on about Nextcloud for way more than anyone wants to read.
> > >  >>
> > >  >> It's like a blend of Dropbox, Google Docs, and more than a hundred
> > > add-on apps for everything from a kanban tool to media streaming to
> > > videoconferencing - all free and open source:
> > >  >>
> > >  >> https://nextcloud.com/
> > >  >>
> > >  >> I use one internallt, to sync my LiveCode plugins folder across my
> > > machines, as well 

Re: google sheets - anybody doing anything besides mergGoogle

[Kaveh Bazargan via use-livecode]

This is where I started, Mike:
https://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html

Then I had to do a lot of work to get unicode imported properly. Somehow
got it to work. :-)

On Thu, 5 Mar 2020 at 19:58, Mike Kerner via use-livecode <
use-livecode@lists.runrev.com> wrote:

> @Kaveh
> what are you using to connect to it?  are you using the sheets api or
> something else?
>
> On Thu, Mar 5, 2020 at 2:34 PM Richard Gaskin via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
> > Bob Sneidar wrote:
> >  > And again, I must caution that any local folders set to sync with a
> >  > nextCloud device, if you then uncheck a subfolder, it will REMOVE THE
> >  > LOCAL SUBFOLDER! The NextCloud people figured that the NextCloud
> >  > device must become the master, and your own local files the slave.
> >
> > Ah, but there's the rub: the concepts of "master" and "slave" do not
> > apply to peer syncing systems.
> >
> > Whether the behavior is correct or not depends on the use-case.  Most
> > other sync systems avoid the question altogether by completely
> > disallowing subfolder control. So if you want the same, limit your use
> > of the options Nextcloud provides - just don't change the checkbox for
> > subfolders.
> >
> > If you do choose to fine-tune your settings for subfolders, for the last
> > several years the implications for the choice are described when you
> > click the checkbox, requiring confirmation. If that's not what you want
> > for your use case, the easiest solution (with any sync system) is to
> > just move the folder outside of the one you've designated for syncing.
> >
> > If this specific scenario is of interest, and simply moving the folder
> > isn't an option, these discussions will lend insight into the
> > seemingly-simple-but-really-quite-nuanced behavior:
> >
> >
> >
> https://help.nextcloud.com/t/unchecked-folders-will-be-removed-from-your-file-system/12335/18
> >
> > https://github.com/owncloud/client/issues/2502
> >
> > Sync is one of those things that seems simple on the surface, and
> > usually is for most users, but there are enough edge cases that good
> > sync is rare and good flexible sync even rarer.
> >
> > Having used Dropbox and Google Drive before moving my important stuff to
> > Nextcloud, I've found not only more control over what gets synced and
> > how, but also fewer conflict files than I used to see.
> >
> > All that said
> >
> >
> > The real point of my post was to draw attention to the very useful
> > WebDAV library bangkok posted from Matthias Rebbe:
> >
> > https://forums.livecode.com/viewtopic.php?f=11=32377=188319#p188099
> >
> >   You can :
> >   -upload a file
> >   -download a file
> >   -create a folder
> >   -delete a folder/file
> >   -list the content of a folder (method PROPFIND)
> >
> > You can use this to talk to ANY server using the popular WebDAV standard.
> >
> > You can make custom workgroup solutions for a wide range of services,
> > including PCloud and Google Drive, or with custom servers running the
> > WebDAV modules available for Apache, Lightttpd, NginX, and more.
> >
> > The nice thing about also considering Nextcloud in the mix of platforms
> > you might support with this library is that you have a ready audience of
> > an estimated 250,000 installs, including many governments, universities,
> > and both large and small businesses.  Extra bonus points that it has a
> > nice UI for user management right in the box, and a thriving community
> > of plugins extending it in new ways.
> >
> > I'm excited about what it's doing for my business today, and how I can
> > lend that experience to helping other businesses with custom tools made
> > in LiveCode tomorrow.
> >
> > WebDAV is kinda cool.  And thanks to Matthias' library, it's also fun.
> >
> > --
> > Richard Gaskin
> > Fourth World Systems
> >
> >
> >
> >  >> On Mar 4, 2020, at 22:58 , Richard Gaskin via use-livecode
> >  wrote:
> >  >>
> >  >> Useful for Anyone to Know:
> >  >> -
> >  >> I've raved about Nextcloud here enough that I'll bet Mark Wieder's
> > tired of it , so I'll try to not let me enthusiasm run away with me -
> > I could go on about Nextcloud for way more than anyone wants to read.
> >  >>
> >  >> It's like a blend of Dropbox, Google Docs, and more than a hundred
> > add-on apps for everything from a kanban tool to media streaming to
> > videoconferencing - all free and open source:
> >  >>
> >  >> https://nextcloud.com/
> >  >>
> >  >> I use one internallt, to sync my LiveCode plugins folder across my
> > machines, as well as some client projects. And I use another externally
> > as a client portal where we share files, a kanban board, etc.
> >  >>
> >  >> If you can set up an Apache Server under Ubuntu on a VPS, adding
> > Nextcloud is as easy as a one-line Snap call.
> >  >>
> >  >> If you're not yet comfortable wrangling servers, there are many
> > companies offering hosting listed at 

Re: google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

@Kaveh
what are you using to connect to it?  are you using the sheets api or
something else?

On Thu, Mar 5, 2020 at 2:34 PM Richard Gaskin via use-livecode <
use-livecode@lists.runrev.com> wrote:

> Bob Sneidar wrote:
>  > And again, I must caution that any local folders set to sync with a
>  > nextCloud device, if you then uncheck a subfolder, it will REMOVE THE
>  > LOCAL SUBFOLDER! The NextCloud people figured that the NextCloud
>  > device must become the master, and your own local files the slave.
>
> Ah, but there's the rub: the concepts of "master" and "slave" do not
> apply to peer syncing systems.
>
> Whether the behavior is correct or not depends on the use-case.  Most
> other sync systems avoid the question altogether by completely
> disallowing subfolder control. So if you want the same, limit your use
> of the options Nextcloud provides - just don't change the checkbox for
> subfolders.
>
> If you do choose to fine-tune your settings for subfolders, for the last
> several years the implications for the choice are described when you
> click the checkbox, requiring confirmation. If that's not what you want
> for your use case, the easiest solution (with any sync system) is to
> just move the folder outside of the one you've designated for syncing.
>
> If this specific scenario is of interest, and simply moving the folder
> isn't an option, these discussions will lend insight into the
> seemingly-simple-but-really-quite-nuanced behavior:
>
>
> https://help.nextcloud.com/t/unchecked-folders-will-be-removed-from-your-file-system/12335/18
>
> https://github.com/owncloud/client/issues/2502
>
> Sync is one of those things that seems simple on the surface, and
> usually is for most users, but there are enough edge cases that good
> sync is rare and good flexible sync even rarer.
>
> Having used Dropbox and Google Drive before moving my important stuff to
> Nextcloud, I've found not only more control over what gets synced and
> how, but also fewer conflict files than I used to see.
>
> All that said
>
>
> The real point of my post was to draw attention to the very useful
> WebDAV library bangkok posted from Matthias Rebbe:
>
> https://forums.livecode.com/viewtopic.php?f=11=32377=188319#p188099
>
>   You can :
>   -upload a file
>   -download a file
>   -create a folder
>   -delete a folder/file
>   -list the content of a folder (method PROPFIND)
>
> You can use this to talk to ANY server using the popular WebDAV standard.
>
> You can make custom workgroup solutions for a wide range of services,
> including PCloud and Google Drive, or with custom servers running the
> WebDAV modules available for Apache, Lightttpd, NginX, and more.
>
> The nice thing about also considering Nextcloud in the mix of platforms
> you might support with this library is that you have a ready audience of
> an estimated 250,000 installs, including many governments, universities,
> and both large and small businesses.  Extra bonus points that it has a
> nice UI for user management right in the box, and a thriving community
> of plugins extending it in new ways.
>
> I'm excited about what it's doing for my business today, and how I can
> lend that experience to helping other businesses with custom tools made
> in LiveCode tomorrow.
>
> WebDAV is kinda cool.  And thanks to Matthias' library, it's also fun.
>
> --
> Richard Gaskin
> Fourth World Systems
>
>
>
>  >> On Mar 4, 2020, at 22:58 , Richard Gaskin via use-livecode
>  wrote:
>  >>
>  >> Useful for Anyone to Know:
>  >> -
>  >> I've raved about Nextcloud here enough that I'll bet Mark Wieder's
> tired of it , so I'll try to not let me enthusiasm run away with me -
> I could go on about Nextcloud for way more than anyone wants to read.
>  >>
>  >> It's like a blend of Dropbox, Google Docs, and more than a hundred
> add-on apps for everything from a kanban tool to media streaming to
> videoconferencing - all free and open source:
>  >>
>  >> https://nextcloud.com/
>  >>
>  >> I use one internallt, to sync my LiveCode plugins folder across my
> machines, as well as some client projects. And I use another externally
> as a client portal where we share files, a kanban board, etc.
>  >>
>  >> If you can set up an Apache Server under Ubuntu on a VPS, adding
> Nextcloud is as easy as a one-line Snap call.
>  >>
>  >> If you're not yet comfortable wrangling servers, there are many
> companies offering hosting listed at the site.
>  >>
>  >> Nextcloud's file repository is a WebDAV server, which makes it a
> perfect compliment to something that showed up in our community just the
> other day:
>  >
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
On the first day, God created the heavens and the Earth
On the second 

Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

Bob Sneidar wrote:
> And again, I must caution that any local folders set to sync with a
> nextCloud device, if you then uncheck a subfolder, it will REMOVE THE
> LOCAL SUBFOLDER! The NextCloud people figured that the NextCloud
> device must become the master, and your own local files the slave.

Ah, but there's the rub: the concepts of "master" and "slave" do not 
apply to peer syncing systems.


Whether the behavior is correct or not depends on the use-case.  Most 
other sync systems avoid the question altogether by completely 
disallowing subfolder control. So if you want the same, limit your use 
of the options Nextcloud provides - just don't change the checkbox for 
subfolders.


If you do choose to fine-tune your settings for subfolders, for the last 
several years the implications for the choice are described when you 
click the checkbox, requiring confirmation. If that's not what you want 
for your use case, the easiest solution (with any sync system) is to 
just move the folder outside of the one you've designated for syncing.


If this specific scenario is of interest, and simply moving the folder 
isn't an option, these discussions will lend insight into the 
seemingly-simple-but-really-quite-nuanced behavior:


https://help.nextcloud.com/t/unchecked-folders-will-be-removed-from-your-file-system/12335/18

https://github.com/owncloud/client/issues/2502

Sync is one of those things that seems simple on the surface, and 
usually is for most users, but there are enough edge cases that good 
sync is rare and good flexible sync even rarer.


Having used Dropbox and Google Drive before moving my important stuff to 
Nextcloud, I've found not only more control over what gets synced and 
how, but also fewer conflict files than I used to see.


All that said


The real point of my post was to draw attention to the very useful 
WebDAV library bangkok posted from Matthias Rebbe:


https://forums.livecode.com/viewtopic.php?f=11=32377=188319#p188099

 You can :
 -upload a file
 -download a file
 -create a folder
 -delete a folder/file
 -list the content of a folder (method PROPFIND)

You can use this to talk to ANY server using the popular WebDAV standard.

You can make custom workgroup solutions for a wide range of services, 
including PCloud and Google Drive, or with custom servers running the 
WebDAV modules available for Apache, Lightttpd, NginX, and more.


The nice thing about also considering Nextcloud in the mix of platforms 
you might support with this library is that you have a ready audience of 
an estimated 250,000 installs, including many governments, universities, 
and both large and small businesses.  Extra bonus points that it has a 
nice UI for user management right in the box, and a thriving community 
of plugins extending it in new ways.


I'm excited about what it's doing for my business today, and how I can 
lend that experience to helping other businesses with custom tools made 
in LiveCode tomorrow.


WebDAV is kinda cool.  And thanks to Matthias' library, it's also fun.

--
Richard Gaskin
Fourth World Systems



>> On Mar 4, 2020, at 22:58 , Richard Gaskin via use-livecode 
 wrote:

>>
>> Useful for Anyone to Know:
>> -
>> I've raved about Nextcloud here enough that I'll bet Mark Wieder's 
tired of it , so I'll try to not let me enthusiasm run away with me - 
I could go on about Nextcloud for way more than anyone wants to read.

>>
>> It's like a blend of Dropbox, Google Docs, and more than a hundred 
add-on apps for everything from a kanban tool to media streaming to 
videoconferencing - all free and open source:

>>
>> https://nextcloud.com/
>>
>> I use one internallt, to sync my LiveCode plugins folder across my 
machines, as well as some client projects. And I use another externally 
as a client portal where we share files, a kanban board, etc.

>>
>> If you can set up an Apache Server under Ubuntu on a VPS, adding 
Nextcloud is as easy as a one-line Snap call.

>>
>> If you're not yet comfortable wrangling servers, there are many 
companies offering hosting listed at the site.

>>
>> Nextcloud's file repository is a WebDAV server, which makes it a 
perfect compliment to something that showed up in our community just the 
other day:

>


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Bob Sneidar via use-livecode]

And again, I must caution that any local folders set to sync with a nextCloud 
device, if you then uncheck a subfolder, it will REMOVE THE LOCAL SUBFOLDER! 
The NextCloud people figured that the NextCloud device must become the master, 
and your own local files the slave. 

Bob S


> On Mar 4, 2020, at 22:58 , Richard Gaskin via use-livecode 
>  wrote:
> 
> Useful for Anyone to Know:
> -
> I've raved about Nextcloud here enough that I'll bet Mark Wieder's tired of 
> it , so I'll try to not let me enthusiasm run away with me - I could go on 
> about Nextcloud for way more than anyone wants to read.
> 
> It's like a blend of Dropbox, Google Docs, and more than a hundred add-on 
> apps for everything from a kanban tool to media streaming to 
> videoconferencing - all free and open source:
> 
> https://nextcloud.com/
> 
> I use one internallt, to sync my LiveCode plugins folder across my machines, 
> as well as some client projects. And I use another externally as a client 
> portal where we share files, a kanban board, etc.
> 
> If you can set up an Apache Server under Ubuntu on a VPS, adding Nextcloud is 
> as easy as a one-line Snap call.
> 
> If you're not yet comfortable wrangling servers, there are many companies 
> offering hosting listed at the site.
> 
> Nextcloud's file repository is a WebDAV server, which makes it a perfect 
> compliment to something that showed up in our community just the other day:


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Richard Gaskin via use-livecode]

On Wed, 4 Mar 2020 at 20:39, Mike Kerner wrote:

>> is anyone using anything besides mergGoogle to work with google
>> sheets? care to share, if you are?


Useful for Anyone to Know:
-
I've raved about Nextcloud here enough that I'll bet Mark Wieder's tired 
of it , so I'll try to not let me enthusiasm run away with me - I 
could go on about Nextcloud for way more than anyone wants to read.


It's like a blend of Dropbox, Google Docs, and more than a hundred 
add-on apps for everything from a kanban tool to media streaming to 
videoconferencing - all free and open source:


https://nextcloud.com/

I use one internallt, to sync my LiveCode plugins folder across my 
machines, as well as some client projects.  And I use another externally 
as a client portal where we share files, a kanban board, etc.


If you can set up an Apache Server under Ubuntu on a VPS, adding 
Nextcloud is as easy as a one-line Snap call.


If you're not yet comfortable wrangling servers, there are many 
companies offering hosting listed at the site.


Nextcloud's file repository is a WebDAV server, which makes it a perfect 
compliment to something that showed up in our community just the other day:



Extremely Useful for LiveCode Developers to Know:

A frequent forum contributor, "bangkok", has posted a super-cool demo of 
a library from Matthias Rebbe for WebDAV client functionality:


https://forums.livecode.com/viewtopic.php?f=11=32377=188319#p188099

You can :
-upload a file
-download a file
-create a folder
-delete a folder/file
-list the content of a folder (method PROPFIND)

You could use this on any WebDAV server, Such as, say, Nextcloud. :)

I've tested the script on both Nextcloud servers I manage - works a 
treat.  Thank you bangkok amd Matthias Rebbe!


In your case, Mike, your data could even be a simple tab-delimited file, 
stored and retrieved using WebDAV.


I'm building out most of my back-office tools around Nextcloud's WebDAV 
as a shared data store.


--
 Richard Gaskin
 Fourth World Systems
 Software Design and Development for the Desktop, Mobile, and the Web
 
 ambassa...@fourthworld.comhttp://www.FourthWorld.com


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: google sheets - anybody doing anything besides mergGoogle

[Kaveh Bazargan via use-livecode]

I use GS as my database for a text processing app. Clearly not robust as a
database but most convenient to edit and add to BT multiple authorised
people. I keep all regex patterns etc

On Wed, 4 Mar 2020 at 20:39, Mike Kerner via use-livecode <
use-livecode@lists.runrev.com> wrote:

> is anyone using anything besides mergGoogle to work with google sheets?
> care to share, if you are?
>
> --
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>and did a little diving.
> And God said, "This is good."
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
-- 
Sent from MetroMail
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

google sheets - anybody doing anything besides mergGoogle

[Mike Kerner via use-livecode]

is anyone using anything besides mergGoogle to work with google sheets?
care to share, if you are?

-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode