libre office data base

[Little Girl]

Hey there,

Peter Goggin via ubuntu-users wrote:

>I have a libre data base I use for financial data.  It has stopped 
>working with the error message:
>
>The driver class could not be loaded 
>./connectivity/source/commontools/dbexception.cxx413
>
>What does this mean? Can I recover this database?

Before I begin, I don't have or use LibreOffice Base, but do have and
use other LibreOffice programs.

My Google searches for command-line ways to export the contents of a
LibreOffice Base file turned up instructions for how to do it from
within LibreOffice, which won't be useful for you since you can't
open the file.

I've often used the command-line to export the contents of
LibreOffice Calc files to CSV. A Google search and a climb through
LibreOffice's man page didn't reveal whether the same can be done
with Base files, but it's worth a try.

Maybe either or both of these would export the data to an
.sqlite or a .db file if you open a terminal window in the same
directory as your database file and replace example.odb with the name
of the database file:

	libreoffice --convert-to sqlite example.odb

	...or...
  
	libreoffice --convert-to db example.odb

If either of them work,  you could then open the resulting exported
file with Base or import it into Base.

If neither of them work, you could try accessing the database from
Python or your favorite language to retrieve the data and then
write it to a .db or .sqlite file that you could either open with
Base or import into Base afterwards.

I can provide some clumsy help with accessing the database from Python
or others in here who are more advanced in Python could probably whip
up some efficient code to get the job done.

-- 
Little Girl

There is no spoon.