This is the code utilized in the various sample/code listings throughout the book as well as other resources (Extensions, Experiments, etc).
|Base [Embedded] Macros||A brief overview on working with macros embedded in a Base document. This topic was not covered in the book as the book was written on version 2.4 of OpenOffice.org. Aside from notes contained in this document all other code should work the same--embedded or in global library.|
|Book Source Code||Zipped file with the entire book source code|
|Other Resources||Sample Database (DB1) and Code as Basic Extension|
|Word Reference API Java Library||Java Library to access the www.wordreference.com API. Library provides interface translate a term, or get synonyms(English only as of 10/30/2011)|
This is an experimental extension that wraps the Java API for Google translate (http://code.google.com/p/google-api-translate-java/)
Sub Main Dim translator As Object Dim sInput As String Dim lFrom As new com.sun.star.lang.Locale Dim lTo As new com.sun.star.lang.Locale Dim Errors() Dim I As Integer lFrom=getLocale() 'GET SOFFICE LOCALE lTo.Language="es" translator=createUnoService("com.baseprogramming.language.Translator") translator.setSourceLocale(lFrom) translator.setTargetLocale(lTo) translator.setHttpReferrer("www.baseprogramming.com") sInput="I am singing in the rain. Just singing in the rain. What a Glorious feeling, I am happy again. Singing, and dancing in the rain." print translator.translate(sInput) End Sub
Currently only tested on OpenOffice.org 3.2/Windows XP. I had some installation issues, which were solved by switching to JRE 1.6.0_13 (Tools->Options; Open OpenOffice.org node, then select Java).
|Data Import Wizard Extension||Data Import Wizard found in chapter 14 bundled as an extension. This was put together using the Basic Add-On Builder extension.|
|DB Doc Shortcut.||This is a brief extension that creates a desktop shortcut for database documents such as forms and reports. This makes it ideal for situations in which you do not want the user to open the database in order to navigate to a form. This was also put together with the BasicAddon extension.|
|BaseShell||I experienced some errors with OpenOffice.org 2.4.1 and socket connections. I changed the BaseShell.py module to connect with a pipe.|
|Base Switchboard Extension||
This is a switchboard (Menu) generator. Menues can be grouped into categories, and menu entries (forms and reports) can reside in the local database or an external database. I will post a quick guide soon.
You may submit any comments or suggestions to
Click here to view documentation.
You can submit a GUI translation by filling out this Form. Please email to firstname.lastname@example.org and I will to my best to include the translations in the next release.
Menu Entry Icons by dryicons.com
|OOo Basic Db Development||Demonstrates how to use OOo Basic to access the database API|
|Forms and Dialogs||Demonstrates how to work with OO Basic and Base Forms as well as dialogs.|