Database Health Report

The Database Health Report  provides you with a snapshot of your CiviCRM database's usage. It reports the last login time and number of contacts and activities modified by each user. WIth this report, you can evaluate the effectiveness of staff trainings, or get a quick glimpse into which users are active and who may need more prodding.

Note: this is packaged as a native CiviCRM extensions, however, it includes queries that depend on Drupal's user table.

API key

Once installed, an 'API Key' tab will be available on contact screens for which you are authorized to manage the API key for this contact. You are authorized either if the contact if yourself, or if you are an administrator with the 'edit all contacts' permission.

You can then add an API key, Edit an exiting API key (with either manual input or an auto-generate feature) or Delete an API key (by setting it's value to blank).


API csv Import GUI

This extension facilitates uploading CSVs via the CiviCRM import interface. Useful for bulk uploading events or campaigns etc.

The civicrm api entity can be set to, for example, Event or Campaign. (Note that for entities like Contribution Pages you need to use API names - either ContributionPage or contribution_page). The same permissions apply as for any api create call.

To use you need to go to civicrm/csvimporter/import . More notes are in the README.


Custom Membership ID

We're using CiviCRM for contact and membership management. The problem is that the CiviCRM "Contact ID" doesn't really suit us as a member number, as not all contacts are members, and members need to have monotonically increasing for the issueance of membership books and packs.

Therefore we've created this CiviCRM extension.

The approach is to create a custom "Contact" entity field called "Membership_ID".

This number will be initalised to the next available number when a membership is created for a contact.

UK Phone Number Validator

Displays phone numbers that are likely to be invalid (in the UK), or that look to be incorrectly assigned as either a mobile phone number or a landline number.

Allows deletion and changes to any phone number through the interface.

USAGE: in the menu under 'Contacts'.

All feedback and additions welcome.

Normalise the data entered in firstname & last name

Normalise the data entered in several fields. So far firstname, last name... so they are Properly Capitalised

What does it do?

It modifies profiles and the normal contact edit/add so when you type (or paste) XAV as the first name, it converts it into Xav

The rule is simple: as long as there is at least one uppercase char and at least one lowercase one (mixed cases), it's good enough and happy.