Editing URBIS BIOMETRIC DB SETUP

[[category:Tetra Clients]]
[[Category:Design Ateliers]]

                                 '''URBIS BIOMETRIC DB SETUP'''


[[image:Urbis-attendance.png]]


1- Biometric store data into MS-Access DB.


There is a script to import Data from MS-Access to Mysql.

Task Schedule of administrator. This script execute every hour. 

IP= 192.168.0.140

Script Name:-  getaccessdata2mysqldb.php

Location:- c://Timedesk/virdi
'''

On Concert/Porcupine Server:-'''

There is a script that Ipmort updated data from 140 machine(Win Xp) to Concert Server.

Location is= /var/w3/da/w3etc/cronjobs/run/studioR/getTimeDeskIOdata.php

# su – rajarshi

$ crontab -l 

# Sync TimeDESK data

45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1



== Setup Details of Win7 Machine ==

Biometric Detail:-

 Machine IP:- 192.168.0.140
 Operating System:- Win 7
 User:- administrator
 Pass:- password@123
 Mysql User:- root
 Pass:- password@345


1- Biometric device store data in Ms Access.
Access DB location :- '''C:\timedesk\Unis.mdb'''

2- We used a Php script to read data from MsAccess and Insert into MySql DB.

Script Location:- '''C:\timedesk\virdi\getaccessdata2mysql.php'''

3- We have scheduled it to execute per hour. check '''task scheduler'''.