Adding fields to export

[Henning]

I need to edit the CSV export file (add address and tel.-nr to the csv).
The plugin mentioned here doesn’t seem to work any more https://theeventscalendar.com/support/forums/topic/adding-custom-attendee-export-fields/#dl_post-1345713
All it does is to give me a grey layover and a save button…

[Andras]

Hi Henning,

Thanks for reaching out!

I believe the solution in that thread is for something different.

Please take a look at this extension, which can give you an idea on how to export other fields as well:

• https://theeventscalendar.com/extensions/include-attendee-phone-number-in-the-event-attendee-report/

Hope this helps. Let me know.

Cheers,
Andras

[Henning]

Dear Andreas, this does post the phone number of the buyer, but doesn’t add it to the export csv… I need the address + phone number in the csv to match it against an other list.

[Andras]

Hi Henning,

Sorry about that.

I found this snippet that should help add all woocommerce meta into the export.

Of course you can remove the ones that you don’t need.

https://gist.github.com/andrasguseo/6caca108be48c0446ce97a080a5eced5

Let me know if that works out for you.

Cheers,
Andras

 

[Henning]

Looking great to me 🙂 Let’s see what my client thinks…

[Andras]

Looking forward to hearing their feedback.

A.

[Henning]

My client would like to have a “paid total” and/or cost per item as well… I have tried with the woocommerce “regular_price” field… That didn’t work. Do you know how to implement that?

[Andras]

Hi Henning,

I updated the snippet 2 days ago to handle RSVPs – it produced an error if an event had tickets and RSVPs as well.

Now I added the Total Order / Total Cost column which goes into the export.

Adding line item costs requires more time invested. It’s a great idea, I might do that in a future version.

Let me know if that works.

Cheers,
Andras

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts