V&M Home Page

AVAILABLE for Consultations or Contracting - I hold passports from Canada and The Netherlands. I would be happy to help you - either in person or working remotely.
Email John

Which mail files will give me problems in today's NME migration.
Some time ago I wrote an application which was designed to examine a Domino mail environment prior to the planning meetings.
Click here to see the original post
You could run against your entire Domino Directory or just against a selected number of users. I've had other consultants use it against thousands of mail files.

However, I got a request to use it on the users whose mail files I am going to migrate tonight. This is my approach using Dell/Quest Notes Migrator for Exchange (NME). I have a different solution for Binary Tree's CMTe.

With NME we import the Domino Directory into a SQL table which is used to manage the migrations. Part of the process is to create a Collection.

Create Collection

Now we want to add people to this collection.

This process initially seems awkward, but in production it works quite well.

Select them all

Now we have all of the people whose name begins with "a". Now we want to get the information out of the SQL table. NME provides us with a way to export the data to a TSV (Tab Separated Value).

We are prompted for a location.

We can see our newly added Collection in the list of Collections

Now we open John's PreMigration Report Application

First we need to configure the environment

This version has the option to use TSV files

This was another request - to determine which users had attachments bigger than what Exchange would allow.

Now we select the TSV to use

Next we provide a file name or reuse an old file name.

The resulting spreadsheet looks like this:

Premigration Report.xlsxPremigration Report.xlsx < Sample Sreadsheet

Request more information

Author's Background
I am a Notes/Consultant with twenty-seven years of experience (almost exclusively with Lotus Notes / Domino). My experience with Notes began when I worked as a Senior Computer Consultant for Price Waterhouse. In 1993, I went to work for Lotus Development Corporation as a Senior Notes / Domino Instructor. I started teaching Application Development and System Administration with Version 3. Helped to develop the course materials for Version 4.x and Release 5.x When LotusScript, Javascript and Java were added to Notes/Domino I started teaching these programming languages.

In 1995, IBM acquired Lotus. For several years we were left alone and the culture did not change. It was a lot of fun to work for Lotus. In 1999 the handwriting was on the wall and I decided it was time for me to leave. So I established V&M to do Lotus Notes/Domino Application Development, System Administration and Training. I've been at it ever since. The life of the consultant is constantly changing. It has given me the chance to travel across Canada and the United States, Scotland, England, Bermuda, Jamaica, Barbados and Hawaii. No travel to the Far East yet. Anyone?

For the last seven years I have been helping companies move their data from Lotus Notes to the Microsoft platform.

Some thoughts on Notes to Exchange Migrations
Migrating from Lotus Notes to Microsoft - Very easy and very hard
Pre- Migration Report that I use
Encrypted Mail Choices
Export a Notes View to CSV
Mail Migrations Using the Cloud
Mail Migrations - Some Lessons Learned
Speeding Some Migrations
Redirecting Mail Migration Traffic
One post migration story
One Approach to Mail Rules
Remove Encryption Button
Microsoft's "Secret" Mail Migration Tool
NME Migrations from a secondary Domino Directory
How to remove encryption from a Notes database
NME and Secondary Address Book
Multi File Selector for Binary Tree CMTe
Problem Mail Files for NME (Notes Migrator for Exchange)
Using a Staging Server for Notes to Exchange migrations
SmartCloud to Office 365
Notes2SharePoint Part 1
Migrating Private Folders
Different roles in an email migrations
What to do with Profile Docs during a Migration

If you would like to see my resume
Click Here

Email John

Copyright 1999-2019, John Vanderhoff. All rights reserved. This document is NOT in the public domain and remains the property of John Vanderhoff. Distribution or modification of this document without the knowledge, review and express permission of John Vanderhoff is strictly prohibited.