vCardOOo logo Documentation

Ce document en français.

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

version 1.1.2

Introduction:

vCardOOo 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 contacts present on a CardDAV server (or vCard Extensions to WebDAV).
It uses RFC 6352 to synchronize your remote address book into a local HsqlDB 2.7.2 database.
This extension is seen by LibreOffice as a database driver responding to the URL: sdbc:address:vcard:*.

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.


Requirement:

The vCardOOo extension uses the OAuth2OOo extension to work.
It must therefore meet the requirement of the OAuth2OOo extension.

The vCardOOo extension uses the jdbcDriverOOo extension to work.
It must therefore meet the requirement of the jdbcDriverOOo extension.

On Linux and macOS the Python packages used by the extension, if already installed, may come from the system and therefore may not be up to date.
To ensure that your Python packages are up to date it is recommended to use the System Info option in the extension Options accessible by:
Tools -> Options -> Internet -> vCardOOo -> 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.


Installation:

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

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


Use:

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

vCardOOo screenshot 1

The Address Book Datasource Wizard open.

In step: 1.Address Book Type:

vCardOOo screenshot 2

In step: 2.Connection Settings:

vCardOOo screenshot 3

A new wizard opens. Data source properties.

In step: 1.Advanced Properties.
In Database type list:

vCardOOo screenshot 4

In step: 2.Connection Settings.
In General: Enter the DBMS/driver-specific connection string here.

In User Authentication: User name:

Then:

vCardOOo screenshot 5

In Authentication required: Password:

vCardOOo screenshot 6

Normally you should see: Connection Test: The connection was established successfully.

vCardOOo screenshot 7

If the connection has been established, you can complete this wizard with the Finish button.

vCardOOo screenshot 8

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

vCardOOo screenshot 9

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:

vCardOOo screenshot 10

Have fun…


Has been tested with:

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


Historical:

Introduction:

This extension was written in order to make usable in free software (LibreOffice or OpenOffice) your personal data (your vCard) stored on a Nextcloud server.

With the eMailerOOo extension, it can be the data source for mail merge by email, to your correspondents (your vCard) coming from the Nextcloud server.

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.1:

What has been done for version 1.0.1:

What has been done for version 1.0.2:

What has been done for version 1.0.3:

What has been done for version 1.1.0:

What has been done for version 1.1.1:

What has been done for version 1.1.2:

What remains to be done for version 1.1.2: