Recommended Practices and Additional Notes
32
rate selected, will be transferred to Microsoft Project. For example, if 5 hours are entered against Task 1
using the Project Manager rate and 3 hours are entered against Task 1 using the Administration
rate, 8 hours will be transferred to Microsoft Project for Task 1.
Troubleshooting Issues involving the Integration Manager
If you encounter any of the issues listed below while using the Integration Manager, use the troubleshooting
information given below each heading to resolve the issue. If any of these issues persist, contact Replicon
Support. For information on how to do this, refer to Contacting Support on page 6.
Deleted Task Still Exists in Web TimeSheet after Update
If you have deleted a task in Microsoft Project and the corresponding task has not been deleted in Web
TimeSheet after an update, verify that the task is not selected on any users timesheets. If the task has been
selected on a users timesheet, Web TimeSheet prevents the task from being deleted, even if no time has
been entered against it. Have the user select another task or delete the timesheet row and then save the
timesheet. Update Web TimeSheet using the Integration Manager again and the task should be deleted
from Web TimeSheet.
Task Work Values Change when New Assignment Added using MSP API
If you add an assignment using Web TimeSheet Integration Manager for MS Project Server (MSPI) your re-
sulting Task Work field in Web TimeSheet will be different than if you added the assignment manually. This
is because MSPI uses MS Project Server's application programming interface (API) tool, which uses this
formula:
Task Work = Task Duration * 8 * Number of resources assigned to task
This results in Task Work being updated.
In contrast, manual entry uses this formula:
Task Duration = Task Work / (8 * Number of resources assigned to task)
This results in Task Duration being updated.
Cannot Connect to Project Server after restoring Database
If you restore the Project Server database on the Project server, you may be prevented from connecting to
Project Server via the Integration Manager, and receive the following error message:
The Microsoft Project server needs to be configured and connected. Please
go to the Configuration tab and enter the server information, your user-
name, password and click the connect button.
If this issue arises, to establish a connection, you should:
1. Reinstall the RPDS Extensions on the Project server. For information on how to do this, refer to the
Integrations chapter in the Web TimeSheet online help.
Installing the RPDS Extensions creates tables and views in the database that are required to con-
nect the Integration Manager and the Project server.
2. If you have created a dedicated username and password in your database for use in connecting to
Web Timesheet, ensure that:
That username and password are assigned to the project database
That user has been assigned db_owner permission (if you are using a SQL database).