How to Export Reports using Database Management

How to Export Reports 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 Reports using the Database Management Utility.

All records associated with the selected Report(s) (Data References) are transferred by default.

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


Fig. 01 – Database Management Utilities – Export Reports

Additional Options

When exporting Reports, the following Additional Options are available:


Fig. 02 – Additional Options when Exporting Reports

  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 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 reports exported and various other tables of data.


Fig. 05 – Folder Structure
    • Related Articles

    • 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 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 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 ...
    • Microvellum Foundation Library Release Notes | Build 24.0919

      The following release notes apply to Microvellum Foundation Library build 24.0919 Additions Added 5 new special Wine Rack products and 9 new Wine Rack Insert subassemblies. Products: Master Vertical Wine Rack Corner Frame Master Vertical Wine Rack ...
    • Foundation Library Catalog: Appliances

      This document lists the full range of appliance products within the Microvellum Foundation Library. Appliances are non-cabinet products such as refrigerators, dryers, microwaves, intended to be placed into Microvellum project rooms for visualization ...
    • Toolbox Release Notes | Build 24.1.0913.641

      The following release notes apply to Toolbox build 24.1.0913.641 Copying Fix Issues were reportedly occurring when users attempted to copy projects and rooms: When attempting to copy a and move a project, it was sometimes the case that products being ...
    • Foundation Library Catalog: Countertops

      This document lists all products in the Countertop category of Microvellum's Foundation Library. Countertop products are products designed to be placed atop counters or placed along wall components to act as surfaces, coming in a variety of shapes to ...