|
Gaviny
|
May 6, 2016 at 3:49 am
Hello,
I was wandering someone could help me with this. I’ve been using the reporting within EE to see how many people have registered, what events they have registered for and the transactions. I know these are separate reports so I was I wanting to know if it was possible to create a report for ALL of that, which I can then filter by event or the event organiser.
Ideally something like this.
• The report needs to work on a date range
○ Look for Registrations for events between that period
○ Check that Event they've signed up for has happened (First Event Day has passed and not cancelled)
• Reporting format needs to show
○ List of Coaches requiring payment
○ How much to pay them
○ List of the registered clients and which event it pertains to.
Many thanks!
|
|
Josh
|
May 6, 2016 at 7:50 am
Hi Gaviny,
That should be possible if you import the CSV report into a spreadsheet application like Microsoft Excel or similar.
|
|
Gaviny
|
May 6, 2016 at 8:51 am
Would that generate a separate file for registrations and transactions? Basically what I need to do is work out who I need to pay each month, but we have multiple venues and coaches. So I would like to get all the information for the venues, events and registrations in one month and then filter by the coach so I know how much I need to pay them.
If exporting to a CSV from the EE backend will accomplish this then fantastic. I was not sure if I was asking for something too specific.
Thanks!
|
|
Josh
|
May 6, 2016 at 9:26 am
Hi there,
Some of the fields that you’ve requested aren’t included in the CSV reports, but there are filter hooks that make it possible for a developer to add them as new columns. You can contact one of the developers listed on this page for a quote for adding the additional information to the reports:
https://eventespresso.com/developers/event-espresso-pros/
|
|
Gaviny
|
May 6, 2016 at 9:51 am
Ok thank you, I will take a look into that. I’ve been in touch with wisdm labs in the past.
Regards
GavinY
|
|
Josh
|
May 6, 2016 at 9:55 am
You’re welcome.
|
|
Gaviny
|
May 9, 2016 at 3:14 am
Sorry if I should be making a new topic for this, but they are kinda related and I didn’t want to clog up the forums.
With regards to what I’ve asked in my previous post. Could someone point me to a list of the EE database tables and documentation for them? if it exists? I’ve looked in the database and think it might be easier if I knew what the different bits were for.
Thanks!
|
|
Josh
|
May 9, 2016 at 8:07 pm
All of the Event Espresso 4 database tables have _esp_ in their name. Along with that, the standard wp_posts table stores data for attendees, events, venues, and people (if you’re using the People add-on) because those are WP custom post types. A few examples:
_esp_event_venue: The association between an event and a venue
_esp_registration: The registration
_esp_attendee_meta: Extra information for attendees not stored in the wp_posts table
|
|
Gaviny
|
May 11, 2016 at 2:08 am
Thanks Josh,
I need to find out which tables to reference to try and make a report. would i need to be looking in the WP tables if the events are custom posts?
Thanks
|
|
Gaviny
|
May 11, 2016 at 7:11 am
Hi Josh,
Sorry to post again but I’m unable to edit my last post with this.
I’ve stumbled across a query on GitHub that I believe you may have written
SQL query
I’ve taken a look at it, and the table its referencing is not in my database (the wp_posts table).
I only seem to have wp_comments and wp_commentsmeta. Now I’m at even more of a loss as to what tables I need to look at. I’ve read through the other ones you mentioned and I can see the information in there. Its just with the wp_posts table being missing, I’m not sure where to start.
Thanks
|
|
Gaviny
|
May 11, 2016 at 9:39 am
Hello again,
I have found the tables I was looking for and I think I’ve figured out what I need to do, so you can mark this topic as closed/resolved if you like. That query I found on GitHub did what I needed pretty much. Just need to change a few things about it.
Many thanks Josh.
|
|
Josh
|
May 11, 2016 at 10:45 am
You’re welcome.
|
