Difference between revisions of "DB:Global Equipment"

Latest revision as of 14:41, 29 December 2010

Database>Equipment

Settings Explanation

Setting	Description
File>New	New Equipment. Database>Equipment[New]
File>Save	Saves the changes.
File>Exit	Closes the form.
Edit>Undo	Undoes ALL changes back to last save. Use sparingly.
Edit>Refresh	Refreshes the data.
Edit>Clear Data	Deletes the data in the current selection.
Edit>Delete Selected Row(s)	Deletes the selected rows from the database. Be sure to save your changes.
Edit>Copy Selection Down	Uses the top cell in the selection as the source data and repeats it down for each cell in the selection.
Edit>Increment Select Down	Uses the top cell in the selection as the source data appending a numeric value and incrementing it down for each cell in the selection.
Tools>Move Equipment to Different ManufacturerID	Change the Manufacturer that the equipment is associated with. Select the manufactuerer that you want to move the equipment to from the drop-down. Database>Equipment>Tools>Move...
Tools>Remove Duplicates	Removes duplicate entries. Uses the following rules: Checks for IO if not found the item is removed. If all items have IO the first in the collect is kept and the subsequent records are dropped.

Grid Basics

Every grid in WireCAD has the same basic functionality. Some functionality is disabled in some grids.

• Not all grids display the filter pane.
• Not all grids display the Add New pane.
• Not all grids display the Group panel.
• Not all grids display the Ripple List.

Exporting Data

Any grid can export data to the following formats:

• Excel
• XML
• HTML
• Text

Data is exported with the current column display order, grouping and sorting applied.

Definitions

Overview

Column Header: The caption at the top of the grid column.
Row: Grid row.
Active Row: The current row that may or may not be editing.
Active Cell: The current cell that is involved in an edit. It has focus.
Selection: Highlighted array of cells upon which an action may be performed.

Sorting

Sorting

Clicking any column header will sort by that column. Clicking it again will change the sort direction.

Grouping

Grouping

Dragging any column header and dropping it onto the Group Panel groups the grid by that column.

Reordering Columns

Reorder Columns

Dragging any column header and dropping in on another column header moves that column.

Display/Hide Columns

Choose Columns

1. Right-click any column header.
2. Select [Choose Columns].
3. Drag existing column headers to the dialog to hide them.
4. Drag columns from the dialog to the grid to show them.

Filtering Data

Using the Filter Pane (if visible)

Filter on existing item

Filter Editor