Connection ZKTeco with ERPNext

flexy2ky · May 1, 2020, 11:34pm

Bumping this up in case someone has an idea of what i’m going through and can recommend a solution.

olamide_shodunke · May 23, 2020, 8:41pm

Did you see the comment below from iMoshi?

iMoshi:

Just got caught up with the thread. And I personally have experience with the MA300 devices.

To put simply there are 2 types of devices from ZKTeco. 1st, RGB, 2nd, black and white (our definition). MA300 is one of the black and white devices, or simply “dumb”-er devices. Devices from ZKTeco that do not have built in screen are those black and white types. Hence for some reason they do not support the default API’s of ZK softwares. The device is really beautiful and well built, but after about a week of trying to connect it with our WordPress HR software we gave up and went with 800h devices. They have built-in screen (the RGB type device), which means they fully support regular APIs. Ugly, clumsy, cheaply built, but supports PyZK.

We have many success with connecting RGB devices with all sorts of softwares such as WordPress, and specially ERPNext.

I suggest you to return the MA300 device and go for devices with built in screens.

Ohh and that firmware difference is bull crap. We have requested for all sorts of firmwares from ZKTeco directly, and they never were able to locate it internally.

flexy2ky · May 24, 2020, 8:11am

@olamide_shodunke Yes i did. But unfortunately this doesn’t seem to be an option for me becaus as you know, most companies here have strict no-return policy and of course the device was with me for more than 24hrs before this post and then the lockdown happened. So my only option is to purchase another device. But i am now skeptical because there’s no guarantee it will work as the documentation for the integration app says 6.60 firmware for all supported devices and this thing is expensive here.

sione · July 2, 2020, 10:01am

Thanks for the very detail step. I did followed your guide and get mine to work.

Malo

Kamo3000 · October 25, 2020, 6:12am

Hi all, I am new with zkteco, I connect zkacess with sql but I have problem with report, I can not use zktime . A lot of information is missing, can any one support

JayRam · October 25, 2020, 7:28am

The ZKTeco experts are @karthikeyan5 and @vigneshsekar.

I had to deploy ZKTeco Biometric Integration at a customer setting, so I reached out to these guys and signed up for a support plan with them. They were awesome. They helped set it up. Trouble helped me shoot problems, and I don’t have to get into the depths of this solution as that is not my core area. And if I have to extend this solution to another biometric devices, I know that I don’t need to break my head on this, I just go them and outsource that part to them.

I think we all need to leverage each other and if as a community we have to thrive, we have to become experts in some area and while each of us take on the complete responsibility for the implementation with a client, we have the confidence that we can deliver because we have the experts in each area supporting us at the back end.

And why should the experts support us? Because we buy a support plan from the experts.

Just a thought!

Thanks

Jay

karthikeyan5 · October 26, 2020, 1:35pm

@flexy2ky, Yes you are right, you can add a “force_udp” parameter as mentioned here: GitHub - fananimi/pyzk: Unofficial library of zkteco fingerprint attendance machine

Thank you @JayRam

Muhamad_Haziq · September 27, 2022, 2:18am

Thank you for the the thread. It has really helped me a LOT as a newcomer.

kanuns · October 25, 2022, 9:51pm

i know this is an old post, but is there a way we can use the device communication password?
my devices have communication password and I cannot use them without it.

I have connected the device via
cd pyzk
python3 test_machine.py with password and it connects but i cannot give password in the erp sync py file so cannot sync

karthikeyan5 · October 29, 2022, 6:13am

@kanuns, currently this is not supported, but it should be a single line feature to add to the script. Do open a feature request at Issues · frappe/biometric-attendance-sync-tool · GitHub. Or please send a PR if you manage to fix it yourself.

The fix will be in this line:

github.com

frappe/biometric-attendance-sync-tool/blob/143660f8ebf59eb9ed1c1782d90b50ed00c8faa2/erpnext_sync.py#L144


      
                      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()
                  info_logger.info("\t".join((ip, "Attendances Fetched:", str(len(attendances)))))
                  status.set(f'{device_id}_push_timestamp', None)

zahra · February 1, 2023, 6:52am

@karthikeyan5

I could fetch data from the biometric device(according to “2023-01-31 17:35:37,366 INFO 192.168.1.199 Attendances Fetched: 37678” in logs.log ) but I have this error in my error.log:

2023-01-31 17:03:32,726 ERROR Error during ERPNext API Call. 1000 1674647885.0 1 Traceback (most recent call last):
File “apps/frappe/frappe/app.py”, line 69, in application
response = frappe.api.handle()
File “apps/frappe/frappe/api.py”, line 55, in handle
return frappe.handler.handle()
File “apps/frappe/frappe/handler.py”, line 38, in handle
data = execute_cmd(cmd)
File “apps/frappe/frappe/handler.py”, line 76, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “apps/frappe/frappe/init.py”, line 1457, in call
return fn(*args, **newargs)
File “apps/erpnext/erpnext/hr/doctype/employee_checkin/employee_checkin.py”, line 103, in add_log_based_on_employee_field
doc.insert()
File “apps/frappe/frappe/model/document.py”, line 261, in insert
self.run_before_save_methods()
File “apps/frappe/frappe/model/document.py”, line 1052, in run_before_save_methods
self.run_method(“validate”)
File “apps/frappe/frappe/model/document.py”, line 941, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1259, in composer
return composed(self, method, *args, **kwargs)
File “apps/frappe/frappe/model/document.py”, line 1241, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “apps/frappe/frappe/model/document.py”, line 938, in fn
return method_object(*args, **kwargs)
File “apps/erpnext/erpnext/hr/doctype/employee_checkin/employee_checkin.py”, line 19, in validate
self.validate_duplicate_log()
File “apps/erpnext/erpnext/hr/doctype/employee_checkin/employee_checkin.py”, line 28, in validate_duplicate_log
frappe.throw(
File “apps/frappe/frappe/init.py”, line 504, in throw
msgprint(
File “apps/frappe/frappe/init.py”, line 479, in msgprint
_raise_exception()
File “apps/frappe/frappe/init.py”, line 434, in _raise_exception
raise raise_exception(msg)
frappe.exceptions.ValidationError: This employee already has a log with the same timestamp.
Employee Checkin EMP-CKIN-01-2023-000005

2023-01-31 17:03:32,726 ERROR exception when calling pull_process_and_push_data function for device{“device_id”: “1”, “ip”: “192.168.1.199”, “punch_direction”: “”, “clear_from_device_on_fetch”: “”}
Traceback (most recent call last):
File “C:\Users\Mehdi\Downloads\biometric-attendance-sync-tool-v1.0-win64\erpnext_sync.py”, line 51, in main
pull_process_and_push_data(device, device_attendance_logs)
File “C:\Users\Mehdi\Downloads\biometric-attendance-sync-tool-v1.0-win64\erpnext_sync.py”, line 129, in pull_process_and_push_data
raise Exception(‘API Call to ERPNext Failed.’)
Exception: API Call to ERPNext Failed.

I don’t have any idea what I should do.

I appreciate any help.

flexy2ky · February 1, 2023, 7:27am

The quick solution will be to go to Employee Checkin doctype and find this record EMP-CKIN-01-2023-000005 and delete it and restart the sync process. I believe the latest version of the tool has some functions to bypass this restriction. So check the documentation or a quick search for other posts about time attendance should tell you how to enable the bypass.

Hope This helps

zahra · February 1, 2023, 8:43am

@flexy2ky
Thank you for your help. It works and I have successful attendance in ERPNext. But it doesn’t have a log type(IN/OUT). Would you please tell me what I should do?

Thank you in advance

flexy2ky · February 1, 2023, 11:50am

That is dependent on your biometric machine.

karthikeyan5 · February 2, 2023, 9:38am

There is some info about log type in following post that might be relevant to your question.

zahra · February 5, 2023, 5:58am

thanks, hopefully it is fixed.

zahra · February 5, 2023, 5:58am

thank you so much.

Desoky01 · March 17, 2023, 9:39pm

Thank you for your instructions, and I did all steps, But I have a comment, there is no file named “push_to_erpnext.py” in GitHub - frappe/biometric-attendance-sync-tool: A simple tool for syncing Biometric Attendance data with your ERPNext server

Desoky01 · March 17, 2023, 9:43pm

I did all steps, but I cant make auto attendance with ERPNext.
Can you share a video for this steps?

TurkerTunali · March 21, 2023, 8:51pm