Email notifications: Getting multiple emails for every record auto-updated in a table, just want 1 email

[cathytyner]

Hi all!

I have a custom table u_classroom_codes with 86 records. Every 3 months I replace data in the table with a scheduled data import. I have an email notification set up so that I receive an email letting me know that the table has been updated with current data. I get 86 emails. I assume I'm getting one email for every record that has been updated. I just want to get one single email so that I know the table has been updated. Can someone suggest how to setup my email notification correctly? Below is a screen shot of how it is currently set. Please note I'm a newbie with no scripting experience.

I think the problem is that the table I selected within 'Email Notifications' is my table with 86 records. The notification is doing as it's told and alerting me every time a record is updated. Maybe I can select a different table such as one that that will only have one records which updates upon my successful data load or maybe when my scheduled job has been completed...?

Components:

• Table: u_classroom_codes (always 86 records)
• Data Source: auto_load_classroom_codes
• Table Transform Map: Auto Classroom Code load
• Scheduled Data Import: Classroom Codes
• Registry: classroom_codes_update.completed
• System Policy > Notifications: "Notify that Classroom Codes table data updated"

Much thanks!!

Cathy

[edwin_munoz · Accepted solution]

Hello Cathy,

You can follow these steps to get the notification you want.

1. Create event in System Policy -> Events -> Registry

      Name: classroom.import.completed

      Table: Import Set

2. Go to the Auto Classroom Code load transform map and select the Transform scripts tab. Create a new transform map script:

      When: onComplete

      Script:

gs.eventQueue("classroom.import.completed", import_set);

3. Edit your notification to be sent when an event is triggered and select the classroom.import.completed event.

EDIT: Maybe you don't have to create a new event and you can use the one you already have.classroom_codes_update.completed.

Who should receive this email? is it always going to be you? or the person who runs the import?

[cathytyner]

Thank you everyone! I understand the concept now. I just tried this and I did not receive an email. Below are my steps. Let me know if you see an obvious newbie mistake!

1. Table Transform Map: Auto Classroom Code load - onComplete script added:

2. Event set to Table Import Set:

3. Notification changed to trigger from event rather than updated records:

I assume the Table selected here should not matter?

Currently the email is just being sent to me. But will eventually add a group once I get it working right.

I then executed my import, which should have completed and triggered the event, which should have sent an email. I checked the event log and I do see that my event classroom_codes_import_completed ran successfully (correct time stamp).

Check email and email logs - no email.

So, I'm still stuck but almost there! Any ideas?

[edwin_munoz]

Hello Cathy,

It seems that you are on the right track, The table in the notification does matter but you have it right, it has to be the same as in the event.

I think the problem is that the only recipient of the email is you, I have had this issue in the past, for some reason emails were not sent to me. Could you please add another user in the recipients list? just to see if you are having the same issue.

[cathytyner]

Thanks again for your reply!

Added a second user in notification, executed import, checked that the event was successful in event log, waited a few minutes, checked email logs for a while, still no email for myself or other user.