Get attendance from biometric machine directly in SQL Server

Question

I am working on attendance System. I daily use to update file to insert data in database using e time track software. Is there any way may I get data directly into Sql Server. Through any store procedure or something else. It would help us to avoid manual edit which generally did by the updating person before update.

Khan Abrar Ahmed · Answer

Hi check this links http://support.emportant.com/support/solutions/articles/205537-automated-attendance- data-integration-from-sql-server-databases http://stackoverflow.com/questions/23752625/how-to-save-biometric-template-directly-into-database-vb-net http://www.ithuan.com/1432681/get-attendance-the-biometric-machine-directly-sql-through

Upendra Pratap Shahi · Answer

Read below link- http://www.codeproject.com/Articles/218914/Steps-to-Create-your-First-SSIS-Package

Pandi P · Answer

CAMS (http://camsunit.com) provides the Web base callback APIs using which you can integarted biometric machines with your web application and store the attendance data into your data base directly. refer the api detals at: http://camsunit.com/application/biometric-web-api.html

Punit Sharma · Answer

Dear Upendra Pratap Sir This code would work when we load data in database from txt file. but I need to update data into database direct from attendance machine which is on my given IP //10.11.11.31