Time Clock - Basic Time Tracking

[QMcKay]

Ensure you have Clocked In and Clocked Out the Employee at least once. More times is better.

Change your Report so it is only making a single SQL call so we can narrow this down.

[Current Hours Daniel B.:13,12, 12, 12, 20, 16, 7]
@@EmployeePunchInLatest:Employee,Daniel B.

In the SQL script shown above, change these lines (just copy from here and paste over your script):

declare @StartDate datetime --= convert(varchar(25),'{Start}',126)
--declare @EndDate date = dateadd(Month,1,@StartDate)
declare @EndDate datetime --= convert(varchar(25),'{End}',126)
declare @Now datetime = CONVERT(VARCHAR(25), GETDATE(), 126)

set @StartDate= left(CONVERT(VARCHAR(25), GETDATE(), 126),7)+'-01T00:00:00'
--set @EndDate  = dateadd(Month,1,@StartDate)
set @EndDate  = dateadd(Month,1,left(convert(varchar(25),@StartDate,126),7)+'-01T00:00:00')


-- set Employee Name
declare @Employee varchar(20) = 'Daniel B.'--'@2'
declare @HolidayFlag varchar(20) = 'Holiday'
declare @EntityType varchar(20) = 'Employee'--'@1'
declare @Clockin varchar(20) = 'PunchIn'
-- set Overtime Hour Limit
declare @HourLimit decimal(4,2) = 8.00

[emre]

You have a typo. Defined it as @@EmployeePunchinLatest but calling it as @@EmployeePunchInLatest. These are case sensitive.

[rightguys]

@emre

You have a typo. Defined it as @@EmployeePunchinLatest but calling it as @@EmployeePunchInLatest. These are case sensitive.

Yep, that was it. Thank you so much.

Just a few things.

1. I notice after the 8th hour of each day, the employee gets OT hours. How do I configure it so that the employee gets OT hours after the 40th HOUR of each WEEK?

2. Will I be able to fit 20 or more employee widgets on this screen? The space seems limited. I guess I’ll just remove the Reports Widget and leave only the Entity Grid Widgets.

3. How do I add PINs to add a layer of security? Something like this: TimeTrex Community Edition Integration: How to integrate third party Payroll/Time Clock software into SambaPOS - #59 by emre

4. In emre’s post, in the link above, there is a button for “Break”. How do I implement that into the reports?

5. How do I CLEAR the SQL data for the Time Clock?

6. How do I EDIT the SQL data for the Time Clock?
   Let’s say an employee forgot to Clock Out at the end of his or her shift, or there was a problem and an employee could not Clock In.

Sorry for asking too much.

[QMcKay]

@rightguys

after the 8th hour of each day, the employee gets OT hours. How do I configure it so that the employee gets OT hours after the 40th HOUR of each WEEK?

You need to change the SQL to calculate it in this way. You will also need to be specific as to what a “week” is - which day it starts and which day it ends.

@rightguys

Will I be able to fit 20 or more employee widgets on this screen? The space seems limited. I guess I’ll just remove the Reports Widget and leave only the Entity Grid Widgets.

Not likely, and the performance for pulling even just 4 Reports can be slow. You could have a single Report, and use automation to load the report for the chosen employee via click of Automation Button, Entity Button, or Entity Grid. I have the Punch Editor and Payroll setups operating this way.

@rightguys

How do I add PINs to add a layer of security?

With more automation, similar to above.

@rightguys

How do I CLEAR the SQL data for the Time Clock?

Run SQL script in SSMS…

DELETE FROM [EntityStateLogs]

@rightguys

How do I EDIT the SQL data for the Time Clock?

Install the Punch Editor setup. Part of this Tutorial:

Time Clock & Punch Editor - Custom Navigation Flow: Uses Employee Entities not Users

I have included only the configuration task as it is easy to update and it helps me keep this tutorial current Configuration Task Configuration Tasks: Time Clock + Punch Editor https://gist.github.com/kendash/35688644368ef581dc2d/raw/ Standalone Punch Editor https://gist.github.com/kendash/9a887f61097f1690b285/raw/ Copy the URL and navigate to Settings > Local Settings > Online Services and paste that URL in the box then go to Settings > Configuratio…

That said, there does not appear to be a stand-alone Tutorial for the Punch Editor. Kendash has put the Timeclock and PunchEditor into a Configuration Task instead… and you may not like the way his Timeclock is set up, since it is quite a different flow. Proceed with caution. I will try to find some time to create a Punch Editor Tutorial.

@rightguys

Sorry for asking too much.

No worries. But each of these should be taken 1 at a time, and you should make separate topics for them.

[rightguys]

Thank you for being so helpful.

[Jesse]

I have a task just for punch editor it’s just hidden. I’ll check it tonight to be sure it was complete then I’ll publish the gist here.

[Jesse]

@rightguys Ok sorry it was late but if you add this to your Configuration Repository URL’s section in Settings > Local Settings > Online Services it will give you the Punch Editor Configuration Task.

https://gist.github.com/kendash/9a887f61097f1690b285/raw/

Additionally if you ever need to add new employees just run the task again and it will auto generate reports etc for you.

[Jesse]

@QMcKay I updated my tutorial to include the Standalone Punch Editor Config Task.

[rightguys]

Wow, thanks so much.

[Dash]

I want to thank you for such a comprehensive walk through of this module. Truly a great assistance . If you have any other Modules to share I would be very grateful. I have struggled to setup some elements up but this walk through has given me a better understanding of setup.

Thank you very much for support and you are a asset to this forum.

[1bigwink]

Hi guys, This looks ace - thank you for sharing. Is there a canned version of this available as a DB Tools import file, can’t seem to find it in the post?

[JTRTech]

Im not sure if there was but setups like these are normally reluctant to share db tool import as they ALWAYS follow with an onslaught of questions from people which just install and them mess it up as haven’t taken the time to learn how the setup was done.

[Mully]

@QMcKay

Handler: @@EmployeePunchinLatest

*** I think it should be @@EmployeePunchInLatest. Upper case I. Emre noticed a typo in comments below and I had the same typo, since I cut and paste I thought I should check tutorial. Its incorrect above in the body of the tutorial. I couldn’t place it where the actual error is. I can explain it better if you can not locate the error. Thanks

[QMcKay]

@Mully

Its incorrect above in the body of the tutorial

…
Fixed, thank you.

[jrryfn]

This is really frustrating. I have a staging environment where I’ve followed this tutorial and the time clock works, INSERTing records into the [EntityStateLogs] table. However, in our production environment, I have the exact set-up, but only see UPDATES for [EntityStateValues].

I’ve numerously checked my TC_LogEntityState Action and Rule, but completely unable to find the reasons why. Can someone help me please?

[Jesse]

We can only guess what is wrong. You need to provide screenshots of your setup for us to help.Right now based off what you have told us there is a 50/50 chance a moose has sat on your other till causing the issue… but I cant be certain…

Ok sorry bad joke.

[na1978]

LOL. Is this a southern joke?

[Jesse]

Not really we have no moose here lol.

[JTRTech]

Canadian I knew told me one time about how they ran over a moose, well not run over more like hit a moose and wrote off car and it just walked off LOL

[Chipwagon]

What if I called my Entities “Servers” (really wish I hadn’t for endless reasons!!), can I modify the Configuration Task to accommodate this?