Participant Export - include custom fields

[lcdweb]

The event participant export process doesn't let me include custom fields. Can I easily hack them into the export code? I really just need one field. I'm looking at CRM/Event/DAO/Participant.php. How would I add that field to the export procedure?
-Brian

[Kurund Jalmi]

Participant Export supports custom data of type "Participant". So only those fields will be exported. For contact related custom data you need to use Contact Export.

HTH

kurund

[sonicthoughts]

sounds like this is coming in 2.1, but where would i modify the export logic to include additional fields from contacts in the participant export?

thanks,

s.

[Donald Lobo]

CRM/Event/Form/Task/Export.php, line 95. Add the additional properties you need exported to returnProperties and hopefully it will work

Please update the topic if it worked / other hacks u had to do to make it work

lobo

[lcdweb]

This is how I do this --
Edit: CRM/Event/BAO/Query.php

Add the following line after line 380 (in the 2.0 version of this file):

Code: [Select]

$properties['custom_#'] = 1;
Where # = the id for the custom field. Code in that area would look like this:

Code: [Select]

                 }
            }
$properties['custom_1'] = 1;
        }

        return $properties;
    }
The equivalent file can be edited to include custom fields in the default CiviMember and CiviContribute export. As I recall, the export code for the contact search is structured differently. Though you have the flexibility to create a custom export in that interface, so it's not really an issue.

-Brian