Ce document en français.
The use of this software subjects you to our Terms Of Use and Data Protection Policy.
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).
It uses Google People API to synchronize your remote Google Contacts into a local HsqlDB 2.7.4 database.
This extension is seen by LibreOffice as a database driver responding to the URL: sdbc:address:google:*
.
Being free software I encourage you:
In short, to participate in the development of this extension.
Because it is together that we can make Free Software smarter.
The gContactOOo extension uses the OAuth2OOo extension to work.
It must therefore meet the requirement of the OAuth2OOo extension.
The gContactOOo extension uses the jdbcDriverOOo extension to work.
It must therefore meet the requirement of the jdbcDriverOOo extension.
Additionally, gContactOOo requires the jdbcDriverOOo extension to be configured to provide com.sun.star.sdb
as the API level, which is the default configuration.
It seems important that the file was not renamed when it was downloaded. If necessary, rename it before installing it.
Install OAuth2OOo.oxt extension
You must install this extension, if it is not already installed.
Install jdbcDriverOOo.oxt extension
You must install this extension, if it is not already installed.
Install gContactOOo.oxt extension
Restart LibreOffice after installation.
Be careful, restarting LibreOffice may not be enough.
soffice
and using the key combination Ctrl + C
if after stopping LibreOffice, the terminal is not active (no command prompt).After restarting LibreOffice, you can ensure that the extension and its driver are correctly installed by checking that the io.github.prrvchr.gContactOOo.Driver
driver is listed in the Connection Pool, accessible via the menu: Tools -> Options -> LibreOffice Base -> Connections. It is not necessary to enable the connection pool.
If the driver is not listed, the reason for the driver failure can be found in the extension’s logging. This log is accessible via the menu: Tools -> Options -> LibreOffice Base -> Google Contacts -> Logging Options.
The gContactLog
logging must first be enabled and then LibreOffice restarted to get the error message in the log.
In LibreOffice / OpenOffice go to: File -> Wizards -> Address Data Source…
The Address Book Datasource Wizard open.
In step: 1.Address Book Type:
In step: 2.Connection Settings:
A new wizard opens. Data source properties.
In step: 1.Advanced Properties.
In Database type list:
In step: 2.Connection Settings.
In General: Enter the DBMS/driver-specific connection string here.
After authorizing the OAuth2OOo application to access your Contacts, normally you should see: Connection Test: The connection was established successfully.
If the connection has been established, you can complete this wizard with the Finish button.
In step: 3.Table Selection.
If your data source has multiple tables, you will be asked to select the primary table.
In this case select the table: All my contacts. If necessary and before any connection it is possible to rename the main table name in: Tools -> Options -> Internet -> gContactOOo -> Main table name.
In step: 4.Field Assignment.
If necessary it is possible to rename the names of the columns of the data source using the button: Field Assignment.
Please continue this wizard with the button: Next.
In step: 5.Data Source Title.
You must create an odb file. To do this you must:
This odb file must also be made accessible. To do this you must:
Have fun…
Normally, the extension is created with Eclipse for Java and LOEclipse. To work around Eclipse, I modified LOEclipse to allow the extension to be created with Apache Ant.
To create the gContactOOo extension with the help of Apache Ant, you need to:
source/gContactOOo/
build.properties
so that the office.install.dir
and sdk.dir
properties point to the folders where LibreOffice and its SDK were installed, respectively.ant
dist/
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)
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 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
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.
Integration and use of the new Hsqldb v2.5.1.
Writing of a new Replicator interface, launched in the background (python Thread) responsible for:
Writing of a new DataBase interface, responsible for making all calls to the database.
Many other fix…
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:
Possibility to open the local HsqlDB database by: Tools -> Options -> Internet -> gContactOOo -> View DataBase
Many other fix…
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…
pip install requirements.txt
dateutil
to convert timestamp strings to UNO DateTime.rdb
file format produced by the unoidl-write
compilation utility. idl
files have been updated to support both available compilation tools: idlc and unoidl-write.com.sun.star.sdb
as API level.Make the address book locally editable with replication of changes.
Add new languages for internationalization…
Anything welcome…