There is a requirement to migrate a large number of documents in a document library, but some documents need to be excluded according to the value of a custom column.
Instead of using the built-in filter capabilities of Content Matrix that is a bit cumbersome, a custom transformer script may be used.
Note: Make sure to enable the Advanced Mode on the Settings tab of the Content Matrix Console to see all the job configuration options.
#Make sure it's not a folder if($dataObject["FSObjType"] -eq "0") { #if column "To Migrate" equals "No" then skip it if($dataObject["To_x0020_Migrate"] -eq "No") { $dataObject = $null } }Note: Specify the Internal Name of the custom column and not the Display Name. For example, the column's Display Name is "To Migrate", but the Internal Name is "To_x0020_Migrate", which is generated by SharePoint automatically
DISCLAIMER
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center