[OPEN-ILS-GENERAL] 3 day Courtesy Notice not being received

[Aaron Zsembery]

If you have SQL access, you can check if Evergreen is actually running the trigger.
You would look in action_trigger.event (for when the trigger runs) and action_trigger.event_output (for the actual text of the sent message).

Below is the query I use to look this up in our system (as set it will return any notifications emailed to or from bill.coffey at waynegov.com in the last 7 days):

SELECT action_trigger.event.id, target, event_def, add_time, run_time, start_time, update_time, 
       complete_time, update_process, state, action_trigger.event_output.data, template_output, error_output, 
       async_output, user_data, action_trigger.event_output.id, action_trigger.event_output.create_time, action_trigger.event_output.is_error
  FROM action_trigger.event
  LEFT OUTER JOIN action_trigger.event_output ON (action_trigger.event_output.id = action_trigger.event.template_output)
WHERE add_time > (NOW()- INTERVAL '1 week') AND data ILIKE '%bill.coffey at waynegov.com%'

You can also filter on event_def (which is the action trigger ID). In our case, if I wanted to ONLY grab Hold Available Notifications, I would add "AND event_def = 5" to the WHERE statement.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260

----- Original Message -----
> From: "Bill Coffey" <bill.coffey at waynegov.com>
> To: "Evergreen Discussion Group" <open-ils-general at list.georgialibraries.org>
> Sent: Wednesday, May 15, 2013 11:07:21 AM
> Subject: Re: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being received
> 
> I should have received 5 - 3 day courtesy notices myself.
> I am receiving Holds.
> I am waiting for the other late notices to verify that I will receive
> them.
> There is nothing going to any junk mail folder or being deleted by my
> email software i.e. Rules to move or delete.
> I am assuming that the same email daemon is sending all the emails
> using our email address wc.publiclibrary at waynegov.com as an alias.
> I am also assuming that the internet provider sees incoming emails as
> coming from wc.publiclibrary at waynegov.com
> 
> I do know that others are receiving holds, but not receiving 3 Day
> Courtesy notices.
> I do not know of anyone that is receiving the 3 Day Courtesy Notices.
> We are in the process of trying to see if anyone has.
> Thanks.
> 
> Bill Coffey
> Wayne County Public Library
> System Administrator
> 1001 E. Ash St.
> Goldsboro NC, 27530
> Bill.Coffey at waynegov.com
> www.wcpl.org
> Work ph: (919) 735-6249
> Fax: (919) 735-1824
> 
> 
> -----Original Message-----
> From: open-ils-general-bounces at list.georgialibraries.org
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On
> Behalf Of Sharp, Chris
> Sent: Wednesday, May 15, 2013 10:41 AM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being
> received
> 
> Bill,
> 
> Are you verifying that your email server has sent the notices?  We
> have found that there are times when email providers mark our sent
> emails as spam and patrons need to contact those providers to let
> them through.  The email server's own logs would probably show this.
>  I would start there, and if you see that the notices aren't getting
> that far, reply again.
> 
> Hope that's helpful,
> 
> Chris
> 
> ----- Original Message -----
> > From: "Bill Coffey" <bill.coffey at waynegov.com>
> > To: "Evergreen Discussion Group
> > (open-ils-general at list.georgialibraries.org)"
> > <open-ils-general at list.georgialibraries.org>
> > Sent: Wednesday, May 15, 2013 8:45:57 AM
> > Subject: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being
> > received
> > 
> > 
> > 
> > 
> > I have been receiving numerous complaints from patrons about not
> > getting a 3 Day Courtesy Notice.
> > 
> > They are getting the Hold notices, and at least the first late
> > notice,
> > I am still verifying the other late notices.
> > 
> > I have checked and triple checked the template and it is working
> > when
> > I test it in the local admin area for notices.
> > 
> > Has anyone had this problem and know of a way to fix it.
> > 
> > 
> > 
> > Thanks
> > 
> > 
> > 
> > Bill Coffey
> > 
> > Wayne County Public Library
> > 
> > System Administrator
> > 
> > 1001 E. Ash St.
> > 
> > Goldsboro NC, 27530
> > 
> > Bill.Coffey at waynegov.com
> > 
> > www.wcpl.org
> > 
> > Work ph: (919) 735-6249
> > 
> > Fax: (919) 735-1824
> > 
> > 
> 
> --
> Chris Sharp
> PINES System Administrator
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, Georgia 30345
> (404) 235-7147
> csharp at georgialibraries.org
> http://pines.georgialibraries.org/
>