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
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
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
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
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
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.
__
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
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
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
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
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
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
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
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
14 matches
Mail list logo
