Clarity

  • 1.  Create a gelscript which will approve the Submitted Time Sheets

    Posted Aug 23, 2016 07:19 AM

    How to write a gel script to approve the Timesheet which are submitted



  • 2.  Re: Create a gelscript which will approve the Submitted Time Sheets

    Posted Sep 09, 2016 04:18 PM

    There is a process available out-of-the-box called "Conditional Automatic Approval". You could review this process and tweak it to meet your needs.

     

    I have seen conflicting information on the message boards about whether it is possible to approve submitted timesheets via XOG, but if you're going to do it with a GEL script it would probably have to use XOG (if it works). You would NOT want to use a SQL update in a GEL script to do this.



  • 3.  Re: Create a gelscript which will approve the Submitted Time Sheets

    Posted Sep 09, 2016 08:09 PM

    You can load (pre) approved timesheets via XOG.

     

    Regarding the SQL update, it is your choice but as of now (14.4), there are no downstream actions when a timesheet goes from Submitted to Approved. Still, the safest is to use a process to set the status to 'Approved'.



  • 4.  Re: Create a gelscript which will approve the Submitted Time Sheets

    Posted Dec 30, 2016 02:38 PM

    You can XOG update the timesheets.  I wrote a XOG process to import timesheets, you can change the XOG on my script to "approved" and set the approver field.  Here's a process I wrote to import timesheets from an external system and write them as Submitted into Clarity.  You can alter this to read the timesheets that are Submitted and write them as Approved.

     

    https://communities.ca.com/thread/241754119