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
1
vote
1 answer

Check in/out in attendance system using codeigniter

I am trying to build an online attendance system where employees sign in and check in daily except for weekends and vacations. so , my idea was to create a daily attendance record as a table in the database. Attendance_date_daily …
alkhamis
  • 49
  • 3
  • 9
1
vote
1 answer

Time & Attendance

As a part of a program I am working on I need a bit of advice. The problem: I receive a report containing employee clock records. I need to determine the first clock IN for the day based on a shift setup. For instance Shift A starts at 8:00am and…
Griffin
  • 79
  • 1
  • 11
1
vote
6 answers

Attendance Management System

I am looking for an open source Attendence Management System, I'd like to be able to customise functions. Please recommend some written in PHP. I am running BPO with around 20 employees. I want to track their daily check-in and check-out…
Bharanikumar
  • 25,457
  • 50
  • 131
  • 201
1
vote
2 answers

essl finger print u990 - How to retrieve the data through any language?

I need to fetch the records from eSSL finger print biometrics device. Does eSSL finger print use any database to store the data? How can I connect the Datasource and fetch the records through Java or any scripting language?
1
vote
1 answer

cant get ndb query results

i just started learning python ndb i want to know how can i display students attending a selected course (filtering Attendance) then mark their attendance with a ardio button for each student,add the attendance value to the preveious one and finally…
1
vote
2 answers

Time calculation past midnight

I have a table that stores clock entries in the following order. UID Clock Status === ===== ====== R01 2013-01-01 17:00:00 Clockin R01 2013-01-01 17:10:00 Clockin R01 …
Bladefreak
  • 331
  • 1
  • 6
  • 17
1
vote
1 answer

Split shift without shift schedule

I have got a table the capture the min/max time in the following format. 1 2012-10-30 12:13:07.000 2012-10-30 15:18:50.000 2 2012-10-30 16:13:07.000 2012-10-30 21:18:50.000 I was wondering if it is possible to capture 2…
Bladefreak
  • 331
  • 1
  • 6
  • 17
1
vote
3 answers

How I can capture Data from attendance machine

I have developed an online leave management system in PHP, MySQL, which is working fine, I have only one issue, we have to upload a csv file of daily captured data. I want to do it automatically. We have a Star Link Attendance machine. Star Link…
Saqueib
  • 3,484
  • 3
  • 33
  • 56
0
votes
1 answer

time attendance is incorrect if checkout time is more than 00:00

I want to make an attendance report of employees. If there any employees who scan checkout after 00.00, the data will go to the next date, I don't want it like that, because it will be difficult to report the number of hours worked for each…
0
votes
0 answers

TypeError: __call__(): incompatible function arguments. Invoked with: <_dlib_pybind11.shape_predictor object

I want to create an attendance system which first get the images of the people and when the person comes in front of the camera, it should store the attendance of the person with the date and time of the attendance. The code I am using for the image…
0
votes
1 answer

SQL Server Attendance Time In Time Out Issue

I am making time in time out attendance system. Example table i have i am just trying to set the value in first right in time and very right time out then i have calculated easily other entries are dummy i tried a lot but no help please see and…
0
votes
0 answers

Attendance in time and out time are on different days in [sql]

I'm a newbie in [SQL] Server; I have trouble to write a sql-query to create a table for [time-and-attendance] i am getting perfect output on in_time and out_time are on same day , but not getting in time and out time are on different time i Have a…
Rabees
  • 1
  • 2
0
votes
0 answers

User's Location not matching with current location

App Description: The AttendanceApp in React Native stores the user's location and status (IN/OUT) in AsyncStorage with the default status as OUT. On opening the app, the user sees a Check In button that triggers the Geolocation API (watchPosition or…
0
votes
0 answers

How can I find the check-in and check-out time using attendance data using Pandas?

Attendance: I am working on the attendance data as shown in the image, using pandas. punch_time is the time the employee checked in or checked-out. punch_state takes on two values i.e. 0 for check-in and 1 for check-out What I am trying to do is…
0
votes
1 answer

Convert sql Rows into Column using Pivot as shown below

I am looking to generate a report which is basically a attendance report using SQL query from table data rows; I have employee punch data as row in table with columns such as PDate | EmpCode | EmpName | PStatus | OT enter image description here The…