Field value lost after Project save

[Nach]

Hi...I'm back with my Baseline10 cost problem. To breifly describe it...
I am copying the value of Cost to Baseline10 in the database for all
projects and want to see it in PWA. I did experiment copying the values to
the particular fiels in MSP_WORKGROUP table..it does show up in the web...but
the problem is everytime somebody opens their project and saves it..I lose
the values in Baseline10Cost..and it becomes blank. Unless the field exists
in the Project while opening it in Professional...i lose the values on
Project save. I don't know how to have them unchanged...any ideas..?

Thanks
Nach

 

[Rod Gill]

The only way to safely save data so PWA can see it in PS 2003 and 2007 is to
use automation to save and publish the project from Project Professional.
Microsoft do not support directly changing the db and often some data is
saved in binary blobs where you can't get at it at all so yes saving or
publishing the project from Project pro will overwrite any changes you make.

In PS 2007 you can use PSI to program this.

--

Rod Gill
Project MVP

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

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Nach]

Hello:

Yes I know that it's not recommended to do any changes to the DB
externally..but I had to do this change for all projects without making the
users go through it and waste their time. But the good news is I finally have
the solution. While going through projdb.html I read that one should set the
parameter PROJ_EXT_EDITED to 1 if they edited something in the DB...I knew
that before too..but didnt know how to/when to set it. So I was just playing
with it..and it worked. Two steps

1. Edit the MSP_BASELINES table or any other table as per your requirement
2. Set the PROJ_EXT_EDITED = 1 in MSP_PROJECTS

After that whenever someone opens the project and saves it in
Professional..the edited data in the DB reflects on the web.

Thansk
Nach