M
Michal Pleban
Hello!
I need to write an application which interfaces with Project Server.
That is, it should be able to read data about projects as well as update
them.
As for reading I did it faily easy. I found the documentation on Project
Server SQL database structure, and I can extract all the needed
information from the MSP_VIEW_* tables.
Updating data, however, is a problem. When I simply modify a field in a
database (say, update the "Percent Work Complete" field for a given
task), other fields (such as earned value) don't get updated. I would
have to recalculate everyting in the same way as Project does, which
would be very painful and error-prone. I don't want to do this.
So I would like to ask if there is any other method of interfacing with
Project Server? Such that I would be able to instruct Project "change
this task's percent of work complete to 75%" and everything would update
accordingly. Ideally, the method shouldn't require running Project
Professional and connecting to the server, it would be best done only on
the server itself. Some ActiveX scripting, or the like.
Thanks in advance,
Michau.
I need to write an application which interfaces with Project Server.
That is, it should be able to read data about projects as well as update
them.
As for reading I did it faily easy. I found the documentation on Project
Server SQL database structure, and I can extract all the needed
information from the MSP_VIEW_* tables.
Updating data, however, is a problem. When I simply modify a field in a
database (say, update the "Percent Work Complete" field for a given
task), other fields (such as earned value) don't get updated. I would
have to recalculate everyting in the same way as Project does, which
would be very painful and error-prone. I don't want to do this.
So I would like to ask if there is any other method of interfacing with
Project Server? Such that I would be able to instruct Project "change
this task's percent of work complete to 75%" and everything would update
accordingly. Ideally, the method shouldn't require running Project
Professional and connecting to the server, it would be best done only on
the server itself. Some ActiveX scripting, or the like.
Thanks in advance,
Michau.