Exposes CiviCRM DB tables to Views

Out of the box CiviCRM provides Views exposure to about 8 CiviCRM data entities. With this module you can access any of the CiviCRM tables in Views.

This is a simple module which does one thing: provides an admin page for site-builders to choose which tables in a site's Drupal DB to expose to Views.

The module then loads all the fields for each chosen table and detects the data type of the field and sets appropriate views field, sort, filter, and argument filters (for example numeric, string, date, or "default").

It also looks for a primary key of the table and if one is found it sets it as the base field for a views base table and makes the table accessible to views.

This module expects the CiviCRM database to be in a separate database from Drupal

It requires Views 3, CiviCRM (any version), and the date_views module (part of the Date module)

After installing CiviCRM follow these instructions to give Drupal access to the CiviCRM database tables:
http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

click on version control to get code, or get it from my Github repo:
https://github.com/jackrabbithanna/views_civicrm_expose_tables

Sponsored by Skvare, LLC

Views CiviCRM Expose Tables

Issues

What is required to make this work where civi and drupal are in a single tableActiveDocumentation Created about 7 years ago

What is required to make this work where civi and drupal are in a single table
Active
Documentation
Created about 7 years ago