What to do with closed projects?

O

OK

My customer asked me what to do with closed projects. Now on the server there are about 1200 projects, but almost 80% of them need to be archived. They are closed.
I have Windows Server 2003/Project Server 2003. I've applied the registry key found in this forum in order to speed up navigation. Now it's faster, but could be better.
I see the problem is a huge number of projects.
If I delete them, we'll lose our data for reporting.
I haven't found yet any procedure explaining what to do in this case.
What is your advice?
Thanks,
Oleg
 
D

Dale Howard [MVP]

OK --

You might try the following approach:

1. Use the EditSite utility to create an additional Project Server instance
called something like "PS Archive"
2. In your production Project Server instance, save each completed project
as an .mpp file temporarily
3. In your production Project Server instance, delete each completed
project
4. Open Microsoft Project Professional and log into your PS Archive
instance
5. Use Tools - Enterprise Options - Import Project to Enterprise and import
each completed project into the project archive

Doing so will maintain all of the project data for historical purposes.
Given the fact that 80% of your client's 1200 projects are closed, this
process will likely take quite a while. Hope this helps.




OK said:
My customer asked me what to do with closed projects. Now on the server
Click to expand...
there are about 1200 projects, but almost 80% of them need to be archived.
They are closed.
I have Windows Server 2003/Project Server 2003. I've applied the registry
Click to expand...
key found in this forum in order to speed up navigation. Now it's faster,
but could be better.
 
O

OK

Dale,
Thanks for your answer.
An additional Project Server instance - it means it will be another web site and SQL DB as for Sample Project Server installation from MS?

I'll try this utility.
Oleg
 
D

Dale Howard [MVP]

OK --

Yes.




OK said:
Dale,
Thanks for your answer.
An additional Project Server instance - it means it will be another web
Click to expand...
site and SQL DB as for Sample Project Server installation from MS?
 
A

Antoon

I have set up an archive like this:
-copied the PS db to PSArchive db
-used EditSite to create a PSArchive web site
-used PSCleaner to remove all projects

Now I try to archive projects, this works fine, but all custom fields are
lost, i.e. the system prompts for the custom fields when I import the locally
saved .mpp file.

Is there a way to accomplish that we don't have to enter all custom fields
when importing?

Thanx,
Antoon
 
A

Antoon

Correction:

custom fields (text, flag, ...) are saved if you choose the right options,
File / Save As ... / Save as File ... / currently loaded global items, but
not the outline codes.
 
G

Gary L. Chefetz \(MVP\)

Antoon:

The only thing that's not saved, as far as I'm aware, are task-level codes.
These need to be copied to local fields first to preserve the data. Resource
and Project-level outline codes and fields should be preserved.

--

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

-
 
Top