Save and Publish Tables

[rnoel]

Can you indicate how the save and publish within MS Project 2007 EPM
solution works.

Does saving a project, save it to a different table in sql compared to
publishing the same project?

Regards

 

[Jonathan Sofer]

2007 has a separate database for published data as apposed to the saved
(draft) data.

A publish will move the data from the Draft db to the Published db. Also,
it will move data from the Published db to the Reporting db as a separate
queue job.

Jonathan

 

[rnoel]

So if I wanted to bring in actuals from another database, so that it is
reflected in MS Project Professional 2007 and Project Web Access, which table
do I use?

Do I bring in the actuals in the draft tables and then publish it. My
programmers are tell me that the draft table does not have the same fields as
the published tables

Regards
R.Noel

 

[rnoel]

So if I wanted to bring in actuals from another database, so that it is
reflected in MS Project Professional 2007 and Project Web Access, which table
do I use?

Do I bring in the actuals in the draft tables and then publish it. My
programmers are tell me that the draft table does not have the same fields as
the published tables

Regards
R.Noel

 

[Jonathan Sofer]

Bringing in the actuals directly into the database is a very tricky task and
I would not recommend doing it directly in the database. I would try and
use the PSI methods to accomplish this.

Jonathan

 

[CTA]

Hello R.Noel,

I would strongly recommend NOT doing this directly. Edits made
directly on the store are extremely dangerous and can possibly leave
your Project data corrupt. The PSI web services are the only
supported programming interfaces for interacting with Project server
where updates are required. Project 2007 implements server-side
scheduling so the introduction of actual data into the store by way of
direct updates circumvents the scheduling engine--Project has no way
of knowing that updates where made so a subsequent save of your
project will overwrite the updates made directly on the tables.

The Statusing web service should be used to update actuals. Th

Here is some info:

http://msdn2.microsoft.com/en-us/library/bb428819.aspx
http://msdn2.microsoft.com/en-us/library/websvcstatusing.aspx
http://blogs.msdn.com/brismith/archive/2007/02/02/adding-timephased-actual-work-through-the-psi.aspx

Hope this helps!

Colby Africa
http://colbyafrica.blogspot.com

 

[rnoel]

Ok
Can you forward any documentation on the use of the PSI method?

Thanks
R.Noel

 

[CTA]

Are your developers familiar with the Project 2007 platform? The 2007
release introduces a host of new techniques and the documentation is
ever evolving. The UpdateStatus method of the
Statusing web service is conceptually straightforward, but the XML you
need to feed it is complicated. There is a tool in the SDK that can
help.

Check out this link:

http://msdn2.microsoft.com/en-us/library/bb428819.aspx

Access the SDK here:

http://msdn2.microsoft.com/en-us/library/ms512767.aspx

Download it (complete with samples and tools) here:

http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

I haven't done any work with the UpdateStatus method myself, but I saw
this post and wanted to warn you away from accessing the tables
directly for updates--this is a BIG no-no these days.

Let me know if I can help further.

Colby
http://colbyafrica.blogspot.com