CiviCRM Community Forums (archive)

I'll let one of the core folks provide the real answer, but here are the outlines:
(1) CiviCRM does not currently provide this functionality.
(2) Most timed things are driven by a cron job, so basically a program would check every set time period (e.g. hour) and see what is coming up, and generate an email.
(3) This would be a great contribution to either code yourself, find someone to code for you, or hire someone to code.

writing a php script to do the above and putting it in a cron job is probably the easiest way to do this. Please share the code on the forum if you do so

lobo

After discussing with donald on IRC, donald told me that event notification will not be implemented in core but he will implement some hooks which will allow us to create them ourselves. For now i post my idea of implementing this as a drupal function inside civicrm.module.

function civicrm_cron() {
$key = "0";
$from = variable_get('site_mail', ini_get('sendmail_from'));
$result = db_query('SELECT civicrm_uf_match.email, civicrm_activity.subject, civicrm_activity.details
FROM civicrm_uf_match, civicrm_activity
WHERE civicrm_activity.source_contact_id = civicrm_uf_match.contact_id
AND status="Scheduled"
AND DATE(scheduled_date_time) = DATE_ADD(CURDATE(), INTERVAL -1 DAY)');
while ($row = db_fetch_array($result)) {
$subject = "CRM Reminder: ".$row['subject'];
$body = "Event details: \n\n".$row['details'];
drupal_mail($key, $row['email'], $subject, $body, $from);
$key++;
}
}

Currently this function only checks the civicrm_activity table (so it will only work for now for activity: event) . When drupal cron runs it will automatically run this function and send an email to the person who created the the activity. It will run only on an event which is set to "Scheduled" and will send an email one day before the event occurs" Currently there is no way to know if an event has been send or not so if you run cron mutiple times per day it will also send multiple emails per day.
If you want to use this function please remember to set cron to run just after midnight. It will then send an email to the person who created the event one day before. I will update the query tomorrow to also include the other activity's.

P.S. I'm not sure if civicrm_uf_match.email is the correct field to check for the user who created the event but it works in my situation.

-Carlo

Hi,

I finally got some time to spend on this so I created a Drupal module (sorry Joomla users).
Could somebody here please check it out and see if its working. If you see any code issues please let me know and I will update it.
If you have any feature request regarding this module please let me know and i will see if i can find the time to implement it.

You can find it here: http://issues.civicrm.org/jira/browse/CRM-2344

-Carlo

Hmmm... I created an issue just to be able to attach this module because the forum doesn't allow me to attach archives.
I tried it again and it still fails so I've had to upload it somewhere else. Get it here:

http://www.clict.nl/civicrm_notifications.tar.gz

-Carlo

Little update for this module:

• Changed the SQL query which should be correct now.
• Added variables to be used in the email template.
• Added some comments to the function.
• Cleaned up some code.

http://www.clict.nl/civicrm_notifications.tar.gz

Regards,

Carlo

Hi BioBen,

You are right, you can't find it anywhere in CiviCRM. civicrm_notifications is a drupal module and not a CiviCRM module.
If you go to your admin page inside drupal you should be able to find it. I haven't checked yet if it is properly working in 1.9, but if there were no database changes then it should work.

You should find the settings here: admin/settings/civicrm_notifications

Enjoy,

Carlo