Finally... added German (Germany) and Dutch (Belgium) Translations. Translations provided by Uwe Hinkel and Georges Kuster. My apologies for having taken so long to post.

Version: 1.2.0 Date: 2010-Jul-15 Size: 74.31 KB

Added ability to launch documents contained inside folders. Code to recurse over folders was adopted from code provided by Drew Jensen--Thank you. Also, many thanks to Frank Schönheit for pointing out two handy methods (hasByHierarchicalName and getByHierarchicalName).

Also added button to automatically search forms and generate switchboard--It may be necessary to edit the labels/fonts/settings for each entry, but the structure is generated automatically. This may come in handy for users who prefer to structure forms with folders.

The Utils module has an AutoExec sub which can be bound to the [Open Document] event of a Base document.

Version: 1.1.0 Date: 2009-Oct-28 Size: 68.15 KB

Added Spanish translations--provided by: Luis E. Juan ( lejuan@teleline.es), Ingrid & Enrique Bulnes.

Also added line of code to refresh switchboard page after it is generated, as it does not seem to always refresh properly in 3.1

Version: 1.0.8 Date: 2009-Jun-11 Size: 62.52 KB

French translations provided by Alex THURGOOD / alex.thurgood@free.fr

Primary keys are no longer auto incrementing. Hopefully this will allow the switchboard to get along better with MySQL. The PK value is automatically fetched based on the previous entry.

NOTE: The main menu entry id MUST NOT be 0--should you have the need to create the main menu entry manually. The required fields are ID, ParentID (0 for main switchboard), Label (any string such as 'Main Menu'), and EntryType (6 for switchboard)

Version: 1.0.7 Date: 2009-Apr-01 Size: 62.75 KB

Fixed bug with switchboard pages/sub-menus (uncommeted function call that was commented my mistake).

Added Slovanian and Africaans translations.

Slovanian translations provided by: Martin Srebotnjak
Africaans translations provided by: Stuart King

--Enjoy

Version: 1.0.6 Date: 2009-Jan-22 Size: 61.32 KB

Added Italian translations provided by Ivano Michieletti/MBM S.R.L. Glenda.

Also, removed step for adding new entry. On previous version, it was necessary to press the [New] Button to add a new entry. If this button was not pressed, it assumed user wants to edit/upate current entry. This lead to an error if no item was selected. Changed such that wizard is always ready to accept a new entry, unless a selection has been made.

Version: 1.0.5 Date: 2008-Dec-15 Size: 49.4 KB

removed some references to the MRI extension which were causing problems in some installations. The MRI extension has nothing to do with this extension, it is simply a tool handy during development--I mistakenly left calls to load the lib in some modules.

Version: 1.0.4 Date: 2008-Nov-15 Size: 43.33 KB

The Switchboard extension generates a Switchboard/Main Menu interface to access Base forms and reports. The switchboard can be grouped into categories, each of which can contain any number of menu entries. Furthermore, you can specify the size and screen location of the form to be opened.

The generators creates three database objects.

1)The SWITCHBOARD table which has some basic information about the switchboard such as size and location of main form as well as size and positioning of menu entries.
2)The SWITCHBOARDITEMS table which has the menu entries configuration information.
3)The SWITCHBOARD form. This is a blank form generated by the wizard, and is populated with the menu entries. This form document can be modified by the user—keeping in mind that the menu entries need to be positioned at runtime.

All these items are generated automatically when the extension main hook is launched, and that database document does not have said objects. The main hook can be accessed through the Tools | Add-ons | OpenOffice.org Base Switchboard menu option. The extension can only be opened from a Registered Base document.

Currently, there are four types of menu entries that can be generated. Forms, Reports, Switchboards, and Switchboard Links. The Form and Report entries open a form or report, respectively. At runtime, the difference between a Switchboard and Switchboard Link is trivial. A Switchboard is an entry that appears as the parent of other entries (a menu). A Switchboard Link is an entry that links to another Switchboard menu—but does not have entries; this is usefully to get back to another menu (such as main menu) from an entry that may be nested somewhere down the hierarchy.

A Database form or report need not be located in the database where the Switchboard is located. This feature makes it possible to have a main switchboard that gives access to forms and reports from any number of databases.

Version 1.0.2/1.0.3 Notes
Fixed several bugs: strange errors that occurred when loading the extension dialog. These were due to failure in trying to fish out the database name from the current frame. Added several other methods of getting database name, should the first fail. As a last resort, it will open a file picker where you can select a registered database—or cancel. Also, fixed bug that deleted the the target menu instead of deleting a switchboard link item—in configuration dialog.

Size bug: There was a bug I thought I had fixed on version 1.0.3, but was still there in some OOo installations--the configuration dialog opened with a size much smaller than the actual settings. This should hopefully be fixed now. Should the error persist, double-click anywhere on the dialog to expand. If nothing happens, you may be clicking on a label which happens to have a transparent back ground. If there is no dialog area that is not covered by a label, you can also double click on the white area at the top-left corner. Continue to double-click until the dialog is the desired size.

I have re-uploaded with a new release/version such that it is caught by the OOo extension manager and you are notified of the update--if you have a recent version of OOo.

Features added: Hungarian translation (Thank you Zoltan Reizinger). Added ability to include a entry button icon as well as specify label font (size, color, Bold, Italic). The font size is especially important, as Base 3.0 forms default to a very small size—also in some Linux versions.

Thank you all who reported bugs and suggestions, and Zoltan for providing translations as well as testing.

Here
is a sample Switchboard with icons.

Version: 1.0.3 Date: 2008-Nov-15 Size: 43.32 KB

The Switchboard extension generates a Switchboard/Main Menu interface to access Base forms and reports. The switchboard can be grouped into categories, each of which can contain any number of menu entries. Furthermore, you can specify the size and screen location of the form to be opened.

The generators creates three database objects.

1)The SWITCHBOARD table which has some basic information about the switchboard such as size and location of main form as well as size and positioning of menu entries.
2)The SWITCHBOARDITEMS table which has the menu entries configuration information.
3)The SWITCHBOARD form. This is a blank form generated by the wizard, and is populated with the menu entries. This form document can be modified by the user—keeping in mind that the menu entries need to be positioned at runtime.

All these items are generated automatically when the extension main hook is launched, and that database document does not have said objects. The main hook can be accessed through the Tools | Add-ons | OpenOffice.org Base Switchboard menu option. The extension can only be opened from a Registered Base document.

Currently, there are four types of menu entries that can be generated. Forms, Reports, Switchboards, and Switchboard Links. The Form and Report entries open a form or report, respectively. At runtime, the difference between a Switchboard and Switchboard Link is trivial. A Switchboard is an entry that appears as the parent of other entries (a menu). A Switchboard Link is an entry that links to another Switchboard menu—but does not have entries; this is usefully to get back to another menu (such as main menu) from an entry that may be nested somewhere down the hierarchy.

A Database form or report need not be located in the database where the Switchboard is located. This feature makes it possible to have a main switchboard that gives access to forms and reports from any number of databases.

Version 1.0.2 Notes
Fixed several bugs: strange errors that occurred when loading the extension dialog. These were due to failure in trying to fish out the database name from the current frame. Added several other methods of getting database name, should the first fail. As a last resort, it will open a file picker where you can select a registered database—or cancel. Also, fixed bug that deleted the the target menu instead of deleting a switchboard link item—in configuration dialog.

Features added: Hungarian translation (Thank you Zoltan Reizinger). Added ability to include a entry button icon as well as specify label font (size, color, Bold, Italic). The font size is especially important, as Base 3.0 forms default to a very small size—also in some Linux versions.

Thank you all who reported bugs and suggestions, and Zoltan for providing translations as well as testing.

Here
is a sample Switchboard with icons.

Version: 1.0.2 Date: 2008-Nov-12 Size: 42.95 KB

The Switchboard extension generates a Switchboard/Main Menu interface to access Base forms and reports. The switchboard can be grouped into categories, each of which can contain any number of menu entries. Furthermore, you can specify the size and screen location of the form to be opened.

The generators creates three database objects.

1. The SWITCHBOARD table which has some basic information about the switchboard such as size and location of main form as well as size and positioning of menu entries.
   
2. The SWITCHBOARDITEMS table which has the menu entries configuration information.
   
3. The SWITCHBOARD form. This is a blank form generated by the wizard, and is populated with the menu entries. This form document can be modified by the user—keeping in mind that the menu entries need to be positioned at runtime.
   

All these items are generated automatically when the extension main hook is invoked, and that database document does not have said objects. The main hook is can be accessed through the Tools | Add-ons | OpenOffice.org Base menu option. The extension can only be invoked from a Registered Base document.

Currently, there are four times of menu entries that can be generated. Forms, Reports, Switchboards, and Switchboard Links. The Form and Report entries open a form or report, respectively. At runtime, the difference between a Switchboard and Switchboard Link is trivial. A Switchboard is an entry which can appear as the parent of other entries (a menu). A Switchboard Link is an entry that links to another Switchboard menu—but does not have entries; this is usefully to get back to another menu (such as main menu) from an entry that may be nested somewhere down the hierarchy.

A Database form or report need not be located in the database where the Switchboard is located. This feature makes it possible to have a main switchboard that gives access to forms and reports from any number of databases.

Version: 1.0.0 Date: 2008-Oct-07 Size: 35.7 KB