Posted: June 7, 2021 at 7:14 am
The site currently uses NCRConsole.com, but the service is being discontinued. Registrations can be exported to a CSV, and I find where EventEspresso accepts csv imports for registrations. Is there anyway the events can be also migrated? Or do they need to be manually setup in Event Espresso before importing the user registrations?
Any knowledge or tips you can offer on migrating from NCR Console to Event Espresso would be appreciated.
Currently, the only method that can be used to ‘export’ events from one site to another is to copy the entire database over and use that on the new site (so not really an export), however, that won’t work if you are trying to ‘merge’ data from one site into another.
So if your ‘new’ site is an existing site different from NCR you’ll need to manually create the events in that site and then export each event’s registrations on NCR and import them into the new events on the new site to keep a record.
Are the events previous events that you are keeping a record of or are the events active/upcoming?
Thanks Tony. Are you suggesting there is a way to migrate a complete database from NCRConsole to EventEspresso? I am familiar with database operations, most recently with MySQL, but was presuming they were entirely different databases. That is why I was expecting to use:
Upcoming events are most important, but my understanding would be required for importing user registrations (that the events already exist).
Depends on what you mean by ‘to EventEspresso’ here?
We (EventEspresso.com) don’t store/host your event data so no, you can’t migrate your database over to us if that is what you are asking?
What I’m referring to above is exporting the database from your NCRConsole site and then using it on another domain. Essentially creating a full copy of your site and then using it on another domain, however, you have a domain linked to your account already and I assume that already has different content than the NCR site? If so, the above won’t work as you’d be trying to merge the 2 databases together, it doesn’t work well.
They are different databases, NCR will have its own DB and so will your new site.
It sounds like copying the entire database isn’t going to be an option for you here, various EE events are stored in the wp_posts tables as custom post types and their ID’s used as foreign keys within multiple custom tables for Event Espresso. So you can’t export those rows from the above and then import them into another site without then mapping the ID to the various rows that use them (we don’t have any methods that will do this automatically for you currently).
If you are exporting the registration using Event Espresso itself, then you don’t need to remap the CSV, we have an Importer add-on for EE4 that can assign the values on the fly.
Not sure I understand this, but you will need to manually recreate the events on the new site, then import each individual events registrations separately.
For historic data, what I recommend you do is clone the NCRConsole site on a subdomain and hide it from public view, that allows you (the admins) to get access to that data should you need it.
Transferring over all of the EE data for users into the new site isn’t going to be easy, it’s doable but will take a fair amount of admin work. How many events need to be migrated over from the ‘old’ site?
EE is replacing NCR
So back to the question, hopefully with more clarity:
Is there a way to use the NCR csv exports to CREATE the events in EE?
Ohh, sorry, when you said NCRConsole.com (which doesn’t load for me) I thought that was a previous site using EE, meaning you are changing from an EE install on NCRConsole.com to a ‘new’ site and wanted to import the data over from ‘old’ EE install into the ‘new’ one.
My mistake, I’ve not heard of NCR Console previously.
So to answer this:
No, you’ll need to manually create the events within Event Espresso and then import the registrations.
However, with regards to this:
It sounds like you are going to import the registration directly into the database yourself, is that correct?
There are a lot of relationships around registrations and I don’t recommend doing this directly but rather using the Importer add-on:
This allows you to import a CSV file of ‘attendees’ into a specific event, it allows you to set the event and specific ticket on that event on which the registrations should be. Maps out the registration questions for you and allows you to select specific fields for specific registration questions.
Then creates all of the EE_Registration, EE_Contact, EE_Tranactions and EE_Line_item objects for you on the fly.
No, I planned on using a tool of EE to import the csv, not attempting to create the relationships myself.
Is the importer included in the Everything Support License?
Yes, the EE4 everything license includes all of our EE4 add-ons.
It’s available in the downloads section on your account page.