Time lost in PWA

[Doug]

I recently made a change to some hours within a project plan and
republished it using the "Overwrite Actual Work" option to push the
changes down to PWA. I didn't realize that there was pending time
submitted by resources against the project that had not been approved,
and now this time is gone out of PWA. Is there a way to get this time
back? Is this submitted but not approved time stored anywhere in a
database table that we perhaps backup? Other ideas? Thanks!! -Doug

 

[James Fraser]

I recently made a change to some hours within a project plan and
republished it using the "Overwrite Actual Work" option to push the
changes down to PWA. I didn't realize that there was pending time
submitted by resources against the project that had not been approved,
and now this time is gone out of PWA. Is there a way to get this time
back? Is this submitted but not approved time stored anywhere in a
database table that we perhaps backup? Other ideas? Thanks!! -Doug

Sounds like your talking about Project Server 2003.
If this is the case, the time is stored in the MSP_WEB_WORK table.

Using this table isn't trivial, as the entries can be compressed if
consecutive days have the same amount of time entered. Also, assigned
time that isn't entered by the resources is stored in this table as
well. It might be a bit of a development effort to get this back.
(Admin effort to restore database to a duplicate before data was over
written, ~1 hour, getting the right data from the MSP_WEB_WORK table
~4 to 8 hours, Re-entering that data into project plan: depends on
project size.) I'd bet the effort to go through this is less than the
resource effort to re-enter the time in PWA, unless it's more than a
couple weeks of data.


Good luck...
James Fraser

 

[James Fraser]

(Admin effort to restore database to a duplicate before data was over
written, ~1 hour, getting the right data from the MSP_WEB_WORK table
~4 to 8 hours, Re-entering that data into project plan: depends on
project size.) I'd bet the effort to go through this is less than the
resource effort to re-enter the time in PWA, unless it's more than a
couple weeks of data.

Meant to say that the effort to complete this is _more_ than asking
resources to reenter data.


James Fraser