How to Export Misc Items using Database Management

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

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

The Misc Item(s) tab of the Database Management Utility allows for the transfer of three separate database items:
  1. Report Groups – Transfers all associated data, including selected report groups, their associated report templates, and associated report dataset definitions.
  2. Render Layers – Transfers all associated data to the Layers table. These layers originate from the Change Materials user interface.
  3. Activity Stations – Transfers all associated data, including selected activity stations and their categories.

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


Fig. 01 – Database Management Utilities – Export Misc Item(s)

Additional Options

When exporting Misc Item(s), the following Additional Options are available:


Fig. 02 – Additional Options when Exporting Misc Item(s)

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

Export Folder Structure


Fig. 05 – Folder Structure

A MicrovellumFactory.sdf database file is created containing the layers, report groups, and report exported.


    • Related Articles

    • How to Import Misc Items 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 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 Graphics 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

    • Toolbox Release Notes | Build 25.1.0213.641

      The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...
    • Toolbox Release Notes: Year of 2024

      This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...
    • Toolbox Release Notes | Build 25.1.0129.641

      The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...
    • Microvellum Foundation Library Release Notes | Build 25.0124

      The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...
    • SQL Server Backups

      This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...