Alerts

[laguna]

I need to generate an Alert to the employee who didn't submit the Timesheet
by the certain time. Next step - send Alert to the manager. The
out-of-the-box Alerts are for Tasks and Jobs. How to create one for
Timesheets?

Any ideas?

Appreciate your help

 

[Inquisit1]

There are no out-of-box solutions for this (unfortunately)...

Essentially you'll want to query the Project Server's 'Published' database
for dbo.MSP_TIMESHEETS.TS_STATUS_ENUM value which represents the current
status of a given user's timesheet.

0 = In Progress
1 = Submitted
2 = Acceptable
3 = Approved
4 = Rejected

Check the value and send an e-mail accordingly.

That's the basic idea...though in practice it's a bit more complicated as
you'll need a way to execute the code on a scheduled basis. You could use
the windows scheduler, or in my case I have installed my code into the WSS
Timer Service. Here is an article explaining how to programmatically create
WSS Timer Jobs:

http://www.andrewconnell.com/blog/articles/CreatingCustomSharePointTimerJobs.aspx


Hope this helps!