Library Data Codes
ProductCode was created to allow Toolbox to understand the type of cabinet or product it is working with and be able to behave accordingly. Four different custom functions can return the correct product Library Type, Library Sub Type, Category, and Subcategory to determine the exact type of product. It is not possible to alter or add different ProductCodes as it is incorporated into the software.
ProductCode is visible in the
spreadsheets as a hidden prompt to view information for that specific product.
For example, a Base Corner Cabinet would contain the following code of C, 2, B,
C in the data. The ProductCode prompt is used extensively throughout the
worksheets in functions. An example of this can be found in the Height of the Base
Corner Cabinet, as the formula used for this prompt is
=INDIRECT(“G!”&MYCATEGORY(ProductCode)&”_Cabinet_Height”). It is
joining to the G! with the MyCategory(ProductCode) to return the Category as
Base.
Related Articles
Microvellum Data Dictionary
Microvellum Data Dictionary Introduction This manual is a guide to the Microvellum Factory and Work Order Databases. This manual has four sections. The first section includes this introduction, and the remainder is General Information about this ...Overview: Material Handling Codes
Material Management Systems are becoming more common in the woodworking industry. One of these is the SCMI Flexstore system. These systems require material information in the header of the TXT files that define the part labels for the sheet. Fig. 1 ...Tutorial: Library Build 048 - Door Data & Wizard
This video explains the differences between the various type of door data (door libraries) contained within the Microvellum Library version 048 and where that data is located. You will see how the appearance of the prompts page adjusts based on the ...Overview: Library Build 048 - Door Data
The Door Data in the Microvellum Library v048 and greater has been significantly improved! The improved data is seen mainly in the solid wood panel doors, whereas the MDF and slab doors are relatively unchanged. This video gives a partial list of ...Extended Part Data Token - XPARTDATA (Overview & Reference)
Some Microvellum users have expressed the need for a way to add custom part data to their reports. The limitation lies in the database fields that are available for this purpose in the database. As of the 15.6 release, there is a new token available ...
Recent Articles
Toolbox Release Notes | Build 24.1.0719.642
The following release notes apply to Toolbox build 24.1.0719.642 900 Tools Fix A recurring issue with 900 tools being used in an incorrect order during certain operations was reported. The issue would manifest as tools switching back and forth during ...Foundation Hardware Highlight: Grass
Microvellum’s Foundation Library is built on the premise of providing our users with the best quality hardware for their construction projects, be they commercial, residential, or anything otherwise. As such, Toolbox has hardware from multiple brands ...Toolbox Release Notes | Build 24.1.0703.641
The following release notes apply to Toolbox build 24.1.0703.641 Product Comments Fix An issue with product comments in has been resolved. It was found that in older builds (pre-2023), when a formula driven product had comments placed into it and the ...Foundation Hardware Highlight: Richelieu
Microvellum’s Foundation Library is built on the premise of providing our users with the best quality hardware for their construction projects, be they commercial, residential, or anything otherwise. As such, Toolbox has hardware from multiple brands ...Selecting an Azure VM to Deploy Microvellum
Selecting the correctly sized virtual machines (VM) in Azure depends on several factors, such workload requirements, budget, and performance requirements. It may be necessary to work closely with an IT professional with experience working in Azure to ...