compucorp / uk.co.compucorp.civicrm.pivotreport Goto Github PK
View Code? Open in Web Editor NEWCiviCRM Pivot table reporting solution
License: Other
CiviCRM Pivot table reporting solution
License: Other
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?
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.