Automatic Timesheet Reminders

[Anon Anon]

Hi,Does anyone know if there is a way to create a process in Clarity that automatically sends a reminder to a resource and their manager if a timesheet does not meet a certain criteria (i.e. we require daily timesheet entry and so we want to send an email if daily totals are less than 7 hours).    Thanks!

[Anon Anon]

There is--you can do this using a process with a GEL script and run the process using a job that runs every day. Here is a sample GEL script that does this. You will need to fill in your own query, which would use the PRJ_BLB_SLICES table if you want to get down to the level of the number of hours people have logged on a specific day.  
             Insert Your query here        
     
             
Hi ${timecard[1]},      This is a reminder that your timesheet is due today.You can access your timesheets by clicking on this link: http://yourclarityurl/action=timeadmin.timesheetBrowserReturn
          

[AlexandreAssis-CA]

Hey  Another possible approach is to use a Timesheet process that validates the time entries when a timesheet is submitted (instead of a daily job).I've actually done it and it works really nice.  I'm sending you a GEL Script that I used - as an example. Don't get frightened. It's big but it does more than what you've asked...See if you can decipher it as GEL can look a bit cryptic (is that even a word?)  Anyways, GEL can be your friend. :)  My script  check 4 rules - basically you will see the comments...                                                                                                                            Rule number 2 actually is for controlling Overtime - and it requires an additional Object that I call "Overtime Limits"  I also created a new object to receive error messages called "Timesheet Validation" - and the user gets notified that their timesheet has been returned because it's invalid and they need to check on Timesheet Validation page to see what's wrong.  One last thing: note I do a direct UPDATE to a table in the end. This is NOT BEST PRACTICE. But it worked for me, as I was building something to DEMO and not to put in production.  Let me know if you need more info ok?Alex    

Attachment(s)

Validate_Final.zip   4 KB 1 version

[Anon Anon]

Dude, I get it!  That is some great gel.  you wouldn't by any chance have that for MSSQL on those selects would you?  I'm a newbie and I'm teaching myself mssql 15 years after leaving the IBM DB2 environment.  Vic  

[Anon Anon]

Thanks pdjohnson and AlexandreAssis!   I really appreciate it, and both of these look like they could solve our problem.   We're really new to the GEL world so I was wondering if you could tell me where I could find some more information about GEL and how to get started.   Just some info to get us to a point where we can apply these GEL scripts you provided.Thanks!  

[Anon Anon]

lbeck,  I'm teaching myself Gel as well and found a zip file that was buried in a discussion thread.  http://caforums.ca.com/ca/board/message?board.id=CAClarityGeneralDiscussion&message.id=459&query.id=3161#M459  Look for the comments from Chris Hackett.   The docs in this zip file have been  worth their weight in gold.  Vic

[AlexandreAssis-CA]

Hey Vic  Sorry, I don't have the MSSQL statements - I haven't worked with MSSQL (thank God) for about 3 years now :)  But
it shouldn't be that different. I believe you just need to understand
the MSSQL function corresponding to Oracle's TO_CHAR and maybe the
concatenation operator is not "||" but "+"   But I don't really remember, sorry.  I intend to write a detailed GEL user guide with all the knowledge I have acumulated -- when I have the time :)I've
used a lot those docs you guys mentioned and the Apache website
http://commons.apache.org/jelly   and our own CA Clarity Integration
guide - on the specific "Gel" tags which are Clarity-only tags...  Hope I get to write that guide and I'll publish it in the Forum when it's done :)Alex    

[System]

Adding a note to push this forward after board consolidation.

[furrelkt7]

AlexandreAssis wrote:
Hey Vic  Sorry, I don't have the MSSQL statements - I haven't worked with MSSQL (thank God) for about 3 years now :)  But it shouldn't be that different. I believe you just need to understand the MSSQL function corresponding to Oracle's TO_CHAR and maybe the concatenation operator is not "||" but "+"  But I don't really remember, sorry.  I intend to write a detailed GEL user guide with all the knowledge I have acumulated -- when I have the time :)I've used a lot those docs you guys mentioned and the Apache website http://commons.apache.org/jelly   and our own CA Clarity Integration guide - on the specific "Gel" tags which are Clarity-only tags...  Hope I get to write that guide and I'll publish it in the Forum when it's done :)Alex       Alexandre,I look forward to getting that guide you are talking about!! I am trying to learn GEL and think it would be most helpful. Let us know!!  Thanks,Keri  

[Anon Anon]

This is very helpful.   Thanks for the info - I'm going to pass this along to the developer here.    I really appreciate your help everyone!