Task Percent Complete (% Complete)

[am_yousef]

I have a web application developed by "Visual Studio.NET 2003".
I am using "Microsoft Project Server 2003", and "Microsoft Office Project
2003"

Using my web application i will change the Task Percentage Complete in a
certain task in a project.
This could be done by changing the ("TaskPercentComplete" field in the table
called "MSP_VIEW_PROJ_TASKS_STD") in the Project Server DB.

After changing the (task percent complete) in the "Project Server DB"
through my application,
I open the Project Web Access (PWA),
click on the "Projects" link,
choose a certain project,
choose the "Tasks Summary" view,
Then i can see this change in the column called ("% Complete") for this
project.

But i can not see this change when i open this Project Plan through the
"Microsoft Office Project 2003".

So what i need,
Is that when i change the (Task Percent Complete) for a certain Project in
"the Project Server DB" through my .NET Application,
This change affects the "Task Percent Complete" (% complete) when i open
this Project Plan through the "Microsoft Office Project 2003".

Any help would be appreciated.

 

[Rod Gill]

All MSP_View tables are read only. No changes to them ever go back to PWA or
the Project data. To update directly you need to update the MSP_Tasks table.
Read the pjdb.htm file (in one of Project's program folders or the CD) and
follow its instructions exactly. Failure to do so may lead to project
corruption. Your revised schedule needs to be opened in Project Professional
and published before changes will be seen in PWA.

You can update using PDS extensions, but that is a steep learning curve and
PDS has been removed for 2007 and replaced by PSI which is different, so PDS
is not worth the investment in time now.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com