BuildHr-CMS-Attendance 1.3.0
Integrate Biometric with BuildHr CMS App
Requires Python: >=3.6

# CMS Attendance 2.0

CMS Attendance used to sync Bio-Metric Attendance data from MS Access or MySQL to Contract Management System(CMS by BuildHr)

## Getting Started

An attendance management tool is a positive strategy to magnify productivity in any organization. CMS Attendance offers attendance device integrations that aid in accurate attendance management.

You can integrate your attendance device with CMS Attendance by making use of APIs. In order to sync your device's attendance entries with your employee's attendance records in CMS, you need to have a common format between your device and your CMS Attendance account.

## Prerequisites

There are certain pre-requisites for your attendance device to be integrated with CMS

We support MS Access and MySQL the same query format as mentioned below.

### Database Query Format

**Select employeeID, eventTime, isCheckin, downloadDate from Attendance**

- **employeeID** : Should be the same employee-id in CMS
- **eventTime** : Attendance In-punch and Out-punch
- **isCheckin** : 1/0 ( 1 denotes check-in and 0 denotes check-out)
- **downloadDate** : Date and Time at which the attendance data got pushed to database

### Python

We build this software with Python. So, you must need 64-bit Python in your system

**Microsoft Store**

- Go to [Python in Store](https://www.microsoft.com/en-in/search?q=python) and choose the `first` one
- Click on `Get`. Now open the browser dialog box with the message of Microsoft Store
- Click on `Open in Microsoft Store`
- Click on `Install` in Microsoft Store

**Others**

- Go to [Python Downloads](https://www.python.org/downloads/windows/) and choose your `os' 64-bit` installer under Files
- `Right click` on the installed file and choose `Run as Administrator`
- Click on the `Recommended Installation` and `Finish` the Python installation

**Install Python Packages**

After the successful installation. Need to install tha listed packages using `pip install <package>` this command in `Command Prompt`

1. [pyodbc](https://pypi.org/project/pyodbc/)
2. [requests](https://pypi.org/project/requests/)
3. [schedule](https://pypi.org/project/schedule/)

### ODBC Driver

Need to install ODBC X64 bit Drivers for [Access](https://www.microsoft.com/en-in/download/details.aspx?id=13255) and [MySQL](https://dev.mysql.com/downloads/connector/odbc/)

## Installing

**ZIP**

- First download CMS-Attendance [Zip file](https://github.com/BuildHR/CMS-Attendance/archive/refs/heads/master.zip)
- Then extract this ZIP to `C:\` folder.
- This is install with the name of `CMS-Attendance` folder in `C:\`

**Git**

- First open `command prompt` as a Administrator
- Then change the directory `C disk` via `cd C:\` this command
- Then install this via `git clone https://github.com/BuildHR/CMS-Attendance.git` command
- This is install with the name of `CMS-Attendance` folder in `C:\`

After the successfull download you need to copy the `CMS-Attendance` file to `C:\Users\<your username>\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup`

Note: If you haven't seen to the `AppData` folder. Then just enable the `Show hidden files` option.

Note: After installation complete you need to contact `BuildHr` for Quick configuration

## Authors

- **SS Subash** - _Developer_ - [SSSubash](https://github.com/sssubash)

See also the list of [contributors](https://github.com/BuildHR/CMS-Attendance/contributors) who participated in this project.