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:
- Query MS SQL for the required User and get IN and Out time.
- Create new attendance on ERPNext depending about the leave policy