Ivms 4200 Time Attendance Configuration
Taneka Tarring
iVMS-4200 software offers a wide range of features. One of these features is the Time & Attendance feature that allows for tracking the employee's attendance and amount of time spent working. This feature is very robust and the setup allows the user to adjust the settings in various ways. This document discusses the simplest setup, which allows for a FLEXIBLE SCHEDULE, meaning that the employee has the freedom of not being assigned to a certain set schedule. The employee can come in and leave anytime within the 24 hour day.
In order to setup time and attendance, an access control device must be added to the iVMS-4200 software. The beauty of the feature is that any of Hikvision's access control devices can be used for this purpose. After adding the access control device, employees must be enrolled in the software and assigned an access schedule (just like with a standard access control setup). The steps below show how to enroll a person and assign an access schedule:
In PERSON click ADD. The ID will be filled in automatically. Enter the user's name and select the gender. the other bits of information are not mandatory. Next, click the + to add a card number. A small window will appear. The card number can be entered manually, or can be enrolled by scanning the card at an enrollment station or the access control system's card reader (for this click settings and navigate to selecting the method).
Click ADD after the card number has been entered, and in the card area of the new user the card will apear with it's number written on it. Each user can have up to 5 cards. after adding the cards press ADD at the bottom to enroll the user.
In the newly emerged window enter a name for this Access Group, then select the template (all day access, all day deny, or a custom created one). select the persons that will be in the Access Group, then select the Access control device and the doors that will be assigned to these persons. Click SAVE.
After creating the Access Group, put a checkmark next to it, then click APPLY CHANGES TO DEVICE. A new window will appear showing the progress. After the changes have been applied, close the progress window.
IMPORTANT: The EXPIRY DATE in this case is more akin to "validity period". For any type of report calculation, the person's shift expiry dates need to include any date that reports need to be made for. While calculating one or more persons' attendance, if intended report dates fall outside of any person's EXPIRY DATE, the iVMS-4200 may hang and require restart as of v3.4.0.9.
After setting all these settings, it is time to select the Access Control device and reader that will serve as the checkpoint. By default the software has all access control readers acting as checkpoints, and since in the FLEXIBLE SCHEDULE setting only the first and the last card swipes (or fingerprint scans/face scans/pin codes...) determine the attendance, it is advised to leave that setting on, otherwise it can be changed under ATTENDANCE CHECKPIONT submenu:
By default, the software will calculate the employee's attendance at 1:00AM, but it can also calculate it manually. To calculate the attendance manually, go to TTENDANCE STATISTICS -> CALCULATION and CALCULATE to calculate the attendance for all, or enter the employee's name or ID number to only calculate the attendance for the particular employee:
The Windows-based iVMS-4200 is a versatile client software application for Hikvision video surveillance, access control and video intercom systems. There are modules for live view, playback, event management, e-maps, attendance and smart device data reporting, such as people counting, queue analysis, heat mapping, license plate recognition and facial recognition. The client software is widely applied to small-scale projects. Each client installation is configured, maintained and operated independently. The client software is free to download and use, and support is available for free.
IMPORTANT! This model requires non-standard firmware. Do Not Install standard firmware (e.g. v.4.1.xx) on this model. Doing so will permanently damage your system. You must use custom firmware v.4.1.25 from the iDS-9632NXI-I8/16S product page.
The I-series NVR (such as the DS-7716NI-I4) is one of Hikvision's most popular and feature-rich recorders. As such, many firmware revisions have been introduced over the years to continually ensure the product is compatible with the newest technology available. Due to the many revisions, we recommend that the user closely follows the instructions below in order to reduce the amount of time spent as well as the chance of failure.
As more affordable IP cameras are introduced over time with greater video resolution and data sizes, more efficient database management also becomes necessary. The introduction of firmware v4.0 brought about a new database architecture in order to be futureproof.
After upgrading to v4.X, the recorder database will need to be converted and optimized. If you are experiencing issues where playback is expected but not found, make sure "Database Repair" is performed as indicated in the procedures and scenarios below.
View the most updated version of this document here:
K-Series DVR upgrade instruction
The Turbo 4 Hybrid DVR K series has multiple models and across different platform and chipset. It also has similar firmware development of other recording product line; DVR K series has also introduced the GUI4.0 to ensure the series to be compatible to the newest technology available. The new database architecture is also brought into the DVR firmware v4.0 to be future proof and for better recording search experience.
As more affordable cameras introduced over time with greater video resolution and data sizes, more efficient database management also becomes necessary. The introduction of firmware v4.0 brought about a new database architecture in order to be futureproof.
After upgrading to v4.X, the recorder database will need to be converted and optimize. If you are experiencing issues, where playback is expected but not found, please make sure to perform "Database Rebuild" as indicated in the procedures and scenarios below.
If the data has not been recorded or has been overwritten, Database rebuild process is not able retrieve those lost data. Have the system upgraded to the latest available firmware version above to prevent any future data lost is strongly recommended for all application.
iVMS-4200 series software tools are designed to configure and manage Hikvision devices in a unified and intuitive manner, including DVRs, NVRs, IP cameras, IPD, DVS, alarm and access control devices, and storage devices, providing functionalities like live view, playback, device parameter configuration, and more.
iVMS-4200 AC Client Software is designed for all your access control needs. The first version comes with powerful access control functions, including time and attendance records, video intercom services, attendance report exporting, status monitoring, real-time alarms, event retrieval, and more.
The iVMS-4200 Mac version is designed for a Mac system. It features real-time live view, playback, E-Maps, and alarm processing modules. Compatible with Hikvision devices, it meets critical requirements for small-sized projects, such as small supermarkets, apartment buildings, and much more.
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.
Integration can be done with any of these databases: MS SQL Server, MS Access and MY SQL. The data from the biometric should be automatically downloaded into the database. Query has to be generated in the following format to fetch data from the database.
If MS Access -> copy the sample path mentioned below the Connection URL and replace the path with the actual path of the database and replace '\' with '//' and at the end enter the access file name followed by its extension.
Select > SQL Server Network Configuration > Protocols >TCP/IP - Enable, then click on TCP/IP, pop-up will be opened, Click on IP address, scroll down at the end change the port number if it is 0, else copy the port number and paste it in connection url. At the end of the url after the port number, the database name has to be entered.
Note: For MS Access, database should be available in the local system. For MS SQL and MY SQL, if database is located in the remote system, enter the IP of the remote system in place of localhost in the connection url.
If downloadDate column is present in the database - minimum of 2 mins can be set. Delay time refers to the time at which the timer should be running in the plugin page and it is the time till the sync happens from the Last Updated Time in the plugin page.
Enter the corresponding query to fetch the details from the database. Sample queries will be available below the query editor. Query can be modified as required to fetch the data in the required format.
select [Id] as employeeId, case [Checkin] when 'IN' then 1 when 'OUT' then 0 end as isCheckin ,[CheckedTime] as eventTime ,[DownloadDate] FROM [ZAttendance].[dbo].[Att-checkin] where DownloadDate>=$1 and DownloadDate
Note: If no checkin/checkout differentiation is available in the database, as in the query above each punch will be pushed to Zoho People Attendance as both checkin and checkout. In this case, the Total Hour Calculation(Attendance > Settings > General Settings > Working Hours) can only be First checkin & Last checkout.
Manual pushing of the data has to be done by selecting the date range and then by clicking on fetch and upload for the data to be pushed to Attendance. Status code 200 refers to the successful sending of the data. In order to check the detailed response, open Tomcat > Logs > Current date Catalina file > see the response.
4a15465005