Library Data Codes

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 23.1.0202.641

      The following Release Notes apply to Toolbox Build 23.1.0202.641. SQL Connection Resolutions: • The issue causing random data connection errors has been fixed. 2D Drawings Resolutions: • An issue that prevented hardware from being visible for some ...
    • How to Configure Toolbox 2023 to Use High-Performance Graphics

      The purpose of this article is to provide guidance on how to update settings on your PC to use high-performance graphics card (GPU) on systems with dual video. PCs often have two graphics adapters: one integrated into the motherboard for basic ...
    • Toolbox Release Notes | Build 23.1.0112.641

      The following Release Notes apply to Toolbox Build 23.1.0112.641. ERP Estimating Resolutions: An issue with the "Show Product Cost Details" not displaying buyout parts has been fixed. An issue that caused the calculation of the material cost to be ...
    • Overview: Adding a New Hardware Item to the Foundation Library

      The purpose of this article is to provide an overview on the process of adding custom hardware items to your Foundation Library. The process is similar for pulls, hinges, catches, locks, latches etc. A more comprehensive tutorial on working with ...
    • Associative Hardware Tutorial

      This document demonstrates how to apply associative hardware to a product designed with Microvellum Toolbox. The tutorial will add the following hardware to the doors of a 2-door base cabinet: • Hinges • Double Touch Latch • Lock • Elbow Catch • ...