views 2 and civicrm

[carolineb]

Hi
I am trying to get civicrm data exposed using views.

But I'm not getting any data exposed at all.

Specifically I am looking to get event data exposed. I'm using views 2, drupal 6 and civicrm 3.4.0

The upcoming events block supplied with civicrm works but I can't see that in views to copy and amend.

Has anybody got any thoughts? I feel like I might be missing somethign realy obvious.

Thanks
Caroline

[Hershel]

Hi Caroline.

Have you done the second step here:

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

?

[carolineb]

Hi Hershel
Thanks no I hadn't done that second stage and wasn't sure I needed to so  thanks.

...for others who end up here


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

Step 2
•You will need to set database prefixes in your Drupal settings.php file so that Views2 can access your CiviCRM DB. The prefixes can be seen on a url like: http://drupal.demo.civicrm.org/civicrm/admin/setting/uf?reset=1.

What I did here was replace my own website url for this bit drupal.demo.civicrm.org ......

http://www.myurl.com/civicrm/admin/setting/uf?reset=1

I then got a list I could copy and paste into the end of my settings file.

Thanks!