How to get data out of Project Server database?

H

hapi

Hi,

I have a customer whose employees enter their actual hours into project
server. I want to get the hours out of project server. What would be the best
way to do it: reading directly from the database or using PDS or something
else?
 
P

Paul Conroy

Using the PDS is the recommended approach as the project server data is not
stored in a normalised format within the database.

P
 
R

Rod Gill

PDS is good, but not supported in Project 2007 so I never use it. For actual
hours, try reading from the MSP_VIEW tables. Some of them have a record for
each day. Try MSP_VIEW_PROJ_TASK_TP_BY_DAY and MSP_VIEW_RES_TP_BY_DAY and
MSP_VIEW_PROJ_ASSN_TP_BY_DAY

See PJSVRDB.HTM in one of Project's program folders for details of all
tables and fields. The VIEW tables are updated after each project is
published.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com
 
Top