Skip to main content

How to Import Materials using Database Management

This article provides a brief tutorial for importing Materials using the Database Management Utility.

J
Written by Jordan Munoz

The Import function of Database Management is a powerful tool that modifies data in the current configuration. It is recommended to ALWAYS back up your data before executing a data Import.

All records associated with the selected Material(s) are transferred by default. These records include Sheet Sizes and Categories. If hardware materials are transferred, any associated drawing files are collected and transferred.

Fig. 01 – Database Management Utility – Import Materials

  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 Materials tab.

  3. The middle panel is populated with data from the database selected in Step 1. Select the Material(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.

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

Fig. 03 – New Name

When a new Material is imported, an import category is added that contains the Material(s). This appears in the tree-view:

Fig. 04 – Import Category

Did this answer your question?