Excel Export First and Last Name in Separate Columns

[mattgbsport]

Hi there, I would like to separate the first and last name fields in the CSV export into different columns.
Any advice on how to do this would be much appreciated.
Thanks
Matt

[Josh]

Hello mattgbsport,

Thanks for reaching out to us!

Unfortunately, there isn’t a straightforward way that I can think of to accomplish this within the current export. Currently, it looks like the CSV pulls from the structure of the attendee list that displays within the table on the backend of the site. The information found within this thread might be able to point you in the right direction to get what you need.

A possible alternative solution for getting the first and last name of attendees for your event would be to query the shop_orders for orders that included the tickets for your event. You could then access the _billing_first_name and _billing_last_name for those orders.

Also, this does sound like it could be a potential feature for our ticketing plugins. Having the ability to control the the CSV export would be a great suggestion for our UserVoice page.

I’m sorry I wasn’t able to give you a direct response however I hope this was able to point you in the right direction.

Thanks!

[Josh]

Hey,

It’s been a while since we’ve heard from you on this thread.

I’ll go ahead and close this thread for now. If you have any further questions, please don’t hesitate to open a new one.

Thanks!

[Author]

Posts