How to Export Work Orders using Database Management

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

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

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

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


Fig. 01 – Database Management Utilities – Export Work Orders

Additional Options

When exporting Processing Stations, the following Additional Options are available:


Fig. 02 – Additional Options for Exporting Work Orders

  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.
  2. Delete Work Orders After Export – Check this box to delete all selected project records and their dependent children after export. This also deletes the folder structure on disc.

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 work orders exported and various other tables of data. A folder is also created for each work order being exported within the folder selected containing the batches, nest drawings, G-Code files, DXF files, and individual work order databases.


Fig. 05 – Folder Structure
    • Related Articles

    • 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 ...
    • 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 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). ...
    • Recent Articles

    • Adding a Font to Toolbox

      This article will explain the process of adding new fonts to Toolbox, both in drawing space and the Report Designer. Toolbox offers an array of fonts for users to customize their text in reports, documents, and drawings. New fonts can be added to the ...
    • Toolbox Release Notes | Build 25.1.0505.641

      The following release notes apply to Toolbox build 25.1.0505.641. Project Workbook Permissions Fix An issue was reported and resolved regarding the permissions of employee access to project factory workbooks. Users who do not have authorization to ...
    • The Microvellum Client Portal

      When logging into Microvellum’s Client Portal, several features are available to help ease the purchasing and management of Microvellum products, the ability to find accurate information in a convenient and timely manner, as well as keep track of ...
    • Toolbox Release Notes | Build 25.1.0421.641

      The following release notes apply to Toolbox build 25.1.0421.641 Drilling Coordinate Fix Fig. 1: Drilling G-code with correct coordinates (left) and an extra erroneous set of coordinates (right). An issue was sometimes occurring when processing parts ...
    • Microvellum Foundation Library Release Notes | Build 25.0418

      The following release notes apply to Microvellum Foundation Library build 25.0418. Additions Added a new Cost Based Estimating Report, “Shop Quote Optimized Option”. Instead of using the square footage plus waste, this will use the actual optimized ...