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

How to do a calculation with a column in database and insert the result Codeigniter

Basically i have to count the monthly meal allowance for each of the employee based on their monthly attendance, which only leave me with just one table, attendance table The calculation for the meal allowance is pretty simple, i only need to count…
Team
  • 55
  • 9
1
vote
2 answers

Attendances query in Microsoft Access

this is my first time posting a question on this forum. I have been struggling with writing a query in Microsoft Access for a week now and I hope someone here can help me out. I am building a time attendance application using fingerprint in vb6.…
Tan Nguyen
  • 21
  • 6
1
vote
1 answer

select 1 row into 2 column query postgresql

I have table like this user_id | date | time| "1" | "2017-01-03"| "06:59:35" "1" | "2017-01-03"| "07:01:17" "1" | "2017-01-03"| "12:03:21" "1" | "2017-01-03"| "16:06:14" "2" | "2017-01-03"| …
willy andika
  • 83
  • 8
1
vote
1 answer

Comparing multiple adjacent cells - Excel Worksheet

I hope this is not a duplicate. I have an attendance tracker in Excel. The columns are days of the year (1/1/2018 - 12/31/2018 from B to NB) and the rows are employees names. Days off are identified as V = Vacation, S = Sick and O= Scheduled day…
Adam Malbon
  • 13
  • 4
1
vote
1 answer

Add user with card numer to ZKTime Device

I'm using Python 2.7, and I use PyZk to communicate with ZKTime (Time Attendence software) on Linux OS, And I can't set user with 'Card Number'. Below the method that allows to add a user in the device, how can I add the card number for…
Abdelmajid ELHAMDAOUI
  • 325
  • 1
  • 9
1
vote
1 answer

Conversion failed when converting date and/or time from character string vb.net

Can't seem to find other way to convert this: sql = "insert into Attendance values('" & Label1.Text & "','" & Button1.Text & "','" & Date.Today & "','" & TimeOfDay & "','null' ) Label1.Text is EmpID from Employee Database Button1.Text is status…
Karen Poscablo
  • 19
  • 1
1
vote
0 answers

Staff Attendance Registry Query MS Access

I am doing a Staff Attendance Registry using MS Access and have these fields for the Time_Registry Table: ID (Autonumber) EMPNO (Employee Number) AttendanceDate (Date) TimeIn (Time) Timeout (Time) Remarks (String). Now, I wanted to do a report…
Jian Carlo V. Rubio
  • 35
  • 4
1
vote
2 answers

block user with zkemkeeper.dll

I am working with biometric device (attendance device) with the sdk support zkemkeeper.dll I fetch the attendance from ZKTeco biometric device sucessfully, but when i am trying to block user, the code executes successfully, but the user is able to…
anandd360
  • 298
  • 3
  • 14
1
vote
3 answers

How to Construct a Single Row from a Multi Row Subset in SQlLSERVER

I have a situation where employees have time-in , and time-out but they are saved into a single column with a type [in =1 ,out = 2], I need to fetch a single employees time (in-out) in a single row separating with Time-In, Time-Out headers. Here is…
DareDevil
  • 5,249
  • 6
  • 50
  • 88
1
vote
1 answer

VBA Programming. Error or Prompt will appear in Userform if field in sheet already has content

I wanted to have a code wherein there will be an error or prompt in the userform if the cell in the sheet- wherein the data will be transferred, already has content. As of now, the code I'm using doesn't show any prompt but it succeeds in not…
Chenille Masangya
  • 43
  • 3
1
vote
0 answers

how to store remote biometric (essl) logs to remote mysql database?

i'm working with bio-metric(essl) to store the logs directly to mysql database. i have 20 bio-metric machines in different locations and want to store the logs of 20 machines to a centralized mysql database. PHP
venu gopal
  • 47
  • 4
1
vote
1 answer

Getting first time-In and last time-Out covering the following day based on a date Collection using linq

I am having a problem getting structured First Entry and Last Entry on the Biometric reading when it exceeds the following day when the user time out. But if the time in and time out is on the same day i can get it formatted the way i want.. here is…
ECie
  • 1,265
  • 4
  • 21
  • 50
1
vote
1 answer

python struct unpack: Int PIN; char verified; time_t time_second; char status;

I am trying to unpack the following struct from binary data received via UDP from a time attendance clock device(DeviceName=TA8020): typedef struct _AttLog_{ Int PIN; //U16 PIN, user number char verified;// verifying method time_t time_second;…
vibration
  • 45
  • 1
  • 5
1
vote
1 answer

PHP simple calendar with attendance system

I'm designing a simple attendance system with calendar using dreamweaver, xampp. I already have the user/admin login page and also the registration page. What I'm trying to do now is how can I make the days on this simple calendar clickable? I mean…
Rhatz
  • 33
  • 1
  • 4
1
vote
2 answers

How to calculate the night working shift in SQL server?

I'm using Fingerprint system to record the IN OUT log of all employee in 4 shifts .Normal shift(08:00-> 17:00) , Shift 1:(06-> 14:00), Shift 2: (14:00-> 22:00) Shift 3:(22:00-> 06:00 tomorrow) . I have 2 main table : When I use the left join…
Cát Tường Vy
  • 398
  • 6
  • 32
1 2
3
…
10 11