URBIS BIOMETRIC DB SETUP: Difference between revisions
| Line 54: | Line 54: | ||
2- We used a Php script to read data from MsAccess and Insert into MySql DB. | 2- We used a Php script to read data from MsAccess and Insert into MySql DB. | ||
Script Location:- '''C:\timedesk\virdi\getaccessdata2mysql.php''' | Script Location:- '''C:\timedesk\virdi\getaccessdata2mysql.php''' | ||
3- We have scheduled it to execute per hour. check '''task scheduler'''. | 3- We have scheduled it to execute per hour. check '''task scheduler'''. | ||
Latest revision as of 08:21, 9 December 2015
URBIS BIOMETRIC DB SETUP
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[edit]
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.