CiviCRM Community Forums (archive)

Hi, I have a Drupal content type (called team) that references multiple Civi contacts (using CiviCRM CCK Contact reference module). I am using views to display a list of the teams with the names of the Civi Contacts. I would like to be able to pull more information from Civi than just the contact name (including custom fields) but I can't seem to work out how!
I have tried using relationships and arguments.
I have tried using Views Field View module but can't seem to get the argument bit to work.
It seems to be that if you do a view based on a CiviCRM Contact you can't pull in any information from the rest of Drupal; but if I do a view based on Drupal nodes I can seem to only get the Contact name even with a relationship put in.

Any help gratefully received!

hi - if this is helpful i will need to find where we wrote this up but we have something like the following
- Drupal Node = Party
- Node has a Civi Reference field to the Civi Contact for the Party
- Party is related in civicrm to various individuals eg CoLeader
- we pull a block on to the Party page that shows the CoLeader name/phone etc

Does that sound like what you are aiming for?

I had a similar question - and like you I'm better at tweaking code than starting from scratch.  It took me a while to figure things out ... here is a log of my discovery (and the php code): http://forum.civicrm.org/index.php/topic,23560.msg99250.html#msg99250    my code has evolved greatly since posting that but the basics of how to call the API and link the node to the CiviCRM record through  $profile_id = $node->field_civicrm_link[0]['contact_id'];   is there

The key lies in using contemplate for the body of your content type "Team".  PHP code goes into contemplate to be able to call the CiviCRM API.  Study up on the API it will help you greatly: http://wiki.civicrm.org/confluence/display/CRMDOC40/CiviCRM+Public+APIs  The explorer greatly helped me to understand how the API works since you can play around with your data: # api explorer (visit /civicrm/ajax/doc/api#explorer on your installation) - see  our screencasthttp://www.youtube.com/watch?hl=en&v=G_mLgR-rbGg&gl=US

Hope this is helpful... in the middle of watching kids and making pancakes!

Thanks jhofer for your input.
In the end I have worked out how to do it via views and inserting a view (inside my view of my team) of the civicontacts using an argument of the CiviCRM ID and linking that to the Members field.
When you have more than one member I had to use the views customfield module http://drupal.org/project/views_customfield and insert php code (brilliant module especially together with the Civi API) to break up the array.
If anyone wants a more detailed explanation just let me know (I probably haven't explained it very well here)