Transformation (3b. Principal Mapping)
Warning: this flow will overwrite the systemName and displayName of target.created.principal and target.lastModified.principal for containers and records!
The principal mapping flow transforms the creators and modifiers of content to be migrated. This flow automatically maps the source.created and source.lastModified principals based on their email address. It requires PRINCIPAL objects including their email addresses to be present in the source and target system databases. In case they are missing in either the source or target database, the configured fallback principal will be set.
If the PRINCIPAL objects in the source databases don't have the email address that correspond to email addresses on PRINCIPAL objects in the target databases, you can use an excel sheet to map usernames to email addresses.
Configure the settings principalMappingPath and principalMappingSheetName to point to this mapping sheet.
The columns in this sheet are:
*Principal Source ID: Refers to thesource.idof the principal.Principal Email: Refers to the email of the source principal. The path to this workbook and sheet name is set in the configuration usingprincipalMappingPathandprincipalMappingSheetName.
Settings
mongoConnection
The Mongo connection string including the database name to connect to. This database should also contain the (exported) PRINCIPAL objects of the source system.
mongoConnectionTarget
The Mongo connection string to connect to containing the (exported) PRINCIPAL objects of the target system.
fallbackPrincipalSystemName
The source.id value of a PRINCIPAL object to be used as a fallback when the principal could not be mapped.
fallbackPrincipalDisplayName
The source.name.displayName value of a PRINCIPAL object to be used as a fallback when the principal could not be mapped.
principalMappingPath
The path to the Excel workbook containing the principals source ID and email.
principalMappingSheetName
The sheet name of the Excel workbook containing the principals source ID and email.