|
Laurita Winery
|
February 22, 2019 at 7:54 am
I am trying to export all of our registrations but when we do this our server times out. Our server times out because we have 88,581 registrations.
Is there a way to export registrations in bunches? If not, can you tell me which tables of the database store this information so I can export directly from there?
|
|
Tony
|
February 22, 2019 at 9:29 am
Hi there,
Is there a way to export registrations in bunches?
There is and it’s the default for Event Espresso, however, in one of your previous threads we switched this back to the old version:
https://eventespresso.com/topic/i-am-unable-to-export-registrations-for-all-my-events/
If you remove define( 'EE_USE_OLD_CSV_REPORT_CLASS', true ); from your wp-config.php file, does it still fail on your server?
|
|
Laurita Winery
|
February 22, 2019 at 11:51 am
Thank you.
I am attempting an export now. I will let you know if we have any issues.
|
|
Laurita Winery
|
February 22, 2019 at 2:16 pm
This has worked for us however, the exported file has 75,517 rows of registrations but the backend of our website says there is 88,581. Do you know why there would be a difference of 13,000 registrations?
|
|
Tony
|
February 22, 2019 at 2:46 pm
Registrations with a transaction that has a status of abandonded will not be included in the export (unless the registration has been approved).
So would those registrations account for your missing numbers?
|
|
Laurita Winery
|
February 22, 2019 at 3:01 pm
Hmm it is very possible. Although I cannot filter the registrations by “abandonded”
|
|
Tony
|
February 22, 2019 at 5:25 pm
No, you can’t because it isn’t a registration status, it’s a transaction status.
However, I have a snippet that adds an additional filter to that table that allows you to filer both registration and transactions statuses:
https://gist.github.com/Pebblo/22995de5472c46a361ecc206bc8e9f9b
You can add that 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/
That means you can select say Abandoned transactions and export the filtered lists.
|
|
Laurita Winery
|
February 25, 2019 at 9:15 am
Thank you for this! However, even after filtering by Abandoned we are still 1,270 registrations short.
|
|
Tony
|
February 26, 2019 at 2:45 am
Hmmm, strange.
So let’s explain where the numbers come from and go from there.
Event Espresso -> Registrations -> View all registrations count
Pulls all registrations that do not have a Reg status of ‘Incomplete’ (this is NOT the same a the transaction status incomplete), meaning it counts all registrations that have submitted contact details on the registration form.
The CSV pulls in all registrations that are not assigned to a Transaction that has a transaction status of either ‘Failed’ or ‘Abandoned’, with the exception of Approved registrations, if the registration is Approved it pulls that in regardless of the Transaction status.
A registration would be assigned to a transaction with a ‘Failed’ status if the registration was ‘Incomplete’, meaning no details had been entered into the registration form.
I’ll check with our developers to confirm I’m not missing something above and get back to you.
|
|
Laurita Winery
|
February 26, 2019 at 6:58 am
Thanks for this information and looking into this for us! I look forward to hearing back from you!
|
|
Tony
|
March 4, 2019 at 12:44 pm
Hi there,
Can you test another option on your site, please?
Go to Event Espresso -> Registrations.
Don’t set any filters etc on the page and just click the ‘Filtered CSV Report’ button.
What number do you get from that?
|
|
Laurita Winery
|
March 4, 2019 at 12:51 pm
88931
This number is higher than it was previously since we had new registrations on the website.
|
|
Tony
|
March 4, 2019 at 1:11 pm
Thank you, so does that match the registration list count?
|
|
Laurita Winery
|
March 4, 2019 at 1:16 pm
It does. So should we use the filtered export instead? Is there a reason that some are missing?
|
|
Tony
|
March 4, 2019 at 2:49 pm
If you’re getting the correct value using the filtered button the difference must be related to Abandoned transactions as that’s the only difference on page load.
The filtered button is designed to export registration using the same conditions used to load the table, meaning on page load it includes abandoned registrations.
I can take a quick look over the registrations and see if anything stands out if you’d like? If so you can send temp login details using this form:
https://eventespresso.com/send-login-details/
|
|
Laurita Winery
|
March 5, 2019 at 7:42 am
I think if we continue to use the Filtered CSV export we will be good! Thank you for all your help, so far when using that button we get the correct number of exported registrants.
|
