Support

Home Forums Event Espresso Premium Include additional questions in CSV export

Include additional questions in CSV export

Posted: January 9, 2020 at 2:53 pm


trainadesign

January 9, 2020 at 2:53 pm

We had an issue with our registration sign ups for camps that proved very cumbersome for the person managing the registrations and I’m wondering if you can look into it and see if you can fix the issue:

For the camps, we added a bunch of questions at registration. They live under Event Espresso > Registration Form > Question Groups. You’ll see “Camp Questions”. When a user goes to register, they have to answer all the questions listed there. The problem is, when I go to export the registration data, it still only includes the basic info and not these additional questions. So the person managing the registrations only gets the answers to these questions as an email message alert when someone signs up. She needs this in excel format. So she had an admin copy and paste each question answer from each registrant into an excel spreadsheet. Obviously not a sustainable solution. Seems like from a dev standpoint it wouldn’t be that difficult for the developer of this plugin to include these special questions into the reports – let me know if you can think of a better or different solution. Thanks!!


Tony

  • Support Staff

January 9, 2020 at 3:42 pm

Hi there,

Event Espresso 4 includes every registration question asked on an event in the export by default, Josh mentioned this in your previous post on this here:

https://eventespresso.com/topic/csv-export-does-not-include-custom-questions-answers/

The issue in this post sounds related to whatever is happening in your other thread.

Are you 100% certain there are no custom functions hooking into the export function to alter the CSV data at all? The only time we’ve seen missing columns from the CSV is when they’ve been removed with a custom function which was forgotten about in a custom functions plugin or the theme’s functions.php file.


trainadesign

January 9, 2020 at 4:27 pm

My apologies, I wasn’t aware of that previous post.

The developer previously working on this has left the company, this is a different person but using the same account from the one in the mentioned post. I’ll look around in the functions to see what I can find, thanks!


Tony

  • Support Staff

January 9, 2020 at 4:40 pm

Ah ok, no problem.

A quick way to test this is to use the WP Health Check plugin and enable Troubleshooting mode.

You install the above then go to Tools -> Site health -> Troubleshooting -> Enable Troubleshooting mode.

That will disable all plugins and switch your site to a default theme (only for you, the admin).

Then you go to the admin bar -> Troubleshooting mode -> Manage active plugins.

Enable Event Espresso in troubleshooting mode and run an export, do you get all of the registration details then?


trainadesign

January 9, 2020 at 4:51 pm

This reply has been marked as private.


Tony

  • Support Staff

January 9, 2020 at 4:58 pm

No, those functions shouldn’t cause issues with the Registration Reports.

The two hooks to look out for are

FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_arra

and

FHEE__EE_Export__report_registrations__reg_csv_array

Both of those allow direct manipulation of the CSV reports.


trainadesign

January 15, 2020 at 4:09 pm

This reply has been marked as private.


Josh

  • Support Staff

January 15, 2020 at 5:08 pm

Hi,

Are there any columns before the “Transaction Promotions” column? That one should actually be the last column and the columns between “Transaction Promotions” and “Phone” will include question related data.


trainadesign

January 15, 2020 at 5:27 pm

This reply has been marked as private.


Josh

  • Support Staff

January 15, 2020 at 6:18 pm

It kind of sounds like there’s an error happening not too longer after the script starts to assemble the data for those rows, which might explain why you’re seeing some data, but it’s not even in the correct column.

One thing you could try to see if it makes any difference is go to Event Espresso > Registrations and do a search or a filter so only a handful of registrations come up. Then click on the “Filtered CSV Report” button to generate a CSV report of only the registrations on screen. Does that pull up all the columns you’re expecting to see?


trainadesign

January 16, 2020 at 1:16 pm

Filtered and searched for a single registration and used the “Filtered CSV Report” button, it’s displaying the same two “Course” and “Camp” columns with the wrong input fields still, not seeing the rest of the questions anywhere.


Josh

  • Support Staff

January 16, 2020 at 4:11 pm

Can you add the following code to a site specific function plugin:

add_action('plugins_loaded', 'remove_the_csv_filters', 999);
function remove_the_csv_filters() {
remove_all_filters('FHEE__EE_Export__report_registrations__reg_csv_array');
remove_all_filters('FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array');
}

Then activate the plugin and run a report. The above code should remove any CSV filter functions if any have been added.


trainadesign

January 17, 2020 at 11:04 am

Tried that and it just removes the last “Transaction Promotions” column in the report, the “Course” and “Camp” columns are still there with the incorrect values.


Josh

  • Support Staff

January 17, 2020 at 1:22 pm

Have you checked the PHP error log just after running a CSV report?

You could also set up WordPress to temporarily log errors to a file by making an edit to your wp-config.php file. We’ve outlined how to do that in this guide:
https://eventespresso.com/wiki/troubleshooting-checklist/#wpdebug


trainadesign

January 17, 2020 at 2:52 pm

thanks, just checked and no errors are being shown after i run a report, would there be another reason for the csv to display the last two columns incorrectly and exclude the extra questions?


Josh

  • Support Staff

January 17, 2020 at 3:12 pm

It is including a few of the extra questions but something is going wrong because there should be more than just two columns, and the data within the two columns isn’t correct. So there could be a problem with the data itself, but I’m less certain of that since it didn’t work with even a single registration report.

Do you know if there are any custom functions loading from the active WordPress theme?


trainadesign

January 17, 2020 at 3:30 pm

yea, there’s a few custom functions, but from what I see, nothing that would be causing these exporting issues in the reports.

Also i tested with WP Health Check, that should’ve switched it over to a default theme correct? the export was still not showing all the questions there so that should rule out any custom functions in the theme being an issue?


Josh

  • Support Staff

January 17, 2020 at 3:53 pm

I’m not sure if WP Health Check’s troubleshooting mode would eliminate all possible custom scripts, for example I think the troubleshooting mode can be set to change the theme or not. Also it doesn’t affect any must-use plugins that could have custom code.


trainadesign

January 17, 2020 at 5:34 pm

This reply has been marked as private.


Josh

  • Support Staff

January 17, 2020 at 8:43 pm

The problem is someone went through and edited all the questions to make them have mostly identical Admin Labels. A few were changed to “Course” and most of the others were changed to “Camp”.

Each question in Event Espresso > Registration Form > Questions needs a unique admin label.

For example, the “Research interest” question should have an admin label like “research-interest”. Another example would be the “Upcoming grade” question, that should have an admin label like “upcoming-grade”.

If you can make this correction then you’ll get all of the additional questions in the CSV report.


trainadesign

January 20, 2020 at 10:11 am

ahhh, makes total sense! i’ll go in and update with unique admin labels. thanks so much for figuring out the issue!

The support post ‘Include additional questions in CSV export’ 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.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by  trainadesign 6 months, 2 weeks ago ago

Topic Tags

Notifications

This topic is:
pending
Do NOT follow this link or you will be banned from the site!