CiviCRM Community Forums (archive)

I'm creating an export that can be used to print up things like rosters for a training and such. I can't find a way to include in the export which city/state the training is being held in or its start date. These trainings happen in many of the same cities, but on different dates. They need a way to be able to tell in the export that where & when information. I can't find any way to do that since those aren't listed as options in the field drop downs for the export.

I'd also like to include the date the confirmation email was sent to the person who signed up for the event. You can go into their registration and send that confirmation, but there is no field in the drop down to be able to list the date that was done. This helps them keep track of what confirmations have been sent and which haven't.

Thanks.

Hi there,

The participant export is going to give you participant info, not event info.  So while you theoretically could add those fields into the code, that's probably not the place to do it.  Instead, I'd customize the code for the Report (under Reports) called "Attendee List".

That report already has the event start date.  From there, I'd just edit the event name to include the City/State (e.g. "Fall Fundraiser - Austin, TX", "Fall Fundraiser - Seattle, WA") but it should be much easier to hack in the city/state of the event there than in Participant Export - and of course you can still export from the report.