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 Import View interface at admin/structure/views/import.

Following on the blog by Eileen about using CiviCRM Entities and Views Bulk Operations (VBO) to update start/end dates of civi Relationships in bulk, another client asked for a quick solution for them confirming who attended an event. This was a free event, they had sent out invites, and wanted a quick way to mark people as 'attending' so that they could then bulk update the Pariticipant Status for those who showed up.

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 View

- add and configure the desired 'bulk operation'

And, setting up a View with a bulk operation to modify Relationship End Dates was pretty much that easy

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 example of that for the German Bundnis party here. (And I will write this approach up in greater detail later)

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 bit of extra configuration.

We recently had a situation where we wanted to synchronise CiviCRM relationships to drupal roles using Drupal rules. We had been doing this for a while - creating a Volunteer role when the contact got a new Volunteer relationship and removing it when the relationship was deleted or expired. However, the problem was that the contact might have another relationship that entitled them to have the Drupal role.

FUZION IS ...

a globally focussed company, based in NZ, working to assist organisations and businesses that are 'doing good' to 'do better'. We deliver effective websites, databases and campaign tools and strategies and build long-term relationships with our clients.

SOLUTIONS WE USE ...

are free and open source software combined with over 30 years of experience. Mostly we work with CiviCRM, Drupal and WordPress. We also integrate with other solutions such as Xero, Moodle and MailChimp to give our clients the best outcome possible.