4

An organization sells a variety of membership types. The goal is to generate an exported CSV that will contain name, address, membership type, and amount paid for that membership.

Two types of memberships are the same price, and CiviDiscount is in use regardless. Thus total amount of the membership contribution is not a reliable way to determine which membership type someone has purchased.

Unless I use price sets and the 'extended reports' extension from Eileen, I cannot find a way to export "membership type (membership)" as well as "total amount (contribution)" data in the same CSV export.

But this extended report doesn't contain address. So time to expand that report I guess?

Am I missing an easier solution here?

enter image description here

  • Is a Drupal View an option? – pmoz Nov 12 '15 at 20:46
  • You could export the view to a csv with View Data Export – pmoz Nov 12 '15 at 22:36
2
+100

I just tried this (at Stoob's request) on one report & it seemed to only require a couple of lines -

https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/commit/fb5ba0d47b1c4fea651fcec5760497bf204c5b56

Note that there are several price set reports & this might not be the one you were focussed on but the principle should be the same

0

I do think expanding the report might be the way forward. If you are developer you could expand on Eileens extension and expand the report code in that extension. That way you also giving back to the community!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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