Biometric Attendance Integration with zkt uface800

mujeerhashmi · June 15, 2023, 4:34am

I have set up the computer on the local LAN along with zkt uface800 to run the biometric-attendance-sync-tool. The attendance is not pulled to erpnext & below are the error logs. Please help

2023-06-08 15:54:33,309	ERROR	10.10.10.121 exception when fetching from device...
Traceback (most recent call last):
  File "C:\Users\MohammedUsmanahsan\Downloads\biometric-attendance-sync-tool-master\biometric-attendance-sync-tool-master\erpnext_sync.py", line 149, in get_all_attendance_from_device
    conn = zk.connect()
  File "C:\Users\MohammedUsmanahsan\AppData\Local\Programs\Python\Python310\lib\site-packages\zk\base.py", line 384, in connect
    raise ZKErrorResponse("Unauthenticated")
zk.exception.ZKErrorResponse: Unauthenticated
2023-06-08 15:54:33,321	ERROR	exception when calling pull_process_and_push_data function for device{"device_id": "office_1", "ip": "10.10.10.121", "punch_direction": "", "clear_from_device_on_fetch": ""}
Traceback (most recent call last):
  File "C:\Users\MohammedUsmanahsan\Downloads\biometric-attendance-sync-tool-master\biometric-attendance-sync-tool-master\erpnext_sync.py", line 149, in get_all_attendance_from_device
    conn = zk.connect()
  File "C:\Users\MohammedUsmanahsan\AppData\Local\Programs\Python\Python310\lib\site-packages\zk\base.py", line 384, in connect
    raise ZKErrorResponse("Unauthenticated")
zk.exception.ZKErrorResponse: Unauthenticated

mujeerhashmi · June 15, 2023, 12:22pm

@karthikeyan5 sorry for tagging you. Can i get some help here.

blaggacao · June 15, 2023, 12:31pm

What did the most significant (according to your criteria) google search result return? And why was that not leading to an answer? (If you have a ChatGPT account, that might even give a more contextual answer, still).

mujeerhashmi · June 17, 2023, 1:17pm

Hello @blaggacao .
Thanks for the directions. I tried a few things before posting here. From the Google search, I checked Advice on connecting biometric machine with pyzk · Issue #6 · fananimi/pyzk · GitHub. It talks about using make_commkey. I see that the pyzk library installed already has that functionality.

I tried downloading & installing the latest pyzk from GitHub. The result was no different.

The chatgpt talks about device credentials for resolving the issue. But because the local.config file in the erpnext biometric attendance sync tool has no such parameter. I thought of checking with the community.

Please let me know if i have missed something which was very obvious to get to the solution. Thanks in advance.

blaggacao · June 17, 2023, 10:35pm

Thank you! Interesting, indeed!

Could you link me to the connection factory of the erpnext biometric attendance sync tool (in the code)?

From what you report, I have a hunch that there may be a local.config item (i.e. an entry in site_config.json) that you’re missing? (or the attendance tool’s connection factory doesn’t support authenticated connections )

mujeerhashmi · June 19, 2023, 12:06pm

This is the function that connects to the device.

github.com

frappe/biometric-attendance-sync-tool/blob/6ed3470fc4a7af31eb43967ed8f89c87227faa57/erpnext_sync.py#L143


      
                          json.dumps(device_attendance_log, default=str)]))
                  else:
                      attendance_failed_logger.error("\t".join([str(erpnext_status_code), str(device_attendance_log['uid']),
                          str(device_attendance_log['user_id']), str(device_attendance_log['timestamp'].timestamp()),
                          str(device_attendance_log['punch']), str(device_attendance_log['status']),
                          json.dumps(device_attendance_log, default=str)]))
                      if not(any(error in erpnext_message for error in allowlisted_errors)):
                          raise Exception('API Call to ERPNext Failed.')
          
          

          
def get_all_attendance_from_device(ip, port=4370, timeout=30, device_id=None, clear_from_device_on_fetch=False):
              #  Sample Attendance Logs [{'punch': 255, 'user_id': '22', 'uid': 12349, 'status': 1, 'timestamp': datetime.datetime(2019, 2, 26, 20, 31, 29)},{'punch': 255, 'user_id': '7', 'uid': 7, 'status': 1, 'timestamp': datetime.datetime(2019, 2, 26, 20, 31, 36)}]
              zk = ZK(ip, port=port, timeout=timeout)
              conn = None
              attendances = []
              try:
                  conn = zk.connect()
                  x = conn.disable_device()
                  # device is disabled when fetching data
                  info_logger.info("\t".join((ip, "Device Disable Attempted. Result:", str(x))))
                  attendances = conn.get_attendance()

In the pyzk library, In the connect function there is a argument for password. I am not sure what password is this & no provision to specify this password in erpnext biometric attendance sync tool.

github.com

fananimi/pyzk/blob/50637985b56c3312bf80346c022ebfa567e02808/zk/base.py#L113


      
                  test UDP connection
                  """
                  self.client = socket(AF_INET, SOCK_DGRAM)
                  self.client.settimeout(10)
          
          

          
class ZK(object):
              """
              ZK main class
              """
              def __init__(self, ip, port=4370, timeout=60, password=0, force_udp=False, ommit_ping=False, verbose=False, encoding='UTF-8'):
                  """
                  Construct a new 'ZK' object.
          
          
        :param ip: machine's IP address
                  :param port: machine's port
                  :param timeout: timeout number
                  :param password: passint
                  :param force_udp: use UDP connection
                  :param omit_ping: check ip using ping before connect
                  :param verbose: showing log while run the commands

This is the template for configurations. I have generated & provided the ERPNext API Key & Secret properly. But I don’t find any place to specify the device credentials as such.

github.com

frappe/biometric-attendance-sync-tool/blob/6ed3470fc4a7af31eb43967ed8f89c87227faa57/local_config.py.template


# ERPNext related configs
ERPNEXT_API_KEY = ''
ERPNEXT_API_SECRET = ''
ERPNEXT_URL = 'http://dev.local:8000'
ERPNEXT_VERSION = 13


# operational configs
PULL_FREQUENCY = 60 # in minutes
LOGS_DIRECTORY = 'logs' # logs of this script is stored in this directory
IMPORT_START_DATE = None # format: '20190501'

# Biometric device configs (all keys mandatory)
    #- device_id - must be unique, strictly alphanumerical chars only. no space allowed.
    #- ip - device IP Address
    #- punch_direction - 'IN'/'OUT'/'AUTO'/None
    #- clear_from_device_on_fetch: if set to true then attendance is deleted after fetch is successful.
                                    #(Caution: this feature can lead to data loss if used carelessly.)
devices = [

This file has been truncated. show original

mujeerhashmi · June 19, 2023, 12:45pm

We have to set up the comm key on the ZKTeco device to 0 for this to work. I will update you here if it works for us.