ERPNext Conference 2019* Blog

Integrating ANVIZ MS SQL Attendance with ERPNext



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