|
Torontot
|
August 29, 2017 at 8:01 am
Hi there,
Is it possible to export the registration data by contact/user, rather than by ticket? Such that the result would be something like this:
<table>
<tr>
<td>Name</td>
<td>email</td>
<td>[a few columns of other contact details etc…]</td>
<td># of Ticket type 1 : individual</td>
<td># of Ticket type 2 : Table of 8</td>
<td># of Ticket type 3 : Table of 10</td>
<td># of Ticket type 4 : Sponsorship</td>
</tr>
<tr>
<td>Joe Person</td>
<td>joe@website.com</td>
<td>…</td>
<td>0</td>
<td>2</td>
<td>1</td>
<td>1</td>
</tr>
</table>
The way it exports now, in order for my client to produce a document that is helpful to her it requires a lot of cleaning/deleting of rows and then she loses the data related to the total number tickets.
Also, is it possible to group purchases like this within WordPress as well? Instead of seeing each ticket? We only request contact information for the Primary Registrant, and only the primary registrant will be making any payment therefore having them separated is not necessary for us and just confusing.
Please advise. Thanks!
Rachael
|
|
Torontot
|
August 29, 2017 at 8:03 am
To clarify, since it says below this editor that you can add HTML code, I was doing that just for a visual. I do understand that the export would be a csv. I am not asking for it to be exported to HTML.
|
|
Josh
|
August 29, 2017 at 12:36 pm
Hi Rachael,
You can go to the Event Espresso > Transactions list table will show you list of each purchase (instead of by each registration like on the Event Espresso > Registrations page).
The registrations CSV report was built to do one row per registration/ticket so if you need to build out a customized report to your client’s specifications I can recommend contacting a developer and they may be able to give you a quote. Here’s a list of recommended developers:
https://eventespresso.com/developers/event-espresso-pros/
|
|
Torontot
|
August 29, 2017 at 1:52 pm
Thank you Josh. That is a good thought, but the transactions list won’t work for us because doesn’t give the number of tickets, only the price. The WordPress version however is not as important as how it exports.
I am a developer are you able to point me in the direction of what I can hook/filter in order to customize the export myself?
|
|
Josh
|
August 29, 2017 at 1:58 pm
In event-espresso-core-reg/core/libraries/batch/JobHandlers/RegistrationsReport.php
there’s this filter hook:
FHEE__EE_Export__report_registrations__reg_csv_array
That hook will let you add/remove columns and filter the content of the rows. You might need additional hooks to be able to eliminate rows, in which case you can add them and do pull request on Github:
https://github.com/eventespresso/event-espresso-core/
|
|
Torontot
|
August 29, 2017 at 2:30 pm
Perfect, its a starting point – thanks!
|
