search

compucorp / uk.co.compucorp.civicrm.pivotreport

CiviCRM Pivot table reporting solution
Other
8 stars 13 forks source link

Installation issues with 4.7.14 #10

Open petednz opened 7 years ago

petednz commented 7 years ago

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

petednz commented 7 years ago

In case this is a conflict with other extensions, these are what are enabled

CiviCRM Report Error (ca.bidon.reporterror) Civisualize. The missing data visualization extension (eu.tttp.civisualize) Custom Field triggers for alted (nz.co.fuzion.altedtriggers) Annual Year Level (nz.co.fuzion.annualyearlevel)
Entity Settings Helper Extension (nz.co.fuzion.entitysetting) ExtendedReport (nz.co.fuzion.extendedreport)
Related Permissions Module (nz.co.fuzion.relatedpermissions)

xurizaemon commented 7 years ago

Nice work, this extension looks 🎸

On the site @petednz is testing, the extension page times out because the site in question has ~30K activities + custom fields, and the page tries to load all the activities into the page as a JSON array.

petednz commented 7 years ago

tried it on a more vanilla site. was able to get page to load at /civicrm/activity-report but all i see is Activity Pivot Table and have 19 errors showing in console eg activity-report:492 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/pivottable/c3.min.css?r=hdmQ0 activity-report:494 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/style.css?r=hdmQ0 activity-report:493 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/css/pivottable/pivot.css?r=hdmQ0 activity-report:398 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/jquery-migrate-1.4.1.min.js?r=hdmQ0 activity-report:400 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/jquery-ui-1.9.2.custom.min.js?r=hdmQ0 activity-report:402 GET http://rm11473.fudev.co.nz/sites//files/civicrm/ext/uk.co.compucorp.civicrm.activityreport/js/pivottable/pivot.min.js?r=hdmQ0

jamienovick commented 7 years ago

Hi Peter / xurizaemon, thanks for the feedback. We'd welcome patches if you can see solutions, otherwise well try and get some eyes on looking at how this can scale to a larger number of activities in the new year.

Best

jamienovick commented 6 years ago

@petednz @xurizaemon Can I ask you guys to test out the latest version of the extension? It has some caching for larger data sets now Let me know your thoughts. Best Jamie

petednz commented 6 years ago

Sure. have assigned to kaylie for some testing.