Logically controlling the GPO outputs on an RFID Reader with a Stored Procedure

[Howie Heckman III]

If you setup a reader with a destination as your Stored Procedure you can use the number of rows that are modified within the stored procedure to be the value which triggers the correct GPOs. Configure the GPOs using the GPO tab on the Reader List. Add 1 GPO and configure it for the following settings:


- Set the port to whichever you are using 1, 2… etc

- Set the Alert type to be Destination Data Insert.

- Set the Port State to True.

- Set the duration for the length of time you’d like the device to be powered up.

- Set the Process ID to match the process you are configuring. If you only have 1, this will be '1'.

- Set the condition to the number of rows that will be affected by the stored procedure.


After you have this configured the reader will send the tag data to the stored procedure, and if the number of rows affected matches what you configured as the Condition for the GPO then the GPO will be powered up.

 

[JCSantaella]

Hello Howie,

Can you provide a sample of a SP to manage this GPO output. I'm not sure how to handle this.

Also would like to send an email alert when an item passes an entry point that is not an authorized item in my destination data.
Thanks in advance.
JC

If you setup a reader with a destination as your Stored Procedure you can use the number of rows that are modified within the stored procedure to be the value which triggers the correct GPOs. Configure the GPOs using the GPO tab on the Reader List. Add 1 GPO and configure it for the following settings:


- Set the port to whichever you are using 1, 2… etc

- Set the Alert type to be Destination Data Insert.

- Set the Port State to True.

- Set the duration for the length of time you’d like the device to be powered up.

- Set the Process ID to match the process you are configuring. If you only have 1, this will be '1'.

- Set the condition to the number of rows that will be affected by the stored procedure.


After you have this configured the reader will send the tag data to the stored procedure, and if the number of rows affected matches what you configured as the Condition for the GPO then the GPO will be powered up.

 

[JCSantaella]

Hello Howie,

Can you provide a sample of a SP to manage this GPO output. I'm not sure how to handle this.

Also would like to send an email alert when an item passes an entry point that is not an authorized item in my destination data.
Thanks in advance.
JC

After a few hours of working around it finally worked.

Thanks!

 

[Howie Heckman III]

Hi JC,

Did you get the email working as well?

I have not set that up in the past, but I believe you can use a sendMail function within a store procedure to send out an email when you need to.

Thanks.

 

[JCSantaella]

Yes, I managed to send email alerts using triggers on each database table, it creates records for each alert on a alerts table and a windows service sends all the email alerts pending every x minutes, seconds, etc.

JC