Processing the attendance data

0
Hi,    I am having attendance data which is getting generated from the biometric machine. the table structure is as below  UserId, DateTime, Mode (In/Out).    Data Example: usr5, 17/07/2025 21:45,in usr6, 17/07/2025 22:15,in usr1, 18/07/2025 8:55,in usr2, 18/07/2025 8:56, in usr3, 18/07/2025 8:45,in usr4, 18/07/2025 8:15, in usr5, 18/07/2025 7:45,out usr6, 18/07/2025 18:15,out  usr1, 18/07/2025 18:55,out usr2, 18/07/2025 17:56, out usr3, 18/07/2025 18:45,out usr4, 18/07/2025 17:15, out usr5, 18/07/2025 21:45,in usr6, 18/07/2025 22:15,in   I want to process the above data daily using scheduler to update the following structure UseId, AttendanceDate, inDateTime, outDateTime   Example Using above set date usr5, 17/07/2025, 17/07/2025 21:45 in, 18/07/2025 7:45 out usr6, 17/07/2025, 17/07/2025 22:15 in, 18/07/2025 18:15 out  usr1, 18/07/2025, 18/07/2025 8:55 in, 18/07/2025 15:55 out usr2, 18/07/2025, 18/07/2025 8:56 in, 18/07/2025 17:56 out usr3, 18/07/2025, 18/07/2025 8:45 in, 18/07/2025 18:45 out usr4, 18/07/2025, 18/07/2025 8:15 in, 18/07/2025 17:15, out usr5, 18/07/2025, 18/07/2025 21:45 in usr6, 18/07/2025, 18/07/2025 22:15 in   How I can achieve this ?   Regards Sudhir
asked
3 answers
0

Hi Saqib,

 

I not getting. Even I don't have idea to fulfill the requirement. 

 

Regards

Sudhir

answered
0

Hi sudhir,

             

1. Domain Model

  • RawAttendance entity with attributes:

    • UserId (String)

    • DateTime (DateTime)

    • Mode (Enumeration: In / Out)

  • DailyAttendance entity with attributes:

    • UserId (String)

    • AttendanceDate (Date)

    • InDateTime (DateTime)

    • OutDateTime (DateTime – optional)

2. Create Microflow ProcessAttendanceData

This microflow will:

  • Group raw records by UserId and AttendanceDate

  • Match each in with the closest out after it

  • Create a new DailyAttendance record

answered
0

Hi Sivakumar,

 

Kindly look into the usr5 and 6. On 17th their IN punch is at night 21:45 and 22:15 hours and their OUT punch is next day that is on 18th. 

 

How to derive this in MF ?

 

Regards

Sudhir 

answered