Author Topic: Calendar module for Drupal and Civi Event - more documentation? (Read 10281 times)

Sansui · July 01, 2009, 06:12:37 am

I saw the announcement about it here - http://civicrm.org/node/557

And here - http://drupal.org/node/385880#comment-1545416

And a patch for Date here - http://drupal.org/node/453688

I checked my files just in case - I do see the patch implemented in the code that I have. In my calendar view for filtering by node type, I see there is an option for "CiviActivity" - is this what I need to get my Civi Events listed on my Drupal calendar? I've tried it without success. Is there any additional documentation about setting up civi events to be viewed with the drupal calendar?

emilyf · July 01, 2009, 06:41:39 am

Did you try just using a feed like in this tutorial? http://www.soleer.com/blog/2008/03/24/how-to-display-civicrm-events-on-a-drupal-calendar/

That tutorial is for Drupal 5, but much of it will be the same in D6.

Donald Lobo · July 01, 2009, 06:43:48 am

No detailed docs on this as yet, but would be great if you can document it as you figure things out.

There should be a default civicrm event views with calendar is: q=admin/build/views url. You should use that to build future calendar views of civievent

lobo

Sansui · July 01, 2009, 06:46:51 am

I guess I missed the one line in that post, that you can't display drupal event nodes and civi events in the same calendar

Had one problem with my civicrm and drupal installs being in a different database. In default/settings.php had to specify the $db_prefix array for the civicrm tables

I managed to get the civi events showing in their own calendar using the view that was supplied by civi crm, but was really hoping to have a combined calendar (like in the link that Emily posted, using feeds in Drupal 5.x). I'm in Drupal 6.x, and from what I can tell on the drupal forums, the old 5.x method with the ical feed does not work for 6.x

Anyone been able to get both drupal and civi events in the same calendar in 6.x?

Sansui · July 01, 2009, 06:56:09 am

Well, this looks like it may be some starting information - http://drupal.org/node/341716

Definitely not as easy as 5.x....

I will try and get this to work, will report back today or tomorrow on results

Sansui · July 01, 2009, 08:15:03 am

Well, progress not so good, so far. After following the instructions in the recipe I linked, I can create an ical feed type, set up the URL using my civi events ical feed, but when trying to map the ical fields, my event content type (which certainly does have the date field), does not have a date field available to mape the ical date field to. It just has 4 generic fields for author, picture, tags etc.

I can't seem to find similar issues on that, and nothing I try results in additional fields to map to.

With so many modules involved to make this recipe happen, I can't even begin to try and pinpoint where the breakdown is. Hopefully someone else will have better luck eventually, and be able to create a civicrm recipe that works to combine drupal nodes and civi crm events

Sansui · July 01, 2009, 12:15:48 pm

Apparently I had the wrong feed - using the file link for ICS in civicrm resulted in a mappable feed. However, once I mapped the VEVENT fields, saved, and refreshed the feed - my sample event was imported, a CCK error was listed and viewing the newly created event shows the date and time was not saved

so close :/

Edit: Well, finally got it working. My advice to anyone else that has similar troubles - don't install civicrm in a separate database from drupal, even if you've set the variables correctly in your drupal settings.php. For whatever reason, even though some things worked, some things like this didn't.

I now have events mapped from my civicrm calendar feed that include the proper date and time, as well as a link to the original event/registration page. All is good

emilyf · July 02, 2009, 05:47:29 am

Is there anything particular you did to get it working that is not in the drupal page you referenced? it would be good to have complete documentation on how to do this. if you don't have time to do it, let me know what you did differently from that page and i can recreate it and write it up for the civi handbook.

Sansui · July 02, 2009, 08:06:04 am

Maybe I will try to make a civicrm specific version of that tutorial after I finish everything with this project

There were only a couple things though I think - I didn't have to create a new event content type, I was able to use the existing one created by the Date wizard just fine. Two, the ical link that needed to be used was a little confusing - I assumed it was the green ical link in civicrm, but if you try to use that one, you get an unmappable feed. You have to use the other file based link, at which point you will be able to map your nodes correctly.

Also, I went ahead and added a cck link field to my event type so that I could map the node url of the civi event into the field for display - that way when someone uses your calendar and views an imported civicrm event, they can still get to the registration page.

Finally, I had some major issues with having civicrm and drupal being in a different database. The calendar didn't like my database settings that specified the location of the civicrm tables for drupal for whatever reason, so I went ahead and installed civicrm in the same database.

emilyf · July 15, 2009, 08:07:27 am

Sansui

I am trying to get this same thing to work. I am following the combination of your instructions with the documentation page on drupal.org.

I am having the same issue as you where when I input the CiviEvent iCal feed, I don't ever see a VEVENT field to map with...just the 4 normal fields show up (sounds like the exact same issue you had).

Only problem is, I've tried every icon on the CiviEvent admin page and nothing fixes it. Can you give me a url example of what you finally used so I can compare it to mine and see if that is the issue?

thanks,
emily

emilyf · July 15, 2009, 08:16:38 am

Oh, I see. OK, for anyone else, here is some clarification:

You can't even use a URL to get this to work. You need to DOWNLOAD the .ics file (click the gray icon that looks like a calendar -- directly left of the green iCAL button). Then in Step 3 of the Drupal tutorial, you need to make sure you change the 'Supply feed as: ' option to 'File Upload'. Then in Step 4 of the Drupal tutorial, you will see that you can upload the file.

If you are confused on which drupal tutorial we are referring to, it's this one: http://drupal.org/node/341716

hope that helps somebody else!

Sansui · July 15, 2009, 09:39:04 am

I simply used the URL for the download link, and that worked for me to provide a mappable input

emilyf · July 15, 2009, 10:14:19 am

Interesting...I wonder if this is Drupal or module version issue. For me, only when I uploaded the .ics could I get VEVENT fields.

Eileen · July 16, 2009, 01:37:12 am

HI there,

Just chiming in - I did get it working and I didn't need to download the ics file. I can't remember all the details but I made comments at the time:

http://forum.civicrm.org/index.php/topic,6320.msg31510.html#msg31510

However, it wouldn't work in the end because we needed to make the feed unavailable to anonymous users and the ical method only works if it is.

Note that the alternative method is to use Views2 to present a calendar. http://forum.civicrm.org/index.php/topic,6320.msg34479.html#msg34479

emilyf · July 16, 2009, 04:55:46 am

Can you guys give me an example URL of what you used...for example, I think you are both talking about using this url:

http://mysite.org/civicrm/event/ical?reset=1

However, when I use that, my VEVENT-mappable fields disappear. If I upload the file, I get them back. Unfortunately, it doesn't refresh my feed items if I use the direct file, so I need to get the URL working.

I tried to attach screenshots but it keeps telling me the forum uploader is full...so here are links to them
http://vermontaccess.net/files/using_ics_file.png -- what my mappable field area looks like when I upload a file
http://vermontaccess.net/files/using_URL.png -- what my mappable field area looks like when I use the url above. You will see that the VEVENT fields disappear.

I would really like to get to the bottom of this as it just doesn't make any sense to me why a URL would work for you guys but not me. I am on Drupal 6.13, Date/Calendar 6.x-2.x-dev, iCal parser 6.x-1.1, Feed API mapper 6.x-1.0-beta11, and Feed API 6.x-1.7-beta3.

CiviCRM Community Forums (archive)

News:

Author Topic: Calendar module for Drupal and Civi Event - more documentation? (Read 10281 times)

Sansui

Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?

Donald Lobo

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?

Sansui

Re: Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?

Eileen

Re: Calendar module for Drupal and Civi Event - more documentation?

emilyf

Re: Calendar module for Drupal and Civi Event - more documentation?