1

I've installed Drupal 7 (7.56) and installed CiviCRM (4.7.27) and the Views Module (with accompanying modules)... however, when I try creating a view... and select "Add a field" the CiviCRM fields are not appearing...

... I have added the variable from sites/all/modules/civicrm/install/index.php e.g. the :

$databases['default']['default']['prefix']= array(
'default' => 'drup_',
'civicrm_acl'   => '`adef_civi_`.',
... all the way to...
);

after the $databases line:

$databases = array('default' => array( 'default' => array(
'driver' => 'mysql',
'database' =>
etc...

In the settings.php file, which resides under /sites/default/

Also, the base url is set in the civicrm.settings.php file e.g.

if (!defined('CIVICRM_UF_BASEURL')) {
     define( 'CIVICRM_UF_BASEURL'      , 
     'https://www.example.com/');
}

Any one have any idea as to why the fields won't show up in Views?

  • When you create the View, what Add New View are you doing (Content, User, CiviCRM...)? – Allen Hutchison Nov 18 '17 at 22:36
  • Admin > Structure > Views .. "Add new view" ... Type Page. – Mo-ster Nov 18 '17 at 22:44
1

Here's what is in my settings.php file, although sanitized to remove actual database names, password, etc (found at the bottom of this post).

After doing that, I make sure that I do a complete cache clear in Drupal so that it picks up the changes I made.

Then I go into Views and choose to make a view that is a CiviCRM type (such as one for events or people) - see screenshot:

enter image description here

Once I do that and then go to the next page (to create a page, block, etc), then I have the CiviCRM fields available for what I chose. In this example, I selected CiviCRM Events, so the fields are all related to events.

enter image description here

Here's the code that is in my settings file:

$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'databasename', 'username' => 'username', 'password' => 'mypassword', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => '', ), ), );

$databases['default']['default']['prefix']= array( 'default' => '', 'civicrm_acl' => 'dbname_crm4.', 'civicrm_acl_cache' => 'dbname_crm4.', 'civicrm_acl_contact_cache' => 'dbname_crm4.', 'civicrm_acl_entity_role' => 'dbname_crm4.', 'civicrm_action_log' => 'dbname_crm4.', 'civicrm_action_mapping' => 'dbname_crm4.', 'civicrm_action_schedule' => 'dbname_crm4.', 'civicrm_activity' => 'dbname_crm4.', 'civicrm_activity_contact' => 'dbname_crm4.', 'civicrm_address' => 'dbname_crm4.', 'civicrm_address_format' => 'dbname_crm4.', 'civicrm_batch' => 'dbname_crm4.', 'civicrm_cache' => 'dbname_crm4.', 'civicrm_campaign' => 'dbname_crm4.', 'civicrm_campaign_group' => 'dbname_crm4.', 'civicrm_case' => 'dbname_crm4.', 'civicrm_case_activity' => 'dbname_crm4.', 'civicrm_case_contact' => 'dbname_crm4.', 'civicrm_case_type' => 'dbname_crm4.', 'civicrm_component' => 'dbname_crm4.', 'civicrm_contact' => 'dbname_crm4.', 'civicrm_contact_type' => 'dbname_crm4.', 'civicrm_contribution' => 'dbname_crm4.', 'civicrm_contribution_page' => 'dbname_crm4.', 'civicrm_contribution_product' => 'dbname_crm4.', 'civicrm_contribution_recur' => 'dbname_crm4.', 'civicrm_contribution_soft' => 'dbname_crm4.', 'civicrm_contribution_widget' => 'dbname_crm4.', 'civicrm_country' => 'dbname_crm4.', 'civicrm_county' => 'dbname_crm4.', 'civicrm_currency' => 'dbname_crm4.', 'civicrm_custom_field' => 'dbname_crm4.', 'civicrm_custom_group' => 'dbname_crm4.', 'civicrm_dashboard' => 'dbname_crm4.', 'civicrm_dashboard_contact' => 'dbname_crm4.', 'civicrm_dedupe_exception' => 'dbname_crm4.', 'civicrm_dedupe_rule' => 'dbname_crm4.', 'civicrm_dedupe_rule_group' => 'dbname_crm4.', 'civicrm_discount' => 'dbname_crm4.', 'civicrm_domain' => 'dbname_crm4.', 'civicrm_email' => 'dbname_crm4.', 'civicrm_entity_batch' => 'dbname_crm4.', 'civicrm_entity_file' => 'dbname_crm4.', 'civicrm_entity_financial_account' => 'dbname_crm4.', 'civicrm_entity_financial_trxn' => 'dbname_crm4.', 'civicrm_entity_tag' => 'dbname_crm4.', 'civicrm_event' => 'dbname_crm4.', 'civicrm_event_carts' => 'dbname_crm4.', 'civicrm_events_in_carts' => 'dbname_crm4.', 'civicrm_extension' => 'dbname_crm4.', 'civicrm_file' => 'dbname_crm4.', 'civicrm_financial_account' => 'dbname_crm4.', 'civicrm_financial_item' => 'dbname_crm4.', 'civicrm_financial_trxn' => 'dbname_crm4.', 'civicrm_financial_type' => 'dbname_crm4.', 'civicrm_grant' => 'dbname_crm4.', 'civicrm_group' => 'dbname_crm4.', 'civicrm_group_contact' => 'dbname_crm4.', 'civicrm_group_contact_cache' => 'dbname_crm4.', 'civicrm_group_nesting' => 'dbname_crm4.', 'civicrm_group_organization' => 'dbname_crm4.', 'civicrm_im' => 'dbname_crm4.', 'civicrm_job' => 'dbname_crm4.', 'civicrm_job_log' => 'dbname_crm4.', 'civicrm_line_item' => 'dbname_crm4.', 'civicrm_loc_block' => 'dbname_crm4.', 'civicrm_location_type' => 'dbname_crm4.', 'civicrm_log' => 'dbname_crm4.', 'civicrm_mail_settings' => 'dbname_crm4.', 'civicrm_mailing' => 'dbname_crm4.', 'civicrm_mailing_abtest' => 'dbname_crm4.', 'civicrm_mailing_bounce_pattern' => 'dbname_crm4.', 'civicrm_mailing_bounce_type' => 'dbname_crm4.', 'civicrm_mailing_component' => 'dbname_crm4.', 'civicrm_mailing_event_bounce' => 'dbname_crm4.', 'civicrm_mailing_event_confirm' => 'dbname_crm4.', 'civicrm_mailing_event_delivered' => 'dbname_crm4.', 'civicrm_mailing_event_forward' => 'dbname_crm4.', 'civicrm_mailing_event_opened' => 'dbname_crm4.', 'civicrm_mailing_event_queue' => 'dbname_crm4.', 'civicrm_mailing_event_reply' => 'dbname_crm4.', 'civicrm_mailing_event_subscribe' => 'dbname_crm4.', 'civicrm_mailing_event_trackable_url_open' => 'dbname_crm4.', 'civicrm_mailing_event_unsubscribe' => 'dbname_crm4.', 'civicrm_mailing_group' => 'dbname_crm4.', 'civicrm_mailing_job' => 'dbname_crm4.', 'civicrm_mailing_recipients' => 'dbname_crm4.', 'civicrm_mailing_spool' => 'dbname_crm4.', 'civicrm_mailing_trackable_url' => 'dbname_crm4.', 'civicrm_managed' => 'dbname_crm4.', 'civicrm_mapping' => 'dbname_crm4.', 'civicrm_mapping_field' => 'dbname_crm4.', 'civicrm_membership' => 'dbname_crm4.', 'civicrm_membership_block' => 'dbname_crm4.', 'civicrm_membership_log' => 'dbname_crm4.', 'civicrm_membership_payment' => 'dbname_crm4.', 'civicrm_membership_status' => 'dbname_crm4.', 'civicrm_membership_type' => 'dbname_crm4.', 'civicrm_menu' => 'dbname_crm4.', 'civicrm_navigation' => 'dbname_crm4.', 'civicrm_note' => 'dbname_crm4.', 'civicrm_openid' => 'dbname_crm4.', 'civicrm_option_group' => 'dbname_crm4.', 'civicrm_option_value' => 'dbname_crm4.', 'civicrm_participant' => 'dbname_crm4.', 'civicrm_participant_payment' => 'dbname_crm4.', 'civicrm_participant_status_type' => 'dbname_crm4.', 'civicrm_payment_processor' => 'dbname_crm4.', 'civicrm_payment_processor_type' => 'dbname_crm4.', 'civicrm_payment_token' => 'dbname_crm4.', 'civicrm_pcp' => 'dbname_crm4.', 'civicrm_pcp_block' => 'dbname_crm4.', 'civicrm_persistent' => 'dbname_crm4.', 'civicrm_phone' => 'dbname_crm4.', 'civicrm_pledge' => 'dbname_crm4.', 'civicrm_pledge_block' => 'dbname_crm4.', 'civicrm_pledge_payment' => 'dbname_crm4.', 'civicrm_preferences_date' => 'dbname_crm4.', 'civicrm_premiums' => 'dbname_crm4.', 'civicrm_premiums_product' => 'dbname_crm4.', 'civicrm_prevnext_cache' => 'dbname_crm4.', 'civicrm_price_field' => 'dbname_crm4.', 'civicrm_price_field_value' => 'dbname_crm4.', 'civicrm_price_set' => 'dbname_crm4.', 'civicrm_price_set_entity' => 'dbname_crm4.', 'civicrm_print_label' => 'dbname_crm4.', 'civicrm_product' => 'dbname_crm4.', 'civicrm_queue_item' => 'dbname_crm4.', 'civicrm_recurring_entity' => 'dbname_crm4.', 'civicrm_relationship' => 'dbname_crm4.', 'civicrm_relationship_type' => 'dbname_crm4.', 'civicrm_report_instance' => 'dbname_crm4.', 'civicrm_saved_search' => 'dbname_crm4.', 'civicrm_setting' => 'dbname_crm4.', 'civicrm_sms_provider' => 'dbname_crm4.', 'civicrm_state_province' => 'dbname_crm4.', 'civicrm_subscription_history' => 'dbname_crm4.', 'civicrm_survey' => 'dbname_crm4.', 'civicrm_system_log' => 'dbname_crm4.', 'civicrm_tag' => 'dbname_crm4.', 'civicrm_tell_friend' => 'dbname_crm4.', 'civicrm_timezone' => 'dbname_crm4.', 'civicrm_uf_field' => 'dbname_crm4.', 'civicrm_uf_group' => 'dbname_crm4.', 'civicrm_uf_join' => 'dbname_crm4.', 'civicrm_uf_match' => 'dbname_crm4.', 'civicrm_value_additional_information_1' => 'dbname_crm4.', 'civicrm_value_commerce_purchases_6' => 'dbname_crm4.', 'civicrm_value_event_information_9' => 'dbname_crm4.', 'civicrm_value_host_location_5' => 'dbname_crm4.', 'civicrm_value_hotel_information_4' => 'dbname_crm4.', 'civicrm_value_hotels_3' => 'dbname_crm4.', 'civicrm_value_member_information_2' => 'dbname_crm4.', 'civicrm_value_private_training_8' => 'dbname_crm4.', 'civicrm_value_private_trainings_7' => 'dbname_crm4.', 'civicrm_website' => 'dbname_crm4.', 'civicrm_word_replacement' => 'dbname_crm4.', 'civicrm_worldregion' => 'dbname_crm4.', );

  • Glad to hear it. Sometimes I've found I just need to see the entire text and process in writing to catch what I've missed. :) – Jenni Simonis Nov 21 '17 at 2:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.