Database Management Utilities (Overview)

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 designed to import into configurations already containing the same type of library.  For example, it is OK to import a Component Cabinet Library into a configuration already containing a Component Cabinet Library.  However, this tool should NOT be used to import a Foundation Library into a configuration containing a Component Cabinet Library or vice versa.   Depending on the source library and destination database, additional development may be required after import to successfully set up the new library. For more information, please visit the  Microvellum Knowledge Network.
See  Database Management Utilities (Reference) in the Microvellum Help Center for a reference article explaining the commands and control options of the Data Management screen.

Import Export Utility

(The article that follows provides an overview for using this tool, also known as the Import-Export Utility.)

Microvellum makes extensive use of databases to maintain data as you work with the software. There are multiple reasons to utilize databases instead of separate files of various types. Among these rationales are security and speed.

While databases are an attractive choice for software designers, they also present a few design challenges, primarily relating to data management. For example, you almost certainly don’t want all your users working directly within the databases for reasons of security and data integrity.

As of Microvellum build 15.6.2404 or greater, we have enhanced the user experience by creating a new interface for interacting with the databases. See the figures below for the new and former access point and database tools interfaces.


Fig. 01 – New Data Management (Database Utilities) Access Point



Fig. 02 – Former Database Utilities Access Point



Fig. 03 – New Data Management Screen Containing Various Database Utilities



Fig. 04 – Former Database Utilities Screen 

Manage Various Data

In general, use the new Database Management Utilities to manage your data in various Microvellum databases. This includes the export and import of the data below.

  • Libraries
  • Projects
  • Products
  • Subassemblies
  • Materials
  • Reports
  • Tool files
  • Processing Stations
  • Work Orders
  • Graphics
  • Misc Item(s)
    • Report Groups
    • AutoCAD Render Layers
    • Activity Stations
  • It also includes a suite of tools for maintaining and preserving existing data structures from corruption.

Fig. 05 – Data Maintenance Tools

One of the concerns that this new data management tool resolves is that the supporting files necessary for proper operation of the target machine when the transfer has been completed are included.

As an example, using the previous version of this tool, it was possible to send an export that would fail when imported because either the materials were missing or the incorrect processing stations were included. The tool now establishes what supporting files are required and automatically includes them in the export file. See the help text under the Tree View or the accompanying reference article for more information about what is included with each category of data.

See Database Management Utilities (Reference) in the Microvellum Help Center for a reference article explaining the commands and control options of the Data Management screen.

Export from Multiple Categories

You may select items from multiple category types and include them in a single export. For example, you may export both projects and products in a single export file. Previously, if you wanted to export a project, processing station, and reports for a support inquiry, you were required to export to three separate databases. Now you may export them all to a single database and send that single database.

The Data Management utility displays the products in the same categories as the interface you use for drawing them or adding them to a project in Toolbox.

Database Objects Display

The center section of the new interface supports two display options – one for a tree view, and the other for a combined view. Most of the database objects display in a Tree View, similar to what is shown in Figure 06 below.


Fig. 06 – Tree View of Database Objects


The exception to this rule is the Graphics category. The objects in this category are not stored in the database but are individual folders and files stored on the computer hard drive. Although they are not database objects, they are included in the database management utilities to facilitate data transfer between computers or between Microvellum configurations.

They are displayed in a combined folder and file structure similar to Windows File Explorer as shown in Figure 07 below.


Fig. 07 – Combined View Showing Folders and Files

Archiving Data

One of the intended uses of this tool is an archiving tool. For example, you may want to clean out your old work orders, but as you may need to refer to them again in the future, you don’t want to simply delete them. Use the Data Management Utilities to move them out of the configuration databases and into archival databases that you create in the export process. See the reference article for more information.

Export Folder Structure

When you export from a factory database, you must first select a destination folder in which to create the export files. Not all category types create the same structure. See the reference article for examples of the different data structures in use.

See Database Management Utilities (Reference) in the Microvellum Help Center for a reference article explaining the commands and control options of the Data Management screen.


    • 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 ...
    • 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 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 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). ...
    • How to Import a Library using Database Management

      NOTICE: The Library Import function is a powerful tool that modifies large sections of data in the current configuration.  ALWAYS back up your data before executing a Library Import. The Library Import functionality of Database Management is designed ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.1105.641

      The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...
    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...
    • Toolbox Release Notes | Build 24.1.1030.641

      The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...
    • Toolbox Release Notes | Build 24.1.1010.641

      The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...
    • Toolbox Release Notes | Build 24.1.1001.641

      The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...