|
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
|
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
|
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
|
