How to Import Products using Database Management

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 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 importing Products using the Database Management Utility.

All records associated with the selected Product(s) are NOT transferred by default. Records such as Subassemblies and Materials should be selected independently.


Fig. 01 – Database Management Utility – Import Products 

  1. Select IMPORT from Selected Source to Current Configuration > browse to the file location containing the MicrovellumFactory.sdf to be imported > select the MicrovellumFactory.sdf.
  2. Select the Products tab.
  3. The middle panel is populated with data from the selected database. Select the Product(s) to be imported from this central panel.
    4. When pulling from an archival database, chances are not everything in the external database needs to be imported. The middle panel in the image above allows you to select only the items you wish to import. The items specified appear in the panel on the right. Items can be selected from multiple categories at once. 
  4. Select Transfer.

Additional Options

When importing products, there are no Additional Options available.

Resolving Duplicates

When importing from a database that includes data duplicated from the Factory Database, like an archival database, the Resolve Duplicate Names window appears.


Fig. 02 – Resolve Duplicate Names

There are three options to resolve duplicates:

  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. 03 – New Name

When a product is imported, the software needs to be restarted before that Product can be selected from the Draw Products menu.

    • Related Articles

    • How to Import a Project 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 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 Import Reports 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 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 Graphics 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 23.1.0605.641

      Report Groups Fix A fix has been made to resolve an issue that reportedly caused errors when report groups attempted to print manually. Fixes and Additions to Part Properties Toolbox Console->Part Properties/Toolbox Setup->Options 2D drawing tokens ...

    • Toolbox Release Notes | Build 23.1.0525.641

      Hardware Machine Token Tool Compensation Fix Users reported an issue that caused hardware machine tokens to produce tool compensation incorrectly. This issue has been examined and resolved. Work Order Cancellation Fix Microvellum Console->Settings ...

    • Toolbox Release Notes | Build 23.1.0523.641

      Toolbox Release Notes | Build 23.1.0523.641 Face 6/Horizontal Drilling Enhancement Toolbox Setup->Options->Toolfiles->Double-click specific Toolfile->Integrated Post Processor Settings->Settings Users will now be able to cut down on file management ...

    • Foundation Hardware Highlight: Blum

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

    • Microvellum Foundation Library Release Notes | Build 23.0517

      This update includes many changes & additions to the Microvellum Face Frame expansion. Not all users will have access to these special products. Contact your account manager for more information. Additions: Added new drawer system Rocheleau R13 EVO ...