View Full Version : Integrating with Lenel OnGuard via SQL or Other
10-26-2010, 05:02 PM
Does anyone have experience in modifying existing cardholder data in Lenel OnGuard via custom SQL scripts or any other way? I need to change the badge number of every cardholder in Lenel and am trying to do so without having to backup, remove and re-create their account.
Any thoughts? Great thanks in advance!
10-27-2010, 12:59 PM
I'm going to email this question over to some people at UTC's Lenel division. I'd recommend that you subscribe to this thread/post, because it may take a little bit of time before my email winds up on the right person's desk.
10-27-2010, 01:57 PM
Thank you, Geoff. I greatly appreciate it. I am subscribed already.
11-12-2010, 10:53 AM
Cheyne, did you ever get a message from anyone on this? I know some folks from there read it, but I wasn't sure if you were contacted off-line about it.
11-12-2010, 11:48 AM
Not yet. I did, however, determine that we did not purchase the licenses for DataConduIT and DataExchange. But I am still very curious whether there is a way to add\update\delete data in the database via SQL or other?
12-06-2011, 12:10 PM
I've been done such since OG 5.5 until 6.4.500 (lastest). It´s no hard at all.. pretty easy actually.
* How to get a Badge ID from a Cardholder:
select b.id from badge b left join emp e on b.empid = e.id where lastname = 'requiredName'
* Having the Badge ID, you can:
update badge set ID = newID where id = oldID (got from previous query).
You can do this with no problem because there´s a field called BadgeLink that controls the relationship from Badge ID and the Access Levels, but the updated information IS NOT downloaded to Access Panel/ISC (That´s why Lenel sells DataConduIT).
If you need something that needs to update DB once or twice a day maybe a post action (Download DB) may not be a problem... once a month: no problem at all (on "small" systems).
If you need to modify data only once (ie: changes on ERP system that needs to be propagated to Onguard), let me know. I can help you with queries regarding: cardholders, badges, access levels, visitors, visits, readers among others.
12-06-2011, 01:27 PM
Thanks for your assistance. That was the crux of our issue: trying to avoid having to download the database to the panels whenever we made a change to a cardholder's account via an SQL statement such as the ones you mentioned. I would need the new data pushed to all the panels immediately upon executing the custom SQL script.
We are considering moving to RS2 very soon anyhow, so I have just been using System Admin to make these changes until that point.
Powered by vBulletin® Version 4.1.9 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.