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

    • Microvellum Foundation Library Release Notes | Build 24.0322

      Additions Added the Master Angled Ends Cabinet. Added a Global prompt, "Hinge Plate Offset From Front" for easier control. Added “Double Division” option to Horizontal Designer Cabinets, 3 Door Cabinets, and other similar products. Added a new ...
    • Common Floating License Connectivity Issues

      This document lists common issues reported by users regarding the topic of Microvellum’s Floating License Activation (FLA) and the connectivity required for FLA to function. Firewall Blocking Activation of Floating License Some users have had an ...
    • Toolbox Release Notes | Build 24.1.0318.641

      The following release notes apply to Toolbox build 24.1.0318.641 Shadowline Fix Figure 1: Shadowline shaping issue (left) and fixed (right). There were reports of users experiencing issues with products having incorrectly shaped shadow lines when the ...
    • Toolbox Release Notes | Build 24.1.0312.641

      The following release notes apply to Toolbox build 24.1.0312.641 Processing Station IDs Processing stations will have IDs added to them as an option within the Toolbox UI, to better distinguish between different processing stations. Perfect Graining ...
    • Toolbox Release Notes | Build 24.1.0306.641

      The following release notes apply to Toolbox build 24.1.0306.641 Destroy Offal Fix Figure 1: Destroy Offal arc part issue. There was an issue reported by users utilizing nesting with the “Destroy Offal” setting applied during processing. ...