none
Delete all AssignmentActualWork for projects RRS feed

  • Question

  • Hi everybody!

    I've a console application that reads data from SQL Database and creates projects in Project Server. I record the AssignmentActualWork using the SubmitStatusForResource function.

    It seems due to some errors in the proccess, the time registered in Project Server is higher that the time that I have in the database.

    Is there any way to delete all the AssignmentActualWork for all the projects in Project Server?

    Regards.

    LyE

    Thursday, October 4, 2012 3:58 PM

Answers

  • Hi,

    I finally founda solution...

    I make a process that reads all existing tasks in all projects and updates the TASK_ACT_WORK to 0 when there is a summary task.

    Thanks.

    • Marked as answer by LyE- Friday, October 5, 2012 11:09 AM
    Friday, October 5, 2012 11:09 AM

All replies

  • Hi there,

    Could I update to 0 the ASSN_ACT_WORK field in MSP_ASSIGNMENTS table in the Project Server Published database or is it necessary to do something else?

    Thanks

    LyE


    • Edited by LyE- Friday, October 5, 2012 9:05 AM
    Friday, October 5, 2012 8:58 AM
  • Hi,

    I finally founda solution...

    I make a process that reads all existing tasks in all projects and updates the TASK_ACT_WORK to 0 when there is a summary task.

    Thanks.

    • Marked as answer by LyE- Friday, October 5, 2012 11:09 AM
    Friday, October 5, 2012 11:09 AM