CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM Data and Drupal Data in one view
Pages: [1]

Author Topic: CiviCRM Data and Drupal Data in one view  (Read 1054 times)

Traveler777

  • I post occasionally
  • **
  • Posts: 43
  • Karma: 0
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.2
CiviCRM Data and Drupal Data in one view
March 05, 2011, 03:02:23 pm
Hi, We are trying to create a view with custom CiviCRM fields, but would like to include the profile picture stored in the Drupal db.

Can anyone direct me in the right direction if it is possible to create a view with custom civicrm fields and drupal fields (mainly only the profile image)?

In the views settings I only seem to be able to include CiviCRM fields, but no mix-and-match.

Thanks

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: CiviCRM Data and Drupal Data in one view
March 05, 2011, 03:11:21 pm
Hey - so if you set it up the view for Civi Contact then  you need to make a Relationship to bring in the Drupal data

Relationship = CiviCRM Contact: Drupal ID

Then use that to pull in fields relating to the Drupal ID

If you have data in a Profile Content (D6) then add another relationship

(Drupal User) Node: Content Profile - or whatever your Content Type is called


HTH
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Traveler777

  • I post occasionally
  • **
  • Posts: 43
  • Karma: 0
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.2
Re: CiviCRM Data and Drupal Data in one view
March 14, 2011, 09:43:05 pm
Pete, that's exactly what we were looking for!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • CiviCRM Data and Drupal Data in one view

This forum was archived on 2017-11-26.