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

2020-07-27 Thread 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

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

2020-07-27 Thread 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

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

2020-07-22 Thread 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

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

2020-07-22 Thread 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

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

2020-07-21 Thread 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. >

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

2020-07-21 Thread 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

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

2020-07-16 Thread 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:

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

2020-03-14 Thread 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

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

2020-03-13 Thread 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

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

2020-03-13 Thread 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,

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

2020-03-12 Thread Mike Kerner via use-livecode
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 some

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

2020-03-12 Thread Ralph DiMola via use-livecode
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. ...

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

2020-03-12 Thread 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

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

2020-03-12 Thread 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

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

2020-03-12 Thread 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

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

2020-03-12 Thread 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

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

2020-03-12 Thread 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

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

2020-03-12 Thread 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.

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

2020-03-12 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

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

2020-03-11 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-08 Thread 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, > >

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-08 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-06 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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:

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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>

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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 > >

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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.

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-05 Thread 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,

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-04 Thread 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

Re: google sheets - anybody doing anything besides mergGoogle

2020-03-04 Thread 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