Support

Home Forums Event Espresso Premium Columns in Filtered CSV report for daily report

Columns in Filtered CSV report for daily report

Posted: April 29, 2022 at 6:54 am


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

  • Support Staff

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

  • Support Staff

May 3, 2022 at 10:35 am

Agreed (and no, not because its one of my snippets πŸ˜‰ )

Any further questions just let us know.

The support post ‘Columns in Filtered CSV report for daily report’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso