Re: Reading data from Google Sheets

why aren't you using merggoogle again? It has issues but it would be easier to get going. On Thu, Nov 15, 2018 at 3:06 PM JJS via use-livecode < use-livecode@lists.runrev.com> wrote: > i used this 3 years ago, found some examples and altered it a bit, still > works ok. > > we used this to find i

Re: Reading data from Google Sheets

i used this 3 years ago, found some examples and altered it a bit, still works ok. we used this to find info back on what others had added to the list. you have to select the columns you want to read in the SELECT statement in the script, you have to play with this the script shows you that

Re: Reading data from Google Sheets

No good. Somewhere the last char of the text of a google sheet is inserted three times in the body of the html tag suite. So adding a delimiting char of any kind is futile. I still think I am overthinking this. Craig -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-Use

Re: Reading data from Google Sheets

Well, heck. Even I know that the string "><" is ubiquitous in html tag sets. Wasn't thinking. So for now, I have to include an arcane char at the end of my sheet file, and lose it in LC. Craig -- Sent from: http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html

Re: Reading data from Google Sheets

Thanks, Colin. I found my way through that setting. Now I do indeed get the data in the sheet, but followed by a massive array of tags. This would not be an issue, except that the very start of that tag dataSet is appended the the text in the last cell of the actual sheet data. In other words, if

Re: Reading data from Google Sheets

On a Google Sheets page there is a Share button in the upper right. If it has a padlock it hasn’t been set up for sharing. Once you click on it you can set various options, including one where anyone with the link can view without having to sign in. __

Re: Reading data from Google Sheets

Hi. Thanks for taking the time with me. I did indeed paste the url into a separate private window in Safari, and it asked me to sign in. I did, and the sheet popped up. A standard window goes directly, without issue. This is not a forum for teaching me how to use google sheets. But do you know h

Re: Reading data from Google Sheets

I’m a big fan of Monte’s mergGoogle for reading sheets. With the exception of an exceptional failure in service midway through this year due to an oAuth issue (now fixed) it made reading and writing sheet data remarkably easy. I’d thoroughly recommend adopting this if you are able. Sean Cole P

Re: Reading data from Google Sheets

Craig, Check the sharing options on the spreadsheet. Remember LiveCode is not logged as your user, so it can only access spreadsheets that are viewable by anyone with the link. In doubt, pick the link you used, open a private window on your favorite browser and check to see if you can view it

Re: Reading data from Google Sheets

All. I tried the sample stack on a simple google sheet, and it returns a universe of tags, not the actual contents of the sheet. What am I doing wrong? I only changed the target url to point to the sheet I created. Craig Newman -- Sent from: http://runtime-revolution.278305.n4.nabble.com/R

Re: Reading data from Google Sheets

There's also the mergGoogle external. On Wed, Nov 14, 2018 at 12:37 AM Kaveh Bazargan via use-livecode < use-livecode@lists.runrev.com> wrote: > Thank you so much to both. And Andre, if you could write a blog post for > every question I have it would help me a lot. ;-) > > Actually I think I had

Re: Reading data from Google Sheets

Thank you so much to both. And Andre, if you could write a blog post for every question I have it would help me a lot. ;-) Actually I think I had looked at the very helpful StackExchange page before for reading Google Sheets directly in R. I will try it and report back with any follow ups. Regard

Re: Reading data from Google Sheets

Kaveh, There is a much easier way. I've just posted about it since it can be of interest for others (there is a demo stack included): http://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html Basically, there are special URLs for retrieving a Google Sheet as a CSV or a JSO

Re: Reading data from Google Sheets

Hi. well the (very) short answer is that you can: put url "yourWebpageAddressHere" into temp What you get is the entirety of the html contents of a page. Others will tell both of us how to get the "visible" text, that is, the tab and return delimited data, buried in all those tags. Craig Newman

Reading data from Google Sheets

Can someone point me to how I can read data from Google Sheets into LiveCode? For now I just need to read, not write. Thanks. -- Kaveh Bazargan Director River Valley Technologies • Twitter • LinkedIn