Ask Your Question

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

asked 2018-03-21 19:49:50 +0200

JAD101 gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-03-21 21:26:27 +0200

JAD101 gravatar image

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.

edit flag offensive delete link more


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

Ratslinger gravatar imageRatslinger ( 2018-03-21 22:05:19 +0200 )edit

answered 2018-03-21 20:14:24 +0200

Ratslinger gravatar image

updated 2018-03-22 00:23:40 +0200


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.

edit flag offensive delete link more


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.

JAD101 gravatar imageJAD101 ( 2018-03-22 18:15:49 +0200 )edit

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

AdmFubar gravatar imageAdmFubar ( 2018-03-22 19:36:05 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2018-03-21 19:49:50 +0200

Seen: 139 times

Last updated: Mar 22 '18