19 April, 2011

Sheila Burkett is the first winner of a copy of Using CiviCRM from Packt Publishing. Packt is running a promotional contest where you just have to post into the forum or email them to qualify to win a copy of the book.

Here's some more information about the book from the Press Release:

Using CiviCRM is the first commercially published book on CiviCRM, and came out in February 2011. It will teach readers to build a CRM that conforms to their needs and to integrate it with Drupal or Joomla!. Written by...

Read more
25 October, 2010
Filed under CiviReport

This has come up a couple of times before. According to my chat with Lobo today, not much is happening on this front. Since our client at Two Mice and a Strawberry has a need for this, we're diving in head first this week. Hopefully we'll have something that's worth contributing to core. Please comment below if you have any thoughts on the ideas presented here.

Our intent is to take the order_bys parameter that's mentioned passingly in the docs and build on it as follows.


The general idea

  • any column available for display is also available for...
Read more
17 December, 2009
Filed under CiviReport, v3.1, CiviCRM, Drupal, Joomla
The second BETA release of version 3.1 is now available for download. You can also try it out on our sandbox site. Please remember it’s a beta release and it shouldn’t be used on production sites.

This release includes several COOL new features:

  • Personal Dashboards - ** NEW in this beta release ** Each CiviCRM user can now configure their own dashboard (CiviCRM Home) to include summary data that's important to their work. Any available 'CiviReports' can be embedded in the dashboard in tabular or graphical format. Check out some examples on Kurund's recent blog post.
  • Contact Subtypes - Extend (and / or rename) the built-in contact types and create custom fields specific to a subtype (...
Read more
03 November, 2009
Filed under CiviReport, v3.0, CiviCRM, Drupal

Introduction: The Need

Progressive Technology Project (PTP) supports grassroots community organizing groups nationwide that engage in social, economic and environmental justice efforts to empower low-income people and communities of color. These groups conduct phone banking and field canvassing as an integral part of their base-building and voter engagement strategies to engage existing and new constituents. PTP hired DharmaTech to help them build PowerBase: a customized CiviCRM for use by community organizing groups.

PowerBase helps groups manage the following data related to phonebanking and field canvassing work:

  • voter info, history, and demographics
  • reason why the phonebank or canvass is taking place
  • responses to questions asked during the phonebank or canvass
  • phonebank or canvass...
Read more
05 October, 2009
By DaveD

The Physician Health Program of BC has a task that goes something like this: Their vendors, and even staff and board members, are not paid directly by them but by the provincial medical association (BCMA), so when invoices from vendors come in, they need to enter the information onto a special form and send that off to the BCMA for payment. Then they periodically send back a statement to reconcile against. Since all the vendors are contacts in CiviCRM already, it made sense to think about putting this in there too.

The customization for entering the invoices and generating the printable forms is currently in first-attempt mode and might still need some tweaking. You can find it in the unfortunately named php repository (php = physician health program). The reconciliation part isn't done yet so I'll just describe the first part. Well, I guess "not done yet" is a form of...

Read more
05 August, 2009
By andrew
This post started out as a reply to Eileen's "Banking Screen?" comment on my previous post on this topic, but by the time I was done, I thought that this warranted its own post. I think that the core "Accounts" or "Banking" functionality that could be helpful to Civi users without getting too out of control, is:
  1. generate a listing of the individual cheque and cash "receipts" processed since the last "deposit" was generated, add selected receipts to a deposit and print it as a deposit listing, using a template that would enable you to submit the listing to your bank with a deposit slip;
  2. enable a bank reconciliation to confirm that each deposit was successful and highlight any discrepancies such as bounced cheques or typo's when entering cash or cheque amounts. Ideally you would be able to tick off each receipt within a deposit as reconciled (or just tick the deposit as a whole and have the system mark each receipt within that deposit as reconciled). If a...
Read more
04 August, 2009
By andrew

We are finding that CiviCRM/accounts issues are becoming increasingly important for our clients, and Eileen's recent blogs and the discussion they are generating are a fantastic step towards helping find the best way for Civi to deal with financial transactions.

For example, I think it could be useful for Civi to ultimately develop functionality for maintaining simple bank accounts within CiviCRM, so that small organisations can maintain basic accounts without the headaches of integration with an external package.

Currently we have clients who are willing to rely on CiviCRM as being the central repository for the detail of all contributions, with a lump sum figure hitting their GL at the end of each month which can be reconciled against CiviCRM's records. This is largely reliant on the organisation having very good procedures in place to attend to banking on the same day as transactions are entered into CiviCRM, to make it easier for payments to be reconciled. It...

Read more
06 July, 2009
Version 2.2.7 was released today with CiviReport ("the return") phase 1. This version includes fourteen report templates with coverage for contact data, activities, contributions, events and memberships. Folks in the community who have had a chance to preview the functionality have been quite excited - and we think this is a significant step forward for CiviCRM. First, a few concepts... CiviReport is delivered with a set of report templates. Each template covers a general reporting area - for example: Donor Report (Summary), LYBUNT (Last Year but not this Year), etc. Administrators can then create one or more report instances from a template - with specific display columns, filters and grouping rules. Users go to the CiviReport menu to see a list of report instances, and run the reports.   For example, your organization might need a report which summarizes donations year-to-date grouped by Country. You create this instance from the... Read more
06 July, 2009

The team has released version 2.2.7 today. This release includes an important security update - and we recommend that you upgrade sites to this release as soon as possible. 2.2.7 also includes phase 1 of CiviReport - with 14 built-in report templates with coverage of contact data, contributions, events and memberships. Stay tuned for a separate blog post with lots more details on the new reporting features. You can review a complete list of 2.2.7 changes on the issue tracker.  


You can download CiviCRM 2.2.7 at our download page. Select from the Newest Files section at the top of the page. The filenames include the 2.2.7 label: civicrm-2.2.7…. Be sure and download the correct version for your CMS (...

Read more
08 May, 2009
By lobo
One of the reported shortcomings of CiviCRM has been the perceived "lack of reporting functionality". This is true to a large extent, but our hope was that most folks would either use
  • Traditional reporting solutions: BIRT, Jasper Reports and/or Crystal Reports. We demoed an integration with BIRT a few releases back, but this did not get any traction. There are a couple of larger deployments that have built custom reports using BIRT and Jasper.
  • Views2 and CiviCRM integration. However the lack of grouping / sub-total functionality has prevented this from being a complete reporting solution. This is also a drupal only solution
  • Custom Drupal modules / Joomla components. Quite a few folks have gone down this path, but there has not been a lot of sharing of these reports within the community
Based on the success of Custom Search, we decided that shipping CiviCRM with a few good... Read more