Making the CiviEvent iCal feed show all events

Making the CiviEvent iCal feed show all events

With Green Renters we find the iCal feed from CiviEvent (part of CiviCRM) invaluable to keep track of events and workshops we have coming up, generally we use the feed pulled into our personal iCal and Google calendars for internal organising, currently the feeds aren’t available to anyone outside of staff.

We also have a variety of views feeds on our website pulling CiviEvents into several places based on various parameters, basically we have several things that need to be confirmed before we want events going live into public pages onto the website for people to view and register. Also, sometimes we have private events, that are only for a select group of people and not for the public to register. However, we would still like then to show up in our calendars so we know they’re coming up, we usually do this through marking events as ‘not active’ or ‘not public’.

CiviEvent’s default way of handling iCal feeds is to only show events that are public and active and I’ve been scratching around trying to fathom how to override this so we could get the information we need and continue working as we do.

In the end, it was one of those stupidly simple solutions that takes advantage of CiviCRMs php function override features, simply copy the ‘sites/all/civicrm/CRM/Event/BAO/Event.php’ file into your custom php folder, in our case ‘sites/drupal_site_folder/custom_php_folder/CRM/Event/BAO/Event.php’.

Then around line 754, depending on your CiviCRM version, find


  <em>WHERE civicrm_event.is_active = 1</em>
</div>


  <em>AND civicrm_event.is_public = 1</em>
</div>


  <em>AND (is_template = 0 OR is_template IS NULL)</em>
</div>


</div>

delete the lines</div>


  <pre style="border-style: initial; border-color: initial; ">

</pre>
  <div style="border-style: initial; border-color: initial; ">
</div>
  <div style="border-style: initial; border-color: initial; ">
  <em>WHERE civicrm_event.is_active = 1</em>
</div>
  <div style="border-style: initial; border-color: initial; ">
  <em>AND civicrm_event.is_public = 1</em>
</div>
  <div style="border-style: initial; border-color: initial; ">
  <em>AND</em>
</div>
</div>


</div>

Save the file. Make sure the Custom PHP path is set in /civicrm/admin/setting/path?reset=1 and all should be well and your iCal feed will be showing ALL events… Just make sure you don’t share it with all and sundry…