Difference between revisions of "DB:Global Equipment"
Wirecadadmin (Talk | contribs) |
Wirecadadmin (Talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 21: | Line 21: | ||
|- | |- | ||
| '''Edit>Refresh'''||Refreshes the data. | | '''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>Copy Selection Down'''||Uses the top cell in the selection as the source data and repeats it down for each cell in the selection. | ||
| Line 26: | Line 30: | ||
| '''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. | | '''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.[[File:MoveManufacturer.png|thumb|Database>Equipment>Tools>Move...]] | + | | '''Tools>Move Equipment to Different ManufacturerID'''||Change the Manufacturer that the equipment is associated with.<br> |
| + | Select the manufactuerer that you want to move the equipment to from the drop-down.[[File:MoveManufacturer.png|thumb|Database>Equipment>Tools>Move...]] | ||
|- | |- | ||
| − | | '''Tools>Remove Duplicates'''|| | + | | '''Tools>Remove Duplicates'''||Removes duplicate entries. Uses the following rules:<br> |
| + | * 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}} | ||
Latest revision as of 14:41, 29 December 2010
| Command Line Shortcut: eg User Permissions Level: EquipmentCollection - AllowAddNew, AllowEdit, AllowDelete |
Contents
Settings Explanation
| Setting | Description |
|---|---|
| File>New | New Equipment. |
| 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. |
| Tools>Remove Duplicates | Removes duplicate entries. Uses the following rules:
|
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
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
Clicking any column header will sort by that column. Clicking it again will change the sort direction.
Grouping
Dragging any column header and dropping it onto the Group Panel groups the grid by that column.
Reordering Columns
Dragging any column header and dropping in on another column header moves that column.
Display/Hide Columns
- Right-click any column header.
- Select [Choose Columns].
- Drag existing column headers to the dialog to hide them.
- Drag columns from the dialog to the grid to show them.
Filtering Data
