Drupal doesn't recognize CiviEvent date as valid argument for calendar

[bcobin]

To reproduce:

1. Create a new View in Drupal - make it a CiviEvent view.

2. Select and add fields (Title, Start date and End date should do it) - as you update, you'll see the fields in preview

3. Select CiviEvent Start Date as Argument

4. Change style to Calendar

Result: The calendar_style style requires a Date argument.

Don't know if this is a Civi thing or a Drupal thing - perhaps somebody could suss it out. Hope this helps!

This seems to me the easiest method to create a CiviEvent calendar in Drupal - if it could be made to work, it's much easier than the whole FeedAPI thing.

[Donald Lobo]

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

lobo

[bcobin]

Thanks, Donald - Sean rocks. It isn't an issue of configuration, though; I've got that down and it's actually very straightforward if you follow the steps above. The problem is that, for whatever reason, Drupal isn't recognizing the exposed CiviEvent dates as valid dates.

There aren't a lot of options here; the issue should be fairly easy to reproduce. Just don't know if it's a Civi or a Drupal thing. Thanks for the tip, though - it's always a nice break to watch DrupalTherapy...

[jalama]

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

[marqpdx]

Does anyone have an idea where the best way to rectify this is?
Changing the nature of a CiviEvent, or changing the Calendar module??

This seems like a huge feature, to be able to display events in a calendar.

I'm willing to see about solutions, but wonder what people think is the best place to start.

thx,
m

[Dave Greenberg]

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).

[jalama]

I talked to KarenS about this at Drupal Camp Chicago.  She has no plans in bringing ical imports back into Calendar in D6 and is going to stick with the Feed Element Mapper/Feed API plan noted above.

The main issue is the flexibility you get by bringing the individual events into Druapl as a node, you can sort, filter, etc... (everything you can do with views).  The way views works in D5 the info from the Ical feed was pulled in as an array meaning you could not filter/sort/impose arguments in views.

[kpurcell]

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

[jalama]

Sorry the link I posted above did have the info I thought it did

you need to set Drupal up import the events from the Ical feed created by CiviCRM, it's explained on Drupal.org here
http://drupal.org/node/341716

[Eileen]

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

[Donald Lobo]

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

can u elaborate a bit more on "require some input from the civi end to fix it ..."

thanx

lobo

[Eileen]

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

[marqpdx]

hi,
following these two threads, i patched both the date and the calendar modules:
http://drupal.org/node/385880
http://drupal.org/node/385886

then, i added the following code, as a test, to the civicrm.views.inc file:

Code: [Select]

$data['civicrm_event']['date_argument'] = array(
'group' => t('Date'),
'title' => t('Date'),
'help' => t('Filter any Views date field by a date argument'),
'argument' => array(
  'handler' => 'date_api_argument_handler',
  'empty name field' => t('Undated'),
),
   );

I was hoping this would be enough to get the date module to recognize a CiviEvent date field as a proper date, so i could make a calendar view of CiviEvents. It does not yet work.

Does this seem the right place to add the argument code above??
thanks,
m

[jalama]

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.

Code: [Select]

//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

Code: [Select]

$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);


[Eileen]

Well done!