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 »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Attendee listing w/ custom fields
Pages: [1]

Author Topic: Attendee listing w/ custom fields  (Read 1160 times)

obrienmd

  • Guest
Attendee listing w/ custom fields
May 21, 2009, 05:33:02 pm
I'm sure I'm missing something obvious here, but I've created an event, and added a good # of custom fields for registration.  I need our office administrator to be able to see a table of all registered attendees, with the custom fields as column headings on each attendee as a row.  Is this possible?

Ideally, I could also have the option to export this to CSV, but I understand that might not be built in.

Thanks in advance!

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Attendee listing w/ custom fields
May 21, 2009, 06:18:23 pm
Showing custom fields applied to participants is currently a little tricky (there are lots of options for contact related custom fields). You can't use search profiles or use a profile to display your search results from the participant search screen.

We ended up using Drupal Views. (e.g. http://sportzone.grdev.co.nz/players2/6/Johnsonville?status=All - in this example team and grade are custom fields)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Attendee listing w/ custom fields
May 21, 2009, 06:24:32 pm
Note that custom fields for participants ARE included in the built-in CSV export...

Find Participants
Select some or all rows
Select "Export" from -more actions- dropdown
Protect your investment in CiviCRM by  becoming a Member!

obrienmd

  • Guest
Re: Attendee listing w/ custom fields
May 21, 2009, 06:40:33 pm
I did this (export CSV), but none of the custom fields are included.

obrienmd

  • Guest
Re: Attendee listing w/ custom fields
May 21, 2009, 07:15:34 pm
Is there an easy way to describe where each event's specific custom fields are kept in the database?  Perhaps I could just hand-code some php for this table.

I'm not a major dev, but my thinking on this would be: grab event id, find out which fields are being used on registration, query all attendees for these fields, output to table...  Thoughts?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Attendee listing w/ custom fields
May 22, 2009, 04:00:12 am
Can we just double confirm that the Custom Fields are 'participant' and not 'event'?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

obrienmd

  • Guest
Re: Attendee listing w/ custom fields
May 22, 2009, 10:28:45 am
Hrm - let me check on this when I get to a non-netbook computer :)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Attendee listing w/ custom fields

This forum was archived on 2017-11-26.