{"id":9260,"date":"2014-08-31T05:04:33","date_gmt":"2014-08-30T19:04:33","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=9260"},"modified":"2019-10-05T14:27:23","modified_gmt":"2019-10-05T04:27:23","slug":"libreoffice-database-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-database-primer-tutorial\/","title":{"rendered":"LibreOffice Database Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Database\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"LibreOffice Database Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Database\/Libre_Database_Primer.jpg\" title=\"LibreOffice Database Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">LibreOffice Database Primer Tutorial<\/p><\/div>\n<p>Over the last couple of days we&#8217;ve mentioned the big link between <a target=_blank title='LibreOffice from The Document Foundation' href='http:\/\/www.libreoffice.org'>LibreOffice<\/a> and <a target=_blank title='OpenOffice' href='http:\/\/www.OpenOffice.org'>OpenOffice<\/a>, and this link is very close when it comes to its database functionality, because the format of the database is shared between the two suites of programs.   It is the .odb extension and we talked about it with previous relevant <a target=_blank href='#omimpt' title='OpenOffice MySql Import Data Migration Primer Tutorial'>OpenOffice MySql Import Data Migration Primer Tutorial<\/a> as shown below.<\/p>\n<p>Here is a tutorial that shows you some database functionality of a great suite of office automation programs called LibreOffice, by The Document Foundation.  LibreOffice has functionality like the <a target=_blank title='Microsoft Office' href='http:\/\/office.microsoft.com\/'>Microsoft Office<\/a> 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 LibreOffice the database has an .odb extension with a similar interface to the database to that of Microsoft Access.<\/p>\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;LibreOffice&#8221; in there somewhere, and arrive at specialized forums and\/or blogs and\/or official sites<\/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\/LibreOffice\/Database\/\">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 a LibreOffice database (= OpenOffice database), and along the way create PDF outputs of some of the processing steps for your edification.<\/p>\n<p>Link to output PDF data file of form data of tutorial <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Database\/country_state.pdf\" title='country_state.pdf'>country_state.pdf<\/a><br \/>\nLink to output PDF data file of report of tutorial <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice\/Database\/Country and State Report.pdf\" title='Country and State Report.pdf'>Country and State Report.pdf<\/a><\/p>\n<p>Link to LibreOffice information &#8230; <a target=_blank href='http:\/\/en.wikipedia.org\/wiki\/LibreOffice' title='LibreOffice information via Wikipedia'>from Wikipedia<\/a>.<br \/>\nLink to LibreOffice &#8220;spiritual home&#8221; &#8230; <a target=_blank title='LibreOffice from The Document Foundation' href='http:\/\/www.libreoffice.org'>LibreOffice<\/a> via the Document Foundation.\n<\/p>\n<hr \/>\n<p id='omimpt'>Previous relevant <a target=_blank href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=4430' title='OpenOffice MySql Import Data Migration Primer Tutorial'>OpenOffice MySql Import Data Migration Primer Tutorial<\/a> is shown below.<\/p>\n<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<hr \/>\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='#d9260' onclick='var dv=document.getElementById(\"d9260\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=database\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d9260' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Over the last couple of days we&#8217;ve mentioned the big link between LibreOffice and OpenOffice, and this link is very close when it comes to its database functionality, because the format of the database is shared between the two suites &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-database-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,694,736,854,881,997,1018,1054,1186,1319],"class_list":["post-9260","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-libreoffice","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\/9260"}],"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=9260"}],"version-history":[{"count":2,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/9260\/revisions"}],"predecessor-version":[{"id":46670,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/9260\/revisions\/46670"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=9260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=9260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=9260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}