Cables View

The Cables View, accessed from the Project Dashboard, gives an overview of all the Cable objects in your project.  The powerful grid UI makes it easy to manage the Attribute values across the Cables in your project, and those of the Products they connect. It includes:

• A Configuration button so you can select which columns (Attributes) are visible.
• An Export button, to save the current view as an Excel spreadsheet.
• The grid, which:
  • Exposes all the Attributes of Cables and those of the Products they connect from and to.
  • Includes links to jump to and select the Cable or the Symbols the Cable connects from and to, in the drawing in which they appear.
  • Allows re-ordering of columns.
  • Includes Sort and Filter tools for each column.
  • Allows copy/paste and dynamic fill of cells, with the option of filling with incrementing values. 

A sample of the Cables View is shown below:

Configuration

Click on the Configuration button to display the Cable Columns dialog. 

This lists all available Attributes for the Cables View, being:

• The Drawing the Cable appears in ("Drawing").
• A link to jump to the Cable in its drawing ("Cable")
• Attributes of Cable objects, e.g. Name, Start Connector, End Connector
• Attributes of the Products each Cable connects, prefixed with "From" or "To", corresponding to the start and end connections of the Cable, e.g. From Manufacturer, From Model Number, To Room, To Location.
• A link to jump to each Symbol the cable connects to ("From Symbol" and "To Symbol") 

Check/uncheck the visibility checkbox to show or hide that column.  Click OK to apply the configuration to the current project.

Setting Default Columns

When you have established the desired visibility state for columns in the Cables View, check the Set as Default checkbox and click OK to apply this configuration as your default for new projects.   

Export 

Click on the Export button to save the contents of the Cables View as an Excel spreadsheet.

Working with the Grid

Click and drag a column heading to re-order the columns.

Click on any column heading to sort by the values in that column.

Use Ctrl+Click on a column heading to:

• Perform a secondary sort using that column's values, or
• If you are already sorting by that column, to remove sorting.   

Click on the down arrow that appears in a column heading when you hover the cursor over it to reveal the Filter tool.

The Filter tools allow you to show and hide data in the Cables View based on particular values in the selected column.

• You can check/uncheck individual values to show/hide rows containing those values.
• Check/uncheck (Select All) to make it easier to filter by a single or small selection of values, or to clear current filters.
• Use the Text Filter, bottom left, to build an expression by which to filter e.g. Contains = "XLR" to show any results that include "XLR" as part of the value.
• You must click on Apply to activate the changes made in the Filter dialog.
• The column heading shows a ✓ icon if filtering has been applied to that column.  To remove filtering, click on the ✓ icon and select Clear.

Entering Data in Cells

Doubleclick on a cell to enter/edit data in that cell.  Note that the following columns are read-only and their values cannot be edited:

• Drawing
• Cable
• From Symbol
• From Manufacturer
• From Model Number
• From Description
• From Port
• To Symbol
• To Manufacturer
• To Model Number
• To Description
• To Port

You can drag over multiple cells to select them; copy/paste on single or multiple cells behaves much like a spreadsheet application so you can, for example:

• copy one cell and paste into multiple cells, 
• copy a range of cells in one row and paste into multiple rows,
• copy a range of cells and paste into a range of the same shape,
• select a range of cells and Delete their values in a single action.

You can dynamically copy the contents of one cell into adjacent cells by dragging; as you approach the bottom right corner of a selected cell the cursor will turn to a cross (+) indicating that you can drag and copy the contents to adjacent cells in any direction.  If the cell's value ends in a number you can increment that value in the cells you're copying to by holding down the Ctrl key as you drag.

Jumping

Cells containing blue, underlined text, i.e. the columns Cable, From Symbol and To Symbol, are links; click on a link to jump to the drawing containing the Cable or Symbol - this will also select the Cable or Symbol.