Transformation

The accelerator creates an Excel report with the transformation result. It provides the following columns:

• Migration Origin: migration.origin.
• Source ID: The id of the object in the source system.
• Source Name: The name of the object in the source system.
• Source Path: The location of the object in the source system.
• Kind: The content store schema.
• Version Series ID: The id that represents the complete set of versions.
• Current version: Indicates if the version is the current version.
• Major Version: The major version number.
• Minor Version: The minor version number.
• Source Creator: The creator display or system name of the object in the source system.
• Source Created Date: The creation date of the object in the source system.
• Source Modifier: The modifier display or system name of the object in the source system.
• Source Last Modified: The modification date of the object in the source system.
• Source Content Type: The content type display or system name of the object in the source system.
• Target Content Type: The content type display or system name of the object after transformation.
• Target Name: The name of the object after transformation.
• Target Path: The location of the object after transformation.
• Target ID: The id of the object after transformation.
• Target Creator: The creator display or system name of the object after transformation.
• Target Modifier: The modifier display or system name of the object after transformation.

In addition, it adds all target.properties fields as additional headers unless the customHeaders flow variable has been specified.

For example:

Migration Origin	Source ID	Source Name	Source Path	Kind	Version Series ID	Current version	Major Version	Minor Version	Source Creator	Source Created Date	Source Modifier	Source Last Modified	Source Content Type	Target Content Type	Target Name	Target Path	Target ID	Target Creator	Target Modifier	ApproverSingle	Business Units	Document Purpose	IsDone	Partial Source Path	Price	Reviewed	Source	RetentionLabel
Alfresco	workspace://SpacesStore/36f734ac-7b44-4998-84f7-4a69f78f6d02;2.0	Arches National Park - delicate arch v2.jpg	/Sites/xill4/documentLibrary/source e2e/Arches National Park - delicate arch v2.bmp	RECORD	workspace://SpacesStore/36f734ac-7b44-4998-84f7-4a69f78f6d02	FALSE	2	0	admin	13/03/2023	admin	13/03/2023	cmis:document	Xillio Document	Arches National Park - delicate arch v2.jpg	https://company.sharepoint.com/sites/demo/Gedeelde documenten/Arches National Park - delicate arch v2.jpg	8fef8e92-f47a-a8a1-0bfd-41ab426ab156	demo@sharepoint.com	demo@sharepoint.com		IT	/DMT/Document Purpose/Analysis, Data, Research	No	1 line	5678	0	Alfresco	Microsoft Information Protected
Alfresco	workspace://SpacesStore/3427fb94-1f21-4947-8008-ff4e2cf5e614;1.0	account``=%.txt	/Sites/xill4/documentLibrary/source e2e/account``=%.txt	RECORD	workspace://SpacesStore/3427fb94-1f21-4947-8008-ff4e2cf5e614	TRUE	1	0	admin	19/01/2023	admin	19/01/2023	cmis:document	Xillio Document	account``=%.txt	https://company.sharepoint.com/sites/demo/Gedeelde documenten/account``=%.txt	644a2ff0-1926-f6ed-7a21-4946d4e29022	demo@sharepoint.com	demo@sharepoint.com	demo@sharepoint.com	R&D,Finance	/DMT/Document Purpose/Finance ＆ Budgeting,/DMT/Document Purpose/Analysis, Data, Research	Yes,No,Maybe	line 1,line 2,line 3	1234	1	Alfresco
Alfresco	workspace://SpacesStore/bc3ec5ad-dd9e-4d83-b17d-b7dcf9a2d980;1.0	shoes_awesome_cambridgeshire.svc	/Sites/xill4/documentLibrary/source e2e/shoes_awesome_cambridgeshire.svc	RECORD	workspace://SpacesStore/bc3ec5ad-dd9e-4d83-b17d-b7dcf9a2d980	TRUE	1	0	admin	19/01/2023	admin	19/01/2023	cmis:document	Xillio Document	shoes_awesome_cambridgeshire.svc	https://company.sharepoint.com/sites/demo/Xill4 document sets/Document Set/shoes_awesome_cambridgeshire.svc	d7166f95-39bb-0a34-e531-0d7077ec14bd	demo@sharepoint.com	demo@sharepoint.com			/DMT/Document Purpose/Finance ＆ Budgeting					Alfresco

Settings

mongoConnection

The Mongo connection string including the database name to connect to.

mongoConnectionTarget

The Mongo connection string to connect to containing the exported SharePoint Online objects. Only used when targetIsSPO is set to true.

reportPath

Path to the Excel file.

sheetName

Name of the sheet.

targetIsSPO

Specifies if the target system is SharePoint Online. If set to true it will use the configured mongoConnectionTarget to retrieve the display names of the metadata fields. If set to false, the system name of the metadata field is used instead.

customHeaders

An object containing additional headers with the content store path of the property. When specifying an empty object, all properties in target.properties are added as headers.

Example:

{
    "Department" : "target.properties.department", 
    "Batch" : "migration.flags.batch"
}