Timesheet Questions

[Gary Zag]

We are in the process of upgrading to Project Server 2007 and have the
following questions about timesheets. Currently we do timesheets in MS Excel
for our accounting/payrole system and then enter task updates in PWA.

1. Can you configure userdefined fields in timesheets?

2. When you import tasks into timesheets can it import values from user
defined task, project and resource enterprize fields?

3. Is there examples code or third party applications available to easily
print or extract timesheet data to get it over to some other
accounting/payrole system?

Thanks

 

[Jonathan Sofer]

1) You can only specify userdefined task and assignment fields to be visible
in both My Tasks and My Timesheet Views. My Tasks will pre-populate with
the value set in the project for that custom task field (AT THE ASSIGNMENT
LEVEL) but it is editable and changes to this assignment value will be
reflected in the project update.

2) If there is data in My Tasks for a custom field that data will come over
to My Timesheet as long as you are creating timesheets with tasks and not at
the project level. And in my testing, although the custom field initially
shows as blank, if you click on the field, it will then show the same value
that was in My Tasks for that particular task (this is a bug in my opinion).
I have not tested whether the data is stored as blank or as the initially
hidden value.

3) The only way I know how to do this is to write your own SQL queries to
extract this data from the reporting (recommended) or published (not
recommended) databases. You can use SQL Reporting Services 2005 to generate
nice reports. See examples provded by Microsoft in their report pack by
downloading the SDK for MSPS 2007
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

Hope this helps,

Jonathan Sofer