Timesheet Tasks & My Tasks Weekly View

K

Kaisera

Hi,
We are working with MS-Project Server 2007 - full resoiurce management.
I have 2 problems need to be clarified:
1. When we add an additional resource to an existing task, save & publish
the project, he does not see it in My Tasks / Timesheet views & not able to
add it's line to the timesheets. On the oposite, if a new task is created for
that matter, all goes ok at all places. Why is that? Is there any solution or
workaround?
2. We configured the My Tasks view to display a full week period break into
days (thanks to SP1 as i know). The problem is that each week, the view seems
to show which days it chooses instead of Sunday-to-Saturday week (for
example: it some times show Thursday-to-Wednesday week). Can it be configured?
Thanks,
Yaara.
 
R

Rod Gill

Re point 1, if you add a new resource that already has % complete>0 then
there is still a bug (after SP1) that causes a corrupt assignment. The
symptoms are that the resource cannot access My Tasks.

The following SQL will highlight which assignment is corrupted:

SELECT MSP_PROJECTS.PROJ_NAME, MSP_ASSIGNMENTS_SAVED.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS_SAVED.ASSN_UID,

MSP_ASSIGNMENTS_SAVED.PROJ_UID,
MSP_ASSIGNMENTS_SAVED.TASK_UID, MSP_ASSIGNMENTS_SAVED.RES_UID

FROM MSP_ASSIGNMENTS_SAVED INNER JOIN

MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
MSP_PROJECTS.PROJ_UID INNER JOIN

MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
MSP_RESOURCES.RES_UID

WHERE (NOT EXISTS

(SELECT TASK_UID

FROM MSP_TASKS_SAVED

WHERE (TASK_UID =
MSP_ASSIGNMENTS_SAVED.TASK_UID)))

--Run against Published Database


As far as I'm aware the only work around is not to add a new assignment to a
partially completed task. Instead create a copy of the task and assign the
new resource to it. A pain I know!

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx
 
D

Dale Howard [MVP]

Yaara --

Rod Gill answered your first question. Allow me to answer the second.
Apparently what you are seeing in the My Tasks display is a bug in SP1.
Unfortunately, this bug renders this cool new feature totally useless. My
advice is to set the display back to the default Progress column and teach
team members how to click in the Progress cell to see a floating timesheet
grid and to enter Actual Work there. Hope this helps.
 
B

Bilal

Dear Rod

I would like to refere to this great solution in my blog, please let me if
you are ok for this and please let me know how do you like me to refer to you
:)

--

Best Regards

Bilal Okour
blog : http://ebilal.spaces.live.com
 
B

Barbara

Hi Rod,

thanks for that solution!

Do you know if that bug is corrected by SP1 Hot Fix Rollup?

By the way: Next to copying the task for additional resources, team members
can also self assign to that task. PM needs to change work and duration
within ProjProf, but at least there is no error when opening My tasks.

Barbara
 
S

Stephen C. Sanderlin

As far as the Post-SP1 Hotfix rollup, I don't see it in the KB articles:
http://support.microsoft.com/kb/941426
http://support.microsoft.com/kb/941657

Therefore, I would strongly recommend contacting PSS with this question
to get a definitive answer.

--
Stephen C. Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

Principal Consultant - BT INS
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top