Integrating CiviEvents with Drupal Calendar

[DicE]

Sonicthoughts,

your change in the \sites\all\modules\civicrm\drupal\modules\views\civicrm\civicrm_handler_field_event_link.inc file seemed to help in my case too. a lot of those errors were removed when activating a view block.

Thanks!
DicE

[Donald Lobo]

committed this fix to v4.2 in svn

lobo

[Michael]

If there's a way to pull CiviCRM 4.2.8  Event fields into a Drupal 7.21 View, please let me know how to do it. I am trying to follow the instructions to create a View of fully-booked events as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

Whenever I try to create a View and select CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships and I can't get past that point.

Any and all help is appreciated, I've been trying to make this work for over a week and have read everything  I can find (and tried most of it) without success. This topic here on the forums seems to be the most up-to-date information on the subject, but the challenge hasn't been met yet as far as I can tell.

Only one database in this case. I don't know if this is related (but it seems like it could be) ... whenever I try to get the Views array information to display as per:

civicrm/admin/setting/uf?reset=1

... no array information at all is displayed. Should I be seeing any array info or is this a change in CiviCRM version 4.2.8?

Any and all help will be very much appreciated.

[Donald Lobo]

might not be exactly what you are looking for, but might want to check this one:

http://civicrm.org/extensions/civicrm-events-calendar

lobo

[Michael]

Thank you, I already did try it but it doesn't do what we need. (Maybe I should move this question to a different topic?) We need to be able to run queries on civicrm events to create a page showing events with vacancies remaining as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

But, as per my previous post I can't select (it changes it immediately after) CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships it changes it immediately after I select it. There's nothing drastically customized on the site, there's no custom hooks or anything like that.

I haven't altered the settings files for either drupal or civicrm. The fact that I can't display the civicrm array data is disturbing but I don't know if this is a bug in either Drupal, an installed module, or a change in Civicrm. Can you tell me please if I should be seeing the array data at:

(website URL)/civicrm/admin/setting/uf?reset=1

... using D7.21 and Civi .4.2.8?

[Donald Lobo]

if you are using the same DB for civicrm and drupal, the array data is not needed and hence now shown

lobo

[Michael]

Thank you, that's one less concern which leaves the original issue:

"We need to be able to run queries on civicrm events to create a page showing events with vacancies remaining as per:

http://wiki.civicrm.org/confluence/display/CRMDOC40/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

But, as per my previous post I can't select (it changes it immediately after) CiviCRM Events from the Show pulldown, it automatically reverts to CiviCRM Relationships it changes it immediately after I select it. There's nothing drastically customized on the site, there's no custom hooks or anything like that. I haven't altered the settings files for either drupal or civicrm."

I assume the documentation referred to above is correct. Is there some change in recent versions that are causing this behavior or is the documentation accurate for 4.2.8? We're stuck until we can resolve this problem.

Thanks very much for the help.

[NASACT]

Just and FYI, Date iCal module https://drupal.org/project/date_ical has a new release and complete rewrite.  It now supports importing of iCal feeds using teh Feeds module and the iCalLibrary modules (extensions if you prefer, symantics). This is huge news for those looking to show all sorts of events from all sorts of places in one calendar view.  Figured I would share the news with everyone.

[Michael]

Thank you, that's useful to know.