The Product List is a module that allows users to make modifications to their products without working directly in the drawing. The following article, detailing the different aspects of the Product List, applies to build 20.1.0826.641 and greater.
To access the Product List in Toolbox, select the Project Tab, and then click on the Product List icon.
Fig. 01 – Product List Interface
Notice in Figure 01, some of the products are printed in blue font, and some are printed in the standard black font. The products in blue text are in the actual drawing. The products in black text are not in the actual drawing.
The ribbon across the top of the interface allows you to access the Project and Library Specification Groups, and create and edit work orders.
On the left side of the interface is the Control Panel. The Control Panel contains two tabs located at the bottom of the window: Project and Product List.
- The Project tab displays the project information, which includes the Current Configuration, Current Project, Current Room, and Current Library.
- The Product List tab displays the project tree and the library product list.
The large center section of the interface is the primary work area. Upon the initial launch of the Product List, all the products in the project are displayed in alphabetic order based on the product description. By default, all the available data fields are loaded: Item #, Description, Quantity, Width, Height, Depth, Comments, Specification Group, and Work Order.
The Product List can be sorted in ascending or descending order by clicking on the column header. Dragging column headers into the grey bar, at the top of the spreadsheet, groups the products in the spreadsheet by that header. There can be multiple groups simultaneously. Multiple groups are nested together. See Figure 2 for an example.
Fig. 02 – Grouping by Column Headers
Fig. 03 - Column Header Checkboxes
Checking and unchecking the Column Header checkboxes, Figure 03, will maximize and minimize the appropriate group within the grid.
A conditional filter can be applied using the arrow on the right of the column header. In Figure 04, I demonstrate this feature by setting the condition to only show products with a Description that contains the word "tall." This is a particularly useful feature for projects with a lot of products to sift through.
Fig. 04 - Conditional Filter Applied to "Description" Column (If Description contains "tall" the item will be displayed)
When a conditional filter has been applied to a column header, a checkmark will appear next to the name.
The work area can also be filtered to display the products that are contained within a category or room by selecting the category or room from the project tree in the Control Panel. When a category or room has been chosen, the products are organized by their item number.
At the top of the work area, there are two tabs: Product List and Parts List. The Product List tab displays the products. The Parts List opens the spreadsheet file for the selected Product.
Many helpful tools can be used when working in the Product List. To access the Product List Context Menu, right-click in the primary work area.
Fig. 05 – Product List Context Menu
- Print Grid – Allows you to physically print the grid.
- Export Grid – Allows you to export the grid to a .csv file, which can be opened with Excel.
Any column groups that have been created are not exported with the grid by default. The option has to be selected in Grid View Settings, see below.
- Grid View Settings – Allows you to make modifications to the Grid Settings, and save views for quick implementation later.
Fig. 06 – Grid View Settings
- Saved Views – This dropdown contains any saved views of the grid (preferred groups, settings, and filters applied) that have been previously created.
- Set as Default – Sets the currently selected view as the default, so that when you return to the Product List, you are returning to this view.
- Reset View – Resets all view changes that have been made.
- Rename – Allows for the name of the selected view to be changed.
- Delete – Deletes the currently selected view.
- All Columns – Selecting this checkbox automatically selects all of the columns in the box below it and displays them in the grid.
- Columns – A list of all of the available columns for individual selection. Highlight a column, and you are given the option to move it right, into the Column Groups section, or up and down, which changes the order of the listed columns in the grid.
- Column Groups – The Column Headers by which groups are formed.
- Reset Columns – This resets the column sizes back to the original sizes. Column sizes are edited in the grid. Back in Grid View Settings, after column sizes have been modified, select "Save" to preserve the sizes created in that view.
- Clear Sorting – This clears any sorting that has been applied in the grid. Descending order reverts back to Ascending order.
- Grid Decimal Places – The number of decimal places preferred for numbers in the grid. A setting of -1 is the default and does not round off numbers.
- Grid Font Size – The font size within the cells of the grid.
The font size can also be modified in grid view with the following buttons.
Fig. 07 – Modify Font Size
- Frozen Columns – Use this parameter to determine the number of frozen columns. Frozen columns stay locked to the left side of the grid when you horizontally scroll. Choose the order you would like the columns in before you set the number of columns on the left to freeze. See Figure 06.
Fig. 08 – Frozen Columns
- Max Sort Columns – The maximum number of columns that can be sorted in the grid.
- Include Group Nodes in Export – Selecting this option allows the group nodes to be exported with the grid. When this is not selected, the groups (and the headers that formed them) are left out of the export.
- Word Wrap – The text within the cells is wrapped.
- Show Number Column – Select to display the number column on the left of the grid.
- Disable Prompt to Save when Sorting Column Data – With this option selected, there is no prompt to save when sorting column data.
- Disable Prompt to Save when Changing Column Widths – With this option selected, there is no prompt to save when changing column widths.
- Disable Prompt to Save when Changing Font Size – With this option selected, there is no prompt to save when changing the font size.
- Save – This option quick-saves an existing view that has been modified.
- Save As – Allows a new name to be chosen for the view when it is saved.
- Close – Closes the Grid View Settings.
- Show Product Prompts – Allows you to access the Product Prompts for the selected Product.
- Show Part Properties – Allows you to access the Part Properties for the selected Product.
- Save Product to Library – Allows you to save a product to the library – requires you to select a category and subcategory.
- Edit Product List – Allows you to access a sub-menu for product editing.
Fig. 09 – Edit Product List Sub-Menu
- Item Number – Modifies the selected Product's item number in the grid.
- Description – Modifies the selected Product's description in the grid.
- Quantity – Modifies the selected Product's description in the grid.
- Width – Modifies the selected Product's width in the grid.
- Height – Modifies the selected Product's height in the grid.
- Depth – Modifies the selected Product's depth in the grid.
- Specification Group – Modifies the selected Product's specification group in the grid.
- Edit Additional Prompts – Opens the Edit Additional Prompts interface.
- Rebuild Product List – This option updates the Product's width, height, and depth values in the product list if they were changed from the Globals or Project Wizard.
Editable cells can be modified by double-clicking within the cell.
- Move Selection to Another Room – Allows you to move a selection of products to another room.
- Copy Selection to Another Room – Allows you to copy a selection of products to another room.
- Parts List Review – Opens a list of parts for the selected product.
- Delete Selected Product(s) – Allows you to delete the selected Product (s).
- Add New Empty Product – Allows you to add a product with an empty spreadsheet – used for creating custom products or quickly cut listing parts.
- Copy Selected Product(s) – Allows you to copy the selected Product (s) inside the current room.
- ReNumber – Allows you to renumber the selected Product (s). Selecting multiple products renumbers the products sequentially.
- Add Comment – Allows you to add comments to the selected Product (s). The interface does not separate the comments. Up to three comments can be added. Each comment needs to be separated using the pipe "|" symbol.
- Rebuild Selected Products from Library – Allows you to rebuild the spreadsheet of a product from the library.
Prompt values are not changed.
- Rebuild Subassemblies from Library – Allows you to rebuild projects and unique subassemblies from the library. Subassemblies have the option to replace the values in the Prompts.
- Clear Work Order Column – Clears out any work order names from the product list.
- Make Product Group from Selection – Allows you to select multiple products to be grouped. Product Groups can be drawn in a single operation instead of drawing the products individually.
Creating a Product Group from selected products deletes the selected products from the current project.
Fig. 10 – Delete Products from the Current Project
Modifications made to products in the Product List are reflected in the drawing. A redraw of the products that were modified would be required.
Work Order Preparation
The Product List is the best way to ensure that the products for a room or project are correct before creating a work order. The Product List shows more information about the products than the work order interface displays.
Before creating a work order, it is recommended to verify that the information for the products is accurate.
- First, rebuild the product list. Rebuilding is recommended to help catch any discrepancies that may exist with the sizes of the products. If the width, height, and depth values of a product were not hard-coded (manually entered) when drawn, those values are still referencing the Project Wizard values. If the Project Wizard default sizes have been changed, there is a good chance that the manufacturing data does not match the drawing. After rebuilding the product list, you should compare the data against the drawings.
- Next, you should verify that the products have the correct specification group assigned.
- Next, you should verify that the product quantities are correct.
- Lastly, you should verify that the item numbers are correct and that they match the drawings.
Once the information has been verified, you can create a work order. Work orders are covered in another section.
Working with the Control Panel
Fig. 11 – Control Panel (Product List tab and Project tab)
- The Control Panel allows you to continue to organize your project. You can edit, add, and delete categories and rooms. You can also add products from the library to a room.
- To edit the project tree, you need to select the category or room you wish to edit and right-click to access the edit menu. Refer to the section Project Organization for editing the project tree.
- By selecting a category, all the products from all of the rooms contained in that category are displayed.
- By selecting a room, all of the products within that room are displayed.
- When a room has been selected, you can continue to add products to the room by choosing the Product from the library list. When adding a product through the Product List, the Product appears in black text. Black text is a visual indicator that the Product has not been drawn. Blue text means the Product is in the drawing.