2026-09-24 23:35:59 Started EtimeofficeIntegration (PID 17188)
2026-09-24 23:35:59 Starting Etimeoffice Integration (PROINSTTECH)...
2026-09-24 23:36:00 Fetching data from: 8/27/2026 12:26:00 PM to 9/24/2026 11:36:00 PM
2026-09-24 23:36:00 API URL being called: https://api.etimeoffice.com/api/DownloadPunchData?Empcode=ALL&FromDate=27/08/2026_12:26&ToDate=24/09/2026_23:36
2026-09-24 23:36:01 Fetched 36 records from API
2026-09-24 23:36:01 Database connection established
2026-09-24 23:36:01 Error processing record 000114 - 31/08/2026 17:56:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=31/08/2026 17:56:00
2026-09-24 23:36:01 Error processing record PTPL-2 - 31/08/2026 12:46:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=PTPL-2, PunchDate=31/08/2026 12:46:00
2026-09-24 23:36:01 Error processing record 000114 - 31/08/2026 09:22:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=31/08/2026 09:22:00
2026-09-24 23:36:01 Error processing record 000114 - 29/08/2026 09:21:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=29/08/2026 09:21:00
2026-09-24 23:36:01 Error processing record 000114 - 28/08/2026 17:18:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=28/08/2026 17:18:00
2026-09-24 23:36:01 Error processing record 000114 - 28/08/2026 09:36:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=28/08/2026 09:36:00
2026-09-24 23:36:01 Error processing record PTPL-2 - 27/08/2026 12:26:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=PTPL-2, PunchDate=27/08/2026 12:26:00
2026-09-24 23:36:01 Error processing record 000114 - 19/09/2026 08:57:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=19/09/2026 08:57:00
2026-09-24 23:36:01 Error processing record 000114 - 18/09/2026 18:16:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=18/09/2026 18:16:00
2026-09-24 23:36:01 Error processing record 000114 - 18/09/2026 09:09:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=18/09/2026 09:09:00
2026-09-24 23:36:01 Error processing record 000114 - 17/09/2026 18:14:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=17/09/2026 18:14:00
2026-09-24 23:36:01 Error processing record 000114 - 17/09/2026 09:35:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=17/09/2026 09:35:00
2026-09-24 23:36:01 Error processing record 000114 - 16/09/2026 17:37:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=16/09/2026 17:37:00
2026-09-24 23:36:01 Error processing record 000114 - 16/09/2026 09:27:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=16/09/2026 09:27:00
2026-09-24 23:36:01 Error processing record 000114 - 15/09/2026 09:24:00: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Error: String was not recognized as a valid DateTime.
2026-09-24 23:36:01 Stack Trace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
2026-09-24 23:36:01 at System.Convert.ToDateTime(String value)
2026-09-24 23:36:01 at EtimeofficeIntegration.Program.InsertPunchData(List`1 punchRecords, String fromDateStr, String toDateStr) in D:\Projects\EtimeofficeIntegration\EtimeofficeIntegration\Program.cs:line 181
2026-09-24 23:36:01 Failed Record: Empcode=000114, PunchDate=15/09/2026 09:24:00
2026-09-24 23:36:03 Insert Summary: 8 inserted, 13 duplicates skipped, 15 errors
2026-09-24 23:36:03 Executing DailyAttendanceSync stored procedure...
2026-09-24 23:36:04 DailyAttendanceSync stored procedure executed successfully.
2026-09-24 23:36:04 Successfully inserted 8 records into database
2026-09-24 23:36:04 Done