|
BCPTA
|
December 18, 2015 at 10:51 am
Hi,
Can you please tell me how we can permanently remove our contacts? I can put them in the “trash” but from there, we need them completely removed from the database.
The reason this is so important is that we have been running tests, and now need to start ‘fresh’ with our site.
But when we have contacts sitting the ‘trash’ they are able to register for events, because they can theoretically be ‘users’ in WP, but their data will never export as being registrants.
See this thread:
https://eventespresso.com/topic/wp-user-integration-bug-registrants-not-exporting/
I see here that this was brought up before:
https://eventespresso.com/topic/contacts-will-not-delete-perm/
And here it was said that we need to remove registrations to do this:
https://eventespresso.com/topic/permanently-deleting-information/
But I have deleted all transactions, and all registrations. The only thing I can not remove are the contacts in the ‘trash’. See these screenshots:
https://cloudup.com/c3Dwb_B6lbV
https://cloudup.com/c8SoxKUmryc
Even if for now we need to do this in the database, or some other way, can you please tell me how to safely remove all contacts in the “Contact List” of EE4?
Do you have plans to fix this soon?
Thank you
|
|
Lorenzo Orlando Caum
|
December 18, 2015 at 12:05 pm
Hi Johanna,
They can be trashed but not permanently deleted. They can be found here:
wp_esp_attendee_meta
However, I do not recommend removing that information since that could unexpectedly break something. There isn’t a permanent delete option as there are several concerns that we are discussing:
If a contact is deleted then should registrations and transactions also be removed?
What happens if this contact is part of one or more group registrants from various events? This would affect the calculations for registration spaces as well as the transaction.
—
Lorenzo
|
|
BCPTA
|
December 18, 2015 at 1:19 pm
I think you could solve this with simple pop ups that just say what would happen if that person is still attached to a registration or transaction. Then an admin can decide to proceed or not. Why wouldn’t an admin have control over what they want on their site and what they don’t want?
But in our scenario all registrations and transactions are completely deleted. They can be permanently removed, so the contacts should be too.
Can you tell me what bad thing could happen if I delete them from the database?
We have a much, much bigger problem in that we need to do a re-import of our members, which are going to attached to our trashed contacts, and they won’t be able to export as registrants in your export option.
The problem right now is that when I imported our users, even if they haven’t registered for an event, they turned into EE contacts:
https://eventespresso.com/topic/users-in-wp-turning-into-ee-contacts/
So now I’m a bit ‘trapped’ – we can’t delete this data, and we can’t do our imports without affecting future use of the functionality for these users.
This is way more problematic to anyone, in my opinion. I do need a way to remove these so we can proceed with our site needs. Can you explain what it would take to do that? What could break?
|
|
Lorenzo Orlando Caum
|
December 18, 2015 at 1:48 pm
Hello,
Unfortunately, a simple popup doesn’t address the original issue which is how to handle existing registrations which could be affected.
If you have a testing / staging site then you could pull in a copy of the site and then test removing those records. If they are just records from importing users, then you should be okay since there isn’t likely to be any registrations from live events.
—
Lorenzo
|
|
BCPTA
|
December 21, 2015 at 7:34 pm
Hi lorenzo,
I removed all rows in the database from this table: wp_esp_attendee_meta
What ended up happening is the contacts are theoretically still in the Contact list, except they are all empty:
See here: https://cloudup.com/cf_W7aYh9YB – there are still 180 in the trash, but the rows are completely empty.
And the weird this is that I can click to “edit” or “restore” a contact, and if I click “edit” I get to a page with all empty fields:
https://cloudup.com/cDQVsldeU65
I’ve deleted all registrations and transactions but I notice the “gateway” table still has info in it – could that be linked to this? I’m just throwing ideas out there to see what we can do.
how can I remove these empty contacts in the “Contact List”?
Thanks
|
|
Josh
|
December 22, 2015 at 7:59 am
You can remove the empty contacts by going into the wp_posts table and removing the posts that have the post_type: espresso_attendees.
|
|
BCPTA
|
December 24, 2015 at 7:19 pm
Ok I did this. Is this something being considered in your development plans?
|
|
Lorenzo Orlando Caum
|
December 25, 2015 at 7:58 pm
Hello, we do have have open ticket with an ongoing discussion about this. I shared some of the points in the discussion in my earlier reply here:
https://eventespresso.com/topic/how-to-permanently-remove-contacts-from-trash/#post-185165
At this time, I can let you know that we are still discussing how those issues should be handled.
—
Lorenzo
|
