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) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Multisite Aggregate Reporting
Pages: [1]

Author Topic: Multisite Aggregate Reporting  (Read 1218 times)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Multisite Aggregate Reporting
March 07, 2009, 04:04:43 pm
I am faced with a situation where one NPO would like to share its online services with a few other similar NPOs. This group runs Drupal and we are in the processing of upgrading from Drupal 5 and CiviCRM 2.1.4 to Drupal 6 and CiviCRM 2.2. One requirement of this project is that no NPO is allowed to see the contacts nor groups of any other NPO. Presumably if we allow them to create custom fields, which I imagine will be necessary, they also won't be allowed to see each others' fields.

The simplest solution would be to create for each NPO a unique CiviCRM database. Each will certainly have a unique Drupal database. The only issue with that is that the main NPO wants to run reports on all contacts across all NPOs. So if the main NPO is NYC and it has two 'client' NPOs called Chicago and LA, then the NYC office (and only NYC) wants to run reports regarding activities, events and other facets of all contacts in NYC, Chicago and LA.

This may well be a purely reporting issue and not strictly a CiviCRM issue, but aggregate database reporting is not something I am familiar with, so if anyone has any suggestions where to learn more about this, I would appreciate it. The only solution suggested thus far is to run the reports (custom PHP and MySQL) against each database independently in succession and then just combine the results across the various databases mathematically in PHP. I suspect there may be a smarter way, however.

The other solution suggested was to share one CiviCRM database and attempt to implement strong ACL rules to keep Chicago out of LA's data etc, but I think that will prove to be more work in the long run.

Thank you.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

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: Multisite Aggregate Reporting
March 07, 2009, 08:29:36 pm

I think mysql allows you to query across tables in multiple databases (assuming the mysql user has the right access to all those databases). You might want to read up and check on that feature of mysql

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

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Multisite Aggregate Reporting
March 08, 2009, 01:30:46 am
Thank you.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

stkrzysiak

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.5.5
  • CMS version: Drupal
  • MySQL version: 5.2
  • PHP version: 5.2
Re: Multisite Aggregate Reporting
July 07, 2011, 09:20:24 am
I am encountering the same multi civi instance aggregate reporting hurdle.  Has anything or method come along to make this easier? 

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • Multisite Aggregate Reporting

This forum was archived on 2017-11-26.