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

#2

Hi

How did this go for you?

Regards


#3

It went well. The attendance is working fine how ever I didnt get time to implement the shift policy.


#4

Great! Would you mind sharing the steps ?


#5

Have a look at this code

Kindly install pip package pymssql in the frappe environment before installing the app.


Bounty: hourly attendance, hourly leave in HR :)
#6

Thanks


#7

Kindly install pip package pymssql in the frappe environment before installing the app.

To solve that problem you have to but pymssql in requirements.txt


#8

with no knowledge about “anviz attendance”. Would you not have to have a fine grained attendance in ERPNext where you actually can import finegrained (hr:min) attendance data into to begin with?

how do you solve that problem?