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

cathytyner · ‎03-11-2015

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 · ‎03-11-2015

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?

View solution in original post

edwin_munoz · ‎03-11-2015

Creating an email notification on Event table might not be the best approach since the condition in the notification is going to be checked every time an event is created.

In my last post you will find how to implement a solution that looks a little cleaner.

jamie_girouard · ‎03-11-2015

Edwin's spot on. I've used his approach in the past to be alerted when import sets complete and it works like a charm.

Simply add an event in the registry for the completion of your import, an onComplete transform map script to trigger the event, and a notification run when your event is triggered.