Support

Home Forums Event Espresso Premium CSV Export does not include Custom Questions/answers

CSV Export does not include Custom Questions/answers

Posted: April 25, 2019 at 4:38 pm


trainadesign

April 25, 2019 at 4:38 pm

Hey EE team,

Our site is using EE 4.9.79.p
All add-ons update to date as well.

We have events with custom questions attached to them. When I export the registration list to CSV, the table/list stops at the column “transaction promotions” after the personal info of the registrant.

I saw in previous forums/searches that this should* work out of the gate, so just want to confirm it does/should, and what troubleshooting steps you’d recommend to solve.

thanks!!


Josh

  • Support Staff

April 25, 2019 at 7:24 pm

The CSV report should include the answers to all questions included in the registration form. May I ask if you go to view the registrations in the admin are the answers to questions included?


trainadesign

May 6, 2019 at 9:23 am

Yes, if I view an individual registration I see the reg-form answers, i.e. school, cell, school name, upcoming grade etc. However when I click “event registrations CSV report” the report ends at the column “Transaction Promotions”


Josh

  • Support Staff

May 6, 2019 at 9:36 am

The report should end at “transaction promotions”, and the columns before that “transaction promotions” should include the custom questions/answers. Here’s a screenshot of an example:

https://slack-files.com/T02SY781D-FJFCVPBAL-29ef2a4fde

When you go to start the CSV report are you viewing a list of registrations for one event, or a list for all events?


trainadesign

May 6, 2019 at 10:01 am

Yes,I am viewing the registrations CSV repot from the specific event.

The fields leading up to the Transaction Promotions field are the generic first/last name, email, address, city/state/zip. But these events have a second set of questions that include things like:

camper name, camper DOB, camper school name, gender, etc, but none of those are showing in the CSV export for the event.


Josh

  • Support Staff

May 6, 2019 at 11:42 am

If there’s any custom functions in the theme’s functions.php file or in a custom plugin, you could check to see if there’s a function that’s hooked to the FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array filter hook.

Aside from that, it might help if we could review the reg form for the event. Can you share a link to the event page for the event?


trainadesign

May 6, 2019 at 11:55 am

This reply has been marked as private.


Josh

  • Support Staff

May 6, 2019 at 12:46 pm

May I ask has anything in the code related to the registration form been altered? The reason I ask is because normally the form inputs do not include a placeholder attribute. An alteration to the form input could affect the way the data is exported to the CSV.


trainadesign

May 10, 2019 at 11:36 am

This reply has been marked as private.


Tony

  • Support Staff

May 10, 2019 at 12:07 pm

Something else to note is the hook above is actually relatively new and there’s another that was used before it (and is still applied if it’s in use).

FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array

Is the ‘latest’ hook but:

FHEE__EE_Export__report_registrations__reg_csv_array

Can also be used, it’s been deprecated not but may well still be in use on your site.

So can you double check that neither of those 2 hooks are in use within your themes functions.php file, or a custom functions plugin.


trainadesign

May 13, 2019 at 12:34 pm

Hey Tony, yep, confirmed that neither of those hooks is in use in any plugin/function.


Tony

  • Support Staff

May 13, 2019 at 2:28 pm

That’s very strange.

Can you link me to an event I can run a test registration on?


trainadesign

May 15, 2019 at 11:01 am

This reply has been marked as private.


Tony

  • Support Staff

May 16, 2019 at 5:52 am

Are you exporting registrations only for that specific event or all events and then finding the registrations for that event?

The only time I’ve seen answers showing in other columns or not appearing in some registrations is when the export was being filtered with poor logic to add/remove columns.

The support post ‘CSV Export does not include Custom Questions/answers’ 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