Integrating with Lenel OnGuard via SQL or Other

[Cheyne]

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!

[SIW Editor]

Cheyne,
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.

Geoff

[Cheyne]

Thank you, Geoff. I greatly appreciate it. I am subscribed already.

-Cheyne

[SIW Editor]

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.

Geoff

[Cheyne]

Geoff,

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?

Thanks!

-Cheyne

[FabioPanunzip]

Cheyne,
I've been done such since OG 5.5 until 6.4.500 (lastest). It´s no hard at all.. pretty easy actually.
Example:
* 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.


Regards.

[Cheyne]

Hi FabioPanunzip,

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.

Thanks again!

Cheyne