Treasure Trove

We did this a while back, and a question on StackExchange meant it was worth sharing.
 This view has another View as a field using drupal views_field_view so there are two views attached. You will probably hit less problems if you import in this orderrecur latest contribution.txtrecur_contribution.txt
Per a request in StackExchanged I cloned this View and cleaned it up in case it could help in their use case.  The view ensures the block shows activities Assigned to the logged in user.
Quickly built this to provide an example view for this question on Stack Exchange. Obviously the relationship types may need resetting to match which relationships are required. They should have Individual as Contact A and Organisation as Contact B.
This came up as a question for a civi report that could provide a pivot table for contacts created each month v the Source field. Having done most of these bits for other use cases I wanted to confirm this would work here.This View uses Aggregation feature in Views under Advanced and the Pivot… more
A question on StackExchange had me wondering if a View would provide a solution for showing Civi Memberships and OG Memberships so I put together a very simple proof of concept. 
A StackExchange question asked how to provide a link to whatever was the latest newsletter. Seemed like a good fit for a View so tried one out. Here is the file. if it helps, let us know.
If you have the CiviCRM Entities module (2.x version)  and the Calendar module then in Views you should find that you can use "Add from template" and there is a template for Civi Event.Previous to the 2.x version of Entities the View needed hand crafting and there is an example attached.
A request on StackExchange seemed like a good candidate for a View using Aggregation that would give a count of how many Memberships had changed from eg Grace to Expired in a particular period, and by Membership Type.Note that you may need to login or Masquerade as user/1 to get access to the… more
It has been possible to make batch changes to CiviCRM data using VBO (Views Bulk Operations) for a while but I only just got around to implementing it for a customer so I am taking the chance to document what I did here!The recipe is basically- install civicrm_entity version 2.x & vbo- create a… more
Because CiviCRM uses ? in its urls it can get tricky to specify when you want a Drupal Block to show on specific donation or other pages.A solution we found to work well is the https://www.drupal.org/project/block_query which adds a new Visibility Setting called Query.There you can set eg id=39 … more
I did this to help out on the CiviCRM Forum. It should show the logged in user any events they are registered for.The ingredients for the view recipe are (in short)View of type 'CiviCRM Participant'View Relationships of type CiviCRM Contacts: Drupal ID (which connects the Participant to the Drupal… more
In many cases, such as for the European Greens, we want to create Drupal pages for some contacts, in their case Parties, so that we can pull together both a collection of information about the contact from Civi, and display related Drupal content, such as News items about the Party. You can see an… more
The European Greens (and other clients since) wanted to have blocks showing News items relating to their Party pages, so that for example a news item that 'node references' Die Grunen would show up on the page about Die Grunen.The concept is simple enough and can be handled in Views but requires a… more
This has come up repeatedly on the Civi Forums and in this case International Mountain Biking Association needed one for Drupal 6, so I thought I would quickly share a Drupal 6 and Drupal 7 solution as a starting point for others.The block is built from a View based on 'memberships' and links the… more
This extension uses the cssin library (https://github.com/djfm/cssin) to convert style sheet links to inline css. This is important for content that is going to a gmail account to render correctly. Also, it makes it easier to see the same thing in your browser as the final emailFor example<link… more
This extension supports CiviXero but has been written so that it could also support different accounting synchronisations in the hope it will encourage greater collaboration. It is a dependency of CiviXeroIt providestables for storing event sync info - in particular civicrm_account_contact &… more
Extended report framework including priceset reports
This extension facilitates uploading CSVs via the CiviCRM import interface. Useful for bulk uploading events or campaigns etc.The civicrm api entity is currently a free-text field which can be set to, for example, Event or Campaign. (Note that for entities like Contribution Pages you need to use… more
This extensions makes the permission flag on a contact's relationship work as a true ACL. In core CiviCRM that flag only allows the user to see the contact's dashboard. However, in many cases it is a useful mechanism to give people permission to view contact records and search for contacts.Contacts… more
When a customer buys something from the Ubercart store, this module:Creates a CiviCRM contact record if the purchaser doesn't already exist.Adds the purchaser to the specified CiviCRM group.Adds (or updates) a contribution history to their record. (this works by rules in Drupal 7. This is not… more
This is a sandbox project, which contains experimental code for developer use only.The most up-to-date code is at githubThis is a migrate add on module for CiviCRM - see http://fuzion.co.nz/content/migrate-2-civicrm-api-3-civimigratehttps://github.com/eileenmcnaughton/civimigrate
A module that provides CiviCRM entities (contacts, addresses, phones) as Drupal entities, to allow rules integration, entity references, node to civi-views etc.
It is possible to integrate CiviCRM with Xero - although the extension (purposefully) cannot be downloaded through the UI as it defintely requires someone technically savy to be involved in setting it up & maintaining it. In this blog I'm going to explain what you can expect and what you can't… more