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

Hi

How did this go for you?

Regards

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

Great! Would you mind sharing the steps ?

Have a look at this code

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

Thanks

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

1 Like

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?

Could you please elaborate your concern more?