Support

Home Forums Event Espresso Premium Error exporting to csv

Error exporting to csv

Posted: January 26, 2022 at 8:01 am

Viewing 15 reply threads


skleijer

January 26, 2022 at 8:01 am

When trying to do download a csv report the following message appears: “An error has occurred. The requested export report could not be found.”
Yesterday everything was working fine. This morning I updatet WordPress zo maybe there is something going wrong here?

There is one event which has priority and my client really needs the reports.

Please help!

Kind regards,
Sya


skleijer

January 26, 2022 at 8:16 am

In addition, The complete message is: An error has occurred. The requested export report could not be found.
EE_Export – export – 113

When trying to download csv report of the registratiosn for an event. It does not matter whether it is an event with 7 or 400 registrations. This problem occurs with all the events.

Matter is urgent.
Please help!
Kind regards,
Sya


Tony

  • Support Staff

January 26, 2022 at 8:57 am

Hi there,

I’ve created a ticket to investigate this, however, that specific error means you are using the ‘old’ export method and should really switch to using the batch export.

Within your sites wp-config.php you’ll have this somewhere:

define( 'EE_USE_OLD_CSV_REPORT_CLASS', true );

Add // to the beginning of that line to comment it out and save.

Now retry the export, does it work for you?

Even if it doesn’t work, you shouldn’t get that same error with that system so please let me know what happens.


skleijer

January 26, 2022 at 10:04 am

Hi Tony
I did not yet try this because I’m a little bit confused about the ‘new batch export method’. We are running EE version 4.10.25.p. Wich means I updated only 2 days ago. Which ‘new batch export’ you are referring too and how do I make that work? We like to be up-to-date you see.
Kind regards,
Sya


Tony

  • Support Staff

January 26, 2022 at 11:44 am

The batch system has actually been in the system for a long time (pre-2015) so I should stop referring to it as the ‘new’ system really.

Initially, Event Espresso used a single query to pull in all of the registration data, build out the CSV array and stream it to the browser. That was fine for smaller numbers of registrations with relatively small numbers of registration questions.

As people started using the system for events with thousands of registrations or using many registration questions on single events, that system couldn’t pull all of the data and output it to the browser within the min PHP timeframe so would cause errors.

We added a ‘batch’ system into Event Espresso which basically pulls in the registration in batches and writes them to a temp file until all of them are included in the file, at which point it sends it to the browser.

So the ‘new’ system works in batches, the ‘old’ system pulls everything in at once.

You can enable/disable the ‘old’ system using the code I gave you above because some server setups did not like the new system (because it writes a temp file and poorly configured servers failed with it).

For your site to be getting the above error, it must be using the ‘old’ system. I went back through your previous posts to 2016 and found this:

https://eventespresso.com/topic/csv-download-not-working/

So, yes, your site has the above code and is using the old export system 🙂 try removing it and see if it works with the ‘new’ system.


skleijer

January 26, 2022 at 1:34 pm

Hi Tony,
I really wished it where true but no code like this is inside my wp-config.php file. Unfortunately.
Within your sites wp-config.php you’ll have this somewhere:
define( ‘EE_USE_OLD_CSV_REPORT_CLASS’, true );
Add // to the beginning of that line to comment it out and save.
Now retry the export, does it work for you?

I tried searching side wide for this code but no luck.
There is something else going on I’m afraid.

Kind regards,
Sya


Tony

  • Support Staff

January 26, 2022 at 2:35 pm

There can’t be something else going on here, that specific error is only thrown in the EE_Export class which only loads if you have the above code active or a really old version of EE.


skleijer

January 26, 2022 at 3:58 pm

Hi Tony,
Ok. I found the code and did what you said. But, now it isn’t possible to download any csv reports. There is an error. And it is no longer possible to select an event and download the report. The function disappeared from te menu all together. We want to download the reports for specific events. That is no longer possible.

Kind regards,
Sya


skleijer

January 26, 2022 at 4:35 pm

There was a plugin conflict that made the registrations not downloading/showing. It’s resolved for now. Thank you Tony.


Tony

  • Support Staff

January 27, 2022 at 3:21 am

Hi there,

I’m curious as to which plugin was conflicting here, can you add some more details?

EE admin pages shouldn’t be affected by most other plugins, especially not specific links such as registration CSVs.


skleijer

January 27, 2022 at 8:00 am

Hi Tony,

It was the firewall plugin Bullet Proof Security that made it impossible to download/generate the csv. We have also Wordfence installed and that works fine.
The csv however is downloaded totally different than it used to. Columns are messed up. Is that something excel does or can I do something about it online with the plugin settings or something?
Kind regards and thanks for remembering my earlier problem. 19 years we use this plugin now.

Sya


Tony

  • Support Staff

January 27, 2022 at 9:31 am

I need more details as ‘messed up’ could mean multiple things 🙂

What is happening with the CSV columns?

Is that something excel does or can I do something about it online with the plugin settings or something?

It’s not the plugin settings, it could be something from Excel but I need more details.

Can you send me the CSV so I can see what it loads up with? You can send that to support[at]eventespresso.com


skleijer

January 28, 2022 at 3:49 am

I want to email the files but where can I send it to?
Kind regards,
Sya


Tony

  • Support Staff

January 28, 2022 at 3:51 am

Send it to support[at]eventespresso.com and I’ll take a look.


skleijer

January 28, 2022 at 3:51 am

Ow i see.


skleijer

February 2, 2022 at 3:12 pm

Hi Tony,
I did email the details to you a couple of days ago but did not yet received an answer.
My client is desperate.
Kind regards,
Sya

Viewing 15 reply threads

The support post ‘Error exporting to csv’ 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