What is stored in task_binary_data in Project 2007 Server?

[Chris]

Does anyone know that??

 

[JackD]

The project developers do. But they have not definitively published exactly
what is there.
I do know that it contains a representation of some of the task data as a
back-up to what is in the database.


-Jack Dahlgren

 

[Chris]

The problem is that I want to write a small application that will be able to
create a project with a few tasks. It works ok but when I open that project
in MS Project 2007 and modify something (or add a new task) and save the
project. When I reopen the project in MSP again the last modified tasks are
visible only. all of other tasks just disappear. I found that when a project
is created by my application the task_binary_data column in db is empty.
My application works in the same way as it is shown in Project 2007 SDK.
That is why I am asking about task_binary_data. I wanted to add there
something by simple sql query. but what should be added there?

 

[Rod Gill]

I think the binary blob is actually the live data and the remaining fields
are actually text copies. The reason I think this, is that If you set the
Ext_Edited_flag then project uses the text values to rebuild the binary
blob.

To create Tasks in a Project 2007 database you need to read the pjdb.htm
file for 2007 and follow its instructions to the letter. If you have and
there is still a problem, please report it to Microsoft along with
instructions on how to reproduce the problem,. Project is still in Beta, so
you may have found a bug. You do need to read that pjdb.htm file THOROUGHLY
though!