CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • calendar customizations - drop-down filters
Pages: [1]

Author Topic: calendar customizations - drop-down filters  (Read 1918 times)

mroswell

  • Guest
calendar customizations - drop-down filters
February 19, 2008, 10:43:53 am
How hard would it be to use CiviCRM with Calendar or Events module to add calendar topic filters and month drop-downs, as appears here:

http://www.caidc.org/cal2/CalendarGet.asp?cal_id=21&assn_id=221
This is a nice calendar, both in appearance and functionality.

What would be involved in this customization?

I saw a post elsewhere about ical difficulties. Does ical actually work?

In addition to the drop-down functionality, we want to be able to export the website calendar to Outlook.

Best Regards,

Margie

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: calendar customizations - drop-down filters
February 19, 2008, 11:58:42 pm
Hey,

Quote from: mroswell on February 19, 2008, 10:43:53 am
How hard would it be to use CiviCRM with Calendar or Events module to add calendar topic filters and month drop-downs, as appears here:

http://www.caidc.org/cal2/CalendarGet.asp?cal_id=21&assn_id=221
This is a nice calendar, both in appearance and functionality.

What would be involved in this customization?

Most of customisations needed would have to happen on Calendar/Views side, so cannot help you too much. iCal information provided by CiviCRM contains event category field that is used for filtering on the page you've given as an example, so it depends if Drupal calendar handles this information or not. If you would need to extract event types directly from CiviCRM, that shouldn't be very hard as well, you just need to reach to civicrm_option_value db table and get the list of records for proper option group. Specific query would be:
select * from civicrm_option_value where option_group_id = (select id from civicrm_option_group where name like 'event_type');

Quote from: mroswell on February 19, 2008, 10:43:53 am
I saw a post elsewhere about ical difficulties. Does ical actually work?

It does in CiviCRM.

Quote from: mroswell on February 19, 2008, 10:43:53 am
In addition to the drop-down functionality, we want to be able to export the website calendar to Outlook.

That's again calendar module's functionality. However, goals that you're trying to achieve seem like quite neat functionality - if you manage to get them together, please share yo experience with others on this forum.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: calendar customizations - drop-down filters
February 21, 2008, 04:52:07 pm
Quote from: mroswell on February 19, 2008, 10:43:53 am
How hard would it be to use CiviCRM with Calendar or Events module to add calendar topic filters and month drop-downs, as appears here:

CiviEvent's iCal feed does allow you to filter by Event Type already - by adding an additional parameter with the event type id to the URL. This means you could potentially aggregate feeds for differerent types of events and visually differentiate them etc. Not sure if there's a way to tell the Drupal calendar to selectively display one of multiple feeds - but it's something you could play with a bit.

You can see the filter feature on the demo using these URLs
http://drupal.demo.civicrm.org/civicrm/event/ical?page=1 -> outputs all public active events
http://drupal.demo.civicrm.org/civicrm/event/ical?page=1&type=3 -> outputs only events of event type "Fundraiser"

You can find the event type id's in the Value column here:
http://drupal.demo.civicrm.org/civicrm/admin/options?group=event_type&reset=1
Protect your investment in CiviCRM by  becoming a Member!

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Re: calendar customizations - drop-down filters
November 16, 2012, 10:23:16 am
Is there a way to create a feed with multiple event types?

I've tried the following with no luck:

http://sitename/civicrm/event/ical?page=1&type=15&type11

This just gives me the last type, not both type 15 and 11.

Thanks!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: calendar customizations - drop-down filters
November 16, 2012, 10:57:31 am
This is not currently supported - the code in CRM/Event/Page/iCalendar.php expects a single positive integer value for event type. If you're interested in working on this - a patch against trunk would be accepted. You'd need to modify the code to explode the $type param on comma - and then make sure each item is an integer. Then check CRM_Event_BAO_Event::getCompleteInfo($start, $type, $id, $end); to see if it can accept a list for $type in the WHERE clause ... Jump on IRC if you need help getting started.
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • calendar customizations - drop-down filters

This forum was archived on 2017-11-26.