User mapping is often a core problem for SharePoint Migrations. The job of creating user mappings, configuring, and importing them into Content Matrix can be time consuming and difficult, depending on the size and complexity of the migration project. To address this need we have created a new command line utility called UserMappingsCLI that can help with the following tasks:
We have also added new PowerShell Cmdlets to import the user mapping into Content Matrix.
Instructions for generating and importing user mappings for SharePoint on-premises to SharePoint Online migration use case.
(A readme file with examples for additional use cases is included in the package)
To configure the UserMappingsCLI tool
To export users
UserMappingsCLI.exe --action=export --source-type=ad --export-type=csv --export="C:\temp\Source-Domain-Users.csv"
UserMappingsCLI.exe --action=export --source-type=aad --export-type=csv --export="C:\temp\Target-M365Tenant-Azure-Users.csv"
Would you like to save your Azure credentials?. Please answer 'yes' or 'no'.
To generate user mappings file using the exported list of users
UserMappingsCLI.exe --action=generate --source-type=csv --source="C:\temp\Source-Domain-Users.csv" --target-type=csv --target="C:\temp\Target-M365Tenant-Azure-Users.csv" --transformer-type=powershell --transformer="C:\Quest\Tools\UserMappingsCLI\sample-transformers\format-mapping.ps1" --storage-type=csv --storage="C:\Quest\Tools\UserMappingsCLI\user-mappings.csv"
It will then generate user mappings (user-mappings.csv) in the following format:
It is important to use the correct claims encoding prefix in the user mappings. The claims prefix depends on the authentication provider used by SharePoint Web Applications. Some examples of standard claims prefixes are given below. For more information about claims encoding format click here
Web apps using classic mode Authentication (Typically SP 2010)
Web apps using claims based authentication
Web apps using SAML authentication
Web apps using Forms-based authentication
If you are not sure which claims format to use, you can launch the Content Matrix global users mappings and inspect the claims prefix used in SharePoint.
To import user mappings into Content Matrix SharePoint Edition
Applies to: Content Matrix 9.0 and above
The "UserMappings.mls" file is portable and you may copy the file directly into the user profiles of any other users to import the mappings and restart Content Matrix which automatically loads the mappings from UserMappings.mls file
2. Special characters in claims prefix may impact the outcome due to the limitations of plain csv. See here for more information and workaround if your claims prefix contains special characters.
3. The "UserMappings.mls" file may get provisioned under a different folder if multiple editions of Content Matrix are installed, for instance "%APPDATA%\Metalogix\Content Matrix Console - eRoom Edition\UserMappings.mls". The file needs to be moved into SharePoint Edition folder in that case.