Support

Home Forums Event Espresso Premium Export events and custom development

Export events and custom development

Posted: February 28, 2018 at 8:19 am


motio

February 28, 2018 at 8:19 am

Hi,

we started this year by selling our courses with event espresso. We like your product and your support a lot and therefore are thinking to invest to make event espresso better for us and hire a developer. I would be glad if you give us a little advice/recommendation for that.
https://eventespresso.com/developers/event-espresso-pros/
On that site we found some developer. Maybe you can recommend us a developer that is familiar with event espresso. If there are some information that a developer would need, it would be great if you could provide us some.

We would like to add the follwing:

– Autofill custom fields
After creating an event, the system should autofill the custom fields: count of dates from the event, duration of an event, Start- and Enddate, Time start and end. To display that one the site we have to do it manually that cost a lot of time, which could be automated.

– Export Events
That is a feature, that I read a lot in the support forum. But it is uncertain when you add this feature. Basically we would need the same csv report like the attendee report with some additional fields e.g. Start- and Enddate, Time start and end, Count of dates from one event, count of attendees, event status (active/canceled/postponed)
(Question that just came to me: Is it possible to make an attendee report where the systems thinks/pretend that in every course is one attendee? By hiding the attendee information, it would be a event report that would be enough.)

We would rather invest in event espresso that other could also use the development. If you see any possibility that our investment would progress the features of event espresso, than let us know.


Tony

  • Support Staff

March 1, 2018 at 9:29 am

Hi there,

Whilst hiring a developer will likely still be necessary, I have a couple of questions on the above as (without knowing all of the details) some of what you are trying to do appears to be the wrong approach.

– Autofill custom fields
After creating an event, the system should autofill the custom fields: count of dates from the event, duration of an event, Start- and Enddate, Time start and end. To display that one the site we have to do it manually that cost a lot of time, which could be automated.

The information that you are adding to custom fields could be pulled directly from EE on the front end output rather than added to a custom field to then be pulled on the page.

I don’t know all of the details for what you are trying to do, but it sounds like a long winded method to pull the info you need and display it. For example for ‘count of dates from the event’ you could count all of the datetimes on the event and just output that directly, however its not clear if you mean all active datetimes, or upcoming datetimes, or just all datetimes regardless of status which changes things a fair bit but the point being you should just be able to pull that data directly rather than using custom fields.

– Export Events
That is a feature, that I read a lot in the support forum. But it is uncertain when you add this feature. Basically we would need the same csv report like the attendee report with some additional fields e.g. Start- and Enddate, Time start and end, Count of dates from one event, count of attendees, event status (active/canceled/postponed)

Could you not just add those to the registrations CSV report we currently have?

(Question that just came to me: Is it possible to make an attendee report where the systems thinks/pretend that in every course is one attendee? By hiding the attendee information, it would be a event report that would be enough.)

Not really, the registration pulls the registrations and then the details liked to those registration (like the event) so it can’t really pretend theres registrations and look over those pretend registrations to pull the events.

With the amount of work involved to try and get something like that to work it would be better focusing that time on creating a new report imo.


motio

March 8, 2018 at 4:26 am

Thank you for the feedback. I think I will postpone this topic and make more experiences with the system. My main concern is how to pull the events (list) for the internal reporting. Otherwise I wouldn’t need that. Right now I do exports of our events with an Plugin (https://eventespresso.com/topic/export-via-wp-all-export/) where I can include the custom fields.


Josh

  • Support Staff

March 9, 2018 at 7:30 am

Hi there,

You could also use the built-in REST API to get the event data, 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 2b add more fields to/remove fields from the above to your specifications)
Step 3: Click the Download button and download the file
Step 4: Open the file in your spreadsheet application


motio

March 14, 2018 at 2:48 pm

Hey Josh,
Thank you for the info, that is a great alternative. Could give me a hint where I can find all usable variables (and custom fields?) and maybe I find informations how to filter the data (e.g. only the first or last of multiple fields, count of dates).


Josh

  • Support Staff

March 14, 2018 at 3:00 pm

The documentation shows how:
https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md
https://github.com/eventespresso/event-espresso-core/blob/master/docs/C–REST-API/ee4-rest-api-reading-data.md

and filtering:
https://github.com/eventespresso/event-espresso-core/blob/master/docs/C–REST-API/ee4-rest-api-GET-filtering-results.md


motio

March 28, 2018 at 9:15 am

Thank you for the links.
I am creating custom tables for different purposes and want to display it via the Table Template add-on and the template_file parameter.

I was wondering if it is possible to export the html table on the front end? I found the following and wanted to try it. Could you hint me to where I should add this to make it work.
https://www.phpflow.com/php/export-html-table-data-to-excel-csv-png-and-pdf-using-jquery-plugin/

Maybe you know a better solution for exporting a html table on the frontend. I could than create private pages to view the custom tables and use this site to export it. Maybe this could be a great workaround for other people.


Josh

  • Support Staff

March 28, 2018 at 6:04 pm

You should probably use the official documentation:
https://github.com/clarketm/TableExport

Then put the .js files into a little WordPress plugin, and wherever it says to include the scripts before the closing body tag of the HTML document, you can use wp_enqueue_script() function:
https://developer.wordpress.org/reference/functions/wp_enqueue_script/

The support post ‘Export events and custom development’ 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 2 months, 3 weeks ago ago

Topic Tags

Notifications

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