Support

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.

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?

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.

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.

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?

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.

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

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?

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.

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.