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

    • 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 ...
    • 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 ...
    • 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 ...
    • 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 ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.0227.641

      The following release notes apply to Toolbox build 24.1.0227.641 UI Fixes Figure 1: Expansion issue with Function Arguments window. There was a noted issue regarding the Function Arguments window in the Formula Editor: when one expanded or increased ...
    • Microvellum Foundation Library Release Notes | Build 24.0221

      Additions Added “Lookup” Option for all Fixed and Adjustable Shelf Quantity variables. Rather than entering a number for base/tall/upper shelf quantity, we now have an option called “Lookup”. When choosing “Lookup” from the dropdown, the shelf ...
    • Toolbox Release Notes | Build 24.1.0219.641

      The following release notes apply to Toolbox build 24.1.0219.641 Copy Product Information Fix An issue has been reported by some users, who found that when attempting to copy and paste their product information by using the “Copy Product Information” ...
    • Toolbox Release Notes | Build 24.1.0213.641

      The following release notes apply to Toolbox build 24.1.0213.641 Edgeband Thickness Fix An issue was reported centered around the Edgeband thickness of products using formula driven materials from their specification groups. When products were ...
    • Toolbox Release Notes | Build 24.1.0207.641

      The following release notes apply to Toolbox build 24.1.0207.641 3D Drawing Fixes Several fixes have been applied to specific issues users reported centered around 3D drawings: Users reported an issue when creating products with interior corners: ...