Creating Task Notes

[Richard]

Hi,

I am exchanging task-level data between a custom
scheduling application and Project Server 2003. Most of
the task information is coming across OK, but not the
task notes.

In the MSP_TASKS table, I am setting the TASK_HAS_NOTES
flag to 1, and storing the note text in the
MSP_TEXT_FIELDS table. I have also remembered to set the
PROJ_EXT_EDITED_TEXT flag in the MSP_PROJECTS table to
say that the project data has been externally modified.

However, when I open up the project in Project Pro 2003,
the note is not visible.

I know that there is an TASK_RTF_NOTES column on the
MSP_TASKS table and that it is of the Image data type.
Should I also be editing this column as well? If so, do I
also have to set the EXT_EDIT_REF_DATA flag?

Regards,

Richard

 

[Ed Morrison]

Task notes is stored in a binary type field (TASK_RTF_NOTES) so it is
difficult to update directly in the database. Microsoft does not even try
it in the PDS. Try using the Project object.

 

[Vadim Bogdanov]

Hi Richard,

I remember that our developers have solved the same issue.

If you still need this - I can send you the code snippets in private email
([email protected]).

Regards,
Vadim