1. Table Name to store Check In and Out - CHECKINOUT

1. Table Name to store Check In and Out - iclock_transaction

Hi Vineshwar,

Can you give me the following information from the vendors:

1. V8 Table name for USERINFO
2. Which field is the same as CHECKINOUT.Processed?
3. In table "CHECKINOUT", is UNPROCESSED records still marked as "1" and Processed Marked as "2"?
4. What are the values that define: IN, Break1IN, Break2IN, OvertimeIN, OUT? In version 5, it was: ClockType. IN = 1, Break1In = 2, Break2IN = 5, OvertimeIN = 7, OUT = 3

5. Here is the query we used to get data from Version 5. Can you translate this to Version 8

   
   

   SELECT

     u.BADGENUMBER

    ,c.CHECKTIME

    ,'' --ClockType. IN = 1, Break1In = 2, Break2IN = 5, OvertimeIN = 7, OUT = 3

    ,CONVERT(VARCHAR(50),c.USERID) +  'BadgeNumber: ' +  ISNULL(u.BADGENUMBER,'')  + 'CheckTime: ' +  CONVERT(VARCHAR(50),c.CHECKTIME,102)  +   CONVERT(VARCHAR(50),c.CHECKTIME,108)   

    ,0

    ,CONVERT(VARCHAR(50),c.USERID)  + ' ' + CONVERT(VARCHAR(50),c.CHECKTIME,102) + ' ' +  CONVERT(VARCHAR(50),c.CHECKTIME,108)  

    from   dbo.CHECKINOUT c

    JOIN   dbo.USERINFO u ON c.USERID = u.USERID

We have installed V8 on QA2 and setup data on QA4. DB Name: ZKTecoSoftware807.

Can you create sample data for:

1. Time IN, OUT
2. Time IN, Break1IN, OUT
3. Time IN, Break2IN, OUT
4. Break1IN, Break2IN
5. and some other variations for us to test

1. ZKTeco Software installed on QA2
2. Database Setup in QA4 [ZKTecoSoftware805]
3. User Details on Table [personnel_employee]
4. TNA Transactions in Table [iclock_transaction]
5. Sample uploaded for User [emp_code = '2425']

Meeting with Sanjay and Vineshwar:

1. Add 10 entries. for Day 1, 2 transactions per "Punch Stage"
2. Add an example of an employee over a 1 week period.
3. Transfer case to development.

Meeting Vineshwar and Sanjay

Notes:

1. Agreed that the states in ZKTeco will be defined as IN, Break1IN, Break2IN, OvertimeIN, OUT? In version 5, it was: ClockType. IN = 1, Break1In = 2, Break2IN = 5, OvertimeIN = 7, OUT = 3. We will use the LinkSOFT INTEGRATION Configuration for TNA devices to allocate the states.
2. The two tables to use are as follows:
   1. personnel_employee - Agreed to use Primary Key as "Employee Code". Department ID is not used and is "system assigned"
   2. iclock_transaction - Transaction table linking to 1. above using Employee Code.
3. Multi-company is not supported, however, we can use "iclock_transaction.TerminalAlias" as the Company code from LinkSOFT.
4. What does Area Code/Department mean?
5. When extracting data, we used to mark transactions as "Processed" in the external system. For this version, we will use the "iclock_transaction.ID" (Identity Column) field to mark the last transaction imported. This value can be stored in the "Integration" settings.

Next step:

1. Vineshwar to get a trial licence extended so we can perform more tests
2. Vineshwar to get an explanation on how to set up Multi-Company. I.e. Where can we place a company code from Linksoft? Propose using "iclock_transaction.TerminalAlias"
3. Development can start work while waiting for the Licence

Figure 1 - SQL script to align with comment 1

SELECT e.emp_code, t.punch_time

 ,t.punch_state

 ,'Employee Number: ' + ISNULL(e.emp_code,'') + 'CheckTime: ' + CONVERT(VARCHAR(50),t.punch_time,102) + CONVERT(VARCHAR(50),t.punch_time,108)

FROM personnel_employee e

JOIN iclock_transaction t ON t.emp_code = e.emp_code

1. The change will be available in version:14.20

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

1. New configuration in menu "Integration ~> TI004 ~> Timesheet.SoftwareVersion". Valid options are 5 and 8
2. Changed structure to handle version 8 data import

3. Affected Areas:

1. Timesheet Import for version 8 of ZKTeco software

4. The issue was caused by:

1. New version of API for ZKTeck Time and Attendance

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

Hi Vineshwar, please complete the following tests on TNA for the ZKTech device changes you have requested

1. Import data into LinkSOFT
2. DELETE TNA data and reimport
3. Enable Rules for TNA processing
4. Submit Processed data

Note that we need to complete this before COB Wednesday 26th October as the release date for 14.2 is 1st November. Please let me know if this cannot be achieved.

1. Setup ZKTECO V5 and perform tests from Table 1
2. Setup ZKTECO V8 and perform tests from Table 1

Environment Details

1. OS version: Win11
2. Application version: 14.20
3. Setup on:
   1. Server: LinkQA4
   2. Database: LinkSOFT
   3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
4. Login Details: Standard username and password for user "admin"

Next Step: Closure