CiviCRM Community Forums (archive)

My goal is to create an alumni group for our organization. I am using Drupal 6.26, CiviCRM 4.2.4, Webform 6.x-3.17, User Registration 6.x-1.x-dev, and Webform CiviCRM Integration 6.x-2.6.

I created the webform and that seems to work fine. Users can fill out the form and it creates a CiviCRM contact record for them and it also creates a Drupal account for them if they don't already have one.

I would now like to set this up so that only Alumni can look at the Alumni Directory. I created a profile, called Alumni Directory (with all of the fields that I want in the directory), and checked off 'Standalone Form or Directory' and 'Search Views'. This all works fine, when I point a browser at that URL I have a form that shows any field that I made searchable. I do a search and the results are as expected. My only issue is trying to make that form accessible only to those that are in the CiviCRM group 'Alumni'. I'm not seeing any way to do this. Can someone point me in the right direction?

That does sound like a good way of doing it. Of course, when I tried I got some issues.

I created a View of type 'CiviCRM Contacts'. When I try to add a field I get the following error:

user warning: Table '[SITE NAME].civicrm_contact' doesn't exist query: SELECT COUNT(*) FROM (SELECT civicrm_contact.first_name AS civicrm_contact_first_name, civicrm_contact.id AS id, civicrm_contact.last_name AS civicrm_contact_last_name FROM civicrm_contact civicrm_contact ) count_alias in C:\apache2\htdocs\drupal\sites\all\modules\views\plugins\views_plugin_pager.inc on line 141.

I looked at the information on this at http://drupal.org/node/1028988 and it looks like I needed to add the output of civicrm/admin/uf in my settings.php file, which I did. After doing this I'm still getting the aforementioned error. Should that be in settings.php or in civicrm.settings.php. I eventually placed it in both files and I'm still getting the error.

The code that I used was:
$databases['default']['default']['prefix']= array(
       
  'civicrm_acl'                              => '`civicrm`.',
  'civicrm_acl_cache'                        => '`civicrm`.',
  'civicrm_acl_contact_cache'                => '`civicrm`.',
  ...
);

Should 'default' and 'prefix' be modified? I just pulled it verbatim from the page.

I also saw the following in that page:

Are you sharing a database between CiviCRM and Drupal? If so then your prefix would be ''. If your CiviCRM DB is called 'civicrm' then the prefix is 'civicrm.'.

I am not sharing the Drupal database. Is there a place in civicrm.settings.php or in settings.php that this has to go?

I tried something a bit different but that does not seem to be working either. I tried to limit access to this profile via ACLs; however, access is not limited, anyone can view the profile.

Here is what I did:

• Created a profile called 'Alumni directory'
• Created a contact group called 'Alumni. This group currently has no members
• Created an ACL Role called Alumni member
• Created an ACL called 'Access alumni directory. With Role = 'Alumni member', Operation = 'View', Type of data = 'A profile', Profile = 'Alumni directory'
• Added a Role Assignment - ACL Role = "Alumni member', Assigned to = 'Alumni'

I can see how this would give anyone in the CiviCRM group 'Alumni' the ability to see the profile 'Alumni directory' but I'm not seeing any way of limiting the ability of anyone that is NOT is the group from seeing the profile. Whenever I go to http://SITE-NAME/civicrm/profile/profile?reset=1&gid=[PROFILE-ID] as any user, even anonymous, I can see the profile.

Am I not understanding how this works (I obviously feel that is indeed the case)?

does this database and table exist?

 Table '[SITE NAME].civicrm_contact'

based on the error. I would go about debugging that and see why its giving that error? does the same user have permissions on both the databases etc

lobo

u'll need to play around with drupal's settings.php and tweak it so views uses the civi db for all civi tables

lobo