compucorp / uk.co.compucorp.civicrm.pivotreport Goto Github PK

I have clients with a need to report on Contacts for which Pivot Reports would be ideal.
However Cotnacts don't appear to be available in ther options.
Is it possible to add Contacts or other entities into the reporting options?
Would be good to do Contact reports by Created date, types, custom fields, state, communication prefs etc
Please advise,
Thanks

In an email Jamie said ... (ignore the name, it supports more then activities)

But when I enable it (and rebuild menus) while i do see an Activity Report entry which now gives the Pivot Table builder, I am unclear how to apply this for non-Activity data.

Add Added By, With and Assigned as choices for creating a Pivot Report of Activities.

Hi - just tried to give this a run for its money. first issue was link not showing up in Menu, once I figured that was Access and there was a Permission involved, I now see the menu item and do not get access denied at civicrm/activity-report

But all I get is the page permanently loading. No drupal log errors or any such to help me give you a clue.

Fatal error: Maximum execution time of 300 seconds exceeded in /.../sites/all/modules/civicrm/Civi/API/SelectQuery.php on line 162

Issue: After installing the extension by manually downloading the repository and putting it in the respective extensions dir within the WP site (in my case 4.7), the server gives error 500 when the Activity Report under Reports is clicked.

To Resolve: Calling Drupal-specific translate function t() inside CRM/Activityreport/Data.php is causing WP to fail. Deleting this function call solved the issue in my case.

Pivot Report: Version 2.0.7

Upgraded env. from: Drupal 10.2.3 - CiviCRM 5.70.2 - PHP version 8.2.18
to: Drupal 10.2.6 - CiviCRM 5.73.1 - PHP version 8.2.18

[PHP User Deprecation] Permission 'access CiviCRM pivot table reports' should be declared with 'label' and 'description' keys.
See https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_permission/
Caller: CRM_Core_Permission::assembleBasicPermissions at /var/www/vhosts/<domain>.be/httpdocs/vendor/civicrm/civicrm-core/CRM/Core/Error.php:1132
[PHP User Deprecation] Permission 'Admin Pivot Report' should be declared with 'label' and 'description' keys.
See https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_permission/
Caller: CRM_Core_Permission::assembleBasicPermissions at /var/www/vhosts/<domain>/httpdocs/vendor/civicrm/civicrm-core/CRM/Core/Error.php:1132

Hi, I've seen many great extensions, as yours is, refrain from extending support to grants within Civicrm, and I'm wondering why, since many not-for-profit organizations give out grants, have to balance the given amounts and would resort to your creation on a constant basis.
Would you accept a (non funded) request to extend the pivot reports to grants as well?
thanks for your work in any way

Hi

We recently had an issue with the database table civicrm_pivotreportcache.

It grew to about 18GB and crashed the whole server (disk full) taking down several sites.

Have you had any reports or issues regarding this table?

I installed this to test it out but am having strange results. When I try to view Contribution Pivot report, it seems to be endlessly loading. Right now it's at nearly 1300% loaded, whatever that means!

Any ideas?

Data label don't match data. I suspect that it is only happening in translated instance.

In the example below, Contact ID is associated with a date field:

For now, the workaround I've found is to use the field names instead of the label but of course not ideal.

diff --git a/CRM/PivotData/DataMembership.php b/CRM/PivotData/DataMembership.php
index e5ef564..fb0a4f2 100644
--- a/CRM/PivotData/DataMembership.php
+++ b/CRM/PivotData/DataMembership.php
@@ -131,6 +131,9 @@ class CRM_PivotData_DataMembership extends CRM_PivotData_AbstractData {
           }
           $result[$group . '.' . $key] = $value;
 
+          // [SV] quick hack to avoid problem with label being mixed up
+          $value['title'] = $value['name'];
+
           if (is_array($value)) {
             $result[$group . '.' . $key]['optionValues'] = $this->getOptionValues($value);
           }

I suspect there is a ksort somewhere that mess the matching between labels and data.

Currently when installed, it shows in the menu:

Pivot Report->Activity, Case, Membership

The extension should conditionally show/hide Case/Membership if those components are enabled/disabled.

Pivot oluşturmak için eklenti kurulumunu yaptım. Ancak erişim yapmaya çalıştığımda "The report data has not yet been built. Please contact your admin. Or if you are an admin, please go to Pivot Report Config to refresh the data." uyarısı alıyorum. Sisteme Super User olarak giriş yapıyorum. Ama Config bağlantısını tıkladığımda "The requested URL was not found on this server." uyarısı alıyorum. Sorunun nedeni ve çözümü için desteğinizi rica ederim.

Joomla: 3.9.25
CiviCRM: 5.35.0

This does not work with the jquery_update or civi_jquery modules. The console log shows errors "TypeError: e.ui.isOverAxis is not a function"

Hi

First of all, thank you so much for this extension. It is amazing! I have gotten more value out of my CiviCRM data than ever thanks to this.

My request is to support pivot reports on events.

The main type of report I'd be interested in is a table with users who have registered in rows and the event names as columns with X's or fees paid to mark the events that user has registered for. (We often do clusters of events and I would use this report to find people who have registered for some but not all of our weekend retreat for example.)

Other ideas that would add value for me would be, e.g., custom attributes as rows, events as columns, and seeing what events are attended by different users according to their custom attributes. Or according to their location.

I'm sure there are a million possibilities.

Thanks for your consideration. And thanks again for this amazing extension.