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
2
votes
3 answers

SQL Query to return Month days as Columns and Total Hours as Row

i am working on an Attendance report were I need to create a SQL Query from one table to return the attendance of employees net hours worked over the month. Day of the month should be as a column and in the rows should be the total Hours of…
Osama Ashraf
  • 25
  • 7
2
votes
1 answer

ZKTeco set RFID Card with SetUser PHP

I am currently working on a project with attendance management system using attendance devices connected on LAN and i own the model SC700 of ZKTeco company. Unfortunately, the device isn't implemented with a web server, so the only way to interact…
GeorgeGeorgitsis
  • 1,262
  • 13
  • 29
2
votes
4 answers

How to Connect Attendance Punching Machine Using zKemKeeper in C#?

I am developing attendance software using asp.net c#, when iam trying to connect biometric device ( attendance punching machine ) using asp.net c# it shows the error Error: "Attempted to read or write protected memory. This is often an indication…
Surya
  • 157
  • 2
  • 7
  • 25
2
votes
2 answers

Calculate difference between rows for each day in month based on type

I want to export data for specific month (based on user input) from MySQL table, I wan't to calculate difference between created_at for each day in that month. attendance_id: 1 = arrival 2 = exit 10 = work from home When user gets to work his…
SuperManSL
  • 1,306
  • 2
  • 12
  • 17
2
votes
1 answer

SQL Query for time attendance for a month

Anyone can help with this one please? Our attendance system generates the following data: User Department Date Time Reader A1 IT 1/3/2014 11:12:00 1 B1 IT 1/3/2014 12:28:06 1 B1 IT …
user3495680
  • 21
  • 1
  • 4
1
vote
0 answers

ZKTECO SDK in java failed to init

Tried official SDK on ZKTeco in java but every time its unable or failed to initialize return -1 Failed to initialize the algorithm library . int ret = FingerprintSensorErrorCode.ZKFP_ERR_OK; //Initialize cbRegTemp =…
Jawad Rafiq
  • 58
  • 6
1
vote
0 answers

Read user fingerprint and assign to user - zk

I am using php zklib to manage zk time attendance machine. I am able to connect to device. What I need is I want to add a new user to the machine from system, I can add the user information using CMD_USER_WRQ. Now I need to invoke the device, so…
Munawir
  • 3,346
  • 9
  • 33
  • 51
1
vote
1 answer

How can I get absent days from ZKTeco device?

I have a ZKTeco K80 device, what I can get now are the logs data ( DateTime, InOut, VerifyMethod..) private void btnPullData_Click(object sender, EventArgs e) { try { ShowStatusBar(string.Empty, true); …
user14743092
1
vote
1 answer

How can I check student attendance in recurring google meet's?

I want to check the students attendance for all google classroom courses. As the meeting_code will be the same for each course (recurring), how can I figure out the attendance for each meeting? Which parameter can help me to solve that? Any…
lu.c.n
  • 31
  • 5
1
vote
1 answer

Google Sheets: COUNTIF in multiple rows but only ONCE if more than 1 in same column

POSTERS NOTE: This is similar to a post by MultiformeIngegno in 12/2016, except I need the answer across columns, not rows. ColA ColB ColC ColD ColE ROLES 11/1/19 11/16/19 …
naridox
  • 23
  • 5
1
vote
1 answer

Attendance system using Django

Models attendance_choices = ( ('absent', 'Absent'), ('present', 'Present') ) class Head_of_department(models.Model): first_name = models.CharField(max_length=200) last_name = models.CharField(max_length=200) email =…
Joel Deleep
  • 1,308
  • 2
  • 14
  • 36
1
vote
1 answer

jacob com.jacob.com.ComFailException: Can't map name to dispid: CardNumber[0] git hub ZkemSDK project

i am in project to connect with access control and attendance machine i found this project that connect to same type using java in github but in line that i want to Set CardNumber property i have an exception "com.jacob.com.ComFailException: Can't…
Hassan Ali Hassan
  • 17
  • 6
1
vote
2 answers

Auto-generated row on Microsoft SQL Server

I am currently working on fingerprint-based student attendance system. I am using Arduino Uno and fingerprint sensor to get student attendance record and store in SQL Server. I have a table called Attendance in my database which is storing student…
Conard
  • 31
  • 8
1
vote
1 answer

Trying to create an attendance system where picture is clicked for attendance.

So I have created this attendance system where you can add photos of each person and the person can click their photo and it will let you know that they have checked in. However I have a little issue. When you click on a photo, it says every person…
Davmarius Ndikumasabo
  • 19
  • 3
1
vote
1 answer

how to loop employee attendance using array_search to get current employees number of days attedance from data object

Here is my data { "data": [ { "firstname": "Amol", "lastname": "Auti", "emp_primary": "1", "emp_id": "1001", "company_name": "Maverick Solution", "id": "1", "in_time": "09:00:00", "out_time":…
Vishal Bondre
  • 64
  • 1
  • 6
1
2
3
…
10 11