Ask Your Question
1

LibreOffice and Thunderbird Addressbook

asked 2018-01-30 21:43:32 +0100

PieterG gravatar image

In my thunderbird address book, besides default personal addressbook and collected addresses, I do have several other address books.

When I use the assistant from LibreOffice to create a data source for addresses I can check thunderbird/icedove.. Then only the two defaults show... none of my other addressbooks.

This is my about: Versie: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 CPU-threads: 4; Besturingssysteem:Windows 6.19; UI-render: standaard; Locale: nl-NL (nl_NL); Calc: group

though windows 6.19 ? is windows 10 of course..

Anyone that can share some info on how to get to the other addressbooks in thunderbird?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2018-02-01 00:32:00 +0100

Ratslinger gravatar image

Hello @PieterG,

Sorry for the delay in answering but have been testing this on & off between other items since your post.

It appears LO (and the Thunderbird DB connector) only retrieve two tables from Thunderbird. These tables are based upon 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). The contents of these create the "AddressBook" and "CollectedAddressBook" tables respectively in Base. Any lists in those files are also transcribed as 'Views' in the Base table section.

If you create new address books, they are named "abook-1.mab", "abook-2.mab" , etc. If you import an address book it is named "impab.mab". Unfortunately these seem to be ignored through the wizard. Additionally, using a macro to access the DB would not get these files either. Also tried from SqLite (used in Thunderbird) but not success.

Now it seems there are some elaborate ways to still accomplish this but the amount of work needed takes a good deal of time transferring data around from one source to another. There also is no automatic updating so every change would need a new transfer of data. There may (not certain) be a way using macros but would need some time to come up with a solution which is acceptable.

This may be cause for you to file a bug report on Bugzilla as it seems there is none on this subject.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more
0

answered 2018-02-02 22:31:36 +0100

PieterG gravatar image

Thanks for your answer @Ratslinger.

The odd thing is that I had this working in OpenOffice 4.0 and previous versions. Therefore I cannot identify this as a thunderbird bug. LibreOffice being a fork I expected it to work same way as in OpenOffice 4.0 (or previous)

When I look in the folder of my thunderbird profile I do see that I also have 7 abook-x.mab (x representing numbers 1 to 7) files that apparently arent seen by the assistant.

If the assistant would check and loop through all abook files my guess would be the address books would then show allright.

Tx,

Pieter

By the way, the update to OpenOffice 4.1 did break the functionality completely... My best bet it to revert to 4.0 or before?

edit flag offensive delete link more

Comments

Probably true on the 4.0 for this function. Can't see other easy options.

Ratslinger gravatar imageRatslinger ( 2018-02-02 22:54:40 +0100 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-01-30 21:43:32 +0100

Seen: 456 times

Last updated: Feb 02 '18