This project is not covered by Drupal’s security advisory policy.
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
Project information
- Module categories: Integrations, Developer Tools
- 9 sites report using this module
- Created by markusa on , updated
- This project is not covered by the security advisory policy.
Use at your own risk! It may have publicly disclosed vulnerabilities.