Where is the baseline last saved date stored in Project Server 2003?

[Kevin]

We are trying to find where is the baseline last saved date is stored
in Project Server 2003 in order to extract that data to a reporting
database.

We can find the both the PROJ_SAVED and the PROJ_PUB dates in SQL, but
no dates for when the baseline for a Project file was last saved (or
any of the baselines, for that matter).
The 'baseline last saved date' is clearly saved in the Project client
file, because you can view it in the Project client UI:
Tools>Tracking>Set Baseline>Baseline last saved (date)

Can anyone directed us to where that data is stored in Project Server?

Based on our research, we suspect the following:
1. The ‘baseline last saved date’ is not stored in the Project
Server SQL database as a discreet piece of data.
2. It is likely stored in a BLOB (binary file), and thus is not
available for extraction from the SQL database.

Thank you for you help.

-Kevin

 

[Barbara - Austria]

Hi Kevin,

You are right, you can’t find it in the database. I solved that with an
event driven VBA macro filling 11 custom fields on project level
(zzBP00-zzBP10). It looks like this:

Private Sub Project_BeforeSave(ByVal pj As Project)
.....
ActiveProject.ProjectSummaryTask.zzBP00 = ""
ActiveProject.ProjectSummaryTask.zzBP01 = ""
.....

If IsDate(ActiveProject.BaselineSavedDate(pjBaseline)) Then
ActiveProject.ProjectSummaryTask.zzBP00 =
ActiveProject.BaselineSavedDate(pjBaseline)
End If
If IsDate(ActiveProject.BaselineSavedDate(pjBaseline1)) Then
ActiveProject.ProjectSummaryTask.zzBP01 =
ActiveProject.BaselineSavedDate(pjBaseline1)
End If
....
End Sub

Since I did that for PS2007, it may be that accessing project custom fields
in 2003 has to be done in a different way. I am sorry, I can’t remember, it
is too long ago and I have no 2003 installation available any longer. But
perhaps the code will give you an idea how to solve?

Good luck!
Barbara

 

[Kevin]

Hi Kevin,

You are right, you can’t find it in the database. I solved that with an
event driven VBA macro filling 11 custom fields on project level
(zzBP00-zzBP10). It looks like this:

Private Sub Project_BeforeSave(ByVal pj As Project)
....
ActiveProject.ProjectSummaryTask.zzBP00 = ""
ActiveProject.ProjectSummaryTask.zzBP01 = ""
....

 If IsDate(ActiveProject.BaselineSavedDate(pjBaseline)) Then
    ActiveProject.ProjectSummaryTask.zzBP00 =
ActiveProject.BaselineSavedDate(pjBaseline)
 End If
 If IsDate(ActiveProject.BaselineSavedDate(pjBaseline1)) Then
     ActiveProject.ProjectSummaryTask.zzBP01 =
ActiveProject.BaselineSavedDate(pjBaseline1)
 End If
...
End Sub

Since I did that for PS2007, it may be that accessing project custom fields
in 2003 has to be done in a different way. I am sorry, I can’t remember, it
is too long ago and I have no 2003 installation available any longer. But
perhaps the code will give you an idea how to solve?

Good luck!
Barbara










- Show quoted text -

Thank you, Barbara. We'll check that out.
-Kevin