Project 2007 Server - Editing Multiple Projects at Once

[evoka]

Is there a way to edit multiple projects in Project 2007 server under
project center, all at once? I have 20-30 projects from different team
members and it has been painful to check each one out, one at a time.
Is there a way to do this all at once and upload all the projects back
into the system in one check in/out? I was able to check out all of
them at once but the check back in creates one project and makes each
project a subproject. Is there a way to check it back in and keep
each as its own project just as they were before?

 

[Jonathan Sofer [MVP]]

What kind of updates are you trying to make? Scheduling updates or simple
mass changes to project level information?

If it is the latter, you could create a macro that opens each project, edits
the project custom field or out of the box field data, saves, publishes and
then closes it based on an excel list for example.

Otherwise, you could keep an offline master project and have all your
projects inserted into the master in R/W mode. You could then open this mpp
master to make edits to your schedules. When you close your mpp master it
will ask you whether you want to save each project in the master an you can
select "yes to all". The problem is that this does not publish the data for
you. In order to do that you will have to use another tool that does
publishing in a batch fashion.

Jonathan

 

[evoka]

I am only making deadline time changes, resource changes, and adding
new tasks to each project if necessary.

What tool could I use to publish the data in a batch?

Alex

 

[Jonathan Sofer [MVP]]

There are several tools out there that you can purchase to publish schedules
in batches. Do a search for "project server 2007 publish utility"

Or you can quite easily write a small VB macro that reads project names from
an excel spreadsheet one at a time and opens the schedule, re-calculates it,
publishes it, and then closes and checks the project back in.

Jonathan