[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 16.12.2015 um 09:19 schrieb Ken Heard:
> On 2015-12-12 20:57, Don Parris wrote:
> 
> 
> The "address books:registering" entry in the LibreOffice Writer help
> (F1) explains how to import various address books into Writer.  I have
> so far set it up to use my icedove address book in Writer, but I have
> yet to use it for actual addressing.
> 
> Regards, Ken
> 
> 

We can connect a Base document with dozends of different database types,
spreadsheets, plain text (csv), dBase and some address books.

This topic is about the KDE address book in particular. LO has a
built-in driver (sdbc:address:kab) which does not work anymore because
the KDE folks added a new abstraction layer "Akonadi" between database
and client applications.

According to the German Wikipedia, Akonadi saves data in some Sqlite,
MySQL or PostgreSQL database.

> https://de.wikipedia.org/wiki/Akonadi


Either we find a way to connect to this database (for all 3 types
drivers are availlable) or someone writes a new sdbc driver for "Aconadi".


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Don Parris]

On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger  wrote:

> Am 12.12.2015 um 14:57 schrieb Don Parris:
> > I want to use KAddressBook as the resource for my LibreOffice mailmerge.
> > Unfortunately, the only way this seems possible is by exporting the
> > contacts from KAddressBook to a CSV file.
> >
> > I have searched high and low, and cannot find any good way to use
> > KAddressBook.  The KDE-PIM group seems to offer little help beyond
> > exporting the data.
>
> How did you formulate your question? Can you provide a hyperlink to your
> help request? Did you ask for specific parameters to connect with the
> underlying database?
> Developers don't know anything about LibreOffice except that it has a
> spreadsheet application so they recommend csv because this is what
> everybody does when database data need to be used with non-database
> applications.
>
>


I though my question - posed some time ago now - was quite clear.  I can't
even recall getting an actual reply to my question.  I found a similar
thread via a Google search, but that just basically told the OP to use
import.  It really is difficult to imagine that the KDE-PIM developers
don't know about LibreOffice or its ability to import addresses.  I really
assume it is incumbent on the LibreOffice devs to create the appropriate
tool.  Did the Evolution devs create the LibreOffice tool for accessing its
address book directly?

It really is completely mind-boggling that two prominent projects would
somehow "miss" each other like this.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 15.12.2015 um 17:23 schrieb Don Parris:
> On Mon, Dec 14, 2015 at 5:17 AM, Andreas Säger  wrote:
> I though my question - posed some time ago now - was quite clear.  

But possibly untechnical. Did you ask how you can connect to the
contacts and issue an SQL query such as
  SELECT * FROM CONTACTS
?


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 15.12.2015 um 17:23 schrieb Don Parris:
> 
> It really is completely mind-boggling that two prominent projects would
> somehow "miss" each other like this.
> 

Only a tiny fraction of LO users is aware of database connectivity. Most
users use Base through the mail merge wizard to connect a serial letter
with a spreadsheet. That wizard hides away the whole database thing.
Most software developers never use any office suite.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Alexander Thurgood]

Le 12/12/2015 14:57, Don Parris a écrit :

Don,



> This leads to a second, related question (maybe a dev lurking around
> here?):  Why hasn't this been addressed after all these years, with Kontact
> as a fairly widely-used program?  Is it impossible?  what would it take to
> get this resolved???  I can't believe I'm the only frustrated Kontact user
> out here.


There's this old stuff :

http://opensource.bureau-cornavin.com/kab/

No idea whether it still works.

And this :

https://forum.openoffice.org/en/forum/viewtopic.php?f=7=36227

would seem to indicate that the shift to the Akonadi backend hosed
connectivity for everyone - you could always blame the KDE people, or
those involved in the KAB software for choosing a backend that no longer
allowed for interfacing with OOo/LO, but I doubt that would do much good

 ;-)

Alex



-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Alexander Thurgood]

Le 12/12/2015 14:57, Don Parris a écrit :



> This leads to a second, related question (maybe a dev lurking around
> here?):  Why hasn't this been addressed after all these years, with Kontact
> as a fairly widely-used program?  Is it impossible?  what would it take to
> get this resolved???  I can't believe I'm the only frustrated Kontact user
> out here.


Someone requested such support back in 2010 :

http://lists.opensuse.org/opensuse-features/2010-12/msg00142.html

and also :

https://bz.apache.org/ooo/show_bug.cgi?id=113909


Doesn't seem like anything happened there either.

Alex





-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Use KAddressBook As LibreOffice Resource

[Andreas Säger]

Am 12.12.2015 um 14:57 schrieb Don Parris:
> I want to use KAddressBook as the resource for my LibreOffice mailmerge.
> Unfortunately, the only way this seems possible is by exporting the
> contacts from KAddressBook to a CSV file.
> 
> I have searched high and low, and cannot find any good way to use
> KAddressBook.  The KDE-PIM group seems to offer little help beyond
> exporting the data.

How did you formulate your question? Can you provide a hyperlink to your
help request? Did you ask for specific parameters to connect with the
underlying database?
Developers don't know anything about LibreOffice except that it has a
spreadsheet application so they recommend csv because this is what
everybody does when database data need to be used with non-database
applications.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted