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

·       In-Direct Global Variable Access

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

.