|
codingforsail
|
April 29, 2022 at 6:54 am
Hi,
ESSA want their day staff to have a list of the attendees and custom questions for that day. I can get mostly what I need from the Filtered CSV Report on the Registrations page.
There are many columns in the csv file that would not be needed, and the staff are not going to have time each day to remove the columns they do not need. Is there a way of specifying the columns that I do need (basically the event name and the custom attendee questions)? ESSA don’t currently use the export.
|
|
Tony
|
May 2, 2022 at 3:56 am
Hi there,
Yes, there is a filter on the registration report which allows you to hook in and alter the output via code.
We have a few examples of doing this here: https://github.com/eventespresso/ee-code-snippet-library/tree/master/admin/registration-reports/core
You have a couple of different ways to do this, you can either whitelist specific fields (and the order) using a snippet like this:
https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/registration-reports/core/tw_ee_registration_report_limit_columns_shown.php
To use that you set each column header as a new field in the array on lines 11-15.
Or you can exclude specific fields and leave all the others as they are (useful as if you add additional custom questions you then don’t need to ‘whitelist’ those to include them in the CSV):
https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/registration-reports/core/tw_registration_report_exclude_fields.php
You can add either of those to a custom functions plugin on your site, we have some documentation on creating one here:
https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/
|
|
codingforsail
|
May 3, 2022 at 8:20 am
Ooh thank you.
Yes, I much prefer the idea of excluding fields that they won’t need. Much more future-proof.
Best wishes,
Anita
|
|
Tony
|
May 3, 2022 at 10:35 am
Agreed (and no, not because its one of my snippets 😉 )
Any further questions just let us know.
|
