Support

Home Forums Event Espresso Premium Expose SQL of Registration CSV

Expose SQL of Registration CSV

Posted: May 23, 2019 at 5:31 pm


snradmin

May 23, 2019 at 5:31 pm

Similar to petranet, I am looking to avoid sending CSV reports to my fellow volunteers on a regular basis (See Custom front-end report? )

I found a solution that would allow me to update the registration data regularly that I can share securely. I need the SQL code that is generated by the RegistrationsReport.php function via show_next_x_db_queries. Is there a snippet or version of this function that only creates the SQL for RegistrationsReport.php?


Tony

  • Support Staff

May 24, 2019 at 5:36 am

Hi there,

I’m sorry but I’m not sure I understand what you are asking for.

There are multiple queries used to generate the registration report, for example pulling in registrations, then payments linked to the registrations, ten datetimes linked to the tickets for the registrations, then answers linked to the registration.

All of those different models so I don’t think you can use show_next_x_db_queries how I think you want to above but again, I’m not really sure I follow.


snradmin

May 24, 2019 at 8:15 am

If I have to use from multiple SQL calls, that is not outside the realm of possibility. How does it put all of those different queries into one CSV?


Tony

  • Support Staff

May 24, 2019 at 8:54 am

You can take a look within RegistrationsReport.php at the get_csv_data_for() method to see how it pulls all of the information in and combines it into an array ready for the CSV.

The support post ‘Expose SQL of Registration CSV’ 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  Tony 6 months ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!
[for="input_96_5_3"]
[for="input_96_5_3"]
[gravityform id=96 title=false description=false]
  • This field is for validation purposes and should be left unchanged.
[i]
[i]
[gravityform id=69 title=false description=false]
  • This field is for validation purposes and should be left unchanged.