|
Daniel Brogan
|
November 2, 2015 at 12:09 pm
Our accountant would like to receive a report totaling all future ticket sales (in order to know future liability for the balance sheet). The registration view can by filtered by month, but is there a way to filter it by a range of months, or even everything after a certain date?
Based on this thread posted below, I tried to modify the month_range parameter in the url to use a greater-than operator in stead of equal, but that didn’t work.
Thanks.
Previous thread:
https://eventespresso.com/topic/attendee-reports-2/
-Dan
|
|
Tony
|
November 3, 2015 at 6:24 am
Hi Daniel,
Turns out you can not alter the paramater used within the URL to change the query for this. When you set the month filter the query uses BETWEEN {1st-of-month-set} AND {end-of-month-set} so its not possible to pass an operator to the query that will show a range of months like you are looking for.
This would need some custom development to pull in date ranges of registrations using another query.
You can pull all of the registration per event by clicking on the ‘Attendees’ link that is available when you hover over the event name – http://take.ms/9q1SR
So if you export the CSV for each event using that would that work?
|
|
Daniel Brogan
|
November 3, 2015 at 8:54 pm
We can try that, but it’s going to be fairly labor intensive. Last month, we were able to make this work by exporting *all* registrations as a single file and then filtering the resulting CSV file in Excel. This month, however, when we click the All Registrations CSV Report button, it chews for several minutes before giving us a 404 error. Any idea what might be causing that? We have 6,500 total registrations in our system. We’ve also noticed that the system generally seems to be running more slowly this month.
Thanks for your help!
|
|
Tony
|
November 4, 2015 at 5:16 am
We have 6,500 total registrations in our system.
Its likely you have reached the number of registrations that your server can export in one batch without timing out.
There’s a couple of steps you can take for this, firstly, try increasing your wp_memory_limit value using something like:
define( 'WP_MAX_MEMORY_LIMIT', '256M' );
within your wp-config.php file.
You can also try upping the max_execution_time within PHP, to do this you’ll need to be able to edit your PHP.ini file and either edit or add:
max_execution_time = 90
Which sets the limit to 90 seconds (default is 60)
You may need to contact your host and have them up this limit for you.
I’ll check and see if there are any other options available to help with this.
|
|
Daniel Brogan
|
November 4, 2015 at 6:47 am
Thanks, Tony. Are there any guidelines or best practices for how many registrations Event Espresso can handle for general operations? Should we be archiving past registrations? Obviously, we’d like to have a client/sales history history to refer to.
|
|
Tony
|
November 4, 2015 at 7:57 am
Are there any guidelines or best practices for how many registrations Event Espresso can handle for general operations?
It really depends on your server but also depends on the amount of registration questions your are requesting too, more question = more data to pull in so we can’t give a guideline figure.
Most users export the registration data per event rather than all registrations so this usually is not a problem.
Should we be archiving past registrations? Obviously, we’d like to have a client/sales history history to refer to.
No you should not archive past registrations but the more registrations that are added the system the more data needs to be pulled in for the export and so then it is more likely to time out.
You will likely need a custom export plugin to export the data within custom date ranges so that the server can handle the amount of data needed, for this you will need the help of a developer.
|
