8 Common Mistakes In Attendance Sheet & How to Solve Them
Introduction
When the transaction logs are not present in attendance sheet, this might be caused by some common mistakes. Don’t panic, you can easily correct these mistakes and re-generate the data in attendance sheet to review the attendance in no time at all. All you have to do is to check and try the following solutions if you experienced the same problem in your system.
Benefits
By knowing this troubleshooting steps, it will save you a lot of valuable time because you can do this by yourself without the need to wait for support personnel to assist you through. By going through this tip, you can familiarize yourself with the software and you will know what went wrong and the way to remedy it in the future.
Mistake 1: User Expired Date has Expired!
The transactions will not appear in the attendance sheet of a user after his/her expiry date. However, the transactions will appear in the terminal data audit list.
Solution:
Therefore, If you want the transaction to reappear in the attendance sheet, go to
Users > Select the user ID > Delete the Expiry Date and regenerate the attendance sheet.
We promise you that the transaction will reappear in the attendance sheet. Give it a try!
Mistake 2: Wrong User Issuance Date!
For example, you enrolled user fingerprint templates on 1 Feb 2017 and started to use the terminal on the same date. Then, four days later 5 Feb 2017, you installed the software on your computer, downloaded the fingerprint templates, and the attendance logs. After the download process, you realized that the transaction data available in the attendance sheet starts on the 5th and the transactions before that date didn’t available.
Please take note that the issued date follows the date of which you downloaded the fingerprint, password or card data. The starting date of the attendance will be based on the issued date and no sooner.
Solution:
If you want the transactions from 1 Feb until 4 Feb 2017 to reappear in the attendance sheet, you need to change the issued date to 1 Feb 2017 and generate the attendance sheet again. Voila, every data will be there!
Mistake 3: Overtime Do Not Appear in Attendance Sheet
The overtime will not appear in the attendance sheet if you didn’t specify the “Maximum no. hours allowed to claim for overtime” in the clocking schedule. So, you need to determine that field.
Solution:
If you want the overtime to reappear in the attendance sheet, please specify the “Maximum no. hours allowed to claim for overtime” e.g. 24:00 at
Configuration > Clocking schedule > Select the clocking schedule that you use > Edit > Setting > the “Maximum no. hours allowed to claim for overtime”.
Please generate at the attendance sheet after making the changes and you will see the overtime data in the attendance sheet.
Mistake 4: No Transaction Appears in the Attendance Sheet
No matter what you do, you can’t get the data to appear on Attendance Sheet and you’re getting frustrated.
Solution:
Don’t sweat just yet. Please go to attendance and click the download button to download the data again because sometimes during the download process, something occurred that caused the data to not be properly downloaded. To confirm that the data has been downloaded successfully into Ingress/TCMS V3, check the attendance log at the terminal by pressing Menu> System Info > Att log
If the Att Log is “0” - the data has been downloaded into the software.
If there’s a value in it - the data has not been downloaded into the software.
This could be caused by the connection interruption between the terminal and the PC.
Mistake 5: Check on the FingerTec Terminal’s Time and Date
While you are busy finding the solution at the software itself, you need to glance over to the terminal also and check the details of the time and date because if the time and date of the device is not correct, rest assured that the transaction data will not be downloaded properly.
Solution:
You need to make sure that the time and date at the terminal are correct because the transaction that appears in the Ingress & TCMS V3 will be based on the terminal time and date. Look at your time and look at the terminal’s time, and adjust it accordingly. Please generate at the attendance sheet after making the changes to get your correct attendance sheet.
Mistake 6: The data is missing and the log has been deleted.
You are panicking because the data is missing but the logs also have been deleted. Now, how to view deleted user ID attendance log? When you deleted the user ID, the records in the attendance sheet will be deleted. However, the raw data of the user ID will remain in the terminal data audit list.
Solution:
To view the deleted user ID records in the attendance sheet, add the deleted user ID in the Users, change the issued date and assign the deleted user ID group. After that, generate the attendance sheet again and you’ll get back your lost data.
Mistake 7: Workers Work during Rest Day and You Forgot to Configure it
Your worker works during the rest day but the transaction data do not appear in the attendance sheet.
Solution:
You need to configure the time for the Rest Day because without it, the transaction will not appear in the attendance sheet. For example: - IN: 07:00 and Out: 23:00. So if the user comes during this range on the rest day, the data will appear in the attendance sheet and DO NOT FORGET to tick the option from the overtime column: work treat as overtime. When you tick this option, it will automatically treat this worktime as overtime and you’ll find all the data is in order in your Attendance Sheet. Refer to the picture below:
Mistake 8: Errors in Configuration
Sample 1: you configure the clocking schedule, IN = 09:00 and OUT = 17:00. The user punches at 13:01 and it appears in the OUT column. You are buffled as to why the transaction didn’t appear in the IN column, and how to make it appear in the IN column?
Solution:
You need to configure the range time. Because if you didn’t, the system will take the middle time as the range time.
Based on your clocking schedule settings, the range of IN time will be 13:00. So, if the user punched at 13:01 onwards, it will fall in the OUT column.
If you want the transaction to appear in the IN column, you will need to configure the range time for the IN column. Please refer below for an example:
Please generate the attendance sheet again after making the changes. Based on the above settings, after the generating process, all transactions before 15:01 will appear in the IN column.
Sample 2: IN = 09:00 and OUT = 17:00, the user works from 09:00 to 20:00 but no overtime appears in the attendance sheet. Why?
Based on the above configuration, the “minimum minutes must worked to qualify for overtime” was 360 minutes or 6 hours. The user works for overtime 3 hours, so the system will not be showing the overtime because the overtime did not exceed 6 hours.
Solution:
If you want the overtime to appear in the attendance sheet, please change the “minimum minutes must worked to qualify for overtime” setting e.g. 60 minutes or delete it. Then generate again at the attendance sheet. After the generating process, the overtime data will appear in the attendance sheet. We promise you.
There you go, 8 mistakes that you could make that are causing the attendance data to go haywire. Attempt all the tips above and if all fail, reach out to support@fingertec.com and we’ll be more than happy to give you a hand.
sir how about start from 4pm to 1am the schedule of employees how to colum to 1 line
ReplyDeleteHello Sir,
DeleteWhat is your schedule type?
If Weekly/Daily schedule, you need to put range time for column OUT
For example IN 4PM and OUT 1AM, so in the range column for OUT, you can set as 2AM, so any clocking data before 2AM consider as the same workday.
when i try to print out using ETC. the date that absent not show on the screen
ReplyDeleteHello Sir/Madam,
DeleteGood day to you.
For ETC report, before generating the report, please tick/check on 'Show Zero Hour' option, then only you generate.
You should be able to view your absent data along in the ETC report.
i have a problem when editing the clocking time in or out ,the modified data will not be saved in attendance sheet even if i generate it
ReplyDeleteHello Sir,
DeleteGood day. Please advice what software you are using with. Is it TCMS v3 or Ingress Software? If you are using Ingress Software, please try the following steps.
Close all application > restart MySQL, Ingress Services and Attendance Service > Run Ingress DB Installer > Open the Ingress Software and check whether the problem still appear or not.
Hello sir
ReplyDeleteI work with ingress MDB (Microsoft Access Data Base ) it that the same config
Dear Sir / Ma'am,
DeleteGood day to you,
Kindly close your Ingress and try to repair your database by following the steps provided in the link below
http://www.fingertectips.com/2016/10/resolve-failed-to-initialize-database.html
If the problem persists, please follow the steps below and see whether it can be resolved or not
1) Backup your database in System Settings > Database Configuration > Browse Database Server Backup Path > Backup
2) Uninstall current Ingress Software from Control Panel
3) Rename FingerTec Ingress folder as "old FingerTec Ingress"
4) Install the latest Ingress below
https://www.fingertec.com/softwareupdate/ingress/software-ingress-mdb_download_e.html
5) Run Ingress Software and restore the backup database above
Please send email to support@fingertec.com should you require further clarification on above issue as our team can assist you further.
Thanks & Best Regards,
Nursyafawani Kasram binti Mohd Hisham
Im having a problem with my FingerTec TA300 where i try to download the attendance sheet but only the names and dates appear. No times at all appear. Please help
ReplyDeleteHello,
DeletePlease let us know the software you are using for our reference.
Then, after downloading attendance, did it show you the number of data downloaded from the device or only 0 transactions downloaded?
Please activate the device from device tab, and re-download the attendance log.
Then, check in the Data Audit List either you are able to view data that has been downloaded. After that, go to Attendance Sheet and generate attendance by selecting user and date range accordingly.
Hello Sir,
DeleteGood day. Once you have downloaded the clocking transaction data from the device, please generate the attendance sheet and check if the clocking data able to be sort based on the clocking schedule assigned for the user or not.
There is no column of 'Short' in Detailed attendance sheet and also overtime column is empty(no data is shown in that column). how to modify the attendance sheet report to add short time and over time details..
ReplyDeletePlz suggest. its urgent
Dear Sir / Ma'am,
DeleteGood day to you,
Referring to your issue, kindly provide us a copy of your backup database for further checking, go to system settings > database configuration > backup. If the database quite large, please upload to any sharing website such as www.sendspace.com or google drive then email to us the download link at support@fingertec.com
Appreciate if you could also provide us some screenshots of which report you are referring to including the user ID and date for our reference.
Thanks & Best Regards,
Nursyafawani Kasram binti Mohd Hisham
What if your schedule is 11 PM (IN) and 7 am (out) on the next day..
ReplyDeleteDear Sir / Ma'am,
DeleteGood day to you,
Referring to your inquiry, if you're using Flexi type schedule, you may use either the 'Maximum work hours to be considered as the same work day' or 'Last log out time to consider as same work day' option (refer here http://prntscr.com/pgbzch). Please note that you can't use both options.
For more details, kindly refer to this link: http://www.fingertectips.com/2017/06/overnight-flexi-hour-clocking-schedule.html
Thanks & Best Regards.
Hi, it seems that our problem here is that on Sundays all workers have records of INs and OUTs but no one's supposed to work Sundays as it is rest day in our calendar. please help
ReplyDeleteDear Sir / Ma'am,
DeleteGood day to you,
Referring to the issue, kindly provide us a copy of your backup database for further checking. Go to system settings > database configuration > backup. If the database quite large, please upload to any sharing website such as www.sendspace.com or google drive and then email to us (support@fingertec.com) the download link.
Thanks & Best Regards
Dears
DeleteHi
Referring to above issue by "Unkown" in [29 January 2020 at 06:02]; we're facing the same issue: when comparing the Event log and reports; some fingerprints fall in another days! for example in log 13-06-2021 and in the report in 14-06-2021 while no fingerprint in 14-06-2021!
hope any solution provided for the issue
thanks a lot
We had check the time/date sync between server, client and terminals and it is ok but still same issue appear!
DeleteHello Sir,
DeleteReferring to the issue, kindly provide us with the backup database file together with sample or screenshot picture of some user IDs, date range and transactions that did not appear correctly in the reporting as our reference when doing the checking. You can upload the file in cloud storage like www.sendspace.com or Google Drive, then share with us the downloading link. You can email all this information to our technical support team at support@fingertec.com.
Best Regards.
Hello Team,
ReplyDeleteI have serious challenges with Ingress, regarding Generating in Attendance Sheet. When scheduling staff into their specific duty roster (schedule ID), once you allocate the staff in the various schedule ID and you generate, it takes you all staff in the one schedule ID but you assigned different schedule ID before generating. Take not that after assigning staff in the various ID, we use the default option, to allow all staff to stay in their respective schedules after generating the entire attendance sheet. I just installed Ingress v4.1.1.0 (MySQL). In short, staff who are in various schedules are erroneously assigned, by Ingress, into one schedule, even when you select DEFAULT when generating. Please explain- Our client is very upset