Page 1 of 1

Email text box/screen

Posted: Fri Apr 13, 2012 3:37 am
by BPJ
Hi.
In e-designer it is possible to create a text screen with values from tags in it, and email it to specified receivers when a tag goes high. Example: generating an daily text report with measured values of the last 24 hour. And also get a confirmation that the email was sent by setting a tag high.
It's a function that is very important for my customer.
How do i create this in IX.

Thank you in advance.

Bendt Johansen
Engineer
Vandteknik ApS

Re: Email text box/screen

Posted: Fri Apr 13, 2012 9:12 am
by mark.monroe
For iX Developer an earlier thread answered a similar question.

There are two pertinent examples included with iX Developer; Script_Email and Script_Database_Export. Those examples are in the Samples tab that you get when iX Developer first opens up. You need to look at the screen scripts as well as the script modules.
Snap 2012-04-13 at 09.00.34.png
Snap 2012-04-13 at 09.00.34.png (69.85 KiB) Viewed 9129 times
You can view the tables in the database by using the DatabaseViewer in the installation directory of iX Developer. The Database that you want to open and test your queries on is in the Temp/Output directory of your project in the PC and is called "Database.sdf".
Snap 2012-04-13 at 09.03.13.png
Snap 2012-04-13 at 09.03.13.png (46.48 KiB) Viewed 9127 times
Snap 2012-04-13 at 09.04.36.png
Snap 2012-04-13 at 09.04.36.png (157.29 KiB) Viewed 9126 times
What you want to do is create an email and add the data that you get from an SQL query to the email. The data can be from a trend view history or data logger. The data for both of those are stored in the database.

Re: Email text box/screen

Posted: Fri Apr 13, 2012 1:24 pm
by BPJ
Wow. That was fast. Thank you for your answer.
I will look at the examples you describe, and try to set it up.

Have a nice weekend