As a digital workplace manager I need to be able to migrate 200,000 files (300gb) of data from a file share to multiple different team sharepoint sites. To do this I first need to export the metadata for that file share as a master list of content that needs moving. I then need to match that to the business rules I've agreed with the content owners e.g. files with last accessed dates older than 2 years will be archived. I then need to use the mapping file the content owners have given me to build an EXCEL formula that indicates where each file / folder will go: to the archive OR to one of the X number of team sharepoint sites. Because that process takes days or weeks I then need to export the metadata just prior to migration (to pick up any new files or changes, run business and mapping rules, split the spreadsheet into one per destination site, then do the actual import using the spreadsheets.
Without the ability to create the spreadsheet using powershell large file migrations are very staff time intensive.
If it were possible to export the correctly formatted ShareGate metadata file then massive file share moves would be much more achievable, and your customers would be happier