Even after several changes in requests during the process - everything has been completed.
I recommend for collaboration!
Refinement of the report export on working hours
Goal:
To receive every day in the morning and evening according to the schedule a file in xlsx or xml format with a specified format list.
Source:
Access Control System (ACS)
U-Prox
Employee Registration Program
U-Prox
Documentation is available at the link
https://access.u-prox.systems/uk/zavantazhennja/
Task:
Create a process that can be placed in Windows Task Scheduler, which will create a query to the registrar's database (MSSQL) and export data into a table in a column format by employees:
| Day | Month | Year | Employee ID | Full Name | Department | Position | Working Hours | Start | End |
During the export process, check if a person forgot to clock in or out after the shift, round the value to the nearest whole number of hours per shift (9)
Save the file in a local folder with the name-date and time of data export
2024-09-16_11_48.xml
An example file with columns is separately available.
PS. Details and additions will be sent personally
Budget: 4000 UAH Deadline: 5 days
Good day. Extensive experience working with similar automation scripts. Please write in more detail what needs to be implemented.
Budget: 500 UAH Deadline: 1 day
Hello
Send the video in private messages. For greater clarity of the task
Budget: 500 UAH Deadline: 2 days
Good day!
Interesting task, let's communicate.
I set the price conditionally, as there are still many questions that need to be clarified.
Budget: 2000 UAH Deadline: 2 days
Hello, Yaroslav!
I am an expert in PHP and have significant experience in data processing. I propose to create an automated processing system that will generate a report from the access control system daily in XLSX or XML formats. I will solve the issue with rounding working hours so that you always have up-to-date data. The file will be saved with the name of the date and time for convenience.
I look forward to your response!
Vasyl. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐
Client Management & CRM 12 proposals 31 July
31 proposals 30 July
17 proposals 27 July
Client Management & CRM 41 proposals 27 July
Enterprise Resource Planning (ERP) 43 proposals 20 July