Hey everyone, I'm pretty new to PowerShell, and I've been given a task to write a script that exports project files stored on SharePoint Online. I want to map specific fields that I need, similar to what the Export Wizard in Excel does, and then save the generated Excel files to two different SharePoint sites. Just to clarify, everything is on SharePoint; I don't have any of these files on my local laptop. I've seen different opinions online, so I'm wondering if this is actually possible?
2 Answers
It sounds like you're on the right track, but it's crucial to specify what exactly you mean by 'project files.' Since you mentioned .MPP, I'm assuming you're referring to MS Project files. You need to clarify which fields you want to export into the .XLSX file. The Export Wizard allows you to select these columns during the export process. Also, be mindful of why you're saving two versions of the same file—it's good to have a set for editing and one for the customer to view only! Good luck with your script!
I’m not familiar with .mpp files either, but generally, Microsoft file formats are often zipped archives containing XML data. A useful approach would be to unzip a couple of .mpp files to see how the data is structured. After that, you could utilize the ImportExcel module that’s been mentioned in discussions. Just be aware, you’ll likely need to download the files locally first if you want to explore them that way.
Related Questions
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically
[Centos] Delete All Files And Folders That Contain a String