Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky
I hope that once you have HSQLDB working, you will transfer eventually migrate to Firebird. It has been far superior and and stable once I worked out the bugs. https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB https://wiki.documentfoundation.org/Documentation/FirebirdMi

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Drew Jensen
Fair enough what people have said. The one thing that hasn't been said is what you need to do with that that it needs to be in a database. Depending on what that is I may disagree with my colleagues and say go for the firebird engine. So - what are you hoping to get from the data in a database ta

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread bunk3m
Thank you Alex, Paulo and Drew. I didn't realize there were so many "bugs" still to work out. I'll stick with HSQLDB for now. I trust there will eventually be a way to migrate to the new DB in the future? On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood wrote: > Le 19/03/2020 à 13:32, bunk3m a é

Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky
See below... On 3/19/20 10:10 AM, Alexander Thurgood wrote: Le 19/03/2020 à 13:32, bunk3m a écrit : I would only recommend using embedded Firebird if you're comfortable with all of its still numerous bugs, and are happy to get your hands dirty correcting data types, lengths, etc and possibly co

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Alexander Thurgood
Le 19/03/2020 à 13:32, bunk3m a écrit : I would only recommend using embedded Firebird if you're comfortable with all of its still numerous bugs, and are happy to get your hands dirty correcting data types, lengths, etc and possibly corrupted data. Also, it is my understanding that there is curre

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread bunk3m
Thank you Alex and Drew. I'll try your suggestions today. I appreciate your help! One more question if I might. If I understand correctly, HSQLDB is being replace by Firebird. So I'd like the engine to be Firebird so I don't end up with an issue in the future. How does one know that Firebird is b

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Alexander Thurgood
Le 19/03/2020 à 01:57, bunk3m a écrit : As Drew has said, you can use your existing flat file in several ways : 1) Go via the empty ODB file method to drag the linked XLSX sheet from your first ODB file to the second, empty ODB file and then follow the import wizard. 2) Create an empty ODB file