Integrating ANVIZ MS SQL Attendance with ERPNext

Frappe HR
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.

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

1 Like
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?

9

Could you please elaborate your concern more?