How to link Thunderbird Lighting data to a LibreOffice Base file.

I am trying to make an application using Lightning calendar and transfer the data into a OpenOffice Base application. This is for a group of blind massotherapists. I am limited in programming skills and need help. I have created 5 employes in Lightning. I would like to use the calendar as a history of each client’s rendez-vous. Therefore transfer the data into the appropriate customer account. Thanks.


Just tested with Lightning installed.

At this time it appears the only accessible tables from Thunderbird to Base using the Thunderbird DB connector are for contents of .mab (Mozilla Address Book) files in Thunderbird. The two files looked at are “abook.mab” (Personal Address Book) and “history.mab” (Collected Addresses). You can’t even access added address books.

Edit based upon new information (SQLite):

Was able to find & open (with DB Browser for SQLite) the mentioned “local.sqlite” database. It contains 11 tables with each table containing records for ‘Tasks’, ‘Events’ etc.

Based upon the original question there will be considerable work to get this functional.

First you would need to make sure you have a working connection to the SQLite DB. You do this via a connector - JDBC or ODBC for this DB. Using Linux, I have never gotten a good connection with JDBC. This post, Base: how to connect to an SQLite database? , explains how I accomplished a connection using ODBC.

Now comes the real tough part. Once you have established you can connect, you would need to do all the processing through macros. This is basic code to access the SQLite DB and the particular tables wanted. Then more code to move the needed data to where you want it. This post, Connect to mssql (ODBC) database via Macro, explains the macro coding necessary for an ODBC connection (can be with or without password).

Now as to why you need macros to do this. Base connects to one database. If you are using the default DB (HLQLDB v1.8 embedded) stated as already set up, you need another connection to the SQLite DB. This is a reason for the macro. Connect via macro and macro code to move data around. You could just create a Base file connected to the SQLite DB via ODBC but still need some macro code for moving the data around to the tables you want.

You can also connect to more than one DB using standalone forms, but that still requires macros to move data from one DB to another.

No matter how you approach the task, there is considerable work to get this up and running even for those experienced in the topics involved.

Thank you Ratslinger for your explanation. I will have to go through every link you mentioned to get the picture. However it looks over my pay grade. I would like to reduce their intervention because of the handicap but it seems there is a limit to what I can do. Let me see what I find and I will get back to you.

This project sound like a Google Summer of Code candidate. Getting these two diverse programs to work together along with assistive input.

In lightning support they say the file containing data is “local.sqlite” which seems not related to Thunderbird files. This file contains the events according to the employe i.e there is a filter or index by employe. What I am looking for is a “bridge” to synchronize the data with a Base file already created. It can be end of day update or a complete synch.
I am sorry the only programming I learned was Business Basic in the 1970’s.

Please do not respond using an answer. Use a comment or amend you original question with additional information.