This article discusses how to use the Database Import Wizard to import documents and their metadata into Meridian Enterprise.
Notes about Performance
-
The time that it takes to import documents is affected by many factors. For the best performance, we recommend that the source database and document files reside on the Meridian server. After the import is complete and has been accepted, the source data can be deleted. To estimate the time required, perform a test import with a subset of the data and extrapolate the results.
-
Perform large imports after business hours so that server performance is maintained for production work. Importing thousands of documents with the Database Import Wizard can cause delays that are unacceptable to system users.
-
To improve the performance of the server during large imports, temporarily configure the following settings. Remember to restore the settings when the import is complete.
-
Depending on the version of Windows, set Processor scheduling or Application response setting to Programs or Applications respectively.
-
Increase the value of the MaximumLogSize setting of the vault to a value that will prevent snapshots from being made during the import, which will delay completion.
-
Increase the value of the MinimumSnapshotInterval setting of the vault to a value that will prevent snapshots from being made during the import, which will delay completion.
-
Important! Before You Get Started
-
Before attempting a large import, back up the vault first. That way, if the import does not go as planned, you can reverse the import easily by restoring the backup. Deleting incorrectly imported documents does not reclaim vault database storage space.
-
After files have been imported to a vault, document properties that were not explicitly set during the import (from title blocks, default property assignments, and so on) contain no values. Those properties will not be synchronized to the imported content files by the Meridian application links. This is by design to prevent overwriting existing values.
The properties can be synchronized from the imported content files. Such properties must be set in the vault to an explicit value at least once before the properties will be synchronized to the content files.
-
Before importing files with external references, such AutoCAD drawings and Autodesk Inventor assemblies, all external reference files must be fully resolved or they must be located in the same folder as the main file. Unresolved external references files will prevent the creation of the required Meridian references.
-
Before you import many documents into a vault, we recommend that you finish all vault configuration. Some configuration changes can be very time-consuming when the vault is populated by a large number of documents. This is especially true for the Field-Path definition. We recommend that you import documents into folders that were created using the Field-Path definition that you have configured.
Database Import Wizard
To import documents and their metadata with the Database Import Wizard:
-
Create a source database that contains metadata about the documents that you want to import, as described in Create an Import Source Database.
-
In Configurator, on the Vault menu, select Import from a Database.
The Database Import Wizard appears.
-
Click Next.
The Configuration File page appears.
-
To use an existing Database Import Wizard configuration file:
-
Select it from the list, OR
-
Click Browse, select the file, and click Open.
-
-
Choose one of the following options:
-
If the configuration file is complete and correct, click Start Import to begin the import immediately.
-
Click Resume to continue a previous import.
-
To configure a new import, click Next.
The Database page appears.
-
-
Click options or type values using the descriptions in the following table.
Database options Option Description Select the database to import from
Click Browse, select a database file type from the list, select the database that contains the document metadata that you want to import, and click Open.
Note:If the source database is a Microsoft Excel worksheet, you must specify the cells that contain the data to import as a named range in the worksheet. You will select this range in the Select Table dialog in the next step. If you don't create a range, the Database Import Wizard cannot determine the data to import.
For more information on naming a range in Excel, refer to the Excel documentation.
Show ODBC driver setup dialog
Allows you to configure an ODBC connection to the database, if one is not available already.
Depending on the data source you selected, the Select Table dialog might appear.
-
If so, select the table (or Excel range) that contains the data that you want to import and click OK.
The File Path Field page appears.
-
Select a field in the source database from Path field that contains the path to the files that you want to import.
-
Click Next.
The Document types page appears.
-
Assign document types, as described in Assign Document Types To Imported Files and click Next.
The External References page appears.
-
If you want the Database Import Wizard to attempt to resolve external references after the import has completed, select Resolve external references.
Resolving references creates a Meridian reference between the documents.
-
Click Next.
The Initialize Properties page appears.
Note:If CAD external references will be resolved during import, the native application may need to be installed on the computer where the Database Import Wizard is run. This is true for all CAD applications except AutoCAD.
-
Select options to initialize properties as described in Initialize Document Properties and click Next.
The Title Block Fields page appears.
-
Select Import title block data if the information in CAD drawing title blocks is more complete or accurate than the data in the source database.
The title block data will overwrite data imported from the source database. The document types assigned to documents with title blocks must be configured to exchange title block data, as described in Configure Standard Title Block Synchronization.
-
Click Next.
The Rendition file path field page appears.
-
Select Add the rendition file to the document if the source database contains a field that contains the paths to separate rendition files that you want to import to the vault.
-
Select that field from the list.
The rendition files will be imported to the vault and associated with the documents that are created.
-
Click Next.
The Exclusions page appears.
-
Select options to exclude certain documents from being imported, as described in Exclude Documents From Import and click Next.
The Revisions page appears.
-
Select options to import document revisions, as described in Import Revisions and click Next.
The Tree Structure dialog box appears.
-
Select an option to specify whether or not the drive letter of the path of the source documents should be used to create the top-level folder of the documents' paths in the vault, and click Next.
The Final Settings page appears.
-
Click options or type values using the descriptions in the following table.
-
Click Next.
The final page appears.
-
Click Finish.
The import begins and a progress dialog box appears showing statistics, as described in Monitor the Import Progress.
If you need to cancel the import for any reason, it can be completed later by loading the same configuration file in step 4 and resuming the import in step 5.
-
When the import is finished, use a Meridian client application to verify the results by checking the following for a representative sample of documents in the vault:
-
Name and location (Field-Path definition) in the vault
-
Document content is present and viewable
-
Correct property values, especially for the properties described in Create an Import Source Database.
-
Document revisions
-
Hybrid documents
-
Meridian references were created during the import for external references, if applicable
-
-
If you chose to create a log file in step 22, review the log file for errors.
