Migrator for Notes to SharePoint 6.16 - User Guide

Import database records

Import database records

The Import Database Records tool reads records from a CSV file and updates values in certain Quest Repository database records. The tool is available only on the main Migrator for Notes to SharePoint node.

To import database records

1	From the Migrator for Notes to SharePoint Console, right-click Migrator for Notes to SharePoint, then select Import Database Records.

2	Select a CSV file that contains the records you want to import.

Then the Import Database Records dialog box appears.

3	Map the data from the file to the corresponding columns in the Quest Repository. For each column in the CSV file, choose one of the available database record properties to which to map it. If your file does not have a header row, do not select the Treat first row as column headers check box.

This tool can be used to update existing records, or add new ones. There are several methods that you can choose from for associating an input record with existing database records:

•	Server and File Path

•	Server and Replica ID

•	Replica ID only

•	Database Key

Depending on what options are selected, you can map additional fields. If you have not done this, a warning message appear sand the OK button is disabled.

When setting values, the related "Locked" flag is set.

Log file entries clearly indicate which databases were updated, added or not found.

Currently, the following database properties are available for mapping:

•

Server

•	Replica ID

•

File Path

•	Database Key

•

Title

•	Technical Class

•	Technical Class Comments

•	Business Class

•	Database Owner

•	Business Owner

•	Analysis Priority

•	Analysis Responsible

•	Migration Priority

•	Migration Responsible

•	Disposition

•	Disposition Comments

•	Design Analyzed

•	Data Analyzed

•	Targets Identified

•	Targets Provisioned

•	Targets Finalized

•	Jobs Assigned

•	Jobs Finalized

•	Content Migrated

•	Migration Verified

•	Target Site

•	Complexity

•	Effort Analysis

•	Effort Targets

•	Effort Jobs

•	Effort Content

•	Effort Testing

•	Base Effort Analysis

•	Base Effort Targets

•	Base Effort Jobs

•	Base Effort Content

•	Base Effort Testing

•	Effort Is Incremental

NOTE: If the column names match exactly, the mapped database property field pre-populates.

Notes databases

Notes databases

The Notes Databases Console Tree node allows you to view and act upon all the Notes databases that were identified during the Database Discovery process. The nodes below this node provide different filters of the databases.

Table 12. Notes databases

Property	Description
All Databases And Templates	Select this node to view all databases and templates in the center pane.
All Databases	Select this node to view the list of all databases in the center pane
Unique Replicas	Select this node to view just the unique database replicas in the center pane. In cases where you have multiple replicas of the same database (that is, they have the same Replica ID) only one representative of the database will appear in the view. The ordering of databases in your Preferred Server list will determine which replica is selected.
By Disposition	This tree node allows you to navigate the databases by the database dispositions as defined in the Migration Status tab of the database properties. In cases where you have multiple replicas of the same database (that is, they have the same Replica ID) only one representative of the database will appear in the view. The ordering of databases in your Preferred Server list will determine which replica is selected.
By Server	This tree node allows you to navigate the databases by the known servers hierarchically
By Technical Class	This tree node allows you to navigate the databases by their technical classes. In cases where you have multiple replicas of the same database (that is, they have the same Replica ID) only one representative of the database will appear in the view. The ordering of databases in your Preferred Server list will determine which replica is selected.
By Business Class	This tree node allows you to navigate the databases by their business classes as defined in the Classification tab of the database properties. In cases where you have multiple replicas of the same database (that is, they have the same Replica ID) only one representative of the database will appear in the view. The ordering of databases in your Preferred Server list will determine which replica is selected.
Notes Templates	This tree node allows you to view all the templates.
Custom Views	This tree node allows you to create your own views of the databases. For more information, see Custom views

Select a Database in the Results View and in the context menu or in the Action Pane is a list of database actions that can be selected.

Database actions

Database actions

 

Table 13. Database actions

Property	Description
Actions - All Databases	The actions listed under the ‘All Databases’ header are actions that are performed on all of the databases in the Results View.
Actions - Selected Item	The actions listed under the database name header are actions that are performed on the selected databases in the Results View. The header name will change according to which databases is selected in the Results View. When performing certain actions for a database that has child databases under it, you will be asked if would you also like to perform the action on the child databases. If you answer: • Yes: The action will be performed on the selected database and all of its child databases. • No: The action will be performed on just the selected database. • Cancel: The action will not be performed at all.

View

View

This action brings up several submenu items that allow you to customize the Results View. Properties such as column selection, column ordering and sorting are defined using the View menu item.

Table 14. View

Property	Description
Add/Remove Columns	Select the submenu item Add/Remove Columns to change the view’s column selection as well as to reorder and sort the columns.
Toggle Grid Lines	Select this menu item to show grid lines in the result view. If the grid lines are already displayed, select this menu item to hide them.
Refresh	Refreshes the data displayed in the console from the data that is stored in the Repository. When you make a change in one dialog box and save it, the data is saved to the Repository but some of the views in the console might not reflect the change. Executing a Refresh will update the views with the new data as well as run the Classification process.
Customize	This submenu item allows you to show or hide items in the Console dialog box.