Documentation

Ce document en français.

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

version 1.0.1

Introduction:

gContactOOo is part of a Suite of LibreOffice ~~and/or OpenOffice~~ extensions allowing to offer you innovative services in these office suites.
This extension gives you access, in LibreOffice, to your phone contacts (the contacts of your Android phone).

Being free software I encourage you:

To duplicate its source code.
To make changes, corrections, improvements.
To open issue if needed.

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

Requirement:

In order to take advantage of the latest versions of the Python libraries used in gContactOOo, version 2 of Python has been abandoned in favor of Python 3.8 minimum.
This means that gContactOOo no longer supports OpenOffice and LibreOffice 6.x on Windows since version 1.0.0. I can only advise you to migrate to LibreOffice 7.x.

gContactOOo uses a local HsqlDB database version 2.7.2.
HsqlDB being a database written in Java, its use requires the installation and configuration in LibreOffice / OpenOffice of a JRE version 11 or later.
I recommend Adoptium as your Java installation source.

If you are using LibreOffice on Linux, you are subject to bug 139538. To work around the problem, please uninstall the packages with commands:

sudo apt remove libreoffice-sdbc-hsqldb (to uninstall the libreoffice-sdbc-hsqldb package)
sudo apt remove libhsqldb1.8.0-java (to uninstall the libhsqldb1.8.0-java package)

If you still want to use the Embedded HsqlDB functionality provided by LibreOffice, then install the HyperSQLOOo extension.

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 1.1.1.

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

Install jdbcDriverOOo.oxt extension version 1.0.5.

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

Install gContactOOo.oxt extension version 1.0.1.

Restart LibreOffice / OpenOffice after installation.

Use:

In LibreOffice / OpenOffice go to File -> Wizards -> Address Data Source…:

gContactOOo screenshot 1

In step: 1. Address Book Type:

select: Other external data source
click on: Next(Button)

gContactOOo screenshot 2

In step: 2. Connection Settings:

click on: Settings(Button)

gContactOOo screenshot 3

In Database type list:

select: Google Contacts
click on: Next(Button)

gContactOOo screenshot 4

In General: Datasource Url:

put: your Google account (ie: your_account@gmail.com)

Then:

click on: Test connection (button)

gContactOOo screenshot 5

After authorizing the OAuth2OOo application to access your Contacts, normally you should see: Connection Test: The connection was established successfully.

gContactOOo screenshot 6

Have fun…

Has been tested with:

LibreOffice 7.3.7.2 - Lubuntu 22.04 - Python version 3.10.12 - OpenJDK-11-JRE (amd64)
LibreOffice 7.5.4.2(x86) - Windows 10 - Python version 3.8.16 - Adoptium JDK Hotspot 11.0.19 (under Lubuntu 22.04 / VirtualBox 6.1.38)
LibreOffice 7.4.3.2(x64) - Windows 10(x64) - Python version 3.8.15 - Adoptium JDK Hotspot 11.0.17 (x64) (under Lubuntu 22.04 / VirtualBox 6.1.38)
Does not work with OpenOffice on Windows see bug 128569. Having no solution, I encourage you to install LibreOffice.

I encourage you in case of problem
to create an issue
I will try to solve it

Historical:

Introduction:

This extension was written in order to make usable in free software (LibreOffice or OpenOffice) your personal data (your address book) stored in your Android phone.

With the eMailerOOo extension, it can be the data source for mail merge by email, to your correspondents contained in your phone.

It will give you access to an information system that only larges companies are able, today, to implement.

What has been done for version 0.0.5:

Integration and use of the new Hsqldb v2.5.1.
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).
Writing of a new DataBase interface, responsible for making all calls to the database.
Many other fix…

What has been done for version 0.0.6:

Driver has a new name: Google Contacts
Driver is now registred for a new protocol: sdbc:address:google:your_account@gmail.com
The jdbcDriverOOo extension now provides the driver needed to access the HsqlDB database used by gContactOOo.
Modifying the Replicator in order to:
- Open and close the database at each replication.
- Go on hold after the last closing of the address book.
- Unload when closing LibreOffice / OpenOffice.
Possibility to open the local HsqlDB database by: Tools -> Options -> Internet -> gContactOOo -> View DataBase
Many other fix…

What has been done for version 1.0.1:

The absence or obsolescence of the OAuth2OOo and/or jdbcDriverOOo extensions necessary for the proper functioning of gContactOOo now displays an error message.
Many other things…

What remains to be done for version 1.0.1:

Make the address book locally editable with replication of changes.
Add new languages for internationalization…
Anything welcome…