Exporting with wp all export

[leviator]

Hi
First of all, great plugin!

We need to automate attendee exporting. We use WP All Export for the heavy lifting, but we have a few questions.
1. Attendees that have RSVP’d and attendees that have bought a ticket seem to have two different post types. Is this correctly understood?
2. Ideally we’d get to export all attendees, for all upcoming events, with some billing details(name, address, note). All neatly sorted by event. Is this something that you have experience with? Google hasn’t been very helpful. So we need to find all these points of information, and query them regularly with WP All Export.

Thanks
Levi

[Andras]

Hi Levi,

Thanks for the kind words!

1. Yes, that is correct. An RSVP of a user will get the ‘tribe_rsvp_attendees’ post_type, while a ticket will be ‘tribe_wooticket’ for example, if you use WooCommerce.

2. We don’t have much experience with WP All Export ourselves, but I’ve seen some of our users using that plugin. I’m not sure how many were using it to export attendee lists.

We do have a built-in export attendees feature, which works by event. Is there something missing from this that would make it work for you? We are always looking for feedback from our users on how we could improve on our plugins.

Cheers,
Andras

 

[leviator]

Hi again

So I’ll have to export tribe_rsvp_attendees and tribe_wooticket, and their corresponding _tribe_tickets_meta. I see the data – great!

Do you have any help to provide with regards to also exporting some of the order information that is relevent pr. ticket? I’m looking for name, address and order note.

Again, thanks!
Levi

[Andras]

Hey,

So, when someone makes a (WooCommerce) ticket purchase, then 2 entries are created in wp_posts: one for the WooCommerce order and one for the ticket itself. Usually the order’s ID number is one below the ID of the ticket. In this screenshot ID 538 is the order, ID 539 is the ticket. https://cloudup.com/c7N_F77LKPg

If there would be more tickets, then they would get ID 540, 541 etc.

Then you will need to look up in wp_postmeta the data where post_id is 538, which will contain the order data, like name, address, email etc. and post_id is 539 which contains the purchased ticket data.

A.

[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