Non project time

C

Colleen

I just upgraded from Server 2002 to Server 2003. In 2002
I had several tasks setup under the NonProject Time
option under Admin. It appears that this option has
been removed in 2003 and replaced with Administrative
projects. I have two problems resulting from this: 1)
How do I get this time converted over to an
Administrative project? and 2) Once it's converted over
to an admin project how do I remove the tasks from the
everyone's task page?

Any help would be greatly appreciated.
Thanks,
Colleen
 
J

johndellenbagh

Colleen said:
I just upgraded from Server 2002 to Server 2003. In 2002
I had several tasks setup under the NonProject Time
option under Admin. It appears that this option has
been removed in 2003 and replaced with Administrative
projects. I have two problems resulting from this: 1)
How do I get this time converted over to an
Administrative project? and 2) Once it's converted over
to an admin project how do I remove the tasks from the
everyone's task page?

Any help would be greatly appreciated.
Thanks,
Colleen

Colleen,

You will need to create administrative projects for the non project
time you want tracked. To remove the Non Project time, please follow
below.

SYMPTOMS:
==========
Customer migrated from Project Server 2002 to Microsoft Office Project
Server 2003
Go to resource task sheet

Expected:

Only to see tasks associated with project plans

Actual:

See tasks associated with project plans and also see Non Project Time

CAUSE:
=======
The database was migrated from 2002
The 2002 database has Non Project categories
Resources added time to the Non Project categories

RESOLUTION:
===========
delete
from MSP_WEB_NONWORKING
delete
from MSP_WEB_NONWORKING_CATEGORIES
delete
from MSP_WEB_MESSAGES_NONWORKING
delete
from MSP_WEB_WORK
where WASSN_ID in (select WASSN_ID
from MSP_WEB_ASSIGNMENTS
where WNWRK_ID >99)
delete
from MSP_WEB_ASSIGNMENTS
where WNWRK_ID > 99
You can e-mail me at (e-mail address removed) if you have questions
with this.
John
 

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