hsqldb record(s) export/import into Thunderbird Calendar

[dreamquartz]

Hello All,

We use Thunderbird Calendar to inform others about locations to go, and contact information @ those locations.
At this point in time it is basically copy/paste, which is becoming a very tedious process.

We are looking for a method to export/import database information into the Calendar (Lightning) of Thunderbird.
The 'others' do not have access to the DataBase.
We would like to do selective info dumps, based on type of info, and 'groups' of people, because not everyone needs the same info.
We have no problem to have separate solutions at this point in time.

I have been looking around @ the forums, internet, and literature, but am unable to determine if it is @ all possible.

I am looking for information on how to proceed, possible (partial) solutions, or any other suggestion and/or comments.

Thank you in advance,

Dream

[Mountaineer]

We are looking for a method to export/import database information into the Calendar (Lightning) of Thunderbird.

I remember some old threads on writing .ics-files from Calc. The same should be possible from Base.
To start:
https://ask.libreoffice.org/t/request-f ... at/94932/3

[dreamquartz]

Thank you so much.That is a good start.

[Jurassic Pork]

Hello,
Here is in attachment , an odb example (sorry in french).
use python macro embedded in the odb file. Need APSO extension to manage embedded python and icalendar python package ( you can get python package with APSO package manager).
the macro export_calendrier_ics exports the records of the database in an ics file. Then you can import this ics file in thunderbird agenda.
Database :

generateICScalendar.png (35.72 KiB) Viewed 1286 times

Thunderbird:

ImportICSthunderbird.png (33.76 KiB) Viewed 1286 times

Friendly, J.P

[Bidouille]

You will find a code snippet on the french forum: https://forum.openoffice.org//fr/forum/ ... 26&t=18054

[Jurassic Pork]

Hello,
here is in attachment, the english version of my database example, and with macro ExportCalendarICS generated in ooBasic by A.I

MyCalendar1.png (33.44 KiB) Viewed 1180 times

MyCalendar2.png (31.14 KiB) Viewed 1180 times

Friendly, J.P