Create Materials from Import File

Create Materials from Import File

We've added a new “Create New Materials from Import File” command to the Database Management Tools tab.  


This tool allows you to select an Excel file and create or modify database materials by import.  During the import, if a material name is found in the existing database materials it will modify the properties, if an existing material name is not found a new material will be created.  You will have the option to review the materials that will be created or edited before continuing.

If an existing sheet stock material is found and there are sheet sizes listed out for the material in the import file, existing materials in the database will be updated with the sheet sizes from the import file.  If no sheet sizes are listed, the sheets in the database will not be updated.

Import File Structure

The selected file must be in .xlsx file format.  Each sheet within the file is reserved for specific material types.  The sheets within the Excel file must be in the following order.

1 st Sheet = Sheet Stock Materials
2 nd Sheet = Solid Stock Materials
3 rd Sheet = Buyout Materials
4 th Sheet = Edgeband Materials
5 th Sheet = Hardware Materials

The first row is reserved for column header names and should not be used for materials.  Start listing materials on row 2.  Each column within the spreadsheet is associated with a property for the material.  The columns may differ for different material types.  Below is the breakdown of each column’s material property and the appropriate property value types.  For example, grain direction requires a value of either 0, 1, or 2.

If you want to update an existing material, any cell left blank will not be populated.  So, for instance, if you wanted to update Labor Values for materials with this tool, enter the Material Name in the first column and then only fill out the Labor Value column.  All other properties will be skipped.


Sheet Stock Materials

Column A = Material Name (String Value)
Column B = Thickness (Double Value)
Column C = Code (String Value)
Column D = Comments (String Value)
Column E = Grain (Integer Value restricted values of: 0 = None, 1 = Grain Length, 2 = Grain Width) Invalid Value will result in setting a value of 0.
Column F = Markup (Double Value)
Column G = Waste Factor (Double Value)
Column H = Labor Value (Double Value)
Column I = Extended Data 1 (String Value)
Column J = Extended Data 2 (String Value)
Column K = Extended Data 3 (String Value)
Column L = Face 6 Flip Setting (Integer Value restricted values of: 0 = By Material, 1= Always Ask, 2 = Always Flip, 3 = Never Flip) Invalid value will result in setting a value of 1.
Column M = Hatching Pattern (Integer Value restricted values of: 0 = No Hatch, 1 = PB Hatch, 2 = Ply Hatch, 3 = Wood Hatch, 4 = Blocking) Invalid value will result in setting a value of 0.
Column N = Future Property (Reserved for future material property)
Column O = Future Property (Reserved for future material property)
Column P = Future Property (Reserved for future material property)
Column Q = Future Property (Reserved for future material property)
Column R = Future Property (Reserved for future material property)
Column S = Future Property (Reserved for future material property)

The next columns are used to create sheets for the material on the same row.  To create multiple sheets, repeat the following column properties in the same order.  So you would start the second sheet in column AF and so on.

Column T = Sheet Quantity (Integer Value)
Column U = Sheet Width (Double Value)
Column V = Sheet Length (Double Value)
Column W = Leading Width Trim (Double Value)
Column X = Trailing Width Trim (Double Value)
Column Y = Leading Length Trim (Double Value)
Column Z = Trailing Length Trim (Double Value)
Column AA = Optimization Priority (Integer Value)
Column AB = Estimate Price (Double Value)
Column AC = Handling Code (String Value)
Column AD = Future Property (Reserved for future material property)
Column AE = Future Property (Reserved for future material property)


Solid Stock & Buyout Materials

Column A = Material Name (String Value)
Column B = Thickness (Double Value)
Column C = Code (String Value)
Column D = Comments (String Value)
Column E = Handling Code (String Value)
Column F = Grain (Integer Value restricted values of: 0 = None, 1 = Grain Length, 2 = Grain Width) Invalid Value will result in setting a value of 0.
Column G = Markup (Double Value)
Column H = Waste Factor (Double Value)
Column I = Labor Value (Double Value)
Column J = Extended Data 1 (String Value)
Column K = Extended Data 2 (String Value)
Column L = Extended Data 3 (String Value)
Column M = Estimate Price (Double Value)
Column N = Unit Type (Integer Value restricted values of: 1 = Each, 2 = Lin Ft/ Lin Meter, 3 = Sq Ft./Sq Meter 4 = Brd Ft./Brd Meter) Invalid Value will result in setting a value of 1.
Column O = Hatching Pattern (Integer Value restricted values of: 0 = No Hatch, 1 = PB Hatch, 2 = Ply Hatch, 3 = Wood Hatch, 4 = Blocking) Invalid value will result in setting a value of 0.


Edgeband Materials

Column A = Material Name (String Value)
Column B = Thickness (Double Value)
Column C = Code (String Value)
Column D = Comments (String Value)
Column E = Handling Code (String Value)
Column F = Part Size Adjustment (Double Value)
Column G = Markup (Double Value)
Column H = Waste Factor (Double Value)
Column I = Labor Value (Double Value)
Column J = Extended Data 1 (String Value)
Column K = Extended Data 2 (String Value)
Column L = Extended Data 3 (String Value)
Column M = Estimate Price (Double Value)
Column N = Unit Type (Integer Value restricted values of: 1 = Each, 2 = Lin Ft/ Lin Meter, 3 = Sq Ft./Sq Meter 4 = Brd Ft./Brd Meter) Invalid Value will result in setting a value of 1.


Hardware Materials

Column A = Material Name (String Value)
Column B = Code (String Value)
Column C = Comments (String Value)
Column D = Handling Code (String Value)
Column E = Markup (Double Value)
Column F = Waste Factor (Double Value)
Column G = Labor Value (Double Value)
Column H = Extended Data 1 (String Value)
Column I = Extended Data 2 (String Value)
Column J = Extended Data 3 (String Value)
Column K = Estimate Price (Double Value)
Column L = Unit Type (Integer Value restricted values of: 1 = Each, 2 = Lin Ft/ Lin Meter) Invalid Value will result in setting a value of 1.
Column M = Non Associative Drawing Name (String Value)
Column N = Associative Drawing Name (String Value)
Column O = 2D Non-Associative Elv Block Name (String Value)
Column P = Skip Spreadsheet Sync (Integer Value restricted values of: 0 = False, 1 = True) Invalid Value will result in setting a value of 0.

Download a sample import spreadsheet in the attached .xlsx file below.


    • Related Articles

    • How to Import Materials using Database Management

      NOTICE: The Import function of Database Management is a powerful tool that modifies data in the current configuration.  ALWAYS  back up your data before executing a data Import. The articles in this section of the Knowledge Base involve importing and ...
    • Database Management Utilities (Reference)

      See Database Management Utilities (Overview) in the Microvellum Help Center for an overview article explaining what is new about the Import Export interface. Import Export Utility As of Microvellum build 15.6.2404 or greater, we have enhanced the ...
    • How to Export Materials using Database Management

      The articles in this section of the Knowledge Base involve importing and exporting from the Database Management window. For general information regarding the Database Management tool, or how to access it, see Database Management Utilities (Overview). ...
    • How to Import Subassemblies using Database Management

      NOTICE: The Import function of Database Management is a powerful tool that modifies data in the current configuration.  ALWAYS  back up your data before executing a data Import. The articles in this section of the Knowledge Base involve importing and ...
    • How to Import Products using Database Management

      NOTICE: The Import function of Database Management is a powerful tool that modifies data in the current configuration.  ALWAYS  back up your data before executing a data Import. The articles in this section of the Knowledge Base involve importing and ...
    • Recent Articles

    • Toolbox Release Notes | Build 21.2.0111.641

      The following Release Notes apply to Toolbox Build 21.2.0111.641 Scrap Management Resolutions: Resolved an issue that was causing the Offal Cutting pattern to cut into rounded parts. Saw Optimizer Resolutions: Resolved an issue where the PTX output ...
    • Toolbox Release Notes | Build 21.1.1227.641

      The following Release Notes apply to Toolbox Build 21.1.1227.641 Edit Design Data Resolutions: Resolved an issue where the workbook prefix (e.g. "L!") would not be added when applying a local variable to a formula. Resolved an issue where the "Revert ...
    • Machine Implementation Process

      Thank you for choosing Microvellum as your platform to streamline your design, engineering, and production processes within your company to propel your business forward.  Follow the steps to ensure a successful and timely implementation of your CNC ...
    • Planning for a Successful Implementation

       Service Engagement Process Thank you for choosing Microvellum as your platform to streamline your design to manufacturing processes within your company. Follow the steps to ensure a successful and timely implementation of your services. Information ...
    • Integration Guide for the Component Cabinet Library

      Below you will find file downloads for Microvellum's Component Cabinet Library Integration Guide.  Form fields are pre-filled with either Metric or Imperial library default values.   This integration guide contains details and settings from ...