0

Thanks is advance. I am using DDEV with Drupal 9.5.2 and CiviCRM 5.57.2 I would like to use civix to look at custom reports. Any advice on how to install it? I've look at the documentation but most of it is for installing on local machine, which is not what I use.

Best A.

2 Answers 2

1

You have probably solved this issue now given the time elapsed, but I'll answer what I think is your specific question 'How do I install Civix when using DDEV?' rather than 'What should I use for reporting with a Drupal/CiviCRM environment'

The quick route for you, without getting into customising your setup, is to SSH into the container and then run the usual setup for Civix to get the latest phar file (assumes you have already launched your containers)

ddev ssh
curl -LsS https://download.civicrm.org/civix/civix.phar -o /usr/local/bin/civix
chmod +x /usr/local/bin/civix

Once you have done this you can check all is working by running:

/usr/local/bin/civix

I am sure you are familiar with the command line so I'm sure you get the idea. See here for further details - Customizing Docker Images

I agree with the comments before - SearchKit is awesome in CiviCRM and if you have the CiviCRM Entity module installed, Drupal Views is also a way to go (particularly if you are using Drupal Webforms; as at the time of writing you cannot access Drupal Webform submission data as such with SearchKit)

If you are enterprise reporting, you can use other tools like Tableau, Microsofts PowerBI or an OpenSoure alternatives like Apache Superset to produce reports directly from the database (databases if you have a split Drupal and CiviCRM setup)

0

Have you tried using SearchKit to build your report? Going forward Searchkit is a way to build reports. We understand complex logics are not handled in Searchkit atm but if its simple report SearchKit is a best option over custom reports.

Custom reports:

  1. You will need to install Civix
  2. Create extension using civix
  3. Create report using civix command
1
  • 1
    Another option since you are using Drupal might be to use CiviCRM Entity plus Drupal Views. Not all tables are accessible this way but it does provide some additional options, and especially if you are more familiar with Drupal Views dev than CiviCRM dev might give you a quicker easier way to get you what you need. Commented Feb 2, 2023 at 0:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.