Attendance Data Pull Utility – Deployment Process (Client Environment)

  • Print
16 Mar 2026
18
0

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.

Was this Article helpful?