Schedule backup from project online.

[Richard Lynch]

Is there a way to save program schedules inclusive of master and sub-projects in a project online environment.
The organization I’m working with does not have an automated system or tool-set currently available, so I’m looking at either:
a) running a manual process to save files local or to SharePoint directory
b) utilizing PwrBi to do a full extract of the oData to local/SharePoint.
These 2 option will necessitate diverting weekly time for the 2 schedulers working for me which would otherwise be used for schedule updates/ maintenance and analysis.
To give an understanding of the complexity, I have a master Project with 6 regional sub-projects. The 6 regional schedules are fed collectively from 12 vendor schedules who for commercial reasons dont see each others schedules. All MPP schedules are hosted in our instance of PWA with vendors granted access for only their schedules.
Reporting is carried out through PwrBi and fed from the oData.
Unfortunately we had an instance this week that a file was corrupted by a drag and drop or cut and paste action, and we quickly realised that the IT team don’t have a rollback solution in place.
Any advice or pointers would be great.
Thanks Richard.

[Eric Schyberg]

Hello Richard,
we have accomplished this with a Project VBA Macro.
It’s actually a Macro that runs in the context of Excel – and launches Project for each Project in PWA.

Overall, what it does:
In XL, where the Macro runs:
Load all Projects into an XL Sheet (refresh the list of projects to be backed up)
Loop over the Projects
Save Each Project into the respective Project Sites / Documents Library
Record success or failure.

I have a few clients using this method successfully- typically a technical PM runs the macro once a week.
any failures are just dealt with one by one.

Let me know if a solution like that will work for you.

Thanks,
Eric

[Author]

Posts