{"id":4430,"date":"2013-09-29T05:09:38","date_gmt":"2013-09-28T19:09:38","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=4430"},"modified":"2019-10-05T14:26:30","modified_gmt":"2019-10-05T04:26:30","slug":"openoffice-mysql-import-data-migration-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/openoffice-mysql-import-data-migration-primer-tutorial\/","title":{"rendered":"OpenOffice MySql Import Data Migration Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"OpenOffice MySql Import Data Migration Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/OpenOffice_Access_Primer.jpg\" title=\"OpenOffice MySql Import Data Migration Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">OpenOffice MySql Import Data Migration Primer Tutorial<\/p><\/div>\n<p>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.<\/p>\n<blockquote><p>Apache OpenOffice (AOO) is an open-source office productivity software suite. It descends from OpenOffice.org and IBM Lotus Symphony.[5]<\/p>\n<p>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]<\/p>\n<p>Apache OpenOffice&#8217;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.<\/p>\n<p>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]<\/p><\/blockquote>\n<p>As you would imagine, such a project has many parts to it, and we will explore some over time, but, as always &#8230;<\/p>\n<ul>\n<li>Feel free to explore yourself<\/li>\n<li>Visit search engines with more specific queries about specific topics, always add &#8220;OpenOffice&#8221; in there somewhere, and arrive at specialized forums and\/or blogs and\/or official sites<\/li>\n<li>Make sure you reset your body&#8217;s clocks &#8230; yes, clocks &#8230; to meet the day with the proper start involving getting out in the day and seeing the sunshine &#8230; if you are not in the dark in winter, that is &#8230; see <a target=_blank title='resetting your body clocks' href='http:\/\/www.shape.com\/lifestyle\/mind-and-body\/reset-your-body-clock'>here<\/a><\/li>\n<li>Think of this tutorial as a way to learn a lot about <a target=_blank title='Access Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=1365'>Microsoft Access<\/a>, as well.<\/li>\n<\/ul>\n<p><a target=_blank title='Enjoy the tutorial' href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/\">Today<\/a>, we use some previously populated MySql database tables from the <a target=_blank title='MySql XML Import Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=1736'>MySql XML Import Primer Tutorial<\/a>  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 <a target=_blank title='PHP and MySql via MAMP Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=933'>MAMP<\/a> webserver, finishing off with an emailed report as well (we are on a Mac laptop &#8230; we have shrunk to a <a target=_blank title='small bee' href='http:\/\/standingoutinmyfield.wordpress.com\/2013\/09\/09\/the-largest-and-the-smallest-bee-in-the-world\/'>perdita minima<\/a> that you get near the top right of the keyboard&#8217;s &#8220;Shift&#8221; key (why so much there?) &#8230; <font size=\"1\">hello honey<\/font>).   Who could call this website <a target=_blank title='lame' href='http:\/\/lame.sourceforge.net\/'><strike>lame<\/strike><\/a> <a style=\"font-size:8px;\" target=_blank title='lame' href='http:\/\/oxforddictionaries.com\/definition\/english\/lame'><strike>lame<\/strike><\/a> <a style=\"font-size:6px;\" target=_blank title='lame' href='http:\/\/www.urbandictionary.com\/define.php?term=lame'>lame<\/a>?!!<\/p>\n<p>Link to some OpenOffice Macro programming source code data file <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/Main.xba_GETME\" title='Main.xba'>Main.xba<\/a> constructed to aid with the import of data using an OpenOffice Form&#8217;s database connection with some embedded SQL statements to insert records &#8230; aided and abetted by the initial MySql table export to SQL by the brilliant <a target=_blank title='phpMyAdmin interface to MySql and PHP Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=492'>phpMyAdmin<\/a> to <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/country_state.sql_GETME\" title='country_state.sql'>country_state.sql<\/a><\/p>\n<p>Link to output PDF data file <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/OpenOffice\/Access\/country_state.pdf\" title='country_state.pdf'>country_state.pdf<\/a><\/p>\n<p>Link to OpenOffice information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/Apache_OpenOffice' title='OpenOffice information via Wikipedia'>from Wikipedia<\/a> as used by quote above.<br \/>\nLink to OpenOffice &#8220;spiritual home&#8221; &#8230; <a target=_blank href='http:\/\/www.openoffice.org\/' title='The Free and Open Productivity Suite'>via Apache Software Foundation<\/a>.\n<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d4430' onclick='var dv=document.getElementById(\"d4430\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?s=Microsoft+Office#content\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d4430' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/openoffice-mysql-import-data-migration-primer-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,9,12,37],"tags":[292,293,299,452,736,854,881,997,1018,1054,1186,1319],"class_list":["post-4430","post","type-post","status-publish","format-standard","hentry","category-data-integration","category-database","category-elearning","category-tutorials","tag-data-integration-2","tag-data-migration","tag-database-2","tag-form","tag-macro","tag-odb","tag-openoffice","tag-programming","tag-query","tag-report","tag-sql","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4430"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=4430"}],"version-history":[{"count":1,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4430\/revisions"}],"predecessor-version":[{"id":46669,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/4430\/revisions\/46669"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=4430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=4430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=4430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}