Support

Home Forums Event Espresso Premium Duplicate User

Duplicate User

Posted: October 22, 2018 at 8:43 am


WEMconference

October 22, 2018 at 8:43 am

Hi

I have a user in the system who has booked the main event and then a system admin has added new events under her name and email manually but now we have 2 contacts with identical emails one is registered to the main event and the other to all the workshop events.

There is only 1 wordpress user with the email but 2x event espresso contacts with the identical email and name.

How do i merge these records so the wordpress user sees all the registrations?

Thanks in advance,
Ben.


Josh

  • Support Staff

October 22, 2018 at 11:10 am

Hi Ben,

What you do is gather the registration ID from the registrations, the target Contact ID, then make a backup of the database, then use a tool like phpmyAdmin to manually edit the ATT_ID value for the registration record(s).

The steps are:
Find the Event Espresso contact ID that you want to merge the registrations to (the target).
https://slack-files.com/T02SY781D-FDM1NJ2NS-bb01486d45
Then get the registration IDs of the registrations you want to merge
Then make a backup of the database.

Then go to phpmyadmin and go into the _esp_registration table. The first column is REG_ID (registration ID) and the third column is ATT_ID (contact ID). You’ll find the registrations, then edit the ID in the ATT_ID column to match the contact ID of the target.


WEMconference

October 22, 2018 at 11:13 am

Hi Josh

That’s great, thanks for the swift response!

Kind regards,
Ben.


Tony

  • Support Staff

October 22, 2018 at 2:35 pm

Hi Ben,

I had a snippet I use for testing that allows you to set the Contact ID through the dashboard to help speed this up a little.

It adds a Contact ID metabox to the EE edit registration page, like this – http://take.ms/TkT0B

On page load it loads the current contact’s ID, if you change that ID it updates the ATT_ID on that registration to whatever value you entered, for example in the above. For example if I input 11 and update on that registration, its now assigned to Contact ID 11 – http://take.ms/5sKTm

This is something I threw together for testing so isn’t official and should be considered untested but you are welcome to try it should you wish:

https://gist.github.com/Pebblo/239dcbbab9514c13ba48fe3e8e9a5add

Add that to a custom functions plugin on the site:

https://eventespresso.com/wiki/create-site-specific-plugin-wordpress-site/


WEMconference

October 23, 2018 at 9:11 am

Hi Tony

That’s great thanks for the code!! I will test it out today.

Kind Regards,
Ben


Tony

  • Support Staff

October 23, 2018 at 9:25 am

You’re most welcome, please do let me know if you run into any problems.


WEMconference

October 31, 2018 at 7:37 am

Thanks for the help on this i used Joshs solution but will look at implementing Tonys as well in future, I will mark this as resolved now.

The support post ‘Duplicate User’ 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.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: closed

Updated by  WEMconference 9 months, 3 weeks ago ago

Topic Tags

Tagged: , ,

Notifications

This topic is: resolved
Do NOT follow this link or you will be banned from the site!