Adding events using external SQL server

MIP
, , ,
1

We have some biometric devices which are not compatible with Milestone, however I have access to the SQL database (named L1) that holds the time and attendance real time records. What i’m trying to accomplish is adding an alarm event in Milestone Corporate whenever certain people access the premises, using the time, date, employee ID & door name.

I tried adding a trigger that adds to Milestone’s database but have no clue which tables needs updating and don’t want to create a mess.

The following guide is very close to what is required…

http://download.milestonesys.com/MIPSDK/Samples/TriggerAlarmFromExternal-ConceptSolution.pdf

Just wondering if this is doable directly through SQL rather than developing a solution with the SDK.

2

I would not go directly to the SQL part - we might change fields or uptimize use of these.

I would suggest you send Analytics events to the Event server filled with relevant fields - and then make a Smart Client plugin that can interpret any extra fields and show these when the operator selects a preview of the event/alarm.

3

Thanks Anders,

Please explain how I could send to the Event server? or send a link that explains this part.

Again many thanks :slight_smile:

4

In the MIPSDK documentation, go to the getting started section on the left hand side and look for “Introduction to Analytics Events”