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)
NOTICE: The Database Management Utility is a powerful tool that modifies large sections of data in the current configuration. ALWAYS back up your data before performing a data import. The Library Import functionality of Database Management is ...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 25.1.0403.641
The following release notes apply to Toolbox build 25.1.0403.641 Trueshape Fix Fig. 1: A bounding box drawn around the container of a part with True Shape nesting applied. An issue was reportedly occurring when processing parts with True Shape ...Foundation Hardware Highlight: Kesseböhmer
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 ...Beta Optimizer Changes
As of build 25.1.0325.641, Microvellum’s optimizer for block nesting, sawing, and scrap management has received an update to improve its functionality. This new optimizer is considered to be in beta form, with development ongoing and new features ...Part Grouping and Sorting (Beta Optimizer)
As of Toolbox build 25.1.0325.641, Microvellum's new Beta Optimizer allows users to sort and group parts with greater degrees of specificity than with the legacy optimizer. This is possible due to an overhaul in the Part Sorting and Grouping ...Sheet Selection Type (Beta Optimizer)
When selecting materials in an operation, Microvellum's optimizer allows for users to assign an optimization priority to specific materials in their material file, to determine which materials should be used up first in the operation. As of Toolbox ...