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

How to separate clock in and out from 1 same column in PHP

I have a little problem with the attendance machine in my office. I want to separate the time in and out which are in 1 column. I've tried so many queries in two weeks and i can't get what i want. I want to separate the values ​​from the…
Afrodyy
  • 1
0
votes
1 answer

Get one Clock In and one clock out time from a record employee table

In the attendance system, many users when uses the attendance device can commit mistakes when they imprint two times or more ( for the clockIn ) and two time or more ( for the clockOut) . So what I have is a table that get all records ( ClockIn and…
user14743092
0
votes
1 answer

SQL query in out time attendance each days

I'm a newbie in SQL Server; I have trouble to write this query. This is my sample data: | Id | date | time | +----+-----------+------------+ | 1 | 2020-11-1 | 07:30:00 | | 1 | 2020-11-1 | 15:50:00 | | 2 | 2020-11-1 |…
rohan
  • 1
0
votes
1 answer

Is there a Discord bot to check attendance to an event in the server?

I'm looking into hosting an academic event in Discord. I need a bot that can check the presence of the enrolled in each activity, an activity being to watch seminars and alike through discord screensharing, so the adm team can have a secure track…
Danielvisky
  • 41
  • 2
  • 7
0
votes
1 answer

Calculate timely attendance per month

I want to calculate amount of came on time or early of employee per specific date. But in the example i put specific USERID as additional criteria. This is my CHECKINOUT table (Total 39 rows): USERID CHECKTIME CHECKTYPE VERIFYCODE …
Dont Bullying Me
  • 89
  • 1
  • 9
0
votes
1 answer

Time Attendances SQL Query

I am currently struggling with writing an SQL Query. This is how my table looks like and where i want to retrieve data from: I want to write a query that has the following result: As you can see in the first table an employee can check IN and OUT…
Tan Nguyen
  • 21
  • 6
0
votes
0 answers

view sql produced by crystal reports

I am developing reports for a system using Workforce Time and Attendance. The system uses an Oracle database, Crystal Reports, and (I think) Business Objects. My reports use parameters. I want to know how those parameters are being used. Is…
dougp
  • 2,810
  • 1
  • 8
  • 31
0
votes
1 answer

Kizala response time in attendance card is not accurate when mark attendance

Kizala response time in attendance card is not showing accurate time with mark attendance. For instance, when I mark attendance at time 11: AM, it shows in the report 9:07 AM. Where can be the problem?
Haitham Desoki
  • 1
0
votes
1 answer

Attendance system in Django

I'm working on Attendance system in Django. but I'm facing some issue. model.py attendance_choices = ( ('absent', 'Absent'), ('present', 'Present') ) class AttendenceTable(models.Model): schedule_name = models.ForeignKey(ScheduleTable,…
Palwesh Sahu
  • 43
  • 9
0
votes
1 answer

Zkteco Time Attendance Terminal (K14) (Auto download logs to DB)

I'm using Zkteco k14 and the app that comes with it. The app comes with a feature that auto downloads Zkteco device logs to the DB. The bad thing is, it's only has 1 min. interval and it's kinda buggy. My question is. Is there a way or a script to…
phengcorn
  • 3
  • 1
  • 2
0
votes
1 answer

The Attendance data by excel file imported into the attendance module have been lost in Odoo 13. How to fix it?

I have successfully imported the attendance data into attendance data of 11/13/2019 by excel file. And I have successfully imported the attendance data of next day too. But the data of day 13 have been lost as you can see. How to fix it?
Leon Nguyen
  • 187
  • 1
  • 16
0
votes
3 answers

Odoo 13' solution to solve about the employee forget to checkout in odoo attendance

I would like to ask about the auto checkout in attendance odoo, because employees often forget to check out. Thus, I would like to mark their checkout automatically. How is the code and where I can insert this code? Thank you!
Leon Nguyen
  • 187
  • 1
  • 16
0
votes
1 answer

Failed to import file excel in Odoo 13. How to?

I'd tried to import file excel in module Attendance of Odoo 13. But I received the error: Import preview failed due to: year 0 is out of range. For CSV files, you may need to select the correct separator. Please help! Thank you!
Leon Nguyen
  • 187
  • 1
  • 16
0
votes
1 answer

Missing Import button in the modules of Odoo 13 on Ubuntu 18.04?

In Odoo 13 version, I saw the Export all button in the modules (Attendances, Employees...), but the Import button still invisible, after changing to the List View mode. What's wrong? Please help! Thank you!
Leon Nguyen
  • 187
  • 1
  • 16
0
votes
1 answer

How to import excel file in attendance module in odoo 12 community?

I'm trying to import an excel file in attendance module in odoo 12 community, but I cannot find the import button anywhere after going to Attendance -> Manage Attendance > Attendances? Even though I installed the base import module already. Please…
Leon Nguyen
  • 187
  • 1
  • 16
1 2 3
…
10 11