ERPNext Conference 2019* ERPNext.com Blog

Integrating ANVIZ MS SQL Attendance with ERPNext

attendance

#1

Hi I am trying to integrate Anviz Crosschex attendance software with ERPNext. It saves attendance in MS SQL. I would like to know the best approach get attendance.

My plan on how to do this is to run a cron job that will do the following:

  1. Query MS SQL for the required User and get IN and Out time.
  2. Create new attendance on ERPNext depending about the leave policy