[Qgis-user] QGIS and geopackages in sharepoint environement

[Sebastian Gutwein]

Although it is not recommended we use google drive and as of the latest
release it works ok for most files including Geopackage. In past versions
any time a layer on a geopackage was opened this would cause the file to be
marked as changed and upload the whole file. In the current version (3.26)
this only happens when edit mode is turned on. However saving after edits
is much slower when it is in the Google drive. It appears that the .wal
file decides to load the entire file into itself when in the google drive
before writing the change to the file.  Of course this doesn't prevent
people from overwriting each other's changes if two people are concurrently
editing on different machines.
The file path doesn't seem to be a problem if the files are in the same
location relative to the project file on different machines.
I would be interested if at some point someone created a solution that
allowed for diffs on geopackages using Lutra's
https://github.com/MerginMaps/geodiff . I imagine if that worked there
would be an cloud unsynced local version and a cloud synced local version
that you could trigger a diff operation against.

On Fri, Aug 5, 2022 at 3:28 PM Gert-Jan van der Weijden (GISNederland) via
Qgis-user <qgis-user at lists.osgeo.org> wrote:

> Hi,
>
> My employer is moving from "traditional" network shares to a 100%
> Sharepoint/MS Teams solution.
>
> The idea behind Sharepoint (and OneDrive) is that the content (files) is
> synchronised between server and local PC's.
> 1. For large files this means a lot of network traffic on each single
> edit.
>
> 2. The path to a dataset (geopackage, shapefile, geotiff) to be used in a
> QGis project (.qgz) is the local path b(c:\users\*joe*\data\etc).
> However, when Joe's college Jane opens this QGis project the next day, the
> data is synchronized to her local path (c:\users\jane\data\etc.), but the
> QGis project file (.qgz) is still pointing to c:\users\joe, which doesn't
> exist on Jane's laptop)
> Solutions?
> a. Microsoft used to advertise a way to make drive mappings to Sharepoint
> sites. That solution was based upon an Internet Explorer library, and is no
> longer supported. I tried to use it; it's clumsy and unreliable.
>
> https://support.microsoft.com/en-us/office/map-a-network-drive-to-a-sharepoint-library-751148de-f579-42f9-bc8c-fcd80ccf0f53
>
> b. 3rd party solutions like ZeeDrive (
> https://www.thinkscape.com/Map-Network-Drives-To-Office-365-OneDrive/)
> and CloudDriveMapper (https://www.iamcloud.com/cloud-drive-mapper/).
> I haven't tried these solutions yet, bu will do so somewhere this month.
>
> By the way, also on the "commercial side of Planet GIS" (Esri's ArcGIS)
> there's no solution for this problem (yet):
> https://support.esri.com/en/technical-article/000025605
>
> The problems as described on that Esri support page are prette much the
> same as in QGis+Sharepoint.
> The so-called "solution or workaround" is hardly to be taken seriously by
> a professional GIS user
>
>
> Apart from the Sharepoint-problems as described above, Geopackages are not
> designed for a multi-user environment.
>
>
> Kind regards,
>
> Gert-Jan
>
>
>
> On 5-8-2022 19:49, chris hermansen via Qgis-user wrote:
>
> Guido and list,
>
> On Fri, Aug 5, 2022 at 6:35 AM Guido Häfliger via Qgis-user <
> qgis-user at lists.osgeo.org> wrote:
>
>> Hello
>>
>>
>>
>> We are discussing in our company to switch from local fileserver/NAS to
>> Sharepoint (hosted in cloud). Will QGIS-projects and geopackages work on
>> sharepoint environment or do we have to expect a lot of troubles? Have
>> anybody experience with QGIS and geopackages on sharepoint? Will we
>> encounter problems if geopackages are opened by several users?
>>
>>
> I can't speak to the use of QGIS with Sharepoint, but we've tried using
> both QGIS and ESRI products with Google Drive for Desktop and the name
> remapping done by GDD in Windows Explorer is not picked up by the file
> manager component used by them; so the file names do not appear as expected.
>
> I've run across the same thing with QGIS and the Google Drive - Nautilus
> connection in GNOME / Linux and not found a solution.
>
> I suggest you try before you buy.
>
>
> --
> Chris Hermansen · clhermansen "at" gmail "dot" com
>
> C'est ma façon de parler.
>
> _______________________________________________
> Qgis-user mailing listQgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
___________________________
Sebastian "Bas* " Gutwein
*rhymes with Josh

Regenerative Design Group
1 Chevalier Ave
Greenfield, Ma 01301
Web: regenerativedesigngroup.com
(631) 241-1018

*Look close, think big, make change. *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220805/9b3f24e8/attachment.htm>