Attendance Device Integration

Attendance Device Integration

An attendance management tool is a positive strategy to magnify productivity in any organization. Zoho People offers attendance device integrations that aid in accurate attendance management.

You can integrate your attendance device with Zoho People by making use of APIs. In order to sync your device's attendance entries with your employee's attendance records in Zoho People, you need to have a common format between your device and your Zoho People account.

There are already two parameters identified which are employee ID and email ID. In the absence of these two parameters, you can sync the unique ID  with your Zoho People account. Here is the list of APIs to integrate your attendance device with Zoho People. 

User ID mapping

  • From Home, go to Attendance > Settings > User ID Mapping > Add User ID Mapping
  • Provide Employee ID or Employee Name and Mapper ID

  • Click Add  

Pre-requisites

There are certain pre-requisites  for your attendance device to be integrated with Zoho People

We support MS SQL Server, MS Access and MYSQL database and the same query format as mentioned below.

Query Requirements:

Please generate the below query format in order to fetch the information from your MS SQL server database.

Please find the sample table schema attached below for your reference

Software that needs to be installed:

Please have the below-mentioned software readily installed in your server system where the database is located.

For Apache Tomcat 8

  • Go to https://tomcat.apache.org/download-80.cgi
  • Click on 32-bit/64-bit Windows Service Installer Under Core

For Java 8

  • Go to http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
  • Download a JDK file under Java SE Development Kit 8u121 that suits your windows configuration
  • From Home, go to Attendance > Settings > User ID Mapping > Add User ID Mapping
  • Provide Employee ID or Employee Name and Mapper ID
  • Click Add  

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohopeople.com