Stack Overflow
Stack Overflow

Questions tagged [time-and-attendance]

Time and Attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

Time and attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

There are a whole range of technical problems involved with this category of business systems, such as:

  • Date/Time Set and Interval mathematics
  • Nuances of date and time in the real world
  • Pattern recognition in event streams
  • Business rules engines
  • And much more.

Time and Attendance systems also tend to overlap (Venn diagram style) with the following:

  • Payroll Systems
  • Scheduling Systems
  • Access Control Systems
  • Employee Benefits Systems

The broader category of these systems is known as Workforce Management.

StackOverflow is not the place to discuss commercial Time and Attendance products. However, there are many programming problems associated with building these products, or integrating with them, that may be appropriate if phrased properly.

Also appropriate are generalized questions that would be useful if building an in-house Time and Attendance system.

165 questions
9
votes
2 answers

How to restore the right date if it was inserted lately

If i have ZKTime machine to register the attendance of the employees . Sometimes this machine insert bulk of transactions in sql server db with wrong later date like 8-2103 instead of 11-2016 What are the possible causes of this problem and…
Anyname Donotcare
  • 11,113
  • 66
  • 219
  • 392
6
votes
3 answers

Update Automation in SQL-Server

I am doing a project called "Attendance Management System" The company has its own biometric finger scanner who checks for employee's attendance and stored in on a database table. The table consist of 4 fields (ID autonumber, EmployeeNo, CheckTime…
Dhenn
  • 295
  • 2
  • 7
  • 27
4
votes
1 answer

Save data from biometric finger device into database - attendance system

I want to develop attendance system for office where employees give the attendance using finger print, I need to buy bio metric device, and i want to save the attendance data only in my cloud database. No other person should be able to access that…
Pradeep Charan
  • 653
  • 2
  • 7
  • 28
4
votes
1 answer

Should I store UTC timestamps or localtime for shifts

I am working on a function that will work out how many workers is on duty and clocked in (or not clocked in) for their shift. The workers "clock in" and "out" and the time stamps of these events will be stored in UTC format since that seems to be…
The Tahaan
  • 6,915
  • 4
  • 34
  • 54
3
votes
0 answers

How to get daily data from Fingerprint attendance machine?

How to get daily data from Fingerprint attendance machine?I planning to use zk device and use with zklib with python. After I learned zklib , I get all attendances datas.But i want to get specific date range or daily. How can i get data. And…
Thazin Khaing
  • 121
  • 3
  • 9
3
votes
1 answer

VBA Programming. How to transfer data from userform to specific rows and columns to a sheet?

I am currently working on an alternative attendance monitoring system as an initiative. Currently, I have designed my userform which looks like the one below: Time Stamp Userform It works like this: The employee will choose the type of time stamp…
Chenille Masangya
  • 43
  • 3
3
votes
2 answers

ZKemkeeper taking long time when reding ReadGeneralLogData

We are using C# ZKempkeeper (CZKEMClass) dlls to downloading attendance data from biometric/finger scanning machines. Some time the code is working fine, but mostly its taking long time and even not giving time out error. This is the line where…
Saifal Maluk
  • 121
  • 2
  • 5
  • 14
3
votes
4 answers

What is the best way to optimize schema for capturing attendance data

We have a sports training camp which is regularly attended by various teams in the city. We have a session per day spanning 2 hrs(9-11 AM) and the time slots could vary for different teams. We would like to capture who attended the training camp on…
Sam
  • 8,387
  • 19
  • 62
  • 97
3
votes
4 answers

RFID Limitations

my graduate project is about Smart Attendance System for University using RFID. What if one student have multiple cards (cheating) and he want to attend his friend as well? The situation here my system will not understand the human adulteration and…
Zonah
  • 31
  • 1
2
votes
3 answers

Digital clocking systems/software? (employee clocking)

How does a digital clocking system deal with user error such as someone forgetting to clock out or someone erroneously entering their code causing them to clock someone else in/out (who might not even be on the schedule that day). Its obvious there…
Bill
2
votes
2 answers

How i can integrate fingerprint scanning device in a PHP application

I am working on an attendance system in PHP, attendance will be recorded with fingerprint device (SUPEREMA). how I will integrate auto attendance through scanning device, any help will be highly appreciated.
Khan
  • 5,052
  • 5
  • 22
  • 23
2
votes
1 answer

Getting a list of header columns where the value is true

I apologise if this question appears simple, but I'm having trouble making it work. I just want to know what days were each employee absent in the column G (the last column), for example I want it like: I tried to apply some MATCH/FILTER and…
user16580724
2
votes
0 answers

How to delete Unwanted data in attendance with Multiple In/Out

How do i delete multiple records of attendance ? I have tried Several Queries to delete the Unwated data. also verify state identify 0 = Time In and 1 = Time Out This is the sample Fiddle Expected Output : user_id verify_date …
Bap mop
  • 320
  • 2
  • 15
2
votes
1 answer

How to combine two rows of output of join query into one?

I have two tables Slot and Timetable Slot: slotID|startTime|endTime ------------------------ 1 |10:00:00|12:00:00 2 |13:00:00|15:00:00 Timetable: ScheduleID|slotID|subjectID|day ------------------------------- 1 |1 |subject1…
Ebenezer Isaac
  • 772
  • 1
  • 8
  • 31
2
votes
1 answer

How do I create attendance system in node.js mongodb, and express

I am trying to write an application which registers attendance for a day when I login and store it on MongoDB database. I can add time a timestamp or time when I login, but I'm having trouble storing only one login time for the day or only one…
Balkrushna
  • 41
  • 2
  • 9
1
2 3
…
10 11