Panduit Database Structure
The Panduit Part Selection Tool uses an open design that allows the user to easily re-design the dialogs with new or different filter criteria or even completely different component groups. This requires the use of Microsoft Access.
Files and Tables
The data and dialog structures for the Panduit Plug-ins are stored in the Panduit.mdb file located in the Plugins\Panduit folder.
Each product has its own table containing data and fields that are specific to that product group. Panduit precedes all the standard product group tables. For example:
Corresponding to the Panduit product tables are the Panduit product queries. The queries link fields in the standard OpenUtilities Substation parts database to the product group tables. This allows standard part fields like Description or Color to be stored in the main parts database and product-specific fields like Duct area to be stored in part-specific tables. The main parts database, currently being used by your project, is dynamically linked to the Panduit.mdb. This makes the Panduit.mdb file portable, and once changes are finalized, the file can be transferred to another machine without resetting links and queries to a new set of file paths. Example query names:
The Button table (ButtonTable) allows you to specify a dialog name for displaying the query information.
|Button Name||The name of the button to display in the main part selection dialog or in one of the other Panduit tools. Button names should be single words without spaces, commas, colons, etc.|
|Dialog_Title||The name of the dialog that will be dynamically created to show the query.|
|Show||Determines if the button will be displayed in the main parts dialog and if the table name will appear in the first selection list after the button is selected. Entire dialogs can be enabled or disabled by toggling the Show field.|
|Table_Name||The query or table name that is displayed by the dialog.|
A tool is provided for editing the button table. Select the Button Table Editor option to display the Button Table Editor dialog.
|Button Name||When you select a button in the Button Name field, the database columns for that button will appear.|
|New||To add a new row to the button table, select the New button. Blank setting fields will appear for the new row. Enter the desired information and select the Apply button.|
|Edit||To edit the displayed information, select the desired
row and then select the
Edit button. Editing (Setting) fields will
appear for the selected row.
Edit the information as desired and select the Apply button.
|Delete||To delete a row from the button table, select the row and then select the Delete button.|
The Index table (IndexTable) allows control of the fields to display and the types of filter to use in each dialog.
A tool is provided in OpenUtilities Substation for editing the Index table. Select Index Table Editor to display the Index Table Editor dialog.
|Button Name/Dialog||When you select a button in the Button Name field and a dialog name in the Dialog field, the database columns for that button and dialog will appear.|
|New||Adds a new row to the Index table. Blank setting fields will appear for the new row.|
|Edit||To edit the displayed information, select the desired row and then select the Edit button. Editing (Setting) fields will appear for the selected row.|
|Delete||Removes the selected row from the Index table.|
|Up Arrow/Down Arrow||Allows you to move a selected row up or down in the list of rows (which affect the order in which the fields appear in the dialog).|
|Exchange||Switches the positions of two selected rows (hold down the <Ctrl> key to in order to select the second row).|