Project Server 2007 reading the Status Date

[MacKenzie Mickelsen]

I am trying to get the status from a project that is in Project Server. I
have opened the project with MS Project 2007 and set the status date. I try
and read the status date by looping through ProjectRow rows collection of the
Project table. Right now I get the value by doing the following

if (project["PROJ_INFO_STATUS_DATE"] is DBNull )
{
info.StatusDate = DateTime.Today;
}
else
{
info.StatusDate = Convert.ToDateTime
(project.PROJ_INFO_STATUS_DATE);
}

However the value of that property/datarow column is always DBNull even
though I know I have set the Status Date and have verified the change. Does
anyone know why I am always getting DBNull? is this the proper method to try
and get at the Status Date? Any help would be greatly appreciated

 

[Andrew Jacks]

G'Day,

First thing you need to do is make sure you are getting the Project
Information from the correct Database. This is selected by setting the
DataStoreEnum to be one of the following:-

PublishedStore
ReportingStore
VersionStore
WorkingStore

If you are using the Published Or Reporting Stores than you need to make
sure that the Project has been published correctly.

Let me know how you get on