Reports
This accelerator contains multiple report flows to support your migration process.
Flows
Container structure report
The accelerator creates an Excel report that captures the container structure. It splits the hierarchy into configurable levels (default is 8) and provides the following columns:
Xillio id: A generated id based on objects metadata.Level1 – LevelN: Represent the first N levels of the container hierarchy, where N is set by maxLevels.Remainder levels: Contains any additional levels beyond the configured N.Source id: Id of the source container.Content type system name: System name of the content type.Content type display name: Display name of the content type.Hierarchy: Full path of the container structure.Document counts: Number of documents within the container.
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
reportPath
Path to the Excel file.
sheetName
Name of the sheet.
maxLevels
Number of hierarchical levels to return as separate columns. Default is 8, configurable as needed.
Content Types Count
The accelerator creates an Excel report that captures the number of content types. By default, it provides the following columns:
Kind: Kind of the content.Content type system name: System name of the content type.Content type display name: Display name of the content type.Count: The number of the content type.
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
reportPath
Path to the Excel file.
sheetName
Name of the sheet.
Metadata Fields
This flow generates an Excel file reporting the following information about the (top-level) metadata fields of RECORD and CONTAINER objects present in the Content Store:
Kind: Object type:RECORDorCONTAINER.Content Type: Content type (source.contentType.systemName).Total Objects: Total number of objects of that kind and content type.Field Name: Name of a metadata field present in those objects.Field Occurs: Number of objects that contain the field.Field Filled: Number of objects where the field is set to a value.Field Empty: Number of objects where the field is empty.Max Length: Longest string length of values for the field (0if the field is not a string).ObjectId:_idof an object containing the field.Sample Value: Example value for the field from the object withObjectId. If the field is a nested object, the value will display as[object Object].
For example:
| Kind | Content Type | Total Objects | Field Name | Field Occurs | Field Filled | Field Empty | Max Length | ObjectId | Sample Value |
|---|---|---|---|---|---|---|---|---|---|
| RECORD | File | 40 | mapping | 40 | 40 | 0 | 0 | 78f888fe... | [object Object] |
| RECORD | File | 40 | rootId | 40 | 40 | 0 | 36 | 78f888fe... | ec25fead-229c-4cac-b279-02ad115993f2 |
| RECORD | File | 40 | rootHierarchy | 40 | 40 | 0 | 49 | 78f888fe... | /sites/demo-site/Shared%20Documents |
| CONTAINER | Folder | 4 | mapping | 4 | 4 | 0 | 0 | 39e578b6... | [object Object] |
| CONTAINER | Folder | 4 | rootId | 4 | 4 | 0 | 36 | 39e578b6... | ec25fead-229c-4cac-b279-02ad115993f2 |
| CONTAINER | Folder | 4 | rootHierarchy | 4 | 4 | 0 | 49 | 39e578b6... | /sites/demo-site/Shared%20Documents |
The field that the metadata items are extracted from depends on the source:
| Source | Property |
|---|---|
| Alfresco | source.properties.succinctProperties |
| OpenText | source.properties.categories.<subcategory> |
| Any other source | source.properties |
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
reportPath
Path to save the Excel file containing the report to.
sheetName
Name of the sheet for the report in the Excel file.
Content Type Fields SPO
The accelerator creates an Excel report that captures all content types, including all fields, for each document library. The following columns are provided:
Site URL: Site URL of the document library.Library URL: Library URL of the document library.Content Type: Display name of the content type.Field systemName: System name of a metadata field.Field displayName: Display name of a metadata field.Field type: Type of value used for the metadata field.
For example:
| Site URL | Library URL | Content Type | Field systemName | Field displayName | Field type |
|---|---|---|---|---|---|
| https://company.sharepoint.com/xill4 | https://company.sharepoint.com/xill4/Documents | Folder | FileLeafRef | Name | unknownFutureValue |
| https://company.sharepoint.com/xill4 | https://company.sharepoint.com/xill4/Documents | Folder | Title | Title | text |
| https://company.sharepoint.com/xill4 | https://company.sharepoint.com/xill4/Documents | Document | FolderChildCount | Folder Child Count | lookup |
| https://company.sharepoint.com/xill5 | https://company.sharepoint.com/xill5/Documents | CustomType | Title | Title | text |
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
reportPath
Path to save the Excel file containing the report to.
sheetName
Name of the sheet for the report in the Excel file.
Content Types SPO
The accelerator creates an Excel report that lists the content types configured per library. By default, it provides the following columns:
Site URL: Site URL of the document library.Library URL: Library URL of the document library.Content Type: Display name of the content type.
Settings
mongoConnection
The Mongo connection string including the database name to connect to.
reportPath
Path to the Excel file.
sheetName
Name of the sheet.