Hide Projects from Project 2003

[Trevor]

Our company works with 100's of projects a year and the list is getting very
large now. We cannot delete Projects since our accounting system is tied to
Project Server.

Is there any field in SQL that allows you to hide a Project so it does not
appear in Project 2003? File > Open

We have filtering enabled, but the user must do this everytime they go into
Project 2003.
Thx

 

[Dale Howard [MVP]]

Trevor --

Refer to the following FAQ for information how to archive completed projects
in the production Project Server database so they do not display in either
the Project Center page in PWA or in the Open dialog in Microsoft Project
Professional:

http://www.projectserverexperts.com/Shared Documents/ArchiveCompletedProjects.htm

Hope this helps.

 

[Andy]

Hi Dale,

Thanks for your infomation below, it's helped my successfully test the
archive most of our projects from timesheeting and other project views. The
one area I'm having difficulty is hiding / archiving timesheet tasks for
staff from a administrative schedule.

I've followed all the steps on the guide (including changing booking to
proposed for all resources) redone and rechecked that I've got them correct
and also try to publish the tasks again (new and changed assignments). I did
notice that when I made a change at one stage that I got the spooler error
"manager can't create a resource account" for that particular schedule, but
all information in PWA and MPP as per the guide appears correct. Is there
anything you can help me with here and is there any other information I can
provide to help you help me resolve it? Thanks in advance,
Andy

 

[Dale Howard [MVP]]

Andy --

I have not tested our methodology with the default Administrative project
feature of Project Server, but I do not believe our method will work.
Project Server has restrictions that force administrative project tasks to
show on each team member's timesheet no matter what. This is one of the
many reasons why we simply don't recommend using the default Administrative
project feature. Instead, we recommend using a regular project that
simulates an Administrative project. If you use our approach, then our
archiving methodology would work correctly for you.

If your administrative project is actually finished, I would recommend that
you save it as an .mpp file for historical tracking purposes and then delete
it from the Project Server database. This will remove those tasks from each
user's timesheet in PWA.

Regarding your Spooler error, refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/CannotCreateAccount.htm

Hope this helps.

 

[PWA Administrator]

We used the same document form msProjectExperts (by the way thanks for your
contributions to our cause!!).

We were able to hide projects from the grade scheme of things (e.g. views)
such that only folks given special group permissions could view them. In this
way, we kept the closed projects on the server so staff could do reviews of
past projects.

Unfortunately, timesheet tasks for those proejcts still show for the users.
While yes....they can hide each task on their timesheet for now 'done and
closed' project taskings, this is a pain.

The best solution we use is to go to Admin screen, Clean database. We go and
delete all COMPLETED tasks for each individual assigned on the project that
has now been closed. This of course, requires a business process whereby the
PM tells the PWA administrator that the project is closed.

The somewhat brute side effect is that all COMPLETED tasks of that named
person across all projects is then removed from site. While this is not
destructive at all to acutals or the specific project plan itself, it does
prevent thereafter...the team member looking at any task s/he completed in a
project, even if still otherwise active.

The only other resource....is as mentioned, remove the project through a
"closing procedure" whereby a mpp file along with WSS documents are zipped up
and put on a web site. Ths process unfortunately removes your ability to look
across a year's projects for costing, estimations, etc.

 

[Gaurav Wason]

Trevor,

If you have access to database I can send you code to flip the flag that can
hide the project. Let me know. We have been using the code for almost 2 years
and it works like a charm. It is the code used by hide button in task
timesheet.
--
Gaurav Wason
(e-mail address removed)
MCP - Project Server
http://projectmadeeasy.com

 

[Dale Howard [MVP]]

PWA Administrator --

The manager of the closed project must set each team member's Booking type
to Proposed and then republish the project. This is clearly detailed in the
FAQ. Doing so will remove the tasks for the closed project from each team
member's timesheet. Hope this helps.

 

[PWA Administrator]

Sure will. I'll contact my tech manager. Somehow, we overlooked the step that
required this to be so set. Thanks!

 

[PWA Administrator]

I'd enjoy having the code...

 

[Gaurav Wason]

Update MSP_WEB_Assignments
Set WASSN_Removed_By_Resource = 1
Where WPROJ_ID in
(Select wproj_id from msp_web_projects where proj_name like
'EnterProjectNameHere')

Just enter the project name without .published and you should be able to
hide the project from timesheet.

Note: if you re-publish the project tasks will show again for the project.



--
Gaurav Wason
(e-mail address removed)
MCP - Project Server
http://projectmadeeasy.com

 

[Annette]

Hello all - I have followed the procedures you've outlined - as far as
changing the resource to "proposed" and then republishing, but individual
tasks are still showing on resources timesheets. Any thoughts?

 

[Mark Everett | PMP]

Annette -

Where I see the process not work is on tasks from the project that were
deleted with remaining work, or for other tasks that have remaining
work.

Since there is a "bug" with tasks that zero hour assignments, that
could cause an issue also.

Mark Everett

 

[Annette]

Mark - I knew about that bug and have made sure that the remaining hours is
set to zero. Any other ideas?

thanks
Annette

 

[Dee]

Hello All, I too am seeing the same problem with some of our projects.
Even though we've set resources to proposed and published the project,
the tasks still appear in the resource's timesheet. Any hint on what we
could be doing wrong will be greatly appreciated.

Thanks,
Deepa