CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • How to handle many groups
Pages: [1]

Author Topic: How to handle many groups  (Read 2262 times)

daveatkins

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
  • CiviCRM version: 4.1.6
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.41
  • PHP version: 5.2.10
How to handle many groups
September 20, 2011, 10:58:10 am
Our CiviCRM is a migration from ACT! We have hundreds of groups there and while we have simplified and eliminated many, we will end up with dozens of groups of contacts--sometimes with very similar names. The organization structure is about committees, subcommittees, and projects--so we identify individuals as mailing list groups for each of these entities--a fairly hierarchical structure; e.g.

Committee 1
 - project 1 - all interested people
 - project 2 - all interested people
 - complete list of interested people
 - leadership and management representatives
 - subcommittee to manage project 1
etc.

I understand we could do a lot with smart groups and tagging...but how do we deal with the flat listing of groups in all the menus? Is there any way to organize the display of groups for management so they show up together with their parent committee? I see an option to specify a parent when creating a group, but this does not seem to do anything of significance--AAA Test group shows up first, then ZZZ subgroup is at the very end of the list.

I've considered using a naming convention; like "Committee Name, project name" - is that the best we can do or is there any way to manage the groups in a hierarchical manner?

ctarascio

  • I post frequently
  • ***
  • Posts: 334
  • Karma: 30
    • American Friends Service Committee
  • CiviCRM version: 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: 5.5.20
  • PHP version: 5.3.13
Re: How to handle many groups
September 20, 2011, 11:12:49 am
hi,
unfortunately, unless you want to get into customizing the code, your only option is establishing a logical naming convention. Or, you could fund this as a project for the core developer team: http://forum.civicrm.org/index.php/topic,16967.msg72233.html#msg72233 and http://civicrm.org/mih

cynthia

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to handle many groups
September 20, 2011, 01:20:44 pm

this module by andrew harris might be useful:

http://drupal.org/sandbox/adharris/1284168

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: How to handle many groups
September 28, 2011, 04:06:03 pm
Dave
We've been using Civi for 4 months and this is exactly the same issue our organisation is facing.  We're also checking out the Andrew Harris info that lobo mentioned with interest.  We are currently doing various things - some interim, some not, some simple, some more sophisticated:

- We haven't used tagging for groups but we have used parenting hierarchies extensively (though you're right that this doesn't 'show' in the Manage Groups area).  I need group names to remain intuitive so have used a naming convention/code in the Description box.  All this does at present is give a quick reference point about the hierarchy.  It would be more use if the Description column could be ordered (like every other column on that page).  I've posted on the forum to see if that might be possible.   

- We're looking into http://emphanos.com/blog/ re Civi option lists as you can add a 'group type' (in addition to Access Control and Mailing List) and search by type eg Committee 1 to just show those groups.

- We've also created a view (see attachment) that enables us to see groups within their parented hierarchies.  This view also shows the number of people in each group/subgroup and clicking on a group name allows all group members to be seen in the right hand column (I haven't shown this as it includes real names!) It's currently proving a challenge to get the hierarchies to show in csv but we're persevering. 

We also plan to develop reporting capabilities on hierarchied groups in the coming months to detail growth and decline over time.  I blogged about this (a bit long-windedly) at http://civicrm.org/blogs/davem/marketing-civicrm as we'd love the sort of reporting available in Civimember to apply to groups too. 

We're committed to the use of groups as we sync our Civi groups with Drupal Organic Groups to enable lots of (imminent) functionality for logged in group members on our website www.woodlandschurch.net 

I'm not a developer so can't tell you more about the groups view technically but let me know if it's of interest and I'll try to get technical info from our developer for you. 

Lindsey

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: How to handle many groups
September 29, 2011, 12:20:01 pm
hi lindsey - would be great if you could export your view and attach at .txt so others can give it a whirl ;-)
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: How to handle many groups
October 03, 2011, 10:53:42 am
Hi Pete
It's too complex for that so we'll set up a sandbox project on drupal.org  Will take a few days to get round to that but I will try to remember to post when we do!
Lindsey

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: How to handle many groups
October 03, 2011, 12:28:19 pm
Thanks Lindsey
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

daveatkins

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
  • CiviCRM version: 4.1.6
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.41
  • PHP version: 5.2.10
Re: How to handle many groups
October 12, 2011, 11:50:55 am
Thanks for the followup replies here. The approach we are looking at now is adopting a naming convention and tweaking the way the groups are created in Civi. I don't have full developer insight into how this works either, but basically we have:

1) groups that are created in Civi automatically when organic groups are created in Drupal and users are granted a role of participant in the group. These are intended to be "read-only" groups--users are not allowed to manage them in Civi.
2) regular groups that users may create on their own from Civi
3) smart groups created in Civi

Right now, the groups from #1 end up in Civi with names like "January 2011" In Drupal, "January 2011" is a child group of "Board Meetings". So, if we can simply cause the name in Civi to be "Board Meetings - January 2011 (Participants)" this would solve the issue from my perspective. For #2 and #3, we can tell people to follow the naming conventions. That is all we really need and all we can afford given we have about 10 hours of development time to spend on this part of our project.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: How to handle many groups
October 12, 2011, 01:19:06 pm
Hi - can you explain why you can't name the OG Nodes as you want them and therefore have the CiviCRM ACL Groups created from them having the names you want?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

daveatkins

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
  • CiviCRM version: 4.1.6
  • CMS version: Drupal 6.28
  • MySQL version: 5.1.41
  • PHP version: 5.2.10
Re: How to handle many groups
October 13, 2011, 06:48:49 am
The OG nodes are named by staff and are used to create committees and projects in a collaborative site. Visually, it will look terrible if the "flattened" information is displayed in this manner on the website. So for example you would see, on a committee page, the title of "XYZ Committee" and then a list of the projects (child groups). If it is possible to have an internal OG name that is used in Civi and a separate display name, then yes, that would solve the problem. A similar issue arises for permalinks when people go in and change the name of the group, etc.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: How to handle many groups
October 13, 2011, 07:06:07 am

civicrm_group and many other civicrm tables have 2 fields:

name - internal name / programmatic handle

title or label - display title / label

Seems like u will need to modify the code if you want the title to to be the OG hierarchy title

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Re: How to handle many groups
October 04, 2012, 12:23:18 pm
Quote from: LindseyM on September 28, 2011, 04:06:03 pm
- We've also created a view (see attachment) that enables us to see groups within their parented hierarchies.  This view also shows the number of people in each group/subgroup and clicking on a group name allows all group members to be seen in the right hand column (I haven't shown this as it includes real names!) It's currently proving a challenge to get the hierarchies to show in csv but we're persevering. 

Hi Lindsey

How did you create that view? I'm very keen to have that functionality.

cheers
Ryan

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: How to handle many groups
October 13, 2012, 10:14:27 am
Hi Ryan
I blogged about it recently at http://civicrm.org/blogs/lindseym/new-features-extension-civi-groups and there's a link to the extension on that page. We're also hoping to make  attendance recording/reporting for groups a reality via the new Recurring Events Make it Happen project so do check out my post at http://civicrm.org/blogs/lindseym/recurring-events-%E2%80%93-it%E2%80%99s-time-%E2%80%98make-it-happen%E2%80%99 and donate if you can!

Lindsey

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Re: How to handle many groups
October 16, 2012, 04:32:04 pm
Hi Lindsey

Thanks so much for that - I will install on our new instance of 4.1.5 and have a play.

cheers!
Ryan

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • How to handle many groups

This forum was archived on 2017-11-26.