libre office data base

[Peter Goggin]

It appears that the data base file is empty.  I suspect that it is a 
disk problem . I have a similar data base on another machine and so I 
will reenter the dat into this data base.  I suspect that my very old 
lenova laptops need to be replaced.

Regards

Peter Goggin

On 13/2/25 06:08, Little Girl wrote:
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20250215/78f9ff62/attachment.html>