Steps involved to capture time automatically in WebPay

Steps involved to capture time automatically in WebPay

1. Enter the Employee in biometric database either manually or create a schedular to capture the employees from WebPay database.

Whenever an employee is inserted in Webpay a column(Updation_flag) in Employee Master table  is ‘N’.

Updation_flag Char(1) Default 'N'

To create the schedular to capture the employees from WebPay database you can use this flag and make that ‘Y’ after capturing. 

2. Send the punch time data in TrnPunchTime table whenever a punch is made in biometric machine. For this use the following table structure:

Table Name TrnPunchTime

Column_Name       Type        Length      Description

Pk_Id             BigInt      -           Identity Column (Auto Generated)

fk_emp_code       VarChar     10          Employee Code

DeptccCode        VarChar     10          StaffID / CardID

TrnDate           DateTime    -           Punch DateTime

Note: You only need to send TrnDate as datetime and fk_emp_code in case card id and employee code is same or DeptccCode in case card id is different from employee code. No need to send both fk_emp_code and DeptccCode.

3.  Whenever you insert the punch time record in TrnPunchTime table remember to insert all the previous punch time records in WebPay database which are not inserted in WebPay database due to network failure or any other disinterruption between the two databases.

Blog by BBSPL

Attendance Time in and Time out management (biometrics)

Attendance Time in and Time out management

Menu direction: Leave & Attendance then Capture Punch Time then Capture Punch Time

You will select the type of file:
The options are:

1. Access Database: The access datebase should be on the same system where the application is present that is on server and it should be present on any of the drive.
2. Excel sheet: There can be two columns for date viz. in date and out date; and there can also be a single column for date. There can be either one column where time in and time out is stored or there can be two columns, one for time in and other for time out.
3. Text file with Tab : This file is basically used to import the text file in a specific format. This is client specific format.
4. Dat file : Same as Point 3
5. Text file without tab : This is used when records are present inside the text file without tab just spaces are there so for this purpose we have to calculate the length of that field
Ex:
If you choose importing Text file without tab then enter the field starting position count and the length of that field. Let us suppose that first row is like this '1 4356 ert 20100923 1003 09:25' and in this string '1003' is employeecode '20100923' is date and '09:25' is Time then in Empcode Enter 20-4 where 20 is the starting position and 4 is the length, for date enter 11-8 where 11 is the starting position and 8 is the length and for time enter 25-5 where 25 is the starting position and 5 is the length.

Blog by BBSPL