Migrating Custom Attributes

 

Please note that this document is a guide only and can continue in much more depth. You should have access to the tool Mfcmapi.exe or another MAPI property viewer application. Customer attributes can be migrated from Noted to Exchange MAPI properties. A good scenario is by which there is an archiving product that assigns a custom message attribute to all messages, and this is required to be migrated.The ‘attrs’tsv’ file i location within the install directory of ‘X:\Program Files\Quest Software\Quest Notes Migrator for Exchange’ and is the file that would need to be modified in order to add your custom message type.

 

Below there is an example of a scenario which a customer attribute is to be migrated and how it is migrated. In this example we will call the custom attribute ‘Custom01′. In order to migrate this from Notes to an Exchange mailbox we need to add this mapping. Essentially we need to map the source attribute to a free property in the MAPI target mailbox(s) that is not in use.To do this you must create (or modify and backup) the unicode (NOT ANSI) file ‘attrs.tsv’. In the example further below, we want to migrate the ‘Custom01′ attribute in Notes to Exchange mailboxes to a random (free) target property of ‘0×4801′ STRING value type. When the migration is run, it automatically looks at the mappings within that file to determine the source and target attributes/properties. If during migration this does not work, below is a list of reason why and what can be done to troubleshoot this:·         

 

·         Confirm that the target property does not already exist and confirm that the target property specified in the ‘attrs.tsv’ file is of the correct format. Please see further below for more information regarding this.·           

·         Use MFCMAP to troubleshoot or view if the property has been created and also if the value has been created of the property.·       

·         Confirm the TSV file is UNICODE and NOT ANSISample file is here:

 

……

 

ID,SourceProperty,TargetPropertySet,TargetProperty,TargetPropertyType

Custom01,FavoriteColor,,0×6700,STRING

…….

 

Here is some more information regarding MAPI properties but it is brief.

 

An unnamed property’s name is a 16-bit integer in the range 0×0001 to 0×7FFF. That 16-bit integer is valid in all mailboxes. An example of a used property would ne 0×0070, this is used by MAPI so you could not use this.

 

A named property’s name is a property set GUID and an ID that is either a 32-bit integer or a string. A 16-bit integer alias in the range 0×8000 to 0xFFFF is assigned to the named property by MAPI. That alias is mailbox-specific. A custom property can be unnamed or named. If it is unnamed, you must select a 16-bit integer TargetProperty in the range 0×0001 to 0×7FFF that is not already in use by MAPI. If it is named, you can select any property set GUID.

 

If you select a property set that is already in use, you must choose a 32-bit integer or string ID that is not already in use in that property set. If you select a brand new property set GUID, you do not have to worry about IDs already being in use because there will not be any. If you want unnamed custom properties, samples to try include 0×48xx, 0×58xx, or 0×78xx range. There are few, if any, properties already in use in those ranges. If you want named custom properties, you should use the PS_PUBLIC_STRINGS property set GUID, (PS_PUBLIC_STRINGS) being an alias for {00020329-0000-0000-C000-000000000046}), and using string IDs with a prefix that is unique to your application (like “Quest-”).

 

Below is a migration checklist for the tool. These are things which should be completed prior to migration and during.

Task	Yes/No?
Environment Tasks
·         Download & Install the Exchange 2003 Connector for Lotus Notes: http://www.microsoft.com/downloads/details.aspx?FamilyID=d9f3a35e-1046-47b5-b09b-bda9de60cd9d&displaylang=en  ·         Download & install the Microsoft Transporter Suite: http://www.microsoft.com/downloads/details.aspx?FamilyId=35FC4205-792B-4306-8E4B-0DE9CCE72172&displaylang=en  ·         Configuring the Exchange 2003 Connector for Lotus Notes: http://support.microsoft.com/kb/883727  ·         Customizing the mapping of attributes with the Connector for Lotus Notes, if required: http://support.microsoft.com/?id=180517  ·         Configuring the Exchange 2007 Microsoft Transporter Suite: Documentation is supplied with the software, also see: http://go.microsoft.com/fwlink/?linkid=80568
·         Confirm Calendar and Mail Routing Coexistence
·         Configure Recipient policies
·         Configure Temporary Sub-Domain
·         Create AD user objects from Connector / Transporter, or by other means
Quest Notes Migrator Tasks
·         Create a computer for the Quest Migration
·         Create Migration Account for Domino Server with admin rights and LocalDomainAdmins membership
·         Create Migration Account for Exchange with receive-as & Send-as rights and NOT a member of Domain Admins
·         Create Migration Account for AD with Domain Admin rights
·         Install Notes Client
·         Install Outlook Client
·         Install PowerShell (2007 only)
·         Install Exchange Admin Tools
·         Exclude Anti-Virus from the migration machine
·         Install SQL (or have a SQL server) with createDB permissions to logon account
·         Download & Install the Quest Tools from:  http://www.quest.com/notes-migrator-for-exchange/
·         Specify SQL Server Config within the Quest Tool
·         Specify Shared Directories Config within the Quest Tool
·         Specify Notes Server Config within the Quest Tool
·         Specify Exchange Server Config within the Quest Tool
·         Specify AD Config within the Quest Tool
·         Run Find NABs
·         Run Find Domains
·         Run Export Notes Directory
·         Modify the Export Directory (if necessary)
·         Create User & Group Collections
·         Confirm Manage Design Classes
·         Run Locate Notes Data Stores
·         Confirm PAB Process by replicating data or sending PAB request
·         Run the Merge Contacts to merge AD user Objects (if required)
·         Set forwarding from Exchange back to Notes after mailbox-enabling objects
·         Confirm migration process & scheduling
·         Start of migration

 

 

 

 

 

 

 

What is MigDBUtil?

 

The Migration Database Utility (MigDBUtil for short) is used in scenarios by which you have replicated mail files from a remote slow connection server, to a more centrally located server in order to improve migration throughout, or simply for preference. When you use Notes Migrator for Exchange is has the Directory Export process that reads the NAB and takes the mail file path address from this and imports that into our database. So the NAB will not reflect the replicated mail file changes, which is where the MigDBUtil tool comes in, which allows us to modify these changes. A screenshot of the tool is below. The tool consists of the following components:

 

    · Add Servers

This component is only used when you have replicated the mail files to a new server which would in no way be within our database and until recently, not have been within the NAB. If you have replicated the mail files to a server that already existed, then this is not required to be run, you can simply run the modify Mail File Paths. By default sample input file is provided within the default installation difrectory named ‘sample_server.csv’

· Modify Mail File Paths

Here we use this by specifying a collection, namely a grouping of users, with an associated input file that contains details of the source path and the now new path. By default a sample input file is provided within the default installation directory named ‘sample_mailfilepath.csv’

· Import/Export Collections

This will not be discussed in detail but is used to back and restore any or all collections you use for the migration

 

 Looking at the Locate Notes Data Stores screen, you may have the following mail file path, which is named as the Domino Server Address column within the NME GUI under the Locate Notes Data Stores menu.

 

 

 

In our scenario we wish to change this path because you have replicated the mail file from the following path of:

Domino65/Wingra!!mail\Folder\gwbush.nsf

To the following new replicated path of:

NewServer/Wingra!!mail\NewFolder\gwbush.nsf

 

Run the Add Servers

Because we have specified a new server we will need to run the Add Servers section of the MigDBUtil and also generate/modify the sample_servers.csv file with the new server name. Below is a screenshot of the template file supplied that has been modified with the new server I will be using.

 

 

Now we save this file and use the Add Servers component to add this server record into our database as seen below.

 

 

Now this record has been successfully added into our database, we can now continue on to modify the mail file path of the user(s) by utilising the ‘Modify Mail File Paths’ component so that when we finally migrate, we are migrating from the newly replicated NSF.

 

Run the Modify Mail File Paths

 

Open the template ‘sample_mailfilepaths.csv’, located in the root install directory. You will need to modify this with Excel (or notepad) and a bit of copy/paste. The original file is below for your reference.

 

 

 

When modified, the resultant file will look like the following:

 

 

The ‘Source Address’ column within our database must match the one within this input file. We gain the ‘Source Address’ column value from a collection we can export from the tool. This is done via the Manage User Collections in the Quest GUI, selecting the collection and then exporting that collection. A snippet of this export is shown below. So we use the ‘SourceAddress’ column as shown, and paste this into the ‘Source Address’ column of the ‘sample_mailfilepaths.csv’.

 

 

Now run the modify Mail File Paths specifying the input file ‘sample_mailfilepaths.csv’ and the result is shown below.

 

 

To confirm this has now worked, the following Locate Notes Data Stores screen will reflect the changes in the GUI.

 

 

 

 

Please see the following document on how to troubleshoot permission based errors that are returned through Quest products. Namely Migration Manager for Exchange and other tool which require full mailbox access and/or no denies on accounts:

Troubleshooting Exchange Permissions