Reply to topic

Connect KMYMoney to LibreOffice (Base)

Steve R.
Registered Member
Posts
5
Karma
0
According to the KMyMoney Manual, Chapter 22, KMyMoney can connect to a relational database. One is MySQL, which I do have, and could use. But I a would like to know if it would be possible to connect to Base which is the LibreOffice relational database. It uses the HSQL relational database engine. I took a quick peak at the QT software website, but could not discern anything. I was not able to find a list of "SQL Drivers".
User avatar Hei Ku
Moderator
Posts
649
Karma
2
OS
It's certainly not tested, so I'd avoid it if possible.


Hei Ku, proud to be a member of the KMyMoney Development Team since January-2008
Steve R.
Registered Member
Posts
5
Karma
0
Thanks. I'm still eperimenting, the focus in on how to import "old" stock prices into KMyMoney. Need to covert the data into a CVS format. Looking into using "AWK" as one alternative.
martinwelsh
Registered Member
Posts
11
Karma
0
Libre Office Base will work with MYSQL.

To enable the operation it is neccessary to install 'connector' from Synaptic - say libreoffice-mysql-connector.
Once this package is installed use of theHelp screens should get you up and running.
Base will give you useable access to all of the Mysql tables but do not expect miracles from Forms and Reports generated by other software.

The Libre Office forums also offer quite useful support if you do not ask 'plonker' questions.

Good luck!

martin welsh
who does not look in here very often!

 
Reply to topic

Bookmarks



Who is online

Registered users: Baidu [Spider], Bing [Bot], Exabot [Bot], garthecho, Google [Bot], koriun, Majestic-12 [Bot], odysseus-art, pedrorodriguez, Steve Guilford, Yahoo [Bot]