Ask Your Question

How do I activate File/Export in Libre Base?

asked 2017-03-10 20:14:57 +0200

tomstuart gravatar image

Yes, I went to Tools/Options/LibreOffice/General and checked the box Use LibreOffice dialogs. Still dimmed.

edit retag flag offensive close merge delete


Base is somewhat different than the others. What are you attempting to accomplish?

Ratslinger gravatar imageRatslinger ( 2017-03-10 22:19:22 +0200 )edit

I want to send a database. I see one can email a database, i.e., the odb file, but the data resides in the configuration file, so that doesn't appear to work. One can also export individual tables via libre calc, but that is tedious for an entire database. I thought there might be a resolution in the File/Export command.

tomstuart gravatar imagetomstuart ( 2017-03-11 03:12:24 +0200 )edit

What type of DB are you talking about: embedded; split; external (which one)?

Ratslinger gravatar imageRatslinger ( 2017-03-11 03:30:53 +0200 )edit

Embedded in Base.

tomstuart gravatar imagetomstuart ( 2017-03-11 18:27:21 +0200 )edit

See my answer. I don't see any reason you can't send the .odb in an email. Just completed a test sending an embedded DB and had no problems.

Ratslinger gravatar imageRatslinger ( 2017-03-11 19:10:17 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2017-03-11 03:49:56 +0200

Ratslinger gravatar image

Based upon you comment, if using an embedded DB, the .odb contains the all the data already and you can email as is. If you are talking of a split DB, zip (or archive) the entire folder, rename the extension (change .zip to something else) because most email services wont allow zipped files, then provide instructions to the recipient. If an external DB (MySQL, PostgreSQL etc.) then email two items, the .odb & a dump of the database from the server.

edit flag offensive delete link more


Thank you for the comprehensive answer. I see now that my database is not embedded, it is split. Also that conversion is not trivial, requires some work.

tomstuart gravatar imagetomstuart ( 2017-03-12 22:24:00 +0200 )edit

On Linux the whole process takes less than 30 seconds. The real time consumption is let the recipient know what to do.

If the answer solves your question please tick the ✔.

Ratslinger gravatar imageRatslinger ( 2017-03-12 22:46:19 +0200 )edit

answered 2017-03-11 13:42:32 +0200

Pansmanser gravatar image

I have found the sql 'script' command useful. SCRIPT 'filename' stores all the tables and much other information. The whole thing, or parts of it can then be run as a sql command to restore data. Particularly useful if you need to modify a large table.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-10 20:14:57 +0200

Seen: 257 times

Last updated: Mar 11 '17