Support

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.

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/

October 23, 2018 at 9:25 am

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