Create a new PowerShell Command to use the Export metadata feature
Some users would need to be able to generate the Excel Spreadsheet for their metadata using PowerShell. When automating a complex migration, having an export for all the lists with a foreach loop would be a powerful way to take full control of the data during the migration project.
I know that I can import from a file share with an Excel file using powershell. Is there any way to generate that Excel file using powershell? I don't see a cmdlet for it.
If I generated it manually, what are the minimum required columns?
I am working on this One Drive for Business migration from O365 tenant to 0365 tenant and since i have around 1000 odd users i have chose to user PowerShell as a migration method. In this specific scenario i will be only migratiing one specific folder from each user and i manage to write a script to automate that part. But problem comes when im going to Export Metadata from those one drive accounts. I have read that we can attach Import metadata excel by additional parameter when we use Copy-Content command in powershell but i haven't found any refernece regarding Exporting metadata.
Please help me on this. If you can direct me how to do it in powershell or automate that part without going each and every user manually it will be great. Hope you will get back to me as soon as possible.
[Deleted User] commented
Definitely would suggest this as a feature - it is needed for some integrations we are doing, and currently have to perform this manually as opposed to all the other steps which can be automated through PowerShell
Mike Hatheway commented
This is working. Use the Export-Report PS command.
Andreas S. ADVIS commented
We would need this feature! We are migrationg thousands of SPWebs addressing single Lists. therefore we get several tousands of entries in the Tasks List of SG-UI.
No way to export the results manually to Excel by Clicking hunderts of Pages in the UI....!!
==> So: how can I get the results of all Tasks in a comfortable way
I would really need this to! As Patrick I will need to genereate 500+ files for the business to analyze and set destinations and metadata for Before actually migrating.
I need to generate over 500 Excel spreadsheets and then hand them over to the business to fill out before performing the actual file share migrations into Office 365. Ideally there would be an API for me to call to automate this.
The export to excel feature is available in the “Bulk edit” screen. I’d like to automate this through powershell as in have the powershell script export all the items in a list to excel (meta data of course, not the actual files).