Answers.Body: <p>Sohal, see this video from CiviCON Denver 2015 as well - it might help -
  <a href="https://youtu.be/i2GpnrVGdrc?list=PLjSU7YfE0E01HW7JPVAI80XDI0sgOSPDs" rel="nofollow">CiviCON Denver- CiviCRM Drupal Integration Showcase</a> </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-09T13:30:19.227Z
Answers.Text: Joe the video is great. Learned a fair bit from it. However, no solution to the code.
Answers.UserDisplayName: Sohal Khatwani
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-09T19:22:56.920Z
Answers.Text: Sohal, oh well. A question - why are you not using just one database for both CiviCRM and Drupal?
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-10T00:09:54.820Z
Answers.Text: Hi Joe, we prefer to keep the database separate as some of our clients do not go for CiviCRM and once integrated we find it quite hard to remove CiviCRM from Drupal when the database is the same.
Answers.UserDisplayName: Sohal Khatwani
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-08T20:19:57.243Z
Answers.LastActivityDate: 2015-08-08T20:19:57.243Z
Answers.UserDisplayName: Joe McLaughlin
Answers.Body: <p>Solved. You need to go to your civicrm.settings file first and then add the drupal base URL in the section where it says add your drupal URL and then you will see the code. </p>
  
  <ol>
  <li><p>Follow the steps in the link for Views. </p></li>
  <li><p>In the civicrm.settings.php file there will a comment around line 58 which asks to enter the Content Management System (CMS) database connection details. Once this is entered the views should show up. </p></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-10T03:12:06.470Z
Answers.Text: Congratulations!
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-10T21:11:56.503Z
Answers.Text: surprised that wasn't causing other havoc
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-11T04:53:09.230Z
Answers.Text: Thanks Joe. Pete we are really beginning to integrate CiviCRM into websites more seamlessly. I am sure that it would cause some chaos in the longer run if not fixed.
Answers.UserDisplayName: Sohal Khatwani
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-29T08:41:42.767Z
Answers.Text: @SohalKhatwani I'm having the same problem but I'm not understanding your solution. Which line did you edit in `civicrm.settings.php` ?
  
  The way this response is written it's like replacing the MySQL URL with the base URL which doesn't make sense at all. Can offer more detailed instructions? ty.
Answers.UserDisplayName: atmosx
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-30T06:47:18.537Z
Answers.Text: Hi @atmosx. There are a couple of steps to get the CiviCRM data into Drupal Views. I will add another detailed answer below.
Answers.UserDisplayName: Sohal Khatwani
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-30T06:49:26.067Z
Answers.Text: Hey, thanks for the reply. My problem was not installing views at all. Works as expected now.
Answers.UserDisplayName: atmosx
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-10T02:55:50.573Z
Answers.LastActivityDate: 2016-08-30T06:50:01.717Z
Answers.LastEditDate: 2016-08-30T06:50:01.717Z
Answers.UserDisplayName: Sohal Khatwani
Body: <p>I am trying to integrate Views with CiviCRM but cannnot see the code in the CMS Datbase section to add to the settings.php file. I am stuck on step 5. Has anyone come across this issue?</p>
  
  <p>The steps are here - <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration" rel="nofollow">http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration</a> </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-08T17:38:30.207Z
Comments.Text: If you are using one database for both Civi and Drupal, then you don't need the code for Views integration.
Comments.UserDisplayName: pmoz
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-09T12:57:01.880Z
Comments.Text: Using different databases for them. Thanks pmoz
Comments.UserDisplayName: Sohal Khatwani
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-09T20:52:33.853Z
Comments.Text: so are you saying that at /civicrm/admin/setting/uf?reset=1 you see nothing? any other indications that your drupal<->civi linkages is problematic? do you have a drupal user id on the contact summary screen and can click it to go to the user record, and vice versa, on drupal user record do you have the civi Name and Address profile showing, and the link back to the civi record?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-08-09T23:12:05.540Z
Comments.Text: That is right pete. I can click between both civicrm user and the drupal user record and it works fine. I cannot see any linkage problem. I see the link to the contact dashboard on the drupal user field.
Comments.UserDisplayName: Sohal Khatwani
Tags: <drupal-views>
Title: Trying to integrate Views with CiviCRM but cannot see the code
ThreadText: # Trying to integrate Views with CiviCRM but cannot see the code
  
  (Asked by: username_0 on 2015-08-08)
  
  I am trying to integrate Views with CiviCRM but cannnot see the code in the CMS Datbase section to add to the settings.php file. I am stuck on step 5. Has anyone come across this issue?
  
  The steps are here - <http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration>
  
  **Tags:** drupal-views
  
  > **Comments:**
  > **username_1**: If you are using one database for both Civi and Drupal, then you don't need the code for Views integration.  
  > **username_0**: Using different databases for them. Thanks username_1  
  > **username_2**: so are you saying that at /civicrm/admin/setting/uf?reset=1 you see nothing? any other indications that your drupal<->civi linkages is problematic? do you have a drupal user id on the contact summary screen and can click it to go to the user record, and vice versa, on drupal user record do you have the civi Name and Address profile showing, and the link back to the civi record?  
  > **username_0**: That is right pete. I can click between both civicrm user and the drupal user record and it works fine. I cannot see any linkage problem. I see the link to the contact dashboard on the drupal user field.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2015-08-10. Score: 3 | Accepted answer
  
  Solved. You need to go to your civicrm.settings file first and then add the drupal base URL in the section where it says add your drupal URL and then you will see the code.
  
  1. Follow the steps in the link for Views.
  2. In the civicrm.settings.php file there will a comment around line 58 which asks to enter the Content Management System (CMS) database connection details. Once this is entered the views should show up.
  
  > **Comments:**
  > **username_3**: Congratulations!  
  > **username_2**: surprised that wasn't causing other havoc  
  > **username_0**: Thanks Joe. Pete we are really beginning to integrate CiviCRM into websites more seamlessly. I am sure that it would cause some chaos in the longer run if not fixed.  
  > **username_4**: @username_0 I'm having the same problem but I'm not understanding your solution. Which line did you edit in `civicrm.settings.php` ?  The way this response is written it's like replacing the MySQL URL with the base URL which doesn't make sense at all. Can offer more detailed instructions? ty.  
  > **username_0**: Hi @username_4. There are a couple of steps to get the CiviCRM data into Drupal Views. I will add another detailed answer below.  
  > **username_4**: Hey, thanks for the reply. My problem was not installing views at all. Works as expected now.  
  
  ---
  
  ### Answer by username_3 on 2015-08-08. Score: 0
  
  username_0, see this video from CiviCON Denver 2015 as well - it might help -
  [CiviCON Denver- CiviCRM Drupal Integration Showcase](https://youtu.be/i2GpnrVGdrc?list=PLjSU7YfE0E01HW7JPVAI80XDI0sgOSPDs)
  
  > **Comments:**
  > **username_0**: Joe the video is great. Learned a fair bit from it. However, no solution to the code.  
  > **username_3**: username_0, oh well. A question - why are you not using just one database for both CiviCRM and Drupal?  
  > **username_0**: Hi Joe, we prefer to keep the database separate as some of our clients do not go for CiviCRM and once integrated we find it quite hard to remove CiviCRM from Drupal when the database is the same.  
  
  ---
  
  