Author Topic: Integrating CiviEvents with Drupal Calendar  (Read 48889 times)

Offline Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15887
  • Karma: 468
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Integrating CiviEvents with Drupal Calendar
« Reply #15 on: October 15, 2009, 11:01:02 am »

might help to read the instructions at:

http://wiki.civicrm.org/confluence/display/CRMDOC/Views2+Integration+Module

carefully

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Offline emilyf

  • Ask me questions
  • ****
  • Posts: 679
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
« Reply #16 on: October 15, 2009, 11:15:05 am »
AH! Nice to know I was on the right track. lobo -- i added this link to the top of the Drupal/Civi Cal integration page. Very useful!

Offline nextwave

  • I post occasionally
  • **
  • Posts: 62
  • Karma: 0
Re: Integrating CiviEvents with Drupal Calendar
« Reply #17 on: October 15, 2009, 01:57:58 pm »
still no luck, I'd have to try to merge the 2 databases. will i need them after i merge ?

thecenterproject

  • Guest
Re: Integrating CiviEvents with Drupal Calendar
« Reply #18 on: January 18, 2010, 02:40:12 pm »
Followed the steps but when I try to view, I get this error:



    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.
    * user warning: Table 'dir_drpl1.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, dir_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') <= '2009-10-11' AND DATE_FORMAT(ADDTIME(civicrm_event.start_date, SEC_TO_TIME(-14400)), '%Y-%m-%d') >= '2009-10-11')) ORDER BY civicrm_event_start_date ASC in /home/<dir>/public_html/sites/all/modules/views/includes/view.inc on line 759.


Any help?
Thanks



I'm getting a similar error:

    * user warning: Table 'tcpcrm_drupal.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(civicrm_event.start_date, '%Y-%m') <= '2010-01' AND DATE_FORMAT(civicrm_event.start_date, '%Y-%m') >= '2010-01')) ORDER BY civicrm_event_start_date ASC in /home/username/thecenterproject/sites/all/modules/views/includes/view.inc on line 769.
    * user warning: Table 'tcpcrm_drupal.civicrm_event' doesn't exist query: SELECT civicrm_event.id AS id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title FROM civicrm_event civicrm_event WHERE ((civicrm_event.is_active <> 0) AND (civicrm_event.is_public <> 0)) AND ((DATE_FORMAT(civicrm_event.start_date, '%Y-%m') <= '2010-01' AND DATE_FORMAT(civicrm_event.start_date, '%Y-%m') >= '2010-01')) ORDER BY civicrm_event_start_date ASC in /home/username/thecenterproject/sites/all/modules/views/includes/view.inc on line 769.

It doesn't seem like this was ever resolved in this string. Any help?

Offline emilyf

  • Ask me questions
  • ****
  • Posts: 679
  • Karma: 54
  • CiviCRM version: 2.x - 4.x
  • CMS version: Drupal 5, 6, 7
Re: Integrating CiviEvents with Drupal Calendar
« Reply #19 on: January 18, 2010, 03:34:03 pm »
is 'tcpcrm_drupal' your drupal database? and is your civi database separate? assuming the answer is yes.

you need to go to
Administer CiviCRM > Global Settings > Drupal Integration Settings

and copy everything that's below 'To enable CiviCRM Views integration, add the following to the site settings.php file' into your settings.php file.

jasonjwwilliams

  • Guest
Re: Integrating CiviEvents with Drupal Calendar
« Reply #20 on: March 20, 2010, 05:51:46 pm »
If your CiviCRM tables are in a separate database from your Drupal DB, use this article to get your Drupal Calendar/CiviCRM integration working:

http://redspire.net/content/civicrm-views-2-integration-remote-civicrm-database

Just setup CiviCRM DB as separate DB connection as described.

Offline CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1238
  • Karma: 114
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.4
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Integrating CiviEvents with Drupal Calendar
« Reply #21 on: June 04, 2010, 03:31:39 pm »
I can confirm, jasonjwwilliams, that those instructions do indeed work.  Thank you to you and emilyf.  I setup a Calendar with Views2 using CiviCRM fields on a setup with a separate Drupal and Civi database on the same server.

I went through the following steps

1. Configure settings.php to use a ['default'] and a ['civicrm'] database as discussed elsewhere
2. Setup the default and civicrm table prefixes in settings.php
3. Went into file civicrm.views.inc and made changes to 4 lines adding 'database' => 'civicrm' as a key pair for: Contacts, Activities, Contributions and Addresses
4. Cleared Views cache

This was enough to get it working.  Thanks team.
Try CiviTeacher: the online video tutorial CiviCRM learning library.

Offline jimmyjam

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
Re: Integrating CiviEvents with Drupal Calendar
« Reply #22 on: October 03, 2010, 08:11:58 pm »
Community,

May I please ask for your help?

I am so close to getting the CiviEvent/Drupal Calendar integration running, but missing a critical step somewhere.

Here is my problem: calendar events aren't showing up on the calendar automatically. They do show up in the Drupal content section and the Drupal calendar when I click the 'Refresh' tab on the feed I created in Step 3 of Option 2 at...

http://wiki.civicrm.org/confluence/display/CRMDOC32/Using+Drupal+Calendar+with+CiviEvent.

After I click the 'Refresh' in the feed's edit view, the calendar events are created and appear in the view I created in step 10. Everything is perfect, except it's not automatic.

My question is: how do I automate the process of creating calendar events from the CiviEvent iCal feed?

Here are the steps I followed:

Chose "Option 2. Integrate CiviEvents iCal feed with Drupal Calendar"

Step 1
OK

Step 2
Chose "Calendar event" as the content type.

Step 3
Chose 'Feed' as the content type.
I don't see a section called "FeedAPI".
I don't see a section called "Parser Common iCal Syndication".

Steps 4-13
Everything works as expected. Civi events show up in my Drupal calendar as expected.

----------------
On a related note, a bunch of errors are showing up in my Drupal log:

Quote
Table &#039;nchs_civicrm.backup_migrate_schedules&#039; doesn&#039;t exist query: UPDATE backup_migrate_schedules SET last_run = 1286156640 WHERE schedule_id = &#039;7348d141b666c5d92d7360b326f9e104&#039; in /home/nchs/public_html/sites/all/modules/backup_migrate/includes/schedules.inc on line 364.

Table &#039;nchs_civicrm.feedapi_stat&#039; doesn&#039;t exist query: DELETE FROM feedapi_stat WHERE timestamp &lt; 1283737439 in /home/nchs/public_html/sites/all/modules/feedapi/feedapi.module on line 689.

Table &#039;nchs_civicrm.search_index&#039; doesn&#039;t exist query: SELECT SUM(score) FROM search_index WHERE word = &#039;402am&#039; in /home/nchs/public_html/modules/search/search.module on line 285.

Table &#039;nchs_civicrm.search_total&#039; doesn&#039;t exist query: UPDATE search_total SET count = 0.301029995664 WHERE word = &#039;402am&#039; in /home/nchs/public_html/modules/search/search.module on line 288.

Table &#039;nchs_civicrm.search_total&#039; doesn&#039;t exist query: SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL in /home/nchs/public_html/modules/search/search.module on line 296.

Offline epg

  • Ask me questions
  • ****
  • Posts: 738
  • Karma: 25
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Integrating CiviEvents with Drupal Calendar
« Reply #23 on: December 22, 2010, 07:47:19 pm »
I am following the "option 2" steps at: http://wiki.civicrm.org/confluence/display/CRMDOC33/Using+Drupal+Calendar+with+CiviEvent

CiviCRM and Drupal DB are in the same database.  I am using Drupal 6.17 and CiviCRM version 3.3.1

I am getting stuck on: step 7: But I Don't See Any VEVENT Fields!

The url I am using is: http://www2.mygroup.org/civicrm/event/ical?reset=1

( I tested with the URL  http://drupal.demo.civicrm.org/civicrm/event/ical?reset=1 , which works )

If I change "drupal.demo.civicrm.org" to my host name, it stops working.

I looked at the output from http://www2.mygroup.org/civicrm/event/ical?reset=1 and compared it to the output from the sandbox, and everything looks good.

What else should I check?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

Offline jackaponte

  • I’m new here
  • *
  • Posts: 19
  • Karma: 2
Re: Integrating CiviEvents with Drupal Calendar
« Reply #24 on: May 09, 2011, 01:49:52 pm »
Now that we're working with CiviCRM 4.0, Drupal 7, and Views 3, are we still limited to the options presented on http://wiki.civicrm.org/confluence/display/CRMDOC33/Using+Drupal+Calendar+with+CiviEvent for CiviEvent integration with Drupal Views/Calendar? Or are there new possibilities?

Offline jalama

  • I post frequently
  • ***
  • Posts: 176
  • Karma: 22
    • Rooty Hollow LLC
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6 and 7
  • MySQL version: 5.1
  • PHP version: 5.2.5 and 5.3
Re: Integrating CiviEvents with Drupal Calendar
« Reply #25 on: July 08, 2011, 07:54:51 am »
Any new features would be what comes with Views 3, ie OR statements in the SQL, grouping, etc...  No major changes have been added to CiviCRM's views support relating to Events. That said that Wiki page doesn't cover everything you can do with views by any means

Offline roswell2011

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.0.4
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: php 5.3
Re: Integrating CiviEvents with Drupal Calendar
« Reply #26 on: October 13, 2011, 09:51:44 am »
Having a hard time integrating CiviEvents with Calendar View. Can't seem to find out how to handle the none existing field date_filter

I am using
Drupal 7
CiviCRM 4.0.6
Chaos tools 7.x-1.0-rc1
Calendar 7.x-3.x-dev
Views   7.x-3.0-rc1

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'civicrm_event.date_filter' in 'where clause'

SELECT civicrm_event.id AS id, civicrm_event.end_date AS civicrm_event_end_date, civicrm_event.event_type_id AS civicrm_event_event_type_id, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.title AS civicrm_event_title
FROM
{civicrm_event} civicrm_event
WHERE (( (DATE_FORMAT(FROM_UNIXTIME(civicrm_event.date_filter), '%Y-%m') >= '2011-10' AND DATE_FORMAT(FROM_UNIXTIME(civicrm_event.date_filter), '%Y-%m') <= '2011-10') ))

Offline NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Integrating CiviEvents with Drupal Calendar
« Reply #27 on: February 16, 2012, 11:22:43 am »
Can someone update the process we use to add iCal CiviEvent Feed using

D7, CCK, Feeds, iCal Feeds and iCal Feeds Parser which works so well in D6?

Thanks So Much.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Offline Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15887
  • Karma: 468
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Integrating CiviEvents with Drupal Calendar
« Reply #28 on: February 16, 2012, 03:26:59 pm »

The first few people who need it and experiment with it will need to lay down and pave the road for others

Seems like you are one of the first to try this combination, so you might want to document how/where you got and hopefully other folks who come down the road can use your stuff and help you make progress

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Offline NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Integrating CiviEvents with Drupal Calendar
« Reply #29 on: February 17, 2012, 06:43:35 am »
Sure, np maybe a new thread for D7 version as it seems quite different.  I have made it pretty far I think all I am lacking is the correct settings somewhere at the content end.  I will document what I have done thus far and how it relates to the older methods and post that in hopes someone can take it the rest of the way.  Thanks.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!