Repository files navigation

Cedocument en français.

The use of this software subjects you to ourTerms Of Use andData Protection Policy.

gDriveOOo is part of aSuite ofLibreOfficeand/orOpenOffice extensions allowing to offer you innovative services in these office suites.

This extension allows you to work in LibreOffice on your files on your phone (files that you have downloaded to your Android phone), even while offline.
It usesGoogle Drive API to synchronize your remote Google Drive files with the help of a local HsqlDB 2.7.2 database.
This extension is seen by LibreOffice as aContent Provider responding to the URL:vnd-google://*.

Being free software I encourage you:

• To duplicate itssource code.
• To make changes, corrections, improvements.
• To openissue if needed.

In short, to participate in the development of this extension.Because it is together that we can make Free Software smarter.

The gDriveOOo extension uses the OAuth2OOo extension to work.
It must therefore meet therequirement of the OAuth2OOo extension.

The gDriveOOo extension uses the jdbcDriverOOo extension to work.
It must therefore meet therequirement of the jdbcDriverOOo extension.

On Linux and macOS the Python packages used by the extension, if already installed, may come from the system and thereforemay not be up to date.
To ensure that your Python packages are up to date it is recommended to use theSystem Info option in the extension Options accessible by:
Tools -> Options -> Internet -> gDriveOOo -> View log -> System Info
If outdated packages appear, you can update them with the command:
pip install --upgrade <package-name>

For more information see:What has been done for version 1.1.0.

It seems important that the file was not renamed when it was downloaded.
If necessary, rename it before installing it.

• InstallOAuth2OOo.oxt extension

  You must first install this extension, if it is not already installed.

• InstalljdbcDriverOOo.oxt extension

  You must install this extension, if it is not already installed.

• InstallgDriveOOo.oxt extension

Restart LibreOffice after installation.
Be careful, restarting LibreOffice may not be enough.

• On Windows to ensure that LibreOffice restarts correctly, use Windows Task Manager to verify that no LibreOffice services are visible after LibreOffice shuts down (and kill it if so).
• Under Linux or macOS you can also ensure that LibreOffice restarts correctly, by launching it from a terminal with the commandsoffice and using the key combinationCtrl + C if after stopping LibreOffice, the terminal is not active (no command prompt).

Open your Google Drive:

InFile -> Open enter in the first drop-down list:

• For a named Url:vnd-google://your_account@gmail.com

or

• For an unnamed Url (anonymous):vnd-google:///

And validate not by theOpen button but by theEnter key.

If you don't giveyour_account@gmail.com, you will be asked for...

Anonymous Urls allow you to remain anonymous (your account does not appear in the Url) while named Urls allow you to access several accounts simultaneously.

After authorizing theOAuth2OOo application to access your Drive files, your Google Drive should open!!! normally 😉

• LibreOffice 7.3.7.2 - Lubuntu 22.04 - Python version 3.10.12

• LibreOffice 7.5.4.2(x86) - Windows 10 - Python version 3.8.16 (under Lubuntu 22.04 / VirtualBox 6.1.38)

• LibreOffice 7.4.3.2(x64) - Windows 10(x64) - Python version 3.8.15 (under Lubuntu 22.04 / VirtualBox 6.1.38)

• LibreOffice 24.8.0.3 (x86_64) - Windows 10(x64) - Python version 3.9.19 (under Lubuntu 22.04 / VirtualBox 6.1.38)

• Does not work with OpenOffice seebug 128569. Having no solution, I encourage you to installLibreOffice.

I encourage you in case of problem 😕
to create anissue
I will try to solve it 😄

• Integration and use of the new HsqlDB v2.5.1 system versioning.

• Writing of a newReplicator interface, launched in the background (python Thread) responsible for:

  • Perform the necessary procedures when creating a new user (initial Pull).

  • Carry out pulls regularly (every ten minutes) in order to synchronize any external changes (Pull all changes).

  • Replicate on demand all changes to the hsqldb 2.5.1 database using system versioning (Push all changes).

• Writing of a newDataBase interface, responsible for making all calls to the database.

• Setting up a cache on the Identifiers, see method:_getUser(), allowing access to a Content (file or folder) without access to the database for subsequent calls.

• Management of duplicate file/folder names bySQL Views: Child, Twin, Uri, and Title generating unique names if duplicates names exist.
  Although this functionality is only needed for gDriveOOo, it is implemented globally...

• Many other fix...

• Using new scheme:vnd-google:// as claimed bydraft-king-vnd-urlscheme-03.txt

• Achievement of handling duplicate file/folder names by SQL views in HsqlDB:

  • ATwin view grouping all the duplicates by parent folder and ordering them by creation date, modification date.
  • AUri view generating unique indexes for each duplicate.
  • ATitle view generating unique names for each duplicate.
  • A recursive viewPath to generate a unique path for each file / folder.

• Creation of aProvider able to respond to the two types of Urls supported (named and anonymous).
  Regular expressions (regex), declared in theUCB configuration file, are now used by OpenOffice/LibreOffice to send URLs to the appropriate ContentProvider.

• Use of the new UNO structDateTimeWithTimezone provided by the extensionjdbcDriverOOo since its version 0.0.4.
  Although this struct already exists in LibreOffice, its creation was necessary in order to remain compatible with OpenOffice (seeEnhancement Request 128560).

• Modification of theReplicator interface, in order to allow:

  • To choose the data synchronization order (local first then remote or vice versa).
  • Synchronization of local changes by atomic operations performed in chronological order to fully support offline work.
    To do this, three SQL proceduresGetPushItems,GetPushProperties andUpdatePushItems are used for each user who has accessed his files / folders.

• Rewrite of theoptions window accessible by:Tools -> Options -> Internet -> gDriveOOo in order to allow:

  • Access to the two log files concerning the activities of the UCP and the data replicator.
  • Choice of synchronization order.
  • The modification of the interval between two synchronizations.
  • Access to the underlying HsqlDB 2.7.2 database managing your Google Drive metadata.

• The presence or absence of a trailing slash in the Url is now supported.

• Many other fix...

• Implementation of the management of shared files.

• The name of the shared folder can be defined before any connection in:Tools -> Options -> Internet -> gDriveOOo -> Handle shared documents in folder:

• Many other fix...

• The absence or obsolescence of theOAuth2OOo and/orjdbcDriverOOo extensions necessary for the proper functioning ofgDriveOOo now displays an error message.

• Many other things...

• Support for version1.2.0 of theOAuth2OOo extension. Previous versions will not work withOAuth2OOo extension 1.2.0 or higher.

• Support for version1.2.1 of theOAuth2OOo extension. Previous versions will not work withOAuth2OOo extension 1.2.1 or higher.

• Support for version1.2.3 of theOAuth2OOo extension. Fixedissue #12.

• Support for version1.2.4 of theOAuth2OOo extension. Many issues resolved.

• Now use Python dateutil package to convert to UNO DateTime.

• All Python packages necessary for the extension are now recorded in arequirements.txt file followingPEP 508.
• Now if you are not on Windows then the Python packages necessary for the extension can be easily installed with the command:
  pip install requirements.txt
• Modification of theRequirement section.

• Fixed a regression preventing the creation of new files.
• Integration of a fix to workaround theissue #159988.

• The creation of the database, during the first connection, uses the UNO API offered by the jdbcDriverOOo extension since version 1.3.2. This makes it possible to record all the information necessary for creating the database in 6 text tables which are in fact6 csv files.
• Rewriting theSQL views necessary for managing duplicates. Now a folder or file's path is calculated by a recursive view that supports duplicates.
• Although the extension supports handling duplicate files and folder, it is no longer possible to create or rename them.
• Installing the extension will disable the option to create a backup copy (ie: .bak file) in LibreOffice. If this option is validated then the extension is no longer capable of saving files.
• The extension will ask you to install the OAuth2OOo and jdbcDriverOOo extensions in versions 1.3.4 and 1.3.2 respectively minimum.
• Many fixes.

• Updated thePython python-dateutil package to version 2.9.0.post0.
• Updated thePython ijson package to version 3.3.0.
• Updated thePython packaging package to version 24.1.
• Updated thePython setuptools package to version 72.1.0 in order to respond to theDependabot security alert.
• The extension will ask you to install the OAuth2OOo and jdbcDriverOOo extensions in versions 1.3.6 and 1.4.2 respectively minimum.

• Updated thePython setuptools package to version 73.0.1.
• The extension will ask you to install the OAuth2OOo and jdbcDriverOOo extensions in versions 1.3.7 and 1.4.5 respectively minimum.
• Changes to extension options that require a restart of LibreOffice will result in a message being displayed.
• Support for LibreOffice version 24.8.x.

• Disabling data replication in the extension options will display an explicit message in the replicator log.
• The extension will ask you to install the OAuth2OOo and jdbcDriverOOo extensions in versions 1.3.8 and 1.4.6 respectively minimum.
• Modification of the extension options accessible via:Tools -> Options... -> Internet -> gDriveOOo in order to comply with the new graphic charter.

• In order to meet the request ofissue #16, the management of theShared with me folder has been implemented.
• Preparation of the extension to the use of a more restricted scope of rights and not requiring theCasa tier 2 certification which is now chargeable. Thanks Google...
• Remote modifications of the contents of the files are taken into account by the replicator.
• If necessary, it is possible to request an initial synchronization in the extension options. It is also possible to request the download of all files already viewed that have a local copy.
• The replicator provides more comprehensive logging.
• Shared folders are now recognizable by their icon.
• Many fixes.

• The extension will ask you to install the OAuth2OOo and jdbcDriverOOo extensions in versions 1.4.0 and 1.4.6 respectively minimum.
• It is possible to build the extension archive (ie: the oxt file) with theApache Ant utility and thebuild.xml script file.
• The extension will refuse to install under OpenOffice regardless of version or LibreOffice other than 7.x or higher.
• Added binaries needed for Python libraries to work on Linux and LibreOffice 24.8 (ie: Python 3.9).
• The ability to not specify the user's account name in the URL is working again.

• Updated thePython packaging package to version 24.2.
• Updated thePython setuptools package to version 75.8.0.
• Updated thePython six package to version 1.17.0.
• Support for Python version 3.13.

• Add new language for internationalization...

• Anything welcome...