[Qgis-user] Conection to gpkg in 365 office

[Charles Dixon-Paver]

I agree that OneDrive is probably the best approach.

In the datasource manager (ctrl+L) you can add data from a variety of
sources, using a number of protocols (http/ ftp etc), which might be
available depending on the Office 365 environment setup, but in terms of
actually establishing a "connection" in QGIS browser to a remote source, I
don't think this is possible for Geopackages. In addition, GPKG, afaik, is
not designed for concurrent connections and having multiple clients connect
simultaneously may cause problems down the line, so this strategy of "gpkg
in the cloud" is generally ill advised anyway.

If you really want to take this approach I strongly recommend uploading the
GPKG file to a centralised location (e.g. a SharePoint library), which can
then be "connected" to your personal OneDrive (last I checked this was
still a thing) and load it onto your device from OneDrive. Then you can use
the GPKG locally and have the changes synchronised automatically to other
users. I think having the data connection will also prevent the file from
using your personal "Office 365 Quota", but I might be wrong. Using
"Check-In/ Check-Out" will also prevent data collisions, loss, or other
errors.

If you are on Linux and want to sync with OneDrive, there are third party
clients available [1], but your mileage may vary. Alternatively, set up
OneDrive on a Windows box and share the sync directory as a local network
share which can be mounted to your machine(s) directly.

1. https://github.com/abraunegg/onedrive

On Wed, 4 Nov 2020 at 17:14, chris hermansen <clhermansen at gmail.com> wrote:

> Alejandro and list,
>
> On Wed, Nov 4, 2020, 05:34 Alejandro Chamizo de Castro <
> alechamizo at gmail.com> wrote:
>
>> Hi colleagues,
>>
>>
>> my company decided to upload all the information to the cloud,
>> specifically to office 365.
>> I'm tired of working locally and periodically uploading GIS files to 365.
>> The question is, can QGIS be connected to a GPKG located in the cloud?
>>
>> I know that the ideal is to have a spatial database in the cloud but it
>> is not the case
>>
>> Thanks a lot
>>
>
> Maybe I'm missing something, but oesn't o365 automatically sync files to
> OneDrive, like Dropbox etc? At least for Windows and Mac desktops?
>
> My theory is that it should handle the synchronization for you.  For
> example this link tells us how to exclude folders from OneDrive, so just
> make sure your data is in a folder that's not excluded...
>
>
> https://support.microsoft.com/en-us/office/choose-which-onedrive-folders-to-sync-to-your-computer-98b8b011-8b94-419b-aa95-a14ff2415e85#:~:text=Help%20%26%20Settings%20%3E%20Preferences
> .,as%20C%3A%20and%20D%3A).
>
> Chris
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20201104/f3856ceb/attachment.html>