Data transferred using Microsoft Project/Microsoft Project Server

This topic provides details on the data transferred between DOVICO Timesheet and Microsoft Project/Project Server when specific actions are performed using the Microsoft Project or Microsoft Project Server Link.

This topic assumes the reader has working knowledge of Microsoft Project and DOVICO Timesheet's Microsoft Project/Project Server Link.

Add/Get Resources

Clicking the Add/Get Resources button transfers all employees from the Microsoft Project/Project Server Resource pool to the DOVICO Timesheet database. If Get Resources is selected a second time, only new and modified employees are synchronized back to DOVICO Timesheet. After its initial use, the Add/Get Resources button only needs to be used when modifications or additions are made to the Microsoft Project/Project Server resource pool.

The employee first and last names and email addresses are transferred from Microsoft Project to DOVICO Timesheet. Employee properties are editable in DOVICO Timesheet except for the employee's First and Last name.

Add Projects

Clicking the Add Project button transfers the selected project, its tasks and resource assignment details from Microsoft Project/Project Server to DOVICO Timesheet. The Add Project button is only required when a new project is sent from Microsoft Project/Project Server to DOVICO Timesheet.

• The project is added to the DOVICO Timesheet database and its properties are editable using DOVICO Timesheet.

• Tasks are not added to the DOVICO Timesheet's Tasks view but are displayed in the Project Assignments view, Budgeted Time & Costs view and to employees entering time.

• Task assignment information transferred is limited to the resources (employees) assigned to the tasks, the tasks' scheduled Start and Finish dates, the estimated hours and the task assignments' WBS codes. The assignments are displayed in the Project Assignments view, and the task assignment details can be viewed using the Budgeted Time & Costs view. The task assignments budget information cannot be edited using DOVICO Timesheet (Estimated hours, Adjusted hours, Start and Finish dates and WBS codes).
   

Get Assignments

Clicking the Get Assignments button updates the task assignments information from Microsoft Project/Project Server to DOVICO Timesheet. That is; resources assigned to the tasks, new tasks (if any), task scheduled Start and Finish dates, estimated hours and WBS codes. This function should be used after modifications are made to the Microsoft Project/Project Server plan file.

Send Time

Clicking the Send Time button sends approved time from DOVICO Timesheet to Microsoft Project/Project Server.

• Approved time is sent as new (or additional) hours per assignment and appears as Actual Work in Microsoft Project/Project Server.

• If selected, ETC values (in hours) are transferred from DOVICO Timesheet to Microsoft Project/Project Server. These appear as Remaining Work in Microsoft Project/Project Server.

• If selected, the project status date is transferred from DOVICO Timesheet to Microsoft Project/Project Server.

Synchronize All

Clicking the Synchronize All button will perform the functions, described above, in the following order: Get Resources, Get Assignments and Send Time.