CiviCRM Community Forums (archive)

I use Activities to track certain events (I don't use civiEvents because it's overkill for these particular events). I need these activities to show up in my drupal fullcalendar view. Currently I'm importing the activities twice (once as drupal nodes and then as civi activities). I thought I could surely create a view of activities and filter the ones i need and create an iCal feed using views that I could then use Feeds in drupal to import regularly to create nodes. I can't get Views to do it because it doesn't recognize the date from civi.

Any ideas on a way I can do this without having to import the items twice? I guess I could switch to using civiEvent for this since it has iCal feed built in but I'd wind up having to completely change workflows.

Yes I can create a view with civi data but it won't create an iCal feed because it won't recognize the date from civi.

I've done the settings thing.

This is the error I get in the feed view:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /admin/structure/views/view/activities_ical/preview/feed/ajax
StatusText: Service unavailable (with message)
ResponseText:

this is the view code:
$view = new view();
$view->name = 'activities_ical';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'civicrm_activity';
$view->human_name = 'Acitivies iCal';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Acitivies iCal';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
  3 => '3',
);
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Field: CiviCRM Activities: Activity ID */
$handler->display->display_options['fields']['id']['id'] = 'id';
$handler->display->display_options['fields']['id']['table'] = 'civicrm_activity';
$handler->display->display_options['fields']['id']['field'] = 'id';
$handler->display->display_options['fields']['id']['label'] = '';
$handler->display->display_options['fields']['id']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['id']['separator'] = '';
/* Field: CiviCRM Activities: Subject */
$handler->display->display_options['fields']['subject']['id'] = 'subject';
$handler->display->display_options['fields']['subject']['table'] = 'civicrm_activity';
$handler->display->display_options['fields']['subject']['field'] = 'subject';
$handler->display->display_options['fields']['subject']['label'] = '';
$handler->display->display_options['fields']['subject']['element_label_colon'] = FALSE;
/* Field: CiviCRM Activities: Scheduled Activity Date */
$handler->display->display_options['fields']['activity_date_time']['id'] = 'activity_date_time';
$handler->display->display_options['fields']['activity_date_time']['table'] = 'civicrm_activity';
$handler->display->display_options['fields']['activity_date_time']['field'] = 'activity_date_time';
$handler->display->display_options['fields']['activity_date_time']['label'] = '';
$handler->display->display_options['fields']['activity_date_time']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['activity_date_time']['date_format'] = 'custom';
$handler->display->display_options['fields']['activity_date_time']['custom_date_format'] = 'Y-m-d h:i a';
$handler->display->display_options['fields']['activity_date_time']['second_date_format'] = 'privatemsg_current_day';
/* Field: CiviCRM Activities: Location */
$handler->display->display_options['fields']['location']['id'] = 'location';
$handler->display->display_options['fields']['location']['table'] = 'civicrm_activity';
$handler->display->display_options['fields']['location']['field'] = 'location';
$handler->display->display_options['fields']['location']['label'] = '';
$handler->display->display_options['fields']['location']['element_label_colon'] = FALSE;
/* Field: CiviCRM Activities: Details */
$handler->display->display_options['fields']['details']['id'] = 'details';
$handler->display->display_options['fields']['details']['table'] = 'civicrm_activity';
$handler->display->display_options['fields']['details']['field'] = 'details';
$handler->display->display_options['fields']['details']['label'] = '';
$handler->display->display_options['fields']['details']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['details']['text_format'] = 'full_html';
/* Field: CiviCRM Tags: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'civicrm_tag';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
/* Filter criterion: CiviCRM Activities: Activity Type */
$handler->display->display_options['filters']['activity_type']['id'] = 'activity_type';
$handler->display->display_options['filters']['activity_type']['table'] = 'civicrm_activity';
$handler->display->display_options['filters']['activity_type']['field'] = 'activity_type';
$handler->display->display_options['filters']['activity_type']['value'] = array(
  38 => '38',
  40 => '40',
  54 => '54',
  55 => '55',
);
/* Filter criterion: CiviCRM Activity Contacts: Activity Contact ID */
$handler->display->display_options['filters']['contact_id']['id'] = 'contact_id';
$handler->display->display_options['filters']['contact_id']['table'] = 'civicrm_activity_contact';
$handler->display->display_options['filters']['contact_id']['field'] = 'contact_id';
$handler->display->display_options['filters']['contact_id']['value']['value'] = '4610';
/* Filter criterion: CiviCRM Activities: Scheduled Activity Date */
$handler->display->display_options['filters']['activity_date_time']['id'] = 'activity_date_time';
$handler->display->display_options['filters']['activity_date_time']['table'] = 'civicrm_activity';
$handler->display->display_options['filters']['activity_date_time']['field'] = 'activity_date_time';
$handler->display->display_options['filters']['activity_date_time']['operator'] = '>=';
$handler->display->display_options['filters']['activity_date_time']['value']['value'] = 'today';
$handler->display->display_options['filters']['activity_date_time']['value']['type'] = 'offset';

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'acitivies-ical';

/* Display: Feed */
$handler = $view->new_display('feed', 'Feed', 'feed');
$handler->display->display_options['pager']['type'] = 'none';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['style_plugin'] = 'date_ical';
$handler->display->display_options['style_options']['cal_name'] = '';
$handler->display->display_options['row_plugin'] = 'date_ical_fields';
$handler->display->display_options['row_options']['date_field'] = 'first_available';
$handler->display->display_options['row_options']['title_field'] = 'subject';
$handler->display->display_options['row_options']['description_field'] = 'details';
$handler->display->display_options['row_options']['location_field'] = 'location';
$handler->display->display_options['row_options']['additional_settings'] = array(
  'skip_blank_dates' => 0,
);
$handler->display->display_options['path'] = 'acitivies-ical.xml';
$handler->display->display_options['displays'] = array(
  'default' => 'default',
  'page' => 'page',
);


Yes, for the page view it shows the date fine. see the screen shot view_page.png

but for the feed view it doesn't interpret the date. see the screen shot view_feed.png

Yes, no issues with drupal content or with importing google calendar iCal feeds using Feeds.