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

PostgreSQL select for attendance between two dates

I'm imlementing attendance table report for date range: Student 01.12 02.12 03.12 04.12 05.12 06.12 STUDENT1 TRUE TRUE TRUE FALSE TRUE FALSE STUDENT2 TRUE FALSE TRUE TRUE TRUE TRUE My table : id_ student_ date_ present_
Nurlan
  • 505
  • 1
  • 4
  • 11
-1
votes
1 answer

MySQL pivot tables - rows to colums

This Query SELECT Student.StudentID, student.`Name`, attendance.Date, CASE WHEN attendance.StudentID IS NOT NULL THEN 'Present' ELSE 'Absent' END AS Attendance_Status FROM student LEFT JOIN attendance ON…
Ali Shaikh
  • 149
  • 11
-2
votes
2 answers

Time Attendance query in Microsoft access

I am having troubles with writing a query in Microsoft Access. This is how my tables looks like and where I want to retrieve data from: I want a query that has the following result: As you can see in the first table a user according to CHECKTYPE…
abed dak
  • 23
  • 5
-2
votes
1 answer

SQL Time Attendance Query

Recently I made a switch from MS Access to SQL Server. Due to this switch I am having issues with making one SQL query to work. This is how the current table looks like in SQL. This is what I am trying to get as result from the query: Previously…
Tan Nguyen
  • 21
  • 6
-2
votes
1 answer

MS Access SQL Query for time In/Out attendance

HI, I'm doing a project which involves time and attendance management. When I download data from the biometric reader, I got the records in the following format, Lunch Break & Work Time Problem Attendance Log Table Name: dbo_CHECKINOUT The user…
Deuk Roy
  • 15
  • 5
-2
votes
1 answer

Error while reading files: Exception in thread "main" java.util.NoSuchElementException: No line found

I have error call here time and date. I'm trying to add time and date specific file location because I want to list an time and date in file text so if I want to see the user attendance I can see the name, stuno, subject, section, time and date of…
HelpMeMahPrend
  • 3
  • 4
-2
votes
1 answer

React native fingerprint library with CryptoObject support

I am building an attendance application with React Native. The students will have to indicate their presence in school by scanning their thumbprint. I have seen several libraries that utilize the Android and iOS fingerprint scanners but none has…
Joshua Chinemezu
  • 36
  • 1
  • 5
-2
votes
1 answer

Attendance using smartphone hotspot

I wanted to build an attendance app (preferably iOS and android) where one phone shares hotspot. Devices connected to the hotspot will send the phone owner's name or ID that makes the hotspot phone recognize the phone users and adds one attendance…
샤딬하믿
  • 15
  • 1
-2
votes
1 answer

Automated attendance system using rfid mc522 with sms notification

can anybody guide me steps how to design an automated attendance system using rfid tags/cards and connecting it with a database with sms notification? i just need to know the steps. im using rfid mc522, arduino uno.
Hassan Rana
  • 1
-2
votes
2 answers

separate the check-in and check-out form a column datetime data type msssql

I need to separate the checkintime column as AM as checkin and PM as checkout;
Manikandan G
  • 11
  • 3
-2
votes
1 answer

VB.NET LISTBOX [in and out]

I was actually working an Attendance System, using listbox i want to monitor whether "employees" timed in or out. txtEmpNum.text as my textbox, rdTin as my radio button for time in, rdTout as my radio button for time out, lblName, lblDept, lblinout…
Bane Lim
  • 1
  • 2
-2
votes
5 answers

How to check best-attending employees of the year

This is my MySQL table: _______________________________________________ Id | Name| Employee id | Date | Attendance _______________________________________________ 1 | xyz | 196 | 2013-04-01 | present 2 | xyz | 196 |…
user2260431
  • 75
  • 1
  • 3
  • 14
-3
votes
2 answers

time attendance

can help me with iterating with python I have file: Sukirman 2011-07-01 09:53:43 Sukirman 2011-07-01 13:11:45 Sukirman 2011-07-01 16:36:03 Sukirman 2011-07-01 17:14:22 Sukirman 2011-07-04 12:16:40 Sukirman 2011-07-04 14:39:28 Sukirman …
prapto
  • 15
  • 2
-3
votes
2 answers

python calculate time attendance to file CSV

I have a csv file containing the pointing personal. of this…
Abdellah
  • 1
-3
votes
2 answers

what functions should I include in my application?

I want to define a time attendance system for government, and right now I am preparing a system requirement document, can someone give me some advices about what features/functions should I include in the system ?
MemoryLeak
  • 7,322
  • 23
  • 90
  • 133
1 2 3
…
10
11