Support

Home Forums Event Espresso Premium Exporting Event Data

Exporting Event Data

Posted: March 1, 2018 at 10:45 am


Troy

March 1, 2018 at 10:45 am

Hello, In EE4 you can export registration data but I don’t see any functionality to export event data (preferably into a spreadsheet). Is this possible, and if so, how? We are looking at a simpler way to double check accuracy on hundreds of events rather than opening each event independently.

thanks.


Josh

  • Support Staff

March 2, 2018 at 6:36 am

Hi Troy,

You can used the built-in REST API and convert the JSON to CSV a file, then open that file in a spreadsheet application.

Step 1: Go to https://json-csv.com/
Step 2: Paste in this URL (you’ll change the example.com to match your site’s domain)
http://example.com/wp-json/ee/v4.8.36/events?order_by=EVT_ID&sort=DESC&limit=200&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name,EVT_desc,status,EVT_display_ticket_selector,EVT_default_registration_status,Venue.VNU_name,Datetime.Ticket.TKT_name,Datetime.Ticket.TKT_price
Step 3: Click the Download button and download the file
Step 4: Open the file in your spreadsheet application


Troy

March 2, 2018 at 10:51 am

Josh – thanks for the reply. Here lies the problem; it has plagued us for years (even in EE3). The ticket ‘Sell Until’ date, if off closes down a class early. Over the years, we have had dozens of classes with revenue / registrations loss because one of my data entry people makes a mistake here. The above export doesn’t show the ‘Sell Until’, so does me no good. Any thoughts how how to do a double check? Ideally, we want this to always be identical to the ‘Event Start’.


Josh

  • Support Staff

March 2, 2018 at 11:03 am

Troy — You can add Datetime.Ticket.TKT_end_date to the GET request URL and it will include the ticket sale end date.

e.g.
http://example.com/wp-json/ee/v4.8.36/events?order_by=EVT_ID&sort=DESC&limit=200&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name,EVT_desc,status,EVT_display_ticket_selector,EVT_default_registration_status,Venue.VNU_name,Datetime.Ticket.TKT_name,Datetime.Ticket.TKT_price,Datetime.Ticket.TKT_end_date

The support post ‘Exporting Event Data’ 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.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  Josh 3 months, 2 weeks ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!