Database Table Form

The database table forms provide a columnar presentation of the data in the model.

Tip:  The database is extensive and several hundred tables can be generated. To view a list of the available input data tables, click the Advanced > Edit > More > Interactive Database Editing command to display the Choose Tables for Interactive Editing form. Click the Expose All Tables check box on the right side of the form. Click the + (plus) symbols next to the various data category names to expose a tree of the available table names. The construction of the model determines the output tables available..

Note:  During display, Excel spreadsheet and Access database files can be created. However, it is not recommended that those files be imported back into the model because the formatting applied during display likely would result in errors when the file is imported. Thus, use the appropriate Orb > Export commands to create Excel spreadsheet and Access database files that will ultimately be imported back into the model. The Export commands include controls that reduce the likelihood of errors when files are imported back into the model.

The following menu commands on the form can be used to work with the tables.

Command

Action

File menu

 

Export Current Table

 

To Excel

Exports the currently displayed table to MS Excel and opens that program, displaying the data in appropriate columns and rows.

To Access

Exports the currently displayed table to MS Access format. Displays the Save Access Database File As form; use the form to specify the location and filename for the exported data. Also opens that program.

Display Current Table

 

In Word as RTF File

Displays the Microsoft Word Rich Text File Format form; use the form to specify the location and file name for the .rtf file. Generates the currently displayed table in MS Word rich text format. Also opens MS Word and displays the exported table.

In Text Editor

Displays the Text File Report form; use the form to specify the location and file name for the .txt file. Generates the currently displayed table in plain text (ASCII) format. Also opens the default Text Editor program and displays the exported table.  

In Text Editor with No Splits

Displays the Text File Report form; use the form to specify the location and file name for the .txt file. Generates the currently displayed table in plain text (ASCII) format as a continuous feed print. Also opens the default Text Editor program and displays the exported table.

In Internet Explorer at HTML

Displays the HTML File Report form; use the form to specify the location and file name for the .html file. Generates currently displayed table using hyper-text markup language format. The resulting file can be edited, formatted or printed using an .HTML editor.

Print Current Table as Text File

Sends the currently displayed table directly to the default printer.

Export All Tables

 

To Excel

Exports all tables in the model to MS Excel and opens that program, displaying the data in appropriate columns and rows.

To Access

Exports all tables in the model to MS Access format. Displays the Save Access Database File As form; use the form to specify the location and filename for the exported data. Also opens that program.

Display All Tables

 

In Word as RTF File

Displays the Microsoft Word Rich Text File Format form; use the form to specify the location and file name for the .rtf file. Generates all of the tables in the model file in MS Word rich text format. Also opens MS Word and displays the exported tables.

In Text Editor

Displays the Text File Report form; use the form to specify the location and file name for the .txt file. Generates all of the tables in the model file in plain text (ASCII) format. Also opens the default Text Editor program and displays the exported tables.  

In Text Editor with No Splits

Displays the Text File Report form; use the form to specify the location and file name for the .txt file. Generates all of the tables in the model file in plain text (ASCII) format as a continuous feed print. Also opens the default Text Editor program and displays the exported tables.

In Internet Explorer at HTML

Displays the HTML File Report form; use the form to specify the location and file name for the .html file. Generates all of the tables in the model file using hyper-text markup language format. The resulting file can be edited, formatted or printed using an .HTML editors.

Print All Tables as Text File

Sends all of the tables in the model file directly to the default printer.

Save Current Table Formats to Table Formats File

Displays the Database Table Formats File form; use the form to specify the location and file name for the .fmt file, which, in this case, stores the format specified for displaying the currently displayed table. As appropriate, use this command after using the Format command and the Modify/Show Database Table Format form to refine the table definition of the currently displayed table.

Save All Table Formats to Table Formats File

Displays the Database Table Formats File form; use the form to specify the location and file name for the .fmt file, which, in this case, stores the format specified for all of the tables in the model file. As appropriate, use this command after using the Form-Filter-Sort command and the Modify/Show Database Table Format form to refine the table definition of all tables in the model file.

Apply Formats from File to Current Table

Displays the Database Table Formats File form; use the form to locate and select the file name for the .fmt file to be applied to the currently displayed table.

Apply Formats from File to All Tables

Displays the Database Table Formats File form; use the form to locate and select the file name for the .fmt file to be applied to all of the tables in the model file.

Add Tables

Redisplays the Choose Tables for {Interactive Editing, Display, Print or Export for [File Type]} form so that additional tables can be added to the interactive editing, display, print or export.

Remove Current Table

Removes the currently displayed table from the list of tables that have been selected to be displayed, printed or exported. This command does not remove the table from the database or the model; thus the table is available for future use.

View menu

 

Maximize (Toggle)

Use this command to toggle between a full screen display of the table or a minimized display of the table. This is similar to the Minimize/Maximize button used in Windows.

Reset Default Column Widths

Restores default column widths to the currently displayed table.

Remove Splits

Removes any program-inserted splits, which function similar to page breaks in Excel or Word.

Format-Filter-Sort menu

 

Format Table

Access the Modify/Show Database Table Format form with the Format tab selected.

Filter Table

Access the Modify/Show Database Table Format form with the Filter tab selected.

Sort Table

Access the Modify/Show Database Table Format form with the Sort tab selected.

Maximize (Toggle)

This command is a toggle and works to maximize or minimize the form, similar to the actions of the standard Windows Maximize and Minimize buttons in the upper right-hand corner of Window screens.

Reset Default Column Widths

Resets the column widths in the form to the system defaults.

Remove Splits

Removes any program or user specified splits (page breaks) in the table.

Select menu

 

Select

 

     Current Record

In the active window, selects the object associated with the selected record.

     Current Table

In the active window, selects the objects associated with the data in the currently displayed table.

Current Table within Current Selection

Can be used to progressively select objects in the active window when those objects share common parameters. It should be used in conjunction with other selection options to select objects that have characteristic A and then characteristics A and B and then characteristics A, B, and C and so on. For example, assume the Format-Filter-Sort menu > Filter command has been used to specify a particular pattern of data tables (i.e., "the current selection"). Use this command to select the objects in the active window associated with that pattern by selecting a table type (e.g., Joint Restraint Assignments) from the drop-down list in the upper right-hand corner of this form. The command can be used repeatedly to select a subset of the previously selected data by selecting another table type or record (click on a particular record).

     All

In the active windows, selects all of the objects associated with all of the data in the specified table(s).

Deselect

 

      Current Record

In the active window, deselects the object associated with the selected record.

       Current Table

In the active window, deslects the objects associated with the currently displayed table.

Invert Selection

Clears the selected items and selects the unselected items in the active window.

Get Previous Selection

Selects whatever objects were last previously selected in the active window.

Clear Selection

In the active window, clears the selection of all currently selected objects. It is an all or nothing command. The command can not be used to selectively clear a portion of a selection.

Options menu

 

Print Landscape

Prints the display so that the width of the print exceeds the length of the print.

Print Filter After Table Title

The Modify/Show Database Table Format form may be used to apply filtering to the data in the table(s). Use this option to specify that the filtering criteria be printed after the table title.

Print Hyperlinked Contents

Generates a table of contents for the table as the first page of the output, with hyperlinks to facilitate movement through the output.

 

Access a database table form as follows:

 

Method 1:  

  1. Click the Design/Rating > Seismic Design > Run Seismic command.

  2. After design has been run, click the Design/Rating > Seismic Design > Report command.

Method 2:

  1. After a Rating Request has been specified, click the Design/Rating > Load Rating > Run Rating command

  2. Click the Show Tables button on the resulting Bridge Object Response Display form.

Method 2:

  1. Click the Home > Display > Show Table command to display the Choose Tables for Display form.

  2. Check the check box associated with the type of data table to be included in the display.

  3. Click the OK button to display the database table.

    • Alternatively, to display a single table type, expand the tree associated with a table type selected on the Choose Tables for Display form by clicking on the plus (+) symbol preceding the table type name. Continue expanding the tree until the table appears (Table: {Name}). Right click on the table name and select Display Table from the resulting drop-down list; then select the In CSiBridge option from the next drop-down list to display the database table form.

Method 3:

  1. Click the Orb > Report > Advanced Report Writer command to display the Create Custom Report form.

  2. Select a database using the appropriate button (Find Existing DB File, Convert Excel File and so forth)

  3. Select the table(s) to be included in the report by highlighting the name(s) in the List of Tables in Current Database File display area; and then click the Add Selected DB Table(s) to Report button.

  4. Highlight a table name in the Items Included in Report area of the Create Custom Report form and click the Show Table button to display a database table form.