CiviCRM Community Forums (archive)

Hi,

Having read through various threads it seems the ability to list CiviCRM profiles in Drupal Profile pages is limited (i.e. to an individual not orgnaisation) and that it seems difficult to have various civicrm profile categories in different sections of a Drupal Profile page created with Panels.

As such I would like to explore how flexible a Profile page can be presented in a Drupal site if I use solely CiviCRM Profile fields. What I want is to be able to have a profile page of registered (and paid) users that displays contact details, location map, image gallery, business logo, profile header image and contact form. I also want unregistered users to be able to search registered users profiles via postcode/community and produce a list with name, logo image, teaser description and location that links to the users profile page.

Can someone please tell me how I am going to acheive this as I am at my whits ends researching both sites.

thanks heaps in advance!!

Cameron

I think you may want to explore what can be done via Views - and then output this in a way that you can use in a pane in panels (blocks, content pane, page etc)

i dont think i still understand it, but if peter's reply makes sense, then do use the views2 integration to expose contact details etc

lobo

Hi caminoz,

The page you require is located at: http://yoursite.com/civicrm/admin/setting/uf?reset=1

I can't copy and paste this information as its specific to your install of CiviCRM, however it will look something like this:

$db_prefix = array(
  'civicrm_acl'                              => 'your_database.',
  'civicrm_acl_cache'                        => 'your_database.',
  'civicrm_acl_entity_role'                  => 'your_database.',
);

etc... there are a lot of values.

Once you have found these, you need to copy them, and paste them into your drupal settings.php file. You can place them just below the line:

$db_prefix = '';

That you see (usually around line 93 depending on the settings you have).

Once you have done this, you should see a whole host of new options when you create a new view.

I hope this helps. All the best,

Adam

One little thing... not quite sure where I am missing it but when I display the view it lists multiple outputs of each of the two fields selected??? Any ideas where I missed something.


Full Street Address:
First Name:
Full Street Address: 52 Terania St
First Name: Cameron
Full Street Address:
First Name: Cameron

Hi,

I have tried everything I can possbily think of but I still get a double result from my view query. Please see details below?? I am hopeing it is something silly that i have missed???

I would so very much appreciate help.

Below is what comes out of the View in the Drupal Panel section (overriding core Drupal Profile). Please note that the 2nd entry is not displaying the address??. Also please note that the double entry first occurs when I add any of the location/address/Postal code fields to the view. i.e.This does not occur if I only list fields for Name and Phone (Primary). But it does occur if I try to add Phone (mobile)

View display -

Contact: Cameron
Phone: 026688XXXX
Address: 5X Terania St
Contact: Cameron
Phone: 026688XXXX
Address:

This is the query result in the View -

SELECT DISTINCT(civicrm_contact.id) AS id,
   users_civicrm_uf_match__civicrm_contact.last_name AS users_civicrm_uf_match__civicrm_contact_last_name,
   users_civicrm_uf_match__civicrm_contact.id AS users_civicrm_uf_match__civicrm_contact_id,
   civicrm_phone.phone AS civicrm_phone_phone,
   civicrm_address.street_address AS civicrm_address_street_address
 FROM visionar_civicrm.civicrm_contact civicrm_contact
 LEFT JOIN visionar_civicrm.civicrm_uf_match civicrm_uf_match ON civicrm_contact.id = civicrm_uf_match.contact_id
 LEFT JOIN users users_civicrm_uf_match ON civicrm_uf_match.uf_id = users_civicrm_uf_match.uid
 LEFT JOIN visionar_civicrm.civicrm_uf_match users_civicrm_uf_match__civicrm_uf_match ON users_civicrm_uf_match.uid = users_civicrm_uf_match__civicrm_uf_match.uf_id
 LEFT JOIN visionar_civicrm.civicrm_uf_match users_civicrm_uf_match_users_civicrm_uf_match__civicrm_uf_match ON users_civicrm_uf_match.uid = users_civicrm_uf_match_users_civicrm_uf_match__civicrm_uf_match.uf_id
 LEFT JOIN visionar_civicrm.civicrm_contact users_civicrm_uf_match__civicrm_contact ON users_civicrm_uf_match__civicrm_uf_match.contact_id = users_civicrm_uf_match__civicrm_contact.id
 LEFT JOIN visionar_civicrm.civicrm_phone civicrm_phone ON civicrm_contact.id = civicrm_phone.contact_id
 LEFT JOIN visionar_civicrm.civicrm_address civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
 WHERE users_civicrm_uf_match__civicrm_contact.id = 1

And here is the entire exported View -

$view = new view;
$view->name = 'Contact_Details';
$view->description = 'Contact Details';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'civicrm_contact';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('relationships', array(
  'drupal_id' => array(
    'label' => 'Drupal User',
    'required' => 0,
    'id' => 'drupal_id',
    'table' => 'civicrm_contact',
    'field' => 'drupal_id',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('fields', array(
  'last_name' => array(
    'label' => 'Contact',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'link_to_civicrm_contact' => 0,
    'exclude' => 0,
    'id' => 'last_name',
    'table' => 'civicrm_contact',
    'field' => 'last_name',
    'relationship' => 'drupal_id',
  ),
  'phone' => array(
    'label' => 'Phone',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'phone',
    'table' => 'civicrm_phone',
    'field' => 'phone',
    'relationship' => 'none',
  ),
  'street_address' => array(
    'label' => 'Address',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'link_class' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'street_address',
    'table' => 'civicrm_address',
    'field' => 'street_address',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array(
  'id' => array(
    'default_action' => 'ignore',
    'style_plugin' => 'default_summary',
    'style_options' => array(),
    'wildcard' => 'all',
    'wildcard_substitution' => 'All',
    'title' => '',
    'breadcrumb' => '',
    'default_argument_type' => 'fixed',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'break_phrase' => 0,
    'not' => 0,
    'id' => 'id',
    'table' => 'civicrm_contact',
    'field' => 'id',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
    ),
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'drupal_id',
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'panel' => 0,
      'civicrmactivity' => 0,
      'page' => 0,
      'profile' => 0,
      'story' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '1' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler->override_option('distinct', 1);
$handler = $view->new_display('panel_pane', 'Content pane', 'panel_pane_1');
$handler->override_option('pane_title', '');
$handler->override_option('pane_description', '');
$handler->override_option('pane_category', array(
  'name' => 'View panes',
  'weight' => 0,
));
$handler->override_option('allow', array(
  'use_pager' => FALSE,
  'items_per_page' => FALSE,
  'offset' => FALSE,
  'link_to_view' => FALSE,
  'more_link' => FALSE,
  'path_override' => FALSE,
  'title_override' => FALSE,
  'exposed_form' => FALSE,
));
$handler->override_option('argument_input', array(
  'uid' => array(
    'type' => 'panel',
    'context' => 'term.tid',
    'panel' => '0',
    'fixed' => '',
    'label' => 'User: Uid',
  ),
));
$handler->override_option('link_to_view', 0);
$handler->override_option('inherit_panels_path', 0);


just to tie this in... I found that if i create a User type View rather than a CiviCRM view it matches up and not double entry. With that in mind entries to the civicrm/views sync need to made... thanks to Jim Taylor please also see this thread http://forum.civicrm.org/index.php/topic,9135.0.html