Posted: April 11, 2018 at 8:22 am
When exporting the CSV from a specific event (Navigating to Events > Click Registrations under the event I would like to export data for), the two buttons are both behaving in unexpected ways. The first button (Event Registrations CSV Report) is exporting the expected dataset of all the registrations for the event but is NOT filling out the column for the event name: ( ‘Event’, ‘event_espresso’ ), however the second button (Filtered CSV Report) does export with the event name column filled. I would just tell my client to use the filtered export functionality in that case but the Filtered CSV Report is also exporting ALL registrations on the system (not just the registrations for the event that is selected.)
Is these issues related to column ordering? Is there some way to get the event name differently so that the column will populate on the normal CSV report? I don’t really care that much about the filtered CSV report not behaving as I expect if I can resolve the event name issue for the normal CSV export.
Here is the code used for re-order / filtering of the columns being exported.
Let me know if you have any additional questions,
Have you recently changed the above code? Unless the forum has altered the content its currently invalid. This line:
The apostrophe ends the string so that would throw a syntax error. You need:
When you export registrations for a specific event EE does not include the Event Name by default, because all of the registrations are for a specific event so its just duplicate data.
However, it’s simple enough to add into the CSV using the function above, add this;
The provided code to add the title back to the single event registrations export worked perfectly.
Thank you so much!
You’re most welcome, I’m glad that worked for you 🙂