Skip to main content

How to get only Punching Data in MS-SQL or MySQL database from Realtime Biometrics Devices?

Realtime biometrics already has their attendance software in MS Access and in MS SQL database but still, if you want biometrics punching data in your MS SQL or MYSQL database then Realtime Provides SDK(Software Development Kit) for all his biometrics. You can create your own application using SDK, SDK is actually device Code. 


 Even realtime Also provides tools or you can say applications/utilities to get the punch data from Realtime Biometrics devices to directly in your database in SQL or in MYSQL database.
So now it's up to you whether you create your own application or just get the Data in your Database using Realtime Application.
When you use realtime Application to get the Punch data in SQL or MySQL you will get punch data in a fixed table format.
For example, have a look below the image that shows how the data will reflect in the MS-SQL table.


Note:- Just make sure the below points if you are going to use Realtime Applications/Utility to get the biometrics Punching data in SQL or in MY SQL...


  • The table structure is going to be fixed that is predefined by Realtime Biometrics.
  • You will need to manually register the DLLs in order to run the application.
Now, what are the steps to get data in the database and how to run the Application?
Just follow the steps below...
  • Download the utility and put somewhere and assign full permission from folder properties, security options.
  • First Create Table in database MS SQL or MYSQL using the table structure available in the Application folder.


  • Now register the DLLs manually, for registering the DLLs just copy all DLLs from the DLL folder and paste all in System32 and SysWOW64 folder in your OS drive's Windows folder.
  • Once Copy-Paste is done just look for reg batch file and run that file as administrator.
  • Now in the application/utility folder, there is a conn txt file in that you have to put your server/database credentials.
  • Now just run the application file and do the setup in biometrics.
And once Biometrics Setup is done you will be able to see the data in SQL/MySQL database.
For more details watch the video in this video it's shown how to get Realtime Biometrics punch data from Biometrics device to MS SQL database device...




Labels:
Location: India

Comments

Post a Comment

Popular posts from this blog

How to remove Admin/Manager from Realtime Devices?

All the Realtime devices have  Manager/admin lock option this is used to Restrict the unauthorized access of device options. But once you forget admin or admin is not available then you need to remove the admin. And if you are trying to access Menu too many times unauthorized then device get S elf Locked. O nce the device is self-locked then you will not be able to access the device menu, even the Authorized admin tries to access it. This means if the device is self-locked then no one can access device menu options not even authorized admin and then you will need to remove the admin either using default keys or from the device directly or using the software. Remove  Admin/Manager using Predefined Key Most of the Realtime Finger Print devices like T52/T60/C121/C110 etc if you want to remove admin then just follow the steps using predefined id and password..... Press Menu Button in the device. Once at the top it shows Manager Confirm ty...
127 comments
Read more

How to change default login name & password in Realsoft 10.7?

In Realsoft desktop software the default login credentials are are rss so for the security purpose you can change the credentials. Follow the steps below to do the same. Login in software with default credentials. Now go to Administrator then Change Passwor d to change User Name and Password. Put the C urrent Login Credentials then put New Details then click on  Change. And here you are done changing the login credentials. Now what next to do??? After changing the password you won't be able to see your added Employee details, for that you will need to enable the credentials for that newly created user. So how to Enable credentials for Newly Added user? Follow us on. Youtube LinkedIn Facebook Instagram Twitter Just got to File then go to Setup . Put the default password as rss110092 . Edit & Enable Show all company then make it save . Once save go to Company Master and you will see you company name. ...
7 comments
Read more

How to Reset / Delete all data from Realtime Devices Using Software ?

Sometime when your Realtime face device's memory is full and it starts showing Transaction Full and you want to clear the logs or If you want to refresh the device and delete any or all enrollments, All these can be done using software or from the device directly. Note:- Before deleting anything from the device, make sure you have already taken backup because once you deleted the data it will delete whole data till the current time and will not be able to recover. How to Take Realtime Device Data Backup? Delete Punch logs from any Realtime Devices using Realtime Attendance Software. Login with any Realtime  Attendance Software and C onnect Device using LAN or USB . Note:- None of the face devices will get connected using the USB cable. Go to data Transfer and Click on Delete Data From Machine , and it will delete all the Punching Logs in the device. Note:- If the software is below Realsoft 10.8 means if the software is 10.6 or 10.7 it will ask you...
6 comments
Read more