Hey everyone! I'm pretty new to PowerShell and I have a task that involves exporting project files. Specifically, I need to create a PowerShell script that can export .mpp files (like from Microsoft Project) and map the necessary fields, similar to what the Export Wizard does in Excel. After that, I need to save these exported files to two separate SharePoint Online sites since everything is stored there, and I don't have anything saved on my laptop. I'm getting mixed messages online and from AI about whether this is actually possible. Any insights?
2 Answers
I'm not too familiar with .mpp files, but from what I know, many Microsoft file formats pack their data as zipped archives with XML inside. You might want to extract a couple of .mpp files to see how their data is organized. Then you could use a tool like ImportExcel as suggested by another user.
It sounds like you have a pretty specific task! You mentioned needing to export .mpp files and map fields for export, which is crucial for your script to function properly. Make sure you clearly outline which fields you need to include and how the Export Wizard operates. Also, think about why you want two copies of the file; it might complicate things if you need to update both later.
Yeah, it's good to keep a copy for editing and a client version. Just be cautious about how you manage updates!
Would that work directly with files on SharePoint Online, or would I have to download them first?