none
Rescheduling Unfinished Work RRS feed

  • Question

  • Is there a way to automate (powershell, VBA, etc) the updating of a project status?  Our project managers enter 'projects' that are more accurately described as 'task lists' - but since the work doesn't have a firm schedule, the schedule slips and the work does not get rescheduled.  However, the PMO office wants a view of the demand on the resource and would like to automate project updates.  Is this possible in Project Online?  
    Tuesday, October 2, 2018 7:03 PM

Answers

  • Hello,

    Are you talking about for each project, automating this option found in Project Desktop: Project > Update Project > Reschedule uncompleted work to start after ? If so, personally I think this should be the Project Owner who does this so that they can check the schedule and have control over it, after all they are responsible for the schedule so should be keeping it up to date. Not sure I would want this automated on a project I was managing! Anyway, if you did want to automate this I think you will need to look at the Project client object model, there isnt a server side API to do this. In the Project object model this method should help: https://docs.microsoft.com/en-gb/office/vba/api/project.application.updateproject

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, October 9, 2018 6:08 PM
    Moderator

All replies

  • Hello,

    Are you talking about for each project, automating this option found in Project Desktop: Project > Update Project > Reschedule uncompleted work to start after ? If so, personally I think this should be the Project Owner who does this so that they can check the schedule and have control over it, after all they are responsible for the schedule so should be keeping it up to date. Not sure I would want this automated on a project I was managing! Anyway, if you did want to automate this I think you will need to look at the Project client object model, there isnt a server side API to do this. In the Project object model this method should help: https://docs.microsoft.com/en-gb/office/vba/api/project.application.updateproject

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, October 9, 2018 6:08 PM
    Moderator
  • As the previous answer it's possible (or even easy manually), but updating the schedule is probably one of the things you shouldn't be automating. Manually updating it should really be a very central part of the weekly/fortnightly/monthly PM cycle.

    It feels like you're missing a process somewhere...

    Wednesday, October 10, 2018 10:35 AM