google sheets - anybody doing anything besides mergGoogle

Mike Kerner MikeKerner at roadrunner.com
Thu Mar 5 15:55:44 EST 2020


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
>
> 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/>
> _______________________________________________
> 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."



More information about the use-livecode mailing list