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 (Moderator: Dave Greenberg) »
  • Modelling an organization's departments in civiCRM
Pages: [1]

Author Topic: Modelling an organization's departments in civiCRM  (Read 1139 times)

vchryssos

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
    • FOSS OFFICE
  • CiviCRM version: 4.5.3
  • CMS version: Joomla
  • MySQL version: 5.5.40-0+wheezy1
  • PHP version: 5.4.34-0+deb7u1
Modelling an organization's departments in civiCRM
February 04, 2015, 09:33:55 am
Hi guys,

I have done a research in this forum, in various civiCRM books and documentation and in the web. Until now I haven't managed to find a coherent answer to the question: how do I model the departments of an organization in civiCRM?

The most characteristic example being that of a university with its departments, faculties etc. (or even a ministry with departments). If a constituent works, for example, for the communication department of the Ministry of Internal Affairs, how would one input this kind of information? Bear in mind that one might need to monitor the time span of this specific constituent in the given place, thus it has to be a relationship of some kind.

A typical case would be the following: I have a lot of constituents which work at the communication departments of various organizations and need to send them a press release. At any given time I need to know that a specific organization has received the press release.

How would you model the organizations' departments in this framework?

KamesCG

  • I’m new here
  • *
  • Posts: 15
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Modelling an organization's departments in civiCRM
February 04, 2015, 10:28:07 am
I would define the most permanent entities like the Ministry of Internal Affairs as a Group and organize the sub-entities of the Ministry of Internal Affairs as Tags.

In specificity, I would create smart-tags, so people can organize themselves when you launch the website by completing certain actions and automatically assigned. For example, fill our Form A (General Information) and be assigned to to Group "Ministry of Internal Affairs" and be Tagged with "Communication".

You should be able to set that up in a few hours and put the workload on the individuals (as opposed to yourself) signing up for the right Group and Tag. You can always setup a workflow, where you still have to verify, but don't have to do the heavy lifting.

You will be able to achieve the level of control you are searching for using CiviMail without really any additional work. When you first start creating a CiviMail Email it asks what group you want to send to. From my understanding, emailing the sub-entities is as easy as designating the Tag under the Group as the targeted email list using more refined CiviMail settings.

--- Additional Comment ---

I would setup Profiles for the different the parent Entities, like Ministry of Internal Affairs, and use a Profiles form to automatically assign people to the sub-entity, like Communications, with a checkbox asking them "In what department in the Ministry of Internal Affairs do you work in?

Unfortunately, I am not to familiar with the Joomla version, but you should be able to theoretically to add forms to the user registration process, so could complete all the tasks of user creation, automatic group/tag assignment and mailing list creation in one simple process.

I would be happy to make a screencast if you aren't able to figure it out. CiviCRM is a large system and sometimes things are hidden in little nooks and crannies.
« Last Edit: February 04, 2015, 10:35:17 am by KamesCG »

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: Modelling an organization's departments in civiCRM
February 04, 2015, 12:04:52 pm
Another option would be to use Relationships since they track start/end dates eg

Comms Person (is comms person for) Department

Department (is Dept of) Faculty

Faculty (is faculty of) University

and if necessary

Individual (is contact person for) Faculty/Department/University

in which case you can then use the Extended Relationships extension we created so that there is 'permission trickle down' ie if the above are all set up so the 'higher' level is permissioned over the 'lower level' so that a 'contact person for the university' can have permission to update details about contacts further down the chain and  a 'contact person for the faculty' can have permission to update details about contacts further down the chain but not further up

not sure how clear that was as an explanation but .... ;-)

Individual (is contact person for) Deparm

Department (is department of) general Staff
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

KamesCG

  • I’m new here
  • *
  • Posts: 15
  • Karma: 2
  • CiviCRM version: 4.5.x
  • CMS version: Drupal 7.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Modelling an organization's departments in civiCRM
February 04, 2015, 01:37:04 pm
Quote from: petednz on February 04, 2015, 12:04:52 pm
Another option would be to use Relationships since they track start/end dates eg

Comms Person (is comms person for) Department

Department (is Dept of) Faculty

Faculty (is faculty of) University

and if necessary

Individual (is contact person for) Faculty/Department/University

in which case you can then use the Extended Relationships extension we created so that there is 'permission trickle down' ie if the above are all set up so the 'higher' level is permissioned over the 'lower level' so that a 'contact person for the university' can have permission to update details about contacts further down the chain and  a 'contact person for the faculty' can have permission to update details about contacts further down the chain but not further up

not sure how clear that was as an explanation but .... ;-)

Individual (is contact person for) Deparm

Department (is department of) general Staff

Do you have any more information on organizing people via the Extended Relationships. What's the overhead and fallbacks of relying on the Extended Relationships extension?

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: Modelling an organization's departments in civiCRM
February 04, 2015, 02:09:50 pm
not sure how to answer but perhaps this does ;-) https://civicrm.org/extensions/relationship-permissions-acls
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

vchryssos

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
    • FOSS OFFICE
  • CiviCRM version: 4.5.3
  • CMS version: Joomla
  • MySQL version: 5.5.40-0+wheezy1
  • PHP version: 5.4.34-0+deb7u1
Re: Modelling an organization's departments in civiCRM
February 06, 2015, 09:12:33 am
Thank you petednz for your prompt and insightful reply!

Quote from: petednz on February 04, 2015, 12:04:52 pm
Another option would be to use Relationships since they track start/end dates eg

Comms Person (is comms person for) Department

Department (is Dept of) Faculty

Faculty (is faculty of) University

and if necessary

Individual (is contact person for) Faculty/Department/University


I think the approach with relationships, that you propose, is more suitable for my case. Tracking dates is an important aspect of the organization's log.

Yet, I have this problem with the proposed approach: suppose you have 'Faculty of human related studies' for two different universities. Then you would end up with:
- Faculty of human related studies (is dpt of) Uni1
- Faculty of human related studies (is dpt of) Uni2

You could differentiate between the two by appending the Uni name to the 'Organization name' (e.g. Faculty of human related studies - Uni1), but this is not very convenient. And if you go further down that road and try to also add the Comms department for the given faculty then it could really get too long! (e.g. Comms - Faculty of human related studies - Uni1).

And why would one need to add all this information to the 'Organization Name'?
Because when you create a new contact and want to choose the proper relation that defines this contact's involvement in the organization, e.g. Individual is (contact person for) Dptmnt/Faculty/Organization, you must have a way to distinguish between the entities, e.g. faculties, which otherwise have the same 'Organization Name' (e.g. Faculty of human related studies).

Quote from: petednz on February 04, 2015, 12:04:52 pm
in which case you can then use the Extended Relationships extension we created so that there is 'permission trickle down' ie if the above are all set up so the 'higher' level is permissioned over the 'lower level' so that a 'contact person for the university' can have permission to update details about contacts further down the chain and  a 'contact person for the faculty' can have permission to update details about contacts further down the chain but not further up

not sure how clear that was as an explanation but .... ;-)

Individual (is contact person for) Deparm

Department (is department of) general Staff

Thanx for the tip! I will definitely check this out.

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: Modelling an organization's departments in civiCRM
February 06, 2015, 02:54:20 pm
Quote from: vchryssos on February 06, 2015, 09:12:33 am
Yet, I have this problem with the proposed approach: suppose you have 'Faculty of human related studies' for two different universities. Then you would end up with:
- Faculty of human related studies (is dpt of) Uni1
- Faculty of human related studies (is dpt of) Uni2

You could differentiate between the two by appending the Uni name to the 'Organization name' (e.g. Faculty of human related studies - Uni1), but this is not very convenient. And if you go further down that road and try to also add the Comms department for the given faculty then it could really get too long! (e.g. Comms - Faculty of human related studies - Uni1).

And why would one need to add all this information to the 'Organization Name'?
Because when you create a new contact and want to choose the proper relation that defines this contact's involvement in the organization, e.g. Individual is (contact person for) Dptmnt/Faculty/Organization, you must have a way to distinguish between the entities, e.g. faculties, which otherwise have the same 'Organization Name' (e.g. Faculty of human related studies).
Yes I see the problem. There are settings at civicrm/admin/setting/search?reset=1 where you can specify what fields should show when you are using search dropdowns. It may point a way to a solution but I can't quite figure what it might be but even ticking 'city' would help a bit assuming you don't have that many universities in same city (heck we don't in NZ!)
Alternatively you (or someone on your behalf) may be able to conjure up some magic so that the autocompletes could show the name of the organisation that has permission over them. no idea what is involved but seems like it would solve the issue
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

vchryssos

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
    • FOSS OFFICE
  • CiviCRM version: 4.5.3
  • CMS version: Joomla
  • MySQL version: 5.5.40-0+wheezy1
  • PHP version: 5.4.34-0+deb7u1
Re: Modelling an organization's departments in civiCRM
February 11, 2015, 05:22:04 am
I guess the simplest solution would just be to amend the Department's title with some indicative keyword, e.g. Dpt. of Applied Siences (UCLA).

Much less trouble..

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Modelling an organization's departments in civiCRM

This forum was archived on 2017-11-26.