CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Searching/Exporting by Event Participation and Membership
Pages: [1]

Author Topic: Searching/Exporting by Event Participation and Membership  (Read 591 times)

mariagwyn

  • I post frequently
  • ***
  • Posts: 149
  • Karma: 4
  • CiviCRM version: CiviCRM 3.3.3
  • CMS version: Drupal 6.20
  • MySQL version: 5.2.14
  • PHP version: 5.0.91-50-log
Searching/Exporting by Event Participation and Membership
August 25, 2010, 05:36:34 pm
My client needs an export list which contains fields regarding event participation as well as the member status of the participant.

  • If I do a participant based search, I can create the export map with all relevant PARTICIPANT fields, but I cannot add membership fields.
  • If I do a member based search, I can export MEMBER fields, but not PARTICIPANT fields.
  • I.e., I can't export a single csv with BOTH Member and Participant Information.
If I use Advanced Search or Search Builder to search for Participants and Members, the only fields I can export are CONTACT related fields.  In other words, I can't even create a sort criteria which allows me to export a list of "Current" members who are also event participants using participant data.

Am I missing something?


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Searching/Exporting by Event Participation and Membership
August 25, 2010, 08:41:58 pm

you will need to write a custom search for this. if you do so, please share your code with the community

http://wiki.civicrm.org/confluence/display/CRMDOC32/Custom+Search+Components

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Searching/Exporting by Event Participation and Membership

This forum was archived on 2017-11-26.