Email text box/screen

[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

[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 (69.85 KiB) Viewed 9131 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 (46.48 KiB) Viewed 9129 times

Snap 2012-04-13 at 09.04.36.png (157.29 KiB) Viewed 9128 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.

[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