CiviCRM Community Forums (archive)

Hi all,

Hoping that someone can shed some light, as I've been trying to figure this out for hours.  I can't see any of my custom fields in Views 2, even though I'm fairly sure I've integrated correctly.  The following custom field groups are listed in my settings.php file:

  'civicrm_value_affiliations_1'             => 'civicrm.',
  'civicrm_value_anhlc_memberships_8'        => 'civicrm.',
  'civicrm_value_annual_income_5'            => 'civicrm.',
  'civicrm_value_annual_nhcp_funding_6'      => 'civicrm.',
  'civicrm_value_auspice_information_3'      => 'civicrm.',
  'civicrm_value_committee_memberships_7'    => 'civicrm.',
  'civicrm_value_network_affiliations'       => 'civicrm.',
  'civicrm_value_organisation_information_4' => 'civicrm.',
  'civicrm_value_test_network_affiliations'  => 'civicrm.',
 
but none of the above appear in Views.  I don't get any errors using core fields, just no option to select custom fields at all.  Any help would be greatly appreciated!

Cheers,
Erica.

Peter, I had a look at my prefix and it's currently just $db_prefix = array(.  I've tried changing it to some of the other prefixes mentioned in the documentation but they all cause the site to break.  Is there something else I should be trying?  FYI, my civicrm is in a different DB to my drupal.

Hi all,

Still trying to figure this one out and have discovered that my Membership and Relationship custom fields are showing up fine, but not for Contacts.  When double checking in PHPMyAdmin that my custom field groups for contacts were active I noticed a difference in the "extends_entity_column_value" table.  For Membership and Relationship custom field groups it gives an ID number of the membership or relationship type, but for all my contact field groups it gives the name of the my contact sub-type instead of the ID number.

I changed the value to the ID number of the contact sub-type in my DB, but this didn't bring the custom field group into views.  I then added a custom field group just for "organization" with no sub type, and this group now appears in views.

So I conclude that Civi/Views are having trouble communicating with Contact Sub Types, but I'm not sure how to fix this!

Any ideas?

ericaordinary ,

So I conclude that Civi/Views are having trouble communicating with Contact Sub Types, but I'm not sure how to fix this!

I tried with CiviCRM 3.2.1 and views 2.11 with custom data Used for Individual and Type student. And I can see the custom fields in views. Is yours the same custom data type ?


Rahul.

Just tested by making a new organisation sub-type and custom data group for that sub-type and views picked up the data group fine.  I think there must be an issue with my existing contact sub-types.  Is there a way to clear civicrm's cache to see if that fixes the problem?