When deploying the attendance pull utility at a client location, the following process must be followed to ensure smooth data transfer from the client’s attendance database to the uKnowva system.

1. Machine Access & Environment Setup

• First, obtain access to one client machine (server) where the utility will be deployed.

• This machine must have network connectivity with the database server where the attendance data is stored.

• Install XAMPP on this machine with the latest stable PHP version .

2. Database Connectivity Setup

Case A – Attendance Database is MySQL

• A PHP script will be written to connect directly to the MySQL database .

• Once the connection is successfully established, the script will:

• Read attendance data from the required database tables.

• Convert the data into the required payload format .

• Call the uKnowva API and push the attendance data to uKnowva.

Case B – Attendance Database is MSSQL

• Required PHP libraries for MSSQL connectivity must first be installed (typically SQLSRV / ODBC drivers ).

• The Server/IT team will install and configure these libraries as per their environment.

• After installation, the server team will write a test PHP script to verify that:

• PHP server can successfully connect to the MSSQL attendance database.

• Once the connection is verified, the setup is handed over to the Development Team .

The Development Team will then:

• Write the script to read attendance data from the database tables.

• Convert the data into the uKnowva payload format .

• Call the uKnowva API to push attendance data.

3. Automation Setup

Once the script is ready and tested:

• The Server Team will configure a Task Scheduler / Cron Job .

• The script will be scheduled to run automatically at regular intervals (e.g., every 5 minutes) .

• This ensures that attendance data is continuously pushed to uKnowva without manual intervention.

4. Summary of Steps

The complete process can be summarized in the following steps:

1. Install XAMPP and verify connectivity from the client machine to the attendance database server.
2. Create a PHP script to establish database connectivity.
3. Development team writes the data processing script to read attendance data and push it to uKnowva via API.
4. Configure a scheduler to run the script automatically (typically every 5 minutes).

This setup ensures reliable and automated synchronization of attendance data from the client’s system to uKnowva.