Apache OpenOffice (AOO) Bugzilla – Issue 58915
Need HSQL data export
Last modified: 2017-01-23 18:39:00 UTC
In an application that is WWW online (with MySQL), and has an offline component (with OOo Base), i need to periodically keep the two databases in sync.. I can export the data from MySQL with phpMyAdmin, then run it into the OOo base via the SQL tool, but i don't have a way to go the other direction (exporting Inserts from the OOo database tool). Please consider a SaveAs or Export for databases. (In ANSI SQL please). Maybe there is a better way i haven't thought of yet, so feel free to come up with a better solution. I have worked with EAI products in the past, and know that this is the type of work they do "automatically" for you. Thanks for any consideration, Steve
What about the SCRIPT command? http://hsqldb.org/doc/guide/ch09.html#script-section
First perhaps a workaround. you can export all tables to Calc, save as "csv" and then import this with phpMyAdmin.
Hi, A GUI for the script feature Frank mention, would be a easy solution, so I reassign this enhancement to the User Experience team for evaluating. Bye Marc
I don't think the script command will prove to be of help here. As far as I can see there is no way to limit the output to a given table. When the command is issued a full dump of the database if performed, all the table definitions, constraints and inserts for all data, in all tables. Further more there is no way to use the command with any type of query. There is no solution that will generate SQL insert commands that I know off, if you discount creating an export script (macro). However, if once can work with a formatted text file (a cvs file was mentioned earlier) then the solution is already in the HSQLDB engine. The use of a text table. You can issue any select statement and have it save its result set to a text table. Lookup the Create Table comamnd in the HSQLDB users manual. I have used this quite successfully to export data from a Base database. Using this techinque you can easily export all the records from a table or any selection you need from a standard SQL Select statement. The option is to use an Insert Into command with a predefined text table. This approach might suit Steves needs better. I think it would be well worth while to explore the addition of an export function into Base, but feel more thought needs to go into the functionality that would be useful. The requirements stated in the initial filing of the issue, IMO, can be readily met with the tool as delivered.
Already reported Workaround with extension *** This issue has been marked as a duplicate of issue 59369 ***