How to Export Materials using Database Management

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).

This simplified article provides a brief tutorial for exporting Materials using the Database Management Utility.

All records associated with the selected Material(s) are transferred by default. These records include Sheet Sizes and Categories. If hardware materials are transferred, any associated drawing files are collected and transferred.

Select the Materials tab > select the Material(s) to be exported > accept the file to be exported to or browse for a different location.


Fig. 01 – Database Management Utilities – Export Materials

Additional Options

When exporting Materials, the following Additional Options are available:


Fig. 02 – Additional Options when Exporting Materials

  1. Zip Exported Items – Check this box to create a compressed zip file named the same as the folder selected for the export files. The zip file contains the same files as the subfolders created in the folder designated for the export files and is located at the same level as the folder selected. 

Once everything has been selected for export, and any desired additional options included select Transfer.

With the Database Management utility, multiple items from multiple categories can be exported at once.

Resolving Duplicates

When the file being exported to is empty, or lacking a MicrovellumFactory.sdf database, a database is automatically created with the exported data inside. When the file being exported to already has a MicrovellumFactory.sdf database, and this database features duplicate information, the Resolve Duplicate Names window appears. When there is no duplicate information, the data being exported is appended to the database.


Fig. 03 – Resolve Duplicate Names

There are three options to resolve duplicate names:

  1. Skip – Does not change the existing item, and an additional item is not added. The item is ignored. 
  2. Replace – Replaces the item in the target location that has the duplicate name. 
  3. Keep Both – Appends to the target location. A new name must be given to the item. 

  4. Fig. 04 – New Name

Export Folder Structure

A MicrovellumFactory.sdf database file is created containing the materials exported.


Fig. 05 – Folder Structure
    • Related Articles

    • How to Export a Project 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 Export Subassemblies 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 Export Products 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 Export Misc Items 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 Export a Library 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). ...
    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 26.0220

      The following release notes apply to the Microvellum Foundation Library build 26.0220. Additions Added DTC Magic Pro and Magic Star Ultra drawer systems. Magic Pro Items added in hardware file 300 and 600 lengths for all drawer heights. Add 60kg ...
    • Microvellum Release Notes | Build 25.2.0223.641

      The following release notes apply to Microvellum build 25.2.0223.641. Add 2D Elevation Tokens to 3D Drawings Fig. 1: The new 2D Elevation setting. A popularly requested feature by the community has been added to the Microvellum software: the checkbox ...
    • Microvellum Processing Center Application

      The standalone Processing Center application provides shop-floor tools for managing and executing manufacturing data generated from Microvellum projects. It enables users to: Print part labels View and print reports Create and re-create manufacturing ...
    • Microvellum Release Notes | Build 25.2.0213.641

      The following release notes apply to Microvellum build 25.2.0213.641 File Name Fix An issue was occurring when processing work orders with the Create Sequential File Names setting enabled. When the setting was enabled, a work order being processed ...
    • Microvellum Release Notes | Build 25.2.0206.641

      The following release notes apply to Microvellum build 25.2.0206.641. Item Number Fix An issue was reported regarding item numbers in composite drawings. Users who processed work orders with multiple products reported that the item numbers would ...