URBIS BIOMETRIC DB SETUP - Revision history

Biswajit: /* Setup Details of Win7 Machine */

2015-12-09T08:21:34Z

Setup Details of Win7 Machine

← Older revision		Revision as of 08:21, 9 December 2015
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'''.

Biswajit: /* Setup Details of Win7 Machine */

2015-12-09T08:20:25Z

Setup Details of Win7 Machine

← Older revision		Revision as of 08:20, 9 December 2015
Line 51:		Line 51:

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

	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'''.

Biswajit: /* Setup Details of Win7 Machine */

2015-12-09T08:19:36Z

Setup Details of Win7 Machine

← Older revision		Revision as of 08:19, 9 December 2015
Line 42:		Line 42:
	Biometric Detail:-		Biometric Detail:-

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

Biswajit at 08:18, 9 December 2015

2015-12-09T08:18:37Z

← Older revision		Revision as of 08:18, 9 December 2015
Line 35:		Line 35:

	45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1		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.

Biswajit at 06:31, 7 November 2015

2015-11-07T06:31:16Z

← Older revision		Revision as of 06:31, 7 November 2015
Line 22:		Line 22:
	'''		'''

	On Concert Server:-'''		On Concert/Porcupine Server:-'''

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

Biswajit at 06:30, 7 November 2015

2015-11-07T06:30:08Z

← Older revision		Revision as of 06:30, 7 November 2015
Line 3:		Line 3:

	'''URBIS BIOMETRIC DB SETUP'''		'''URBIS BIOMETRIC DB SETUP'''


			[[image:Urbis-attendance.png]]

Biswajit at 06:05, 7 November 2015

2015-11-07T06:05:08Z

← Older revision		Revision as of 06:05, 7 November 2015
Line 1:		Line 1:
	'''URBIS BIOMETRIC DB SETUP'''		[[category:Tetra Clients]]
			[[Category:Design Ateliers]]

			'''URBIS BIOMETRIC DB SETUP'''

Pramod: Created page with " '''URBIS BIOMETRIC DB SETUP''' 1- Biometric store data into MS-Access DB. There is a script to import Data from MS-Access to Mysql. Tas..."

2015-11-06T09:27:48Z

Created page with " '''URBIS BIOMETRIC DB SETUP''' 1- Biometric store data into MS-Access DB. There is a script to import Data from MS-Access to Mysql. Tas..."

New page

'''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 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