Migrator for Notes to Exchange 4.15.2 - Administration Guide

Notes Data Locator Wizard

Introduction

Notes data stores contain data associated with Lotus Notes features: emails, PABs, archives, calendar data, and so forth. (Generically, a data store is simply any repository of data.) Some Notes data stores reside in central locations, where they are available to all users, while other data stores reside on users' local workstations, each containing only information associated with the individual user. Migrator for Notes to Exchange's migration software can migrate data from anywhere within the Notes system, but only if it knows where the various data stores reside.

Migrator for Notes to Exchange therefore include a Notes Data Locator Wizard that scans the Notes environment for all data stores associated with a designated user collection. The wizard records (in Migrator for Notes to Exchange's SQL database) the locations of all data stores it finds, together with several associated statistics, and displays this information in a table in Migrator for Notes to Exchange's Notes Migration Manager, on the Locate Notes Data Stores screen (under User Collections). The statistics collected by the wizard include such things as: size of the store, number of items in the store, average per-item size of items in the store, date and time the statistics were last collected or updated, and so forth.

The Notes Data Locator Wizard defines a task that will locate data files in the Notes source for a particular user collection, or gather statistics from previously located data files, and schedules the task to run at a particular time, or at a series of recurring times. The wizard can be told to locate data files by type (mail vs. PABs vs. archives) in any combination.

Migrator for Notes to Exchange's Notes Data Locator Wizard is launched from the Locate Notes Data Stores screen of Notes Migration Manager, and is always applied to a particular user collection, specified in the Locate Notes Data Stores screen. Field definitions and application notes for the wizard’s screens appear in separate subsections below.

NOTE: Since the PAB Replicator is designed to copy users’ local data stores to a centralized location, be sure that all users have run the PAB Replicator before you run the Notes Data Locator Wizard.

How to add NSF file locations to user collections

If the Notes Data Locator Wizard does not find users' NSF files, but you know their locations, you can add the per-user NSF paths to the SQL database so the Data Migration Wizard can migrate them. To edit the contents of a SQL Server data table, you must first export the table to a .tsv file, then use Microsoft Excel or a similar application to edit its contents, and then import the amended values back into the SQL database. (This process is explained in Appendix A under How do I specify per-user locations for Notes source data?) Within the data table, the MailFilePath column defines the specific paths and NSF filenames to users' mail files. For example:

Wizard process screens

The Notes Data Locator Wizard is configured on these screens: