google sheets - anybody doing anything besides mergGoogle

Thu Mar 5 15:46:23 EST 2020

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 at 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 at 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&t=32377&p=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
> > <use-livecode at lists.runrev.com> wrote:
> >  >>
> >  >> Useful for Anyone to Know:
> >  >> -------------------------
> >  >> I've raved about Nextcloud here enough that I'll bet Mark Wieder's
> > tired of it <g>, 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 at 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 at 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 <http://rivervalleytechnologies.com/> • Twitter
<https://twitter.com/kaveh1000> • LinkedIn
<https://www.linkedin.com/in/bazargankaveh/>