|
iaeonpac
|
September 26, 2014 at 9:06 am
Just migrating to a new domain. I have the new server set up and have migrated the license key and all site content data.
On the day the new domain is to take over from the old I need to get all EE event and attendee data from the old domain onto the new (and not mess up the rest of WordPress with a full database migration in the process due to many differences!)
The new domain has all EE data from a few days ago so there will be about 10 days of new data.
I see I can ‘export all event data’ from the event overview page as well as ‘import events’ – As nearly all events will already be on the new domain I imagine I can just import a manually cleaned .csv which only has new events?
How though do I import new attendee data? I see there is ‘Export all attendee data’ but have not spotted an ‘import attendee’ function?
It would be fine to remove all EE event and attendee data from the new site when it is re-synched with the old on migration day if this is somehow easier. Do I need to do this directly on tables on the MySQL database with a db admin tool? What would be the procedure as I would like to rehearse!
|
|
Lorenzo Orlando Caum
|
September 26, 2014 at 10:01 am
Hi,
We have an add-on available that can help you with this:
https://eventespresso.com/wiki/attendee-batch-import-add-on/
You’ll need to join the pre-release channel from your account page before you can download the add-on.
—
Lorenzo
|
|
iaeonpac
|
September 26, 2014 at 5:15 pm
Hi,
Thanks Lorenzo. It looks like the add-on deals with the events_attendee and events_answer database tables but not the events_meta table?
I am also not clear if it actually handles all fields or only those in the example.csv?
I imagine I may be able to figure it out but it might be safer to run commands on the database tables directly to a) get new data from the old site and b) add this data to the new one, OR just empty the three tables and re-populate them?
|
|
Josh
|
September 29, 2014 at 10:49 am
Hi there,
You could also copy over all the tables that are prefixed with _events_ from the old site to the new using phpmyAdmin. This will ensure you get all the event data and attendee data. I can imagine that if the associated event data does not get copied over, the attendee won’t be accessible from the admin.
After copying the _events_ tables, you’ll need to manually configure is what’s saved in the _options table. This includes what’s saved on the Event Espresso > General Settings page and any EE3 add-on settings. These will need to be re-entered on the new site when the _options table isn’t copied over.
|
|
iaeonpac
|
September 29, 2014 at 11:05 am
Thanks Josh – The _options table was copied as few days back when the old site was ‘frozen’ (bar new attendee registrations). As there are NO new events I hope I can get away with only copying
_events_answer
_events_attendee
_events_meta
?
|
|
Josh
|
September 29, 2014 at 11:26 am
I don’t quite understand why you’re looking to only copy the _events_answer, _events_attendee, and _events_meta. Have you already copied over the _events_detail and other related tables then?
|
|
iaeonpac
|
September 29, 2014 at 1:07 pm
I cloned an entire existing website a few days ago including EE and all tables related to it.
The only new data on the existing site which needs a refresh when the new domain goes live is attendee data. The events the attendees are booking are already on the new site.
Hope that explains it better?
|
|
Josh
|
September 29, 2014 at 1:21 pm
The attendee data is stored in:
_events_answer
_events_attendee
_events_attendee_meta
The above three listed tables can be copied over to the new site using PHPmyAdmin.
|
|
iaeonpac
|
September 29, 2014 at 1:40 pm
thanks Josh
|
|
Josh
|
September 29, 2014 at 1:57 pm
You’re welcome.
|
