How to Import Work Orders using Database Management

How to Import Work Orders 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 Work Orders using the Database Management Utility.

All records associated with the selected Work Order(s) are transferred by default.


Fig. 01 – Database Management Utility – Import Work Orders 

  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 Work Orders tab. 
  3. The middle panel is populated with data from the database selected in Step 1. Select the Work Order(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.

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

    • Related Articles

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

    • Database Management Utilities (Overview)

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

    • Recommended Procedure for Working Remotely

      The following Procedure for Working Remotely requires that all clients be running the same Microvellum Software Build and Library Build We recommend that you do not try to work remotely with Microvellum and AutoCAD using a Virtual Private Network ...

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

    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 26.0112

      Additions In accordance with Microvellum's new subscription changes, all Face Frame Expansion products and subassemblies, as well as the Range Hood Master product have been added to the full library install and library update zips (now included with ...

    • Toolbox Release Notes | Build 25.2.0114.641

      The following release notes apply to Toolbox build 25.2.0114.641 Processing Center Message Fix Fig. 1: An error message running in the background of the software. An issue was reported within the Processing Center. When processing an order, there ...

    • Toolbox Release Notes | Build 25.1.1218.641

      The following release notes apply to Toolbox build 25.1.1218.641 Part Properties Fixes A handful of issues centered around the Part Properties interface have been resolved: The Reference for Measurement tool in the interface has been fully removed ...

    • Transferring Global Variables to a new Library

      This article will explain the process of transferring customized Global Variables from your current library to a new installation of the Microvellum Foundation Library. The G! Workbook The Foundation Library contains all standard and custom data in ...

    • Microvellum Foundation Library Release Notes | Build 25.1121

      The following release notes apply to the Microvellum Foundation Library build 25.1121. Additions Added the new product, Master Island End Cabinet, to the Master Cabinets FF product category. Added the Nesting Optimization Report Select Processing ...