|
Chris Stambaugh
|
September 23, 2014 at 2:12 pm
Hi,
I need to produce a report that shows the ticket end date for all my upcoming events. How can I accomplish this?
Thanks,
Paul
|
|
Lorenzo Orlando Caum
|
September 23, 2014 at 3:26 pm
Hi Paul,
This type of reporting is not currently available in Event Espresso 4.
—
Lorenzo
|
|
Chris Stambaugh
|
September 23, 2014 at 3:39 pm
So how can I find all the events I inadvertently put the incorrect ticket_end date (the default) instead of the correct one? Certainly going through hundreds of events, one at a time, isn’t your solution. Is it?
Paul
|
|
Lorenzo Orlando Caum
|
September 23, 2014 at 3:48 pm
Are you comfortable working with the database using a tool like PHPMyAdmin or Adminer?
—
Lorenzo
|
|
Chris Stambaugh
|
September 25, 2014 at 11:47 am
Yes.
The information I need to see on a report is:
Event Name, Event Start Date, Ticket End Date
Thanks,
Paul
|
|
Chris Stambaugh
|
September 25, 2014 at 3:30 pm
Josh,
That’s a good start, but if I forget to fill out the empty field, the system just defaults to today’s date which doesn’t help me at all.
Paul
|
|
Josh
|
September 25, 2014 at 5:39 pm
Are you looking to correct the incorrect Ticket End Dates Paul?
|
|
Chris Stambaugh
|
September 25, 2014 at 6:21 pm
Josh,
Yes, absolutely.
Paul
|
|
Josh
|
September 26, 2014 at 12:08 am
Hi Paul,
You can generate a custom report that includes Event name, Event start date, and Ticket sell until date by logging into phpMyadmin and pasting in this custom query into the SQL tab, then run it.
https://gist.github.com/joshfeck/d096c690791098ae7f9e
phpMyadmin is installed on most servers and accessed through the host’s control panel.
If you don’t have phpMyadmin, the standalone Adminer can be installed or also the Adminer WordPress plugin.
|
