Sunday, July 12, 2015

Fingerprint Time Attendance Tips

  Fingerprint Time Attendance Tips

In the name of Allah, Most Gracious, Most Merciful      
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      Today you will learn some new ideas and techniques; many developers have no experience with "Fingerprint Employee Time Attendance Clock" so I thought to share my experience regarding this point.

     Regardless of your experience or the knowledge of your implementation skills, there are some aspects you should be aware of on demand to develop with any programming language. 

     This is the experience talks, which are not written in books or even learned from courses. But this is the technical knowledge that you have to gain or at least have a knowledge background on it.


Fingerprint Attendance Tips…

The following are some tips on "Fingerprint Employee Time Attendance Clock" you should read and consider:


1.     Manuals: Reading the manual of the fingerprint device, If not available you can take the device's Name or serial-no and Google the internet.

2.     Hardware: Check up the plugs and hardware connections and make sure your Machine Power is switched on.

3.     API: If either you or the technician successfully installs your finger print device, you may found no application program interface (API) to retrieve the data. Considering such devices generate text file on some schedule basis; this schedule is related to the adjustment of the clock device (Check-In or Check-In) Clock Machine.

4.      ODBC: Connecting the software of the fingerprint machine to the Oracle database requires connecting to the ODBC. Hence, access to the databases is managed by the 'Microsoft ODBC Driver Manager'. The driver manager provides the linkage between an ODBC application and an ODBC driver for a specific database management system.


Note: ODBC applications do not need to be re-linked or re-compiled in order to change which database management system they are accessing. For more information pls. refer to ODBC. You can also Download Oracle 11g release 2 client ODBC drivers


5.     If successfully connected to Oracle database then you will have a table called e.g. ATTENDANCE; this Table has such database columns defined as follow:

·        "Serial": Specifying the transaction serial no.
·        "Emp_id": Specifying the employee's id.
·        "Trans_Date ": Specifying the date and time of the employee's transaction.
·        "Location_name": Specifying the company's gate name or entrance number where the fingerprint attendance machine is located.
·        "Status": The status column is predetermined defined to register only two values either (IN) or (OUT).
     In fact, this table is a raw table registers each fingerprint the employee made. Each transaction is registered into a database row. Unfortunately, it is free of control BUT waits for your technical skills to operate on it.

Sample transaction: 


Serial Emp_id Trans_Date Location_name Status
15400
00001
23/mar/2015 8:15:33

G001 IN
16589
00001
23/mar/2015 15:15:33

G001 OUT

    
      You should take into account that each fingerprint results in an individual transaction. This is not a good practice as expected since the output data is not normalized this is the least to say…
          
So you will need to create 

  • Create a new database table to normalize clock table data (IN) or (OUT) in one database record.
  • Create a database trigger on the initial clock table to insert, update transactions into your new created table using After-insert After-update Triggers. 
  • Create a database link to retrieve any old data registered in Excel Sheets prior to the clock fingerprint usage.
  • Create a form to register the attendance manually in case of any unexpected technical problems.

Note: No doubt, calling a customer support employee or a sales engineer is defiantly a good idea. They are the dedicated technicians to the job; they specialize in defining, installing, connecting the fingerprint machine to the database and can professionally demonstrate its usage.


      You should also be alerted to the operation and troubleshooting steps followed by him to solve problems. In order to guarantee further safe and successful workflow at the client's company or inside your workplace.




Hope this initially helps you …

    Learn more about:

·          Dependent Drop Down list


My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.

.

No comments :