CiviCRM Community Forums (archive)

I want to create an event reminder template that will be sent out several hours or a day before an event that reminds people that they registered for an event.

The problem is that I cannot find any tokens in the 'User Driven Messages' template builder that relate to events.  I do however see several event templates in the 'System Workflow Messages' list, however I don't want to re-purpose those templates, but rather add a new one.

Is there an example or a way to send out a message that will reference an event that I can use with 'schedule reminders'?

Otherwise, I am forced to be generic in the email that I send out to event participants.


Thanks

Yeah, I am aware of how to create a reminder for a specific event.  The issue is that when you are creating several events a week across 3 continents, it would be nice if we could create a generic event reminder email that will go out with every event and remind registered participants several hours before the event.

Does anything like that exist?  Coming in a future release?

Yes, I can send a generic response to events.  That part was fairly straight forward.  I would like to reference the name of the event, date and similar in the email that goes out.  Similar to the way that you can insert a contact name and other custom tokens into the email.

I can see why that event tokens might not have been included, as it might have been difficult to identify the event for which the email was being generated.

What is confusing is that there were about 4 pre-built templates for events in 4.2 under the 'System Workflow Messages' that relate to event registration, confirmation etc.  It would be great it one was delivered for event reminders.

Thanks Lobo, that works!   

I think that adding these (and any others that are missing) to the 'insert token' would be much appreciated.

Hmm - event related tokens appear to be available via Insert Tokens pop-up in both 4.2 and 4.3. Screenshot attached. The one thing that isn't currently in place is filtering the available tokens based on the type of reminder (e.g. only show event related reminders if Entity for reminder is Event Type or Event Name.

The event summary token is not being populated on my site (Drupal 7, MySQL 5.5, php 5.3.19, Civicrm 4.2).   My code has the code used in the patch.  And when I print out the tokenParams in /CRM/Core/BAO/ActionSchedule.php my summary token is there.
How can I trace and find out where it's going wrong?

The event summary token is not being populated on my site (Drupal 7, MySQL 5.5, php 5.3.19, Civicrm 4.2).   My code has the code used in the patch.  And when I print out the tokenParams in /CRM/Core/BAO/ActionSchedule.php my summary token is there.
How can I trace and find out where it's going wrong?

The query which retrieves event info is assembled and executed around line 648 (in trunk version of ActionSchedule.php). So you could dump that $query variable, and run it in MySQL to see whether the 'summary' column has the expected data etc..

      $dao = CRM_Core_DAO::executeQuery($query,
        array(1 => array($actionSchedule->id, 'Integer'))
      );