How to Import Reports using Database Management

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

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


Fig. 01 – Database Management Utility – Import Reports 
  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 Reports tab. 
  3. The middle panel is populated with data from the selected database. Select the Report(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

The imported Report(s) are located with the rest of the reports.

    • 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 Import Subassemblies 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 Import Graphics 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 Import Materials 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

    • Toolbox Release Notes | Build 25.1.1204.641

      The following release notes apply to Toolbox build 25.1.1204.641 Toolbox Login Screen Update Fig. 1: The updated Toolbox Login interface. The Toolbox Login interface has had several changes applied to it to enhance its usability and allow for greater ...

    • Toolbox Release Notes | Build 25.1.1120.641

      The following release notes apply to Toolbox build 25.1.1120.641 Mouse Wheel Fix There was a reported issue in certain interfaces (such as report groups) in which hovering over a dropdown menu (such as Output Type) would result in the options within ...

    • Dynamic Dimensioning in Toolbox BSB

      When applying dimensions to products and other solids in Toolbox BSB, by default, all dimensions are drawn in 2D on the Y plane, requiring one to switch to a top view (or an appropriately high isometric view) to see them. BricsCAD has a feature that ...

    • Toolbox Release Notes | Build 25.1.1107.641

      The following release notes apply to Toolbox build 25.1.1107.641. Subassembly Prompt Fixes A pair of issues were reportedly occurring when attempting to work with subassembly prompts in the Edit Design Data interface. Subassemblies copied to the ...

    • Microvellum Foundation Library Release Notes | Build 25.1024

      The following release notes apply to the Microvellum Foundation Library build 25.1024. Additions Added Face Profile Options to the Door Wizard for enhanced design flexibility. Users can now apply decorative visual profiles to doors, drawer fronts, ...