Using Library Designer - Strategy, Tips, and Tricks
Library Designer is a powerful tool that can be utilized to make Library wide changes affecting many products at once. In this article, we’ll cover Strategy, Tips, and Tricks that will help you get the most out of Library Designer.
Before getting started, ensure that the Library Designer database has been configured and test to make sure it's communicating with the factory database. For help setting up Library Designer for the first time see Setting Up Library Designer.
Make a backup copy of your factory database before experimenting with Library Designer
Selecting Multiple Database Items at Once
Holding down different combinations of the Shift and Ctrl keys while selecting items in the tree view will allow multiple items, or groups of items, to be selected together.
Ctrl + Click
Hold down the Ctrl key to select multiple items at once. Each item clicked while the Ctrl key is held down will stay selected.
Fig. 01 – Library Designer – Ctrl + Click
Shift + Click
Hold down the Shift key to select a group of consecutive items from the list. Click on the first item, then hold down the Shift key while clicking the last item you want to be included in your selection. Clicked items and all items sandwiched between will be selected.
Fig. 02 – Library Designer – Shift + Click
Ctrl + Shift + Click
Multiple groups of items can be selected by combining the functionality of Ctrl + Click and Shift + Click . With an item or group of items already selected, hold down Ctrl and click the first item to be selected. Continue holding Ctrl and begin holding Shift while clicking the last item in the list of consecutive items to be selected. Clicked items and all items sandwiched between them will be selected while maintaining all previously selected items.
Fig. 03 – Library Designer – Ctrl + Shift + Click
Select Multiple Items to Show Like Attributes
When multiple items are selected in the tree view, only data attributes that are the same for all highlighted items are displayed.
Fig. 04 – Library Designer – Show Like Attributes
Underscore vs No Underscore
Be aware that some prompts have underscores while others do not. In older libraries, underscores were used by default. Current library development uses spaces in place of underscores. Be sure to scroll down and check for prompts with underscores as they are not listed adjacent to the non-underscored prompts in the alphabetized list.
Fig. 05 – Library Designer – Underscore vs No Underscore
Click to Apply – Parts, Products, and Subassemblies Using This Item
When unchecking items in the Part, Products, or Subassemblies Using This Item lists, remember to finalize the action using the Click to Apply link.
Fig. 06 – Library Designer – Click to Apply
Send To Library Designer
Library Designer is not always the most efficient option for editing your library data. When you need to make changes to one or two cabinets, it is much faster to edit the workbooks accessible through Database Explorer. Be sure to update the modified cabinets in your Library Designer database using the Send to Library Designer option found by right-clicking the cabinet in the Database Explorer tree view. Alternatively, you can delete and rebuild the Library Designer database.
Fig. 07 – Database Explorer – Send to Library Designer
Rebuild Selected Products From Library
Library Designer only updates your template products and will not edit products that already exist in a project. If you would like to apply changes made in Library Designer to products inside an existing project, you can update those products from the product list. Right-click on a selected product or group of products, then select Rebuild Selected Products From Library.
Fig. 08 – Product List – Rebuild Selected Products From Library
Workbook Compatibility with Library Designer
When creating or editing your workbook there are a few things to keep in mind to preserve compatibility with Library Designer. When Library Designer reads your workbook it follows certain rules to maintain efficiency. The Following guidelines will help ensure Library Designer analyzes your Library data accurately and completely.
- Do not leave more than one blank row between prompts. When Library designer scans your workbooks, it processes single blank rows between prompts without issue. However, data below two or more blank rows may not be analyzed.
- Do not place lookup tables in the prompt worksheet, this may cause issues when Library Designer reads your prompts. Instead, create a new worksheet called LookUpTables to store your look-up tables.
- Do not leave blank machine token columns, everything to the right of a blank machine token column will not be analyzed by Library Designer.
- Do not use zeros or any other generic placeholder to fill empty machine token columns. Library designer will read all matching machine tokens as the same token, confusing your Library Designer database.
Fig. 09 – Workbook Designer – Two Blank Rows
Fig. 10 – Workbook Designer – LookUpTables Tab
Fig. 11 – Workbook Designer – Blank Machine Token
Fig. 12 – Workbook Designer – Zero Machine Token
Working with Multiple Libraries
Although it is not recommended for inexperienced users, Library Designer will allow you to add more than one library to your Library Designer database.
Fig. 13 – Library Designer – Two Libraries
Keep in mind that while the libraries are listed separately in the tree view, Library Designer accesses all of them when looking up items. For instance, with a prompt or other database item selected, Library Designer will include all Parts, Products, and Subassemblies across all imported libraries in the Using This Item lists. Any changes made will be applied accordingly across all libraries.
Fig. 14 – Library Designer – Two Libraries Using This Item
For more information on how to use Library Designer see Using Library Designer - Beginner’s Guide.
Related Articles
Using Library Designer - Beginner's Guide
Microvellum's Library Designer provides users with an impressive amount of power and control over their product data. It's a tool used by engineers to quickly make sweeping changes to groups of prompts, sub-assemblies, parts, products, and more. It's ...Setting Up Library Designer
The Library Designer Tool is used for editing existing products and NOT for creating new products from scratch. This article provides information for setting up the Library Designer for the first time. For information on working in the Library ...Using Library Designer - Find and Replace
Library Designer’s Find and Replace is a powerful and commonly used tool. It is useful for replacing formulas, locating orphaned global variable references, determining if products are referencing a particular global variable, or any time it is ...Using Library Designer - Sample Exercise 2 - Update a Whole Category
Overview - Library Designer
This article provides an example of how Library Designer can be utilized to make Library wide changes affecting many products at once. Before getting started, ensure that the Library Designer database has been configured and test to make sure it's ...
Recent Articles
Toolbox Release Notes | Build 24.1.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...Toolbox Release Notes | Build 24.1.1125.641
The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...Toolbox Release Notes | Build 24.1.1105.641
The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...Microvellum Foundation Library Release Notes | Build 24.1025
The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...