gContactOOo
Ce document en français.
The use of this software subjects you to our Terms Of Use and Data Protection Policy
version 0.0.6
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 to your phone contacts in LibreOffice / OpenOffice (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:
gContactOOo 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)
I recommend AdoptOpenJDK as your Java installation source.
If you are using LibreOffice on Linux, then you are subject to bug 139538.
To work around the problem, please uninstall the packages:
- libreoffice-sdbc-hsqldb
- libhsqldb1.8.0-java
If you still want to use the Embedded HsqlDB functionality provided by LibreOffice, then install the HsqlDBembeddedOOo extension.
OpenOffice and LibreOffice on Windows are not subject to this malfunction.
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 gContactOOo.oxt extension version 0.0.6.
Restart LibreOffice / OpenOffice after installation.
Use:
In LibreOffice / OpenOffice go to File -> Wizards -> Address Data Source…:
In step: 1. Address Book Type:
- select: Other external data source
- click on: Next(Button)
In step: 2. Connection Settings:
- click on: Settings(Button)
In Database type list:
- select: Google Contacts
- click on: Next(Button)
In General: Datasource Url:
- put: your Google account (ie: your_account@gmail.com)
Then:
- click on: Test connection (button)
After authorizing the OAuth2OOo application to access your Contacts, normally you should see: Connection Test: The connection was established successfully.
Have fun…
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.8 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.
-
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
-
Many other fix…
What remains to be done for version 0.0.6:
-
Write the implementation Pull Change and Push Change in the new Replicator interface.
-
Add new language for internationalization…
-
Anything welcome…