version 0.0.5

Ce document en français

The use of this software subjects you to our Terms Of Use and Data Protection Policy

Introduction:

gDriveOOo is a LibreOffice and/or OpenOffice extension allowing to offer you innovative services in these office suites.
This extension allows you to work in LibreOffice / OpenOffice on your files on your phone (files that you have downloaded to your Android phone).

Being free software I encourage you:

• To duplicate its source code.
• To make changes, corrections, improvements.

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

Requirement:

gDriveOOo uses a local Hsqldb database of version 2.5.1.
The use of Hsqldb requires the installation and configuration within
LibreOffice / OpenOffice of a JRE version 1.8 minimum (ie: Java version 8)

Sometimes it may be necessary for LibreOffice users must have no Hsqldb driver installed with LibreOffice
(check your Installed Application under Windows or your Packet Manager under Linux).
It seems that version 7.x of LibreOffice has fixed this problem and is able to work with different driver version of Hsqldb simultaneously.
OpenOffice doesn't seem to need this workaround.

Installation:

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

• Install OAuth2OOo.oxt extension version 0.0.5.

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

• Install gDriveOOo.oxt extension version 0.0.5.

Restart LibreOffice / OpenOffice after installation.

Configuration:

Configure LibreOffice Open / Save dialogs (not necessary with OpenOffice):

• For LibreOffice V5.x and before:

In menu Tools - Options - LibreOffice - General: check use LibreOffice dialogs.

• For LibreOffice V6.x and above:

In menu Tools - Options - LibreOffice - Advanced - Open Expert Configuration

Search for: UseSystemFileDialog (Found under: org.openoffice.Office.Common > Misc)

Edit or change "true" to "false" (set it to "false")

Use:

Open your Google Drive:

In File - Open - File name enter:

• vnd.google-apps://your_account/

or

• vnd.google-apps:///

If you don't give your_account, you will be asked for...

After authorizing the OAuthOOo application to access your Drive, your Google Drive should open!!! normally ;-)

Has been tested with:

• LibreOffice 6.4.4.2 - Ubuntu 20.04 - LxQt 0.14.1

• LibreOffice 7.0.0.0.alpha1 - Ubuntu 20.04 - LxQt 0.14.1

• OpenOffice 4.1.5 x86_64 - Ubuntu 20.04 - LxQt 0.14.1

• OpenOffice 4.2.0.Build:9820 x86_64 - Ubuntu 20.04 - LxQt 0.14.1

• LibreOffice 6.1.5.2 - Raspbian 10 buster - Raspberry Pi 4 Model B

• LibreOffice 6.4.4.2 (x64) - Windows 7 SP1

I encourage you in case of problem :-(
to create an issue
I will try to solve it ;-)

Historical:

What has been done for version 0.0.5:

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

• Writing of a new Replicator 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 new DataBase interface, responsible for making all calls to the database.

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

• Management of duplicate file/folder names by SQL 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...

What remains to be done for version 0.0.5:

• Write the implementation Pull Change in the new Replicator interface.

• Add new language for internationalization...

• Anything welcome...