Extract Weekly Time From Project Server

[JDC_Consulting]

Assuming someone out there has done this.....

Is there a good way to extract ALL time for multiple resources for a given
period of time (e.g., a week). The extract needs to link the resource, task,
hours and cost. In essences it would be like exporting the timesheet grid
for every resource (approx 100). Need to send the data to a non-Microsoft
time reporting system. Any format (Excel, XML, comma delimited, etc.) would
be ok as long as we can get the correct data.

Also need to create some reports from Project Serer in the same vein....
- Personnel not reporting time in a given week
- Time reported less than 40 hours
- Time reported > 60 hours

Thanks in advance for any help.

Jeff Crawford

 

[Jan De Messemaeker]

Hi,

Done it several times, yes, in VBA directly on open projects.
The method that is key is Timescaledata.

HTH

 

[Rod Gill]

If you use Project Server, look at the MSP_VIEW tables, the ones with _TP in
are time phased data on a daily basis. Very useful for your sort of queries.

 

[JDC_Consulting]

Rod and Jan -

Thanks for your insight. I dumped a small project in XML format and can see
the daily time in the timephased data records. Was hoping that there might
be a solution that required less technical development. However, if that's
what it takes...

Jeff

 

[Vadim Bogdanov]

Hi Jeff,

I suspect that you may use OLAP reporting in PWA for this. Do you have
project server installed?

Regards,
Vadim