admin help

News and Information

Created to help with Admin functions

  1. When the Drupal User does not match up with the correct Civicrm user, you can change this my doing a sql query in the civicrm database to table civicrm_uf_match.
    1. for example 

      update `civicrm_uf_match` set contact_id = replace (contact_id, '720', '907'); 

      Where 720 is the civicrm Contact_ID of what it is connected to and 920 is the civicrm contact id you want to change it to.  you can find the contact_id by doing a civicrm search and selecting the contact, the contact id will be in the URL .   The uf_id in the civicrm_uf_match corresponds the drupal user id which can be seen the the URL when viewing the user.

       
  2. When doing a search builder  query for birthdate range, use "<" "19960801" and ">=" "19940901"
  3. admin access to phplist login/passwd admin/gr8!ASA22
  4. top set breaks use "<!--break-->" 
  5. Using RSVP to send a invitation.
    1. Invitations only send in non-HTML, so format it in text form.  After convert to HTML so that viewing it will look better.
    2. Only send invitations in batches of 10 emails