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) »
  • What table?
Pages: [1]

Author Topic: What table?  (Read 2280 times)

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
What table?
June 05, 2007, 06:04:01 pm
What table is a person's event registration stored in?

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: What table?
June 05, 2007, 07:05:11 pm

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

mcsmom

  • I post frequently
  • ***
  • Posts: 266
  • Karma: 23
    • Official Joomla! Book
  • CiviCRM version: 4 and 3.4
  • CMS version: Joomla!
Re: What table?
June 06, 2007, 07:45:07 am
Thanks.

tmccartney

  • I post frequently
  • ***
  • Posts: 154
  • Karma: 9
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.28
Re: What table?
December 03, 2008, 11:17:30 am
I'm bumping an old topic for further clarification.  I have an event set up and have put in a few test registrations.  I've looked in the civicrm_participants table for the names and other info about the registrants, and I'm not seeing it.  All that table has is participant ID, contact ID, register date, etc.

Is there another table where this stuff might be getting stored?  I'm using a custom profile that contains some custom fields, if that matters.

Thanks!

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: What table?
December 03, 2008, 12:09:14 pm

you might want to skim thru the civicrm ERD: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+ERD+2.0

a lot of contact info is stored in the civicrm_contact table, address info in civicrm_address etc. All custom groups have dynamic tables created that store the custom values

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

tmccartney

  • I post frequently
  • ***
  • Posts: 154
  • Karma: 9
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.28
Re: What table?
December 03, 2008, 02:59:27 pm
There just doesn't appear to be any good way to extract usable data about your registrants from CiviCRM.  Is there a way to list participants other than just by name and e-mail address?  I'd like to be able to export them to their own table that I can use for mailing next year.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: What table?
December 03, 2008, 11:18:31 pm
You should use Find Participant,
Select Export Participants from more action
Select fields for exports.

Here you can select fields that you want.
You Are Designed To Choose... Defined By Choice.

tmccartney

  • I post frequently
  • ***
  • Posts: 154
  • Karma: 9
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.34-cll-lve
  • PHP version: 5.3.28
Re: What table?
December 04, 2008, 03:39:58 am
Thanks.  I finally figured out that my custom fields need to be added to the "Individual" group in order to be exported.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • What table?

This forum was archived on 2017-11-26.