Answers.Body: <p>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).</p>
  
  <p>After doing that, I make sure that I do a complete cache clear in Drupal so that it picks up the changes I made.</p>
  
  <p>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:</p>
  
  <p><a href="https://i.sstatic.net/T32A8.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/T32A8.jpg" alt="enter image description here"></a></p>
  
  <p>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.</p>
  
  <p><a href="https://i.sstatic.net/lZlWX.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/lZlWX.jpg" alt="enter image description here"></a></p>
  
  <p>Here's the code that is in my settings file:</p>
  
  <p><code>$databases = array (
    'default' => 
    array (
      'default' => 
      array (
        'database' => 'databasename',
        'username' => 'username',
        'password' => 'mypassword',
        'host' => 'localhost',
        'port' => '',
        'driver' => 'mysql',
        'prefix' => '',
      ),
    ),
  );</p>
  
  <p>$databases['default']['default']['prefix']= array(
    'default' => '',
    'civicrm_acl'                              => '<code>dbname_crm4</code>.',
    'civicrm_acl_cache'                        => '<code>dbname_crm4</code>.',
    'civicrm_acl_contact_cache'                => '<code>dbname_crm4</code>.',
    'civicrm_acl_entity_role'                  => '<code>dbname_crm4</code>.',
    'civicrm_action_log'                       => '<code>dbname_crm4</code>.',
    'civicrm_action_mapping'                   => '<code>dbname_crm4</code>.',
    'civicrm_action_schedule'                  => '<code>dbname_crm4</code>.',
    'civicrm_activity'                         => '<code>dbname_crm4</code>.',
    'civicrm_activity_contact'                 => '<code>dbname_crm4</code>.',
    'civicrm_address'                          => '<code>dbname_crm4</code>.',
    'civicrm_address_format'                   => '<code>dbname_crm4</code>.',
    'civicrm_batch'                            => '<code>dbname_crm4</code>.',
    'civicrm_cache'                            => '<code>dbname_crm4</code>.',
    'civicrm_campaign'                         => '<code>dbname_crm4</code>.',
    'civicrm_campaign_group'                   => '<code>dbname_crm4</code>.',
    'civicrm_case'                             => '<code>dbname_crm4</code>.',
    'civicrm_case_activity'                    => '<code>dbname_crm4</code>.',
    'civicrm_case_contact'                     => '<code>dbname_crm4</code>.',
    'civicrm_case_type'                        => '<code>dbname_crm4</code>.',
    'civicrm_component'                        => '<code>dbname_crm4</code>.',
    'civicrm_contact'                          => '<code>dbname_crm4</code>.',
    'civicrm_contact_type'                     => '<code>dbname_crm4</code>.',
    'civicrm_contribution'                     => '<code>dbname_crm4</code>.',
    'civicrm_contribution_page'                => '<code>dbname_crm4</code>.',
    'civicrm_contribution_product'             => '<code>dbname_crm4</code>.',
    'civicrm_contribution_recur'               => '<code>dbname_crm4</code>.',
    'civicrm_contribution_soft'                => '<code>dbname_crm4</code>.',
    'civicrm_contribution_widget'              => '<code>dbname_crm4</code>.',
    'civicrm_country'                          => '<code>dbname_crm4</code>.',
    'civicrm_county'                           => '<code>dbname_crm4</code>.',
    'civicrm_currency'                         => '<code>dbname_crm4</code>.',
    'civicrm_custom_field'                     => '<code>dbname_crm4</code>.',
    'civicrm_custom_group'                     => '<code>dbname_crm4</code>.',
    'civicrm_dashboard'                        => '<code>dbname_crm4</code>.',
    'civicrm_dashboard_contact'                => '<code>dbname_crm4</code>.',
    'civicrm_dedupe_exception'                 => '<code>dbname_crm4</code>.',
    'civicrm_dedupe_rule'                      => '<code>dbname_crm4</code>.',
    'civicrm_dedupe_rule_group'                => '<code>dbname_crm4</code>.',
    'civicrm_discount'                         => '<code>dbname_crm4</code>.',
    'civicrm_domain'                           => '<code>dbname_crm4</code>.',
    'civicrm_email'                            => '<code>dbname_crm4</code>.',
    'civicrm_entity_batch'                     => '<code>dbname_crm4</code>.',
    'civicrm_entity_file'                      => '<code>dbname_crm4</code>.',
    'civicrm_entity_financial_account'         => '<code>dbname_crm4</code>.',
    'civicrm_entity_financial_trxn'            => '<code>dbname_crm4</code>.',
    'civicrm_entity_tag'                       => '<code>dbname_crm4</code>.',
    'civicrm_event'                            => '<code>dbname_crm4</code>.',
    'civicrm_event_carts'                      => '<code>dbname_crm4</code>.',
    'civicrm_events_in_carts'                  => '<code>dbname_crm4</code>.',
    'civicrm_extension'                        => '<code>dbname_crm4</code>.',
    'civicrm_file'                             => '<code>dbname_crm4</code>.',
    'civicrm_financial_account'                => '<code>dbname_crm4</code>.',
    'civicrm_financial_item'                   => '<code>dbname_crm4</code>.',
    'civicrm_financial_trxn'                   => '<code>dbname_crm4</code>.',
    'civicrm_financial_type'                   => '<code>dbname_crm4</code>.',
    'civicrm_grant'                            => '<code>dbname_crm4</code>.',
    'civicrm_group'                            => '<code>dbname_crm4</code>.',
    'civicrm_group_contact'                    => '<code>dbname_crm4</code>.',
    'civicrm_group_contact_cache'              => '<code>dbname_crm4</code>.',
    'civicrm_group_nesting'                    => '<code>dbname_crm4</code>.',
    'civicrm_group_organization'               => '<code>dbname_crm4</code>.',
    'civicrm_im'                               => '<code>dbname_crm4</code>.',
    'civicrm_job'                              => '<code>dbname_crm4</code>.',
    'civicrm_job_log'                          => '<code>dbname_crm4</code>.',
    'civicrm_line_item'                        => '<code>dbname_crm4</code>.',
    'civicrm_loc_block'                        => '<code>dbname_crm4</code>.',
    'civicrm_location_type'                    => '<code>dbname_crm4</code>.',
    'civicrm_log'                              => '<code>dbname_crm4</code>.',
    'civicrm_mail_settings'                    => '<code>dbname_crm4</code>.',
    'civicrm_mailing'                          => '<code>dbname_crm4</code>.',
    'civicrm_mailing_abtest'                   => '<code>dbname_crm4</code>.',
    'civicrm_mailing_bounce_pattern'           => '<code>dbname_crm4</code>.',
    'civicrm_mailing_bounce_type'              => '<code>dbname_crm4</code>.',
    'civicrm_mailing_component'                => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_bounce'             => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_confirm'            => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_delivered'          => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_forward'            => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_opened'             => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_queue'              => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_reply'              => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_subscribe'          => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_trackable_url_open' => '<code>dbname_crm4</code>.',
    'civicrm_mailing_event_unsubscribe'        => '<code>dbname_crm4</code>.',
    'civicrm_mailing_group'                    => '<code>dbname_crm4</code>.',
    'civicrm_mailing_job'                      => '<code>dbname_crm4</code>.',
    'civicrm_mailing_recipients'               => '<code>dbname_crm4</code>.',
    'civicrm_mailing_spool'                    => '<code>dbname_crm4</code>.',
    'civicrm_mailing_trackable_url'            => '<code>dbname_crm4</code>.',
    'civicrm_managed'                          => '<code>dbname_crm4</code>.',
    'civicrm_mapping'                          => '<code>dbname_crm4</code>.',
    'civicrm_mapping_field'                    => '<code>dbname_crm4</code>.',
    'civicrm_membership'                       => '<code>dbname_crm4</code>.',
    'civicrm_membership_block'                 => '<code>dbname_crm4</code>.',
    'civicrm_membership_log'                   => '<code>dbname_crm4</code>.',
    'civicrm_membership_payment'               => '<code>dbname_crm4</code>.',
    'civicrm_membership_status'                => '<code>dbname_crm4</code>.',
    'civicrm_membership_type'                  => '<code>dbname_crm4</code>.',
    'civicrm_menu'                             => '<code>dbname_crm4</code>.',
    'civicrm_navigation'                       => '<code>dbname_crm4</code>.',
    'civicrm_note'                             => '<code>dbname_crm4</code>.',
    'civicrm_openid'                           => '<code>dbname_crm4</code>.',
    'civicrm_option_group'                     => '<code>dbname_crm4</code>.',
    'civicrm_option_value'                     => '<code>dbname_crm4</code>.',
    'civicrm_participant'                      => '<code>dbname_crm4</code>.',
    'civicrm_participant_payment'              => '<code>dbname_crm4</code>.',
    'civicrm_participant_status_type'          => '<code>dbname_crm4</code>.',
    'civicrm_payment_processor'                => '<code>dbname_crm4</code>.',
    'civicrm_payment_processor_type'           => '<code>dbname_crm4</code>.',
    'civicrm_payment_token'                    => '<code>dbname_crm4</code>.',
    'civicrm_pcp'                              => '<code>dbname_crm4</code>.',
    'civicrm_pcp_block'                        => '<code>dbname_crm4</code>.',
    'civicrm_persistent'                       => '<code>dbname_crm4</code>.',
    'civicrm_phone'                            => '<code>dbname_crm4</code>.',
    'civicrm_pledge'                           => '<code>dbname_crm4</code>.',
    'civicrm_pledge_block'                     => '<code>dbname_crm4</code>.',
    'civicrm_pledge_payment'                   => '<code>dbname_crm4</code>.',
    'civicrm_preferences_date'                 => '<code>dbname_crm4</code>.',
    'civicrm_premiums'                         => '<code>dbname_crm4</code>.',
    'civicrm_premiums_product'                 => '<code>dbname_crm4</code>.',
    'civicrm_prevnext_cache'                   => '<code>dbname_crm4</code>.',
    'civicrm_price_field'                      => '<code>dbname_crm4</code>.',
    'civicrm_price_field_value'                => '<code>dbname_crm4</code>.',
    'civicrm_price_set'                        => '<code>dbname_crm4</code>.',
    'civicrm_price_set_entity'                 => '<code>dbname_crm4</code>.',
    'civicrm_print_label'                      => '<code>dbname_crm4</code>.',
    'civicrm_product'                          => '<code>dbname_crm4</code>.',
    'civicrm_queue_item'                       => '<code>dbname_crm4</code>.',
    'civicrm_recurring_entity'                 => '<code>dbname_crm4</code>.',
    'civicrm_relationship'                     => '<code>dbname_crm4</code>.',
    'civicrm_relationship_type'                => '<code>dbname_crm4</code>.',
    'civicrm_report_instance'                  => '<code>dbname_crm4</code>.',
    'civicrm_saved_search'                     => '<code>dbname_crm4</code>.',
    'civicrm_setting'                          => '<code>dbname_crm4</code>.',
    'civicrm_sms_provider'                     => '<code>dbname_crm4</code>.',
    'civicrm_state_province'                   => '<code>dbname_crm4</code>.',
    'civicrm_subscription_history'             => '<code>dbname_crm4</code>.',
    'civicrm_survey'                           => '<code>dbname_crm4</code>.',
    'civicrm_system_log'                       => '<code>dbname_crm4</code>.',
    'civicrm_tag'                              => '<code>dbname_crm4</code>.',
    'civicrm_tell_friend'                      => '<code>dbname_crm4</code>.',
    'civicrm_timezone'                         => '<code>dbname_crm4</code>.',
    'civicrm_uf_field'                         => '<code>dbname_crm4</code>.',
    'civicrm_uf_group'                         => '<code>dbname_crm4</code>.',
    'civicrm_uf_join'                          => '<code>dbname_crm4</code>.',
    'civicrm_uf_match'                         => '<code>dbname_crm4</code>.',
    'civicrm_value_additional_information_1'   => '<code>dbname_crm4</code>.',
    'civicrm_value_commerce_purchases_6'       => '<code>dbname_crm4</code>.',
    'civicrm_value_event_information_9'        => '<code>dbname_crm4</code>.',
    'civicrm_value_host_location_5'            => '<code>dbname_crm4</code>.',
    'civicrm_value_hotel_information_4'        => '<code>dbname_crm4</code>.',
    'civicrm_value_hotels_3'                   => '<code>dbname_crm4</code>.',
    'civicrm_value_member_information_2'       => '<code>dbname_crm4</code>.',
    'civicrm_value_private_training_8'         => '<code>dbname_crm4</code>.',
    'civicrm_value_private_trainings_7'        => '<code>dbname_crm4</code>.',
    'civicrm_website'                          => '<code>dbname_crm4</code>.',
    'civicrm_word_replacement'                 => '<code>dbname_crm4</code>.',
    'civicrm_worldregion'                      => '<code>dbname_crm4</code>.',
  );
  </code></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-21T02:05:53.770Z
Answers.Text: 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. :)
Answers.UserDisplayName: Jenni Simonis
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-19T05:24:16.733Z
Answers.LastActivityDate: 2017-11-19T05:24:16.733Z
Answers.UserDisplayName: Jenni Simonis
Body: <p>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...</p>
  
  <p>... I have added the variable from sites/all/modules/civicrm/install/index.php e.g. the :</p>
  
  <pre><code>$databases['default']['default']['prefix']= array(
  'default' =&gt; 'drup_',
  'civicrm_acl'   =&gt; '`adef_civi_`.',
  ... all the way to...
  );
  </code></pre>
  
  <p>after the $databases line:</p>
  
  <pre><code>$databases = array('default' =&gt; array( 'default' =&gt; array(
  'driver' =&gt; 'mysql',
  'database' =&gt;
  etc...
  </code></pre>
  
  <p>In the settings.php file, which resides under /sites/default/</p>
  
  <p>Also, the base url is set in the civicrm.settings.php file e.g.</p>
  
  <pre><code>if (!defined('CIVICRM_UF_BASEURL')) {
       define( 'CIVICRM_UF_BASEURL'      , 
       'https://www.example.com/');
  }
  </code></pre>
  
  <p>Any one have any idea as to why the fields won't show up in Views?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-18T22:36:52.010Z
Comments.Text: When you create the View, what Add New View are you doing (Content, User, CiviCRM...)?
Comments.UserDisplayName: Allen Hutchison
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-18T22:44:27.607Z
Comments.Text: Admin > Structure > Views .. "Add new view" ... Type Page.
Comments.UserDisplayName: Mo-ster
Tags: <drupal><drupal-views><fields>
Title: Drupal 7 Views Not Seeing CiviCRM fields
ThreadText: # Drupal 7 Views Not Seeing CiviCRM fields
  
  (Asked by: username_0 on 2017-11-18)
  
  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?
  
  **Tags:** drupal, drupal-views, fields
  
  > **Comments:**
  > **username_1**: When you create the View, what Add New View are you doing (Content, User, CiviCRM...)?  
  > **username_0**: Admin > Structure > Views .. "Add new view" ... Type Page.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2017-11-19. Score: 1 | Accepted answer
  
  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](https://i.sstatic.net/T32A8.jpg)](https://i.sstatic.net/T32A8.jpg)
  
  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](https://i.sstatic.net/lZlWX.jpg)](https://i.sstatic.net/lZlWX.jpg)
  
  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`.',
  );
  
  > **Comments:**
  > **username_2**: 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. :)  
  
  ---
  
  