CiviCRM Community Forums (archive)

you might want to watch this: http://www.drupaltherapy.com/node/76 and see if that helps you suss it out

lobo

Drupal's calendar module only works with Drupal nodes, so in a way it's both a civi & a drupal thing as civi events are not drupal nodes.   You need to import events into drupal from the ical feed, http://wiki.civicrm.org/confluence/display/CRMDOC/Using+Drupal+Calendar+with+CiviEvent

Prior versions of the Calendar module allowed you to point it to an external iCal feed (such as the one that CiviEvent spits out). If there's a way to get that feature "back into" Calendar - that seems like a reasonable approach (and generally useful for many use cases where a Calendar user wants to integrate dates from various applications / sources).

Ok, say I'm confused - but what is the best way to wire up CiviEvents to be displayed in a calendar view using Drupal 6.X and CiviCRM 2.X?

Any example you can find are Drupal 5.5 and CiviCRM 1.9 or talk about setting up your own Drupal events.

Help!

Ken

Hi,

There are two threads on this topic the other is here:

http://forum.civicrm.org/index.php/topic,5804.msg25436.html#msg25436

To summarise the ICS method does work although there's a bit of mucking around (e.g. configuring links to connect to the civicrm event not the Drupal node) but currently doesn't work if viewing events are restricted to logged in users.

The other method involves someone putting a bit more time into work already in progress to allow the civicrm events date field to feed directly into the calendar. I think it may not be that much work and would be a better solution as Ed says but it does require some input from the civi end to fix it up & get it going.

Gotchas on the ICS method - make sure you get your feed_mapper module patched up properly (patch 9 at the moment - ignore 10) & one other module needs patching - ? check the thread . Set your drupal permissions for the feed object before starting, use datetime fields to map to, map the vevent to the datefield's top level (don't map all the little bits & pieces) & watch the drupaltherapy screencast on setting your date arguments if you are not sure, don't forget to refresh the feed content item to get things to happen & test using a known good feed - i.e. test it in your browser when not logged on first. If you get an ical parser error relating to line 101 of code it's the feed that is the problem.

You need to create two content type, - your event item & your feed item. Don't select 'show in calendar' - this relates to the 'events' method for the events calendar. You then create a content item for the feed type and enter the feed url & the field mappings against this. When you hit refresh they should be created

I haven't gone down to code level but it looks like there's some beta patches to try to open up the calendar integration but see comment 1 here

http://drupal.org/node/385880

I think civi does call a civi date handler - I don't know how it compares with the calls being made in that code

I'll submit a civicrm patch soon, with everything you need.  Here's the summary.  First you need make the change in this patch to the Drupal Date API, http://drupal.org/node/453688

Next, add the code above plus this below into civicrm.views.inc.  This is the call to hook_date_api_fields.  further in order to get all the benefits of the Calendar Module import the pasted below the hook_date_api_field code.  You can simple set the style of the view to Calendar, but you will not get all the benefits of the Calendar module if you do it that way.

Again, I will be submitting a patch dependent on KarenS rolling this patch into Date API, http://drupal.org/node/453688.  Which is a simple one line patch that anyone can do on their own if they wanted to.  My patch will include the attached view as a default view loaded when you load future version of CiviCRM.

//Date API integration for civicrm fields
function civicrm_date_api_fields($field) {
  $values = array(
    // The type of date: DATE_UNIX, DATE_ISO, DATE_DATETIME.
    'sql_type' => DATE_DATETIME,
    // Timezone handling options: 'none', 'site', 'date', 'utc'.
    'tz_handling' => 'site',
    // Needed only for dates that use 'date' tz_handling.
    'timezone_field' => '',
    // Needed only for dates that use 'date' tz_handling.
    'offset_field' => '',
    // Array of "table.field" values for related fields that should be
    // loaded automatically in the Views SQL.
    'related_fields' => array(),
    // Granularity of this date field's db data.
    'granularity' => array('year', 'month', 'day', 'hour', 'minute', 'second'),
  );

  switch ($field) {
    case 'civicrm_event.start_date':
    case 'civicrm_event.end_date':
    case 'civicrm_event.registration_start_date':
    case 'civicrm_event.registration_end_date':
      return $values;
  }
}


Default view

$view = new view;
$view->name = 'civicrm_events';
$view->description = 'CiviCRM Event Calendar';
$view->tag = 'CiviEvent';
$view->view_php = '';
$view->base_table = 'civicrm_event';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = TRUE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
  'start_date' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'date_format' => 'medium',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'start_date',
    'table' => 'civicrm_event',
    'field' => 'start_date',
    'relationship' => 'none',
  ),
  'title' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_civicrm_event' => 'page',
    'custom_link' => '',
    'exclude' => 0,
    'id' => 'title',
    'table' => 'civicrm_event',
    'field' => 'title',
    'relationship' => 'none',
  ),
));
$handler->override_option('sorts', array(
  'start_date' => array(
    'order' => 'ASC',
    'granularity' => 'second',
    'id' => 'start_date',
    'table' => 'civicrm_event',
    'field' => 'start_date',
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array(
  'date_argument' => array(
    'default_action' => 'default',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'default_argument_type' => 'date',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'date_fields' => array(
      'civicrm_event.start_date' => 'civicrm_event.start_date',
    ),
    'year_range' => '-3:+3',
    'date_method' => 'OR',
    'granularity' => 'month',
    'id' => 'date_argument',
    'table' => 'civicrm_event',
    'field' => 'date_argument',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
      '8' => 0,
      '12' => 0,
      '14' => 0,
      '9' => 0,
      '15' => 0,
      '10' => 0,
      '5' => 0,
      '4' => 0,
      '7' => 0,
      '11' => 0,
      '6' => 0,
      '13' => 0,
    ),
    'relationship' => 'none',
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'webform' => 0,
      'blog' => 0,
      'broadcast' => 0,
      'class' => 0,
      'feed' => 0,
      'icalfeed' => 0,
      'page' => 0,
      'podcast' => 0,
      'story' => 0,
      'video_upload' => 0,
      'wiki' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '2' => 0,
      '3' => 0,
      '6' => 0,
      '4' => 0,
      '5' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('filters', array(
  'is_active' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'is_active',
    'table' => 'civicrm_event',
    'field' => 'is_active',
    'relationship' => 'none',
  ),
  'is_public' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'is_public',
    'table' => 'civicrm_event',
    'field' => 'is_public',
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('title', 'Events');
$handler->override_option('header_empty', 1);
$handler->override_option('items_per_page', 0);
$handler->override_option('use_more', 0);
$handler->override_option('style_plugin', 'calendar_nav');
$handler = $view->new_display('calendar', 'Events page', 'calendar_1');
$handler->override_option('path', 'calendar');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));
$handler->override_option('calendar_colors', array(
  '0' => array(),
));
$handler->override_option('calendar_colors_vocabulary', array());
$handler->override_option('calendar_colors_taxonomy', array());
$handler->override_option('calendar_popup', 0);
$handler->override_option('calendar_date_link', '');
$handler = $view->new_display('calendar_block', 'Events block', 'calendar_block_1');
$handler->override_option('block_description', 'Events');
$handler->override_option('block_caching', -1);
$handler = $view->new_display('calendar_period', 'Year view', 'calendar_period_1');
$handler->override_option('style_plugin', 'calendar_style');
$handler->override_option('style_options', array(
  'display_type' => 'year',
  'name_size' => 1,
  'max_items' => 0,
));
$handler->override_option('attachment_position', 'after');
$handler->override_option('inherit_arguments', TRUE);
$handler->override_option('inherit_exposed_filters', TRUE);
$handler->override_option('displays', array(
  'calendar_1' => 'calendar_1',
  'default' => 0,
  'calendar_block_1' => 0,
));
$handler->override_option('calendar_type', 'year');
$handler = $view->new_display('calendar_period', 'Month view', 'calendar_period_2');
$handler->override_option('style_plugin', 'calendar_style');
$handler->override_option('style_options', array(
  'display_type' => 'month',
  'name_size' => '99',
  'with_weekno' => '1',
  'date_fields' => NULL,
  'max_items' => 0,
));
$handler->override_option('attachment_position', 'after');
$handler->override_option('inherit_arguments', TRUE);
$handler->override_option('inherit_exposed_filters', TRUE);
$handler->override_option('displays', array(
  'calendar_1' => 'calendar_1',
  'default' => 0,
  'calendar_block_1' => 0,
));
$handler->override_option('calendar_type', 'month');
$handler = $view->new_display('calendar_period', 'Day view', 'calendar_period_3');
$handler->override_option('style_plugin', 'calendar_style');
$handler->override_option('style_options', array(
  'name_size' => '99',
  'with_weekno' => 0,
  'max_items' => 0,
  'max_items_behavior' => 'more',
  'groupby_times' => 'hour',
  'groupby_times_custom' => '',
  'groupby_field' => '',
));
$handler->override_option('attachment_position', 'after');
$handler->override_option('inherit_arguments', TRUE);
$handler->override_option('inherit_exposed_filters', TRUE);
$handler->override_option('displays', array(
  'calendar_1' => 'calendar_1',
  'default' => 0,
  'calendar_block_1' => 0,
));
$handler->override_option('calendar_type', 'day');
$handler = $view->new_display('calendar_period', 'Week view', 'calendar_period_4');
$handler->override_option('style_plugin', 'calendar_style');
$handler->override_option('style_options', array(
  'name_size' => '99',
  'with_weekno' => 0,
  'max_items' => 0,
  'max_items_behavior' => 'more',
  'groupby_times' => 'hour',
  'groupby_times_custom' => '',
  'groupby_field' => '',
));
$handler->override_option('attachment_position', 'after');
$handler->override_option('inherit_arguments', TRUE);
$handler->override_option('inherit_exposed_filters', TRUE);
$handler->override_option('displays', array(
  'calendar_1' => 'calendar_1',
  'default' => 0,
  'calendar_block_1' => 0,
));
$handler->override_option('calendar_type', 'week');
$handler = $view->new_display('calendar_period', 'Block view', 'calendar_period_5');
$handler->override_option('style_plugin', 'calendar_style');
$handler->override_option('style_options', array(
  'display_type' => 'month',
  'name_size' => '1',
));
$handler->override_option('attachment_position', 'after');
$handler->override_option('inherit_arguments', TRUE);
$handler->override_option('inherit_exposed_filters', TRUE);
$handler->override_option('displays', array(
  'calendar_1' => 0,
  'default' => 0,
  'calendar_block_1' => 'calendar_block_1',
));
$handler->override_option('calendar_type', 'month');
$handler = $view->new_display('block', 'Upcoming Events', 'block_1');
$handler->override_option('fields', array(
  'start_date' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'date_format' => 'medium',
    'custom_date_format' => '',
    'exclude' => 0,
    'id' => 'start_date',
    'table' => 'civicrm_event',
    'field' => 'start_date',
    'relationship' => 'none',
  ),
  'title' => array(
    'label' => '',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_civicrm_event' => 'page',
    'custom_link' => '',
    'exclude' => 0,
    'id' => 'title',
    'table' => 'civicrm_event',
    'field' => 'title',
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array());
$handler->override_option('filters', array(
  'is_active' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'is_active',
    'table' => 'civicrm_event',
    'field' => 'is_active',
    'relationship' => 'none',
  ),
  'is_public' => array(
    'operator' => '=',
    'value' => '1',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'is_public',
    'table' => 'civicrm_event',
    'field' => 'is_public',
    'relationship' => 'none',
  ),
));
$handler->override_option('title', 'Upcoming Events');
$handler->override_option('items_per_page', 5);
$handler->override_option('use_more', 1);
$handler->override_option('style_plugin', 'list');
$handler->override_option('style_options', array(
  'grouping' => '',
  'type' => 'ul',
));
$handler->override_option('block_description', 'Upcoming Events');
$handler->override_option('block_caching', -1);