Integrating CiviEvents with Drupal Calendar

[Donald Lobo]

might help to read the instructions at:

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

carefully

lobo

[emilyf]

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!

[nextwave]

still no luck, I'd have to try to merge the 2 databases. will i need them after i merge ?

[thecenterproject]

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?

[emilyf]

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]

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 [nofollow]

Just setup CiviCRM DB as separate DB connection as described.

[Stoob]

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.

[jimmyjam]

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:

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.

[epg]

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?

[jackaponte]

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?

[jalama]

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

[roswell2011]

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') ))

[NASACT]

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.

[Donald Lobo]

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

[NASACT]

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.