Stage at 23:49, 12 November 2015

2015-11-12T23:49:50Z

Stage: Created page with "Under certain circumstances, the no biometric template can update the employee's template. As of November 2015, an employee that is enrolled that is already in the software ca..."

2015-11-12T23:49:32Z

Created page with "Under certain circumstances, the no biometric template can update the employee's template. As of November 2015, an employee that is enrolled that is already in the software ca..."

New page

Under certain circumstances, the no biometric template can update the employee's template. As of November 2015, an employee that is enrolled that is already in the software cannot be made a no biometric employee at the clock. This is now controlled by the software, in the same manner that supervisors are controlled by the software.

This script will use the templates from the punches to update the employee's template. Start with a date from the current month and work your way back a month at a time until all employees have a template.

<nowiki>UPDATE
EmployeeClockID
SET
HandPunchTemplate0 = RawPunch.HandPunchTemplate0,
HandPunchTemplate1 = RawPunch.HandPunchTemplate1,
HandPunchTemplate2 = RawPunch.HandPunchTemplate2,
HandPunchTemplate3 = RawPunch.HandPunchTemplate3,
HandPunchTemplate4 = RawPunch.HandPunchTemplate4,
HandPunchTemplate5 = RawPunch.HandPunchTemplate5,
HandPunchTemplate6 = RawPunch.HandPunchTemplate6,
HandPunchTemplate7 = RawPunch.HandPunchTemplate7,
HandPunchTemplate8 = RawPunch.HandPunchTemplate8
FROM
EmployeeClockID
INNER JOIN
RawPunch
ON
EmployeeClockID.FkEmployeeID = RawPunch.FkEmployeeID
WHERE
RawPunchType = 7 -- good punch
AND RawPunch.HandPunchTemplate0 <> 255 -- do not want no biometric templates
AND RawPunchDateTime > '12/1/2015' -- recent punches first
AND EmployeeClockID.HandPunchTemplate0 = 255 -- and employee has a no biometric template

SELECT
*
FROM
EmployeeClockID
WHERE
HandPunchTemplate0 = 255</nowiki>

@@ Line 3: / Line 3: @@
 This script will use the templates from the punches to update the employee's template. Start with a date from the current month and work your way back a month at a time until all employees have a template.
-<nowiki>UPDATE
+ <nowiki>
 	EmployeeClockID
 SET

Remove No Biometric Templates - Revision history

Stage at 23:49, 12 November 2015

Stage: Created page with "Under certain circumstances, the no biometric template can update the employee's template. As of November 2015, an employee that is enrolled that is already in the software ca..."