External File update for timesheets

[Mark Byington]

I am researching an 'automated' method for updating a small number of EPM
projects/timesheets from an external time sheet - such as an Excel
spreadsheet.

Does someone do this already? Is there a preferred method?

Looking for any guidance or reference documentation.

Thanks.

 

[Ray McCoppin]

Yes you can. You need to look a the PDS methods for timesheets in the PDS
documentation


The timesheet API provides the ability to get assignments from Microsoft®
Office Project Server 2003, edit those assignments, and inform the project
manager of existing edits. This API also provides a programmatic interface to
Project Server assignment data that is independent of the Microsoft Office
Project Professional 2003 client or the Microsoft Office Project Web Access
timesheet tool. Management of assignments can be accomplished by native calls
to the PDS.

The timesheet API does not provide the programmatic ability for the project
manager to approve timesheet transactions after team members have submitted
them. The project manager still needs to log on to Project Web Access to
approve transactions, in order for Project Server to save the updates in the
project plan.

The new Project 2003 add-in for Microsoft Outlook® uses the timesheet API to
communicate with Project Server.

The three timesheet API methods are:

AssignmentsGet (new)
AssignmentsSave (new)
AssignmentsProjectManagerUpdate (new)

 

[Mark Byington]

Thanks! I'll start researching.