PS2003 and Enterprise Calendars

[Paul Miller]

Our company use a package for managing absence requests, holiday, sickness etc.

When the project team request holiday, they have to do so in our absence
package, then inform the PS2003 administrator who changes the necessary
calendar to be a non-working time for the relevant period. This is open to
the obvious human errors which occur frequently.

Using an administrative project works well for time-sheet logging, but not
very well for forward planning, levelling etc.

I would like to take the data from the absence system and automatically
update the SQL tables behind PS2003 to remove the manual process. Does anyone
have any details on how to do this as I cannot see how this information is
held within the project server database.

Thanks

 

[Diaa Hussein - I would be glad to help]

Our company use a package for managing absence requests, holiday, sickness etc.

When the project team request holiday, they have to do so in our absence
package, then inform the PS2003 administrator who changes the necessary
calendar to be a non-working time for the relevant period. This is open to
the obvious human errors which occur frequently.

Using an administrative project works well for time-sheet logging, but not
very well for forward planning, levelling etc.

I would like to take the data from the absence system and automatically
update the SQL tables behind PS2003 to remove the manual process. Does anyone
have any details on how to do this as I cannot see how this information is
held within the project server database.

Thanks

Dear Paul
Mainly your work will be on 2 tables on the SQL Database
MSP_CALENDARS to identify the resource calender based on the RES_UID
MSP_CALENDAR_DATA to change the working time of this resource by this
field CD_DAY_OR_EXCEPTION and CD_WORKING
for more information please refer to the project server Database
sturcure manual which can be found on the installation cd of the
project server under the name of Projdb.htm

i hope this information is helpful for you
incase you need more assitance please feel free to contact me

 

[Paul Miller]

Diaa,

Many thanks for that. I have been trying to identify the entries in the
MSP_CALENDAR_DATA table by using simple experiments like setting me to
non-working on a specific day. However, I cannot seem to find the entries in
the table. Every change I make does not seem to alter the number of records
in the table which seems to stay at a constant 9043 rows.

What am I missing????

 

[Gary L. Chefetz [MVP]]

Paul:

In 2003, you cannot do this in the data tables. You must automate this using
the Project Object model in WINPROJ as the data is stored in binary. We
developed a tool for 2003 that allows resources to self-service their
non-working time requests with the option to have an approver in the loop.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com