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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • custom data and events
Pages: [1]

Author Topic: custom data and events  (Read 1167 times)

CousiMo

  • I post frequently
  • ***
  • Posts: 126
  • Karma: 2
custom data and events
September 25, 2007, 10:25:11 pm
I am trying to print out a list of participants for a certain event, and show some custom data for that participatnt ..

1. On Civicrm_custom_option i see the id # that i want to search for, but where do i see the "indivudual with this custom info?

if i look under _custom_value, i see char data with some #'s is that it?   if so how does relate to custom_option

i am suing navicat to access the mysql databse
civcirm 1.8

2. is there a way for me to do this under the civicrm?

thanks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: custom data and events
September 25, 2007, 11:21:16 pm
If you set your custom data fields as "Searchable" - you can use CiviEvent >> Find Participants to search by Event and/or Field Values. If you use the Export action from these search results, the custom field option values will be included in the export rows.
Protect your investment in CiviCRM by  becoming a Member!

CousiMo

  • I post frequently
  • ***
  • Posts: 126
  • Karma: 2
Re: custom data and events
September 26, 2007, 06:30:56 am
That worked for exporting but i am getting the full database, not just the event i searched for.. it 637 for exporting then when it exported it exported 20,000 names

What about using a Navicatmsql, to access the database.. where how is the custom data stored

tahnks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: custom data and events
September 26, 2007, 10:01:18 am
Assuming you are using the latest CiviCRM release, export should output only the selected / or all rows FROM YOUR SEARCH RESULTS. If you are getting different behavior - can you please try and recreate this on the demo site (http://demo.civicrm.org/drupal).

If you still want to get at the data directly in the DB... all custom field values are stored in civicrm_custom_value table. This table contains keys to the custom field the data is associated with, and to the contact, participant etc record the data belongs to (entity_table, entity_id). Multiple-selection field values are stored in char_data w/ a non-printing character delimiter between values.

Check the ERD on the wiki for more details on the schema:
http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+ERD
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • custom data and events

This forum was archived on 2017-11-26.