Publishing Multiple Projects

[Abi]

Hi,

Sorry if this has already been posted before but I cannot find it anymore.

I would like to ask if anyone has already found a way to update/publish
multiple project plans simultaneously? any tips? or a third party tool that
does this?

We have about 500 active projects in the project server and when a new
enterprise field is requested by one department to be added to the Enterprise
Global Template (for tracking their projects), we are required to update the
new field of all projects --- old and new.

Surely, this can be done using an SQL Script BUT I am not sure which tables
to touch and it would be too risky doing that.

Months ago, I could update the enterprise fields of multiple projects by
going to the Project Center, selecting the projects I want to update and
clicking the open button then MS Project Pro opens each project then I can
just display the field and update. However, recently, when I try to do that,
the fields are not updating anymore.

Anyone out there who has the answer to my Project Server dilemma?

By the way, we're using Project Server 2003 SP2a and Project Pro 2003 SP2.

Thanks

 

[Paul Conroy]

I would strongly discourage anyone trying to perform updates directly to the
database.

You should be looking to perform these tasks programmatically via the PDS.
The Project Server SDK is a good starting point.

 

[Rod Gill]

I would write a simple VBA macro to read the name of all projects in Project
Server directly from the MSP_VIEW tables then open each project in turn into
Project professional then Publish.

This would take around 10 seconds a file depending on PC, server and network
speed but you would be able to run the macro then leave it to look after
itself whilst you took a break.

 

[Abi]

Hi Paul,

Thanks for replying.

So you are saying there is no third party tools or there is NO OTHER WAY to
do this EXCEPT to create my own program via PDS -- which of course MUST be
done in a Test server environment.

anyway...anyone else who has this dilemma? is there an easier solution that
can be done in a week?