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

cathytyner · ‎03-11-2015

Correction: I see the SysID in Parm1, not Parm2.

edwin_munoz · ‎03-11-2015

How are you running the transform?

Can you see the system log and search for "The quarter value is"

cathytyner · ‎03-11-2015

Good News Edwin, I think I figured it out. I used the following script to insert the field in my email body, and it works. This will do. It doesn't have to be in the subject.

lookup();






function lookup() {


var gr = new GlideRecord('u_classroom_codes');//going out to the custom table


           gr.addQuery('u_location', current.variables.location);


           gr.query();


           if(gr.next()) {


                   template.print("<p></p><b>Quarter     = </b> " + gr.u_quarter);


           }


}

Problem resolved. Thanks so much for your efforts. Very much appreciated.

cathytyner · ‎03-11-2015

I tried to edit my subject line in my email notification set up like this (see pic below).

"Classroom Codes data updated for ${u_classroom_codes.u_quarter}" in the subject line but that does not pull the field in from table "u_classroom_codes."

jamie_girouard · ‎03-11-2015

Cathy,

On the who will receive tab make sure "send to event creator" is checked or else you won't get the email.