Support

Home Forums Event Espresso Premium Old registration data cleanup / Contacts

Old registration data cleanup / Contacts

Posted: July 21, 2015 at 10:30 am

Viewing 3 reply threads


Emily Ruff

July 21, 2015 at 10:30 am

We use EE for an once-a-year conference. We want to wipe out last year’s registration including Contacts, to start clean for the next event. I did Not reset EE data entirely, because we do want to retain things like venue and Invoice template. So, I went into phpAdmin and truncated these tables:

wp_esp_registration
wp_esp_registration_payment
wp_esp_transaction
wp_esp_line_item
wp_esp_payment,
wp_esp_attendee_meta for contact list
wp_esp_answer
wp_esp_extra_meta

Now the registration seem removed, but Contact List is showing 400 something blank records (/wp-admin/admin.php?page=espresso_registrations&action=contact_list&contact_list_nonce=d4ddef5a19&return=event_registrations).

I was expecting a table called wp_esp_contact where I can delete all the contact list records, but there isn’t. Any advice on how to delete old Contact List?


Lorenzo Orlando Caum

  • Support Staff

July 21, 2015 at 10:58 am

Hello, please be sure to backup your database before making any changes like this directly.

Check your wp_posts (dbprefix_posts) table for the following custom post type:

espresso_attendees


Lorenzo


Emily Ruff

July 22, 2015 at 9:01 am

that worked. Thank you Lorenzo!


Lorenzo Orlando Caum

  • Support Staff

July 22, 2015 at 10:52 am

Thanks for letting us know Emily. I’ll update this support post to resolved.

If you need help with anything else, then please create a new support post in our support forums:

https://eventespresso.com/support/forums/


Lorenzo

Viewing 3 reply threads

The support post ‘Old registration data cleanup / Contacts’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso