OpenOffice MySql Import Data Migration Primer Tutorial
Here is a tutorial that shows you some database functionality of a great suite of office automation programs called OpenOffice, by Apache Software Foundation. OpenOffice has functionality like the Microsoft Office suite of programs, bringing the user a lot of the feel of those well loved concepts to your document creation work, and integrated into the one place. Today we do a bit of work that Microsoft Access database might do for you, but in OpenOffice the database has an .odb extension with a similar interface to the database to that of Microsoft Access.
Apache OpenOffice (AOO) is an open-source office productivity software suite. It descends from OpenOffice.org and IBM Lotus Symphony.[5]
Apache OpenOffice contains a word processor (Writer), a spreadsheet (Calc), a presentation application (Impress), a drawing application (Draw), a formula editor (Math), and a database management application (Base).[6]
Apache OpenOffice’s default file format is the OpenDocument Format (ODF), an ISO/IEC standard, which originated with OpenOffice.org. It can also read a wide variety of other file formats, with particular attention to those from Microsoft Office.
Apache OpenOffice is developed for Linux, OS X and Windows, with ports to other operating systems. It is distributed under the Apache License.[4] The first release was version 3.4.0, on 8 May 2012.[1]
As you would imagine, such a project has many parts to it, and we will explore some over time, but, as always …
- Feel free to explore yourself
- Visit search engines with more specific queries about specific topics, always add “OpenOffice” in there somewhere, and arrive at specialized forums and/or blogs and/or official sites
- Make sure you reset your body’s clocks … yes, clocks … to meet the day with the proper start involving getting out in the day and seeing the sunshine … if you are not in the dark in winter, that is … see here
- Think of this tutorial as a way to learn a lot about Microsoft Access, as well.
Today, we use some previously populated MySql database tables from the MySql XML Import Primer Tutorial and migrate the data from these tables into an OpenOffice database, and then we will export a report of that database to PDF and display on a local MAMP webserver, finishing off with an emailed report as well (we are on a Mac laptop … we have shrunk to a perdita minima that you get near the top right of the keyboard’s “Shift” key (why so much there?) … hello honey). Who could call this website lame lame lame?!!
Link to some OpenOffice Macro programming source code data file Main.xba constructed to aid with the import of data using an OpenOffice Form’s database connection with some embedded SQL statements to insert records … aided and abetted by the initial MySql table export to SQL by the brilliant phpMyAdmin to country_state.sql
Link to output PDF data file country_state.pdf
Link to OpenOffice information … from Wikipedia as used by quote above.
Link to OpenOffice “spiritual home” … via Apache Software Foundation.
If this was interesting you may be interested in this too.
