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 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 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:
- Report Groups – Transfers all associated data, including selected report groups, their associated report templates, and associated report dataset definitions.
- Render Layers – Transfers all associated data to the Layers table. These layers originate from the Change Materials user interface.
- Activity Stations – Transfers all associated data, including selected activity stations and their categories.
Fig. 01 – Database Management Utility – Import Misc Item(s)
- Select IMPORT from Selected Source to Current Configuration > browse to the file location containing the MicrovellumFactory.sdf to be imported > select the MicrovellumFactory.sdf.
- Select the Misc Item(s) tab.
- The middle panel is populated with data from the database selected in Step 1. Select the Misc Item(s) to be imported from this central panel.
- Select Transfer.
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.
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:
- Skip – Does not change the existing item, and an additional item is not added. The item is ignored.
- Replace – Replaces the item in the target location that has the duplicate name.
- Keep Both – Appends to the target location. A new name must be given to the item.
Fig. 03 – New Name
Related Articles
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). ...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 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 24.1.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...Toolbox Release Notes | Build 24.1.1125.641
The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...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 ...