Page 1 of 1

Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 12:26 pm
by skigeek
1. I have created a new table called Email_TimeNotifications. It has the Frequency, Name, Active and Path. I have added a record to it.
2. I added a udb_property of TN_RecordTypes = "Email_TimedNotifications".
3. I created a Email_Notification_Rule - on RecordType = "Email_TimedNotifications"
Action=DailyNotifications,
Condition = "$Frequency eq "Daily"
Subject = "ClearQuest - $name"
Body = "<HTML><BODY>
<H2 ALIGN="Center">$name</H2>
RETURN_QUERY_RESULTS_AS_HTML_TABLE($Path)
</BODY></HTML>
***** To = When I put ES_GetSubscribersEmails() I get an error that this cannot be found. If I put a email address it works.

To execute it I use: cqperl timedNotification.pl foo "" BETSX XX DailyNotification

Re: Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 3:01 pm
by Pavel
Hi,

ES_GetSubscribersEmails() is a part of the EmailSubscription package.
Did you apply it to the schema?

Thank you,
Pavel

Re: Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 3:58 pm
by skigeek
Yes... It is.. Email notifications are working well. And ES_GetSubscribersEmails() is used for all other record types, just not for timed notifications.

Re: Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 4:15 pm
by Pavel
Hi,

Could you copy the error message, please?

Thank you,
Pavel

Re: Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 4:26 pm
by Pavel
Hi,

In the TimedNotification.pl, find the following line (line 25?):

Code: Select all

my @scripts = qw( UDB_Properties EN_Notification EN_Parser );


Change it to (add ES_Scripts section):

Code: Select all

my @scripts = qw( UDB_Properties EN_Notification EN_Parser ES_Scripts);


It should fix the issue.

Thank you,
Pavel

Re: Timed Notification Question/Problem

Posted: Fri Dec 19, 2014 6:15 pm
by skigeek
Yep... Fixed the issue.. Thanks.. You rock.