Make tasks read-only in Project Web Access for resources

[Thomas Czichowsky]

Hi all,
I'm using Project Server 2002 and am dealing with an issue regarding
unfinished tasks. I don't want resources to update actuals on a task
if the finish date lies a certain period of time in the past. For
example: A task should have been finished 4 months ago but is not yet
finished. In this case it should not be possible for a team member to
assign actual work to this task.
I first thought of filtering the timesheet view but found no
possibility how to do this. It is also not possible to delete these
tasks or assignements since I want to keep this information.
I'm thankful for any ideas on this issue!
Regards Thomas

 

[Dale Howard [MVP]]

Thomas --

This cannot be done in Project Server 2002. Sorry.

 

[Gary L. Chefetz \(MVP\)]

Thomas:

If you know SQL and want to take the time to study the database
documentation that shipped with your server, then you can solve this by
removing the tasks from the users timesheets through a SQL query.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

 

[Thomas Czichowsky]

Gary,
thanks for your help so far. Which table do you think of? Think it must be
one of the MSP_VIEW-Tables but don't know which one exactly?
Regards Thomas

 

[Ludo]

Thomas,

I would suggest you to "play" with the fields "WASSN_REMOVED_BY_RESOURCES"
and "WASSN_DELETED_IN_PROJ" in "MSP_WEB_ASSIGNMENTS" table. Those fields
(flags, 0 or 1) allows to mark assignemnts as read only
(WASSN_DELETED_IN_PROJ = 1) - This one is set to 1 when the assignment is
deleted from MS Project and the plan is published - or hidden in Timesheet
(WASSN_REMOVED_BY_RESOURCES = 1) - This one is used when the user use the
"Hide Task" Function.

A good example of this is what I've developped: the possibillity for the
Project manager to prevent booking on tasks or to hide them directly from the
project plan (using 2 flag fields). This allow the PM to manage on what task
he wants his resources to book time against.

I hope this helps,

 

[Thomas Czichowsky]

Ludo,
thanks you very much for that hint! This seems to work for me, too.
Regards Thomas