Support

May 8, 2019 at 9:29 am

Hi,

What you could do is send a request via the built-in REST API, which will give you a JSON response with all the data. Then you can 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, and category-slug to match the event’s category slug)
https://example.com/wp-json/ee/v4.8.36/events?order_by=EVT_ID&sort=DESC&limit=200&calculate=spots_taken&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name&where[Term_Taxonomy.Term.slug]=category-slug
Step 3: Click the Download button and download the file
Step 4: Open the file in your spreadsheet application

You’ll note that the above request URL will get all the events for one category, so the end results could be merged into one file. Alternatively you could do this to get all events and include the category name:

https://example.com/wp-json/ee/v4.8.36/events?order_by=EVT_ID&sort=DESC&limit=200&calculate=spots_taken&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name,Term_Taxonomy.term_id,Term_Taxonomy.Term.name

Then downside with the above is it will output additional rows for each type of event taxonomy which would involve deleting them from the spreadsheet.

May 9, 2019 at 4:34 am

When you say ‘a few’, would a few be 200 events?

using the above I get 200 events from your site as the request has a limit of 200 to prevent time outs, that is set with limit=200 which you can try with higher values, however, your site may timeout before the request can be complete.

How many events are you expecting?

May 9, 2019 at 6:48 am

Yes, can limit the results based on date using something like:

where[Datetime.DTT_EVT_end][BETWEEN]=2019-04-01T00:00:01,2019-05-01T00:00:01

So then the URL would be:

https://fishability.org.au/wp-json/ee/v4.8.36/events?where%5BDatetime.DTT_EVT_end%5D%5BBETWEEN%5D=2019-04-01T00:00:01,2019-05-01T00:00:01&order_by=EVT_ID&sort=DESC&limit=200&calculate=spots_taken&include=Datetime.DTT_EVT_start,Datetime.DTT_EVT_end,EVT_name,Term_Taxonomy.term_id,Term_Taxonomy.Term.name

That would show you the events between 2019-04-01 and 2019-05-01.

May 10, 2019 at 7:11 am

You can edit the columns in your spreadsheet editor. In this case, you’d change the date format for the datetime column. The JSON response will always include the time along with the date.