Affiliations













Professional Affiliations


Contact Information

Odesta Automation and Engineering, LLC.
270 Doug Baker Blvd.
STE 700-382
Birmingham, AL 35242 

Phone: 205.677.0063
Fax: 205.623.0778

E-Mail:

sales@odesta.us



I/Gear

The information on this page pertains to Version 6.x unless specified otherwise.

Testing e-mail datalink

posted Jun 27, 2011 5:11 AM by Darren Ash

A really great, simple, SMTP server for testing with is the free PostCast server.  The free Download is located: http://www.postcastserver.com/Download/

It works really well.  It only runs when you launch it and it captures the outgoing mail where you can read it from the que.  Really helps in debugging an I/Gear email datalink before turning it loose on the network.

Trigger e-mail from query that ONLY returns data.

posted Jun 27, 2011 4:56 AM by Darren Ash   [ updated Jun 30, 2011 11:52 AM ]

This would consist of a database query that executes and you want to email that data if records are returned.

For the database table, create a dummy field that is a calulated value (not stored) that always resolves to 1, in this case the field name is "Mail".

For the database datalink input command you create a query and map the data to datapoints that are bound to the columns.

For the trigger, set it to custom triggering and it would look similar to the following:

{SQL Server.GetNewAlarms.TriggerColumn}(0) = 1 AND {SQL Server.GetNewAlarms.TriggerColumn}.RAWDATA.REFRESH


See attached example.

1-2 of 2