The mapping table is used to convert email addresses everywhere it is needed.
It is used to convert email addresses found during the migration.
For Mail Migration, it is used to convert email addresses in:
- Mail headers
- appointments (Calendar entries)
For Drive Migration, Sites, Groups, and Teams migration:
- It is used to convert permissions and metadata (CreatedBy, ModifiedBy)
Be careful: if the mapping table is incorrect or incomplete, your migration data may get corrupted.
If an entry is missing in the mapping table, the email address to migrate will not be converted.
For permission migrations, this would be impacted since the permission will not be migrated.
For instance, if a permission is given to email@example.com and there is no corresponding entry in the mapping table, the address will not be converted to firstname.lastname@example.org and the engine will try to push email@example.com. The target may reject it and return entry does not exist.
If you modify the mapping table after the migration, the missing permission will not be remigrated because only modifications that occurred in the source document are pushed during delta passes.
If the product does not detect a change in the source document between 2 passes, the document will not be pushed again and the permissions will not be reapplied.
Metadata such as CreatedBy or ModifiedBy may not be correctly filled with appropriate usernames if they are not included in the Mapping Table.
So be careful. The mapping table is a key component to a successful migration and you should ensure that it is correctly filled prior to starting your migration.
How to Edit the Mapping table.
Mapping table entries are automatically added to the list when you create a user to migrate from the mail migration or file migration area.
You can also add mapping entries manually or import them through a CSV file.
The file must have the following fields in the header row:
|FirstName||First Name of the user.|
|LastName||Last Name of the user.|
|DisplayName||First Name and Last Name of the user.|
|SourceEmail||Email Address of the source.|
|TargetEmail||Email Address of the target.|
|EntryType||Enter 0 for user, 1 for group.|