Support

Home Forums Event Espresso Premium Migration from NCR – best method

Migration from NCR – best method

Posted: June 7, 2021 at 7:14 am


denisemorgan

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.


Tony

  • Support Staff

June 8, 2021 at 4:41 am

Hi there,

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?


denisemorgan

June 8, 2021 at 5:01 am

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:
1. Export from NCRConsole to csv
2. Remap csv to EventEspresso csv layout
3. Import csv into EventEspresso

Upcoming events are most important, but my understanding would be required for importing user registrations (that the events already exist).
Historical information is also highly desired for maintaining continuity and customer loyalty, etc.

Thank you.


Tony

  • Support Staff

June 8, 2021 at 5:22 am

Are you suggesting there is a way to migrate a complete database from NCRConsole to EventEspresso?

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.

I am familiar with database operations, most recently with MySQL, but was presuming they were entirely different databases.

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).

That is why I was expecting to use:
1. Export from NCRConsole to csv
2. Remap csv to EventEspresso csv layout
3. Import csv into EventEspresso

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.

Upcoming events are most important, but my understanding would be required for importing user registrations (that the events already exist).

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.

Historical information is also highly desired for maintaining continuity and customer loyalty, etc.

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?


denisemorgan

June 9, 2021 at 4:42 am

EE is replacing NCR
So it is desired to migrate the NCR data pertaining to events and registrations to EE.
There is no domain change. The same domain is being used.
As I attempted to explain the goal is to migrate the NCR data into the database EE uses.
You seemed to switch your response into exporting FROM EE, that is not the desire.
I have some csvs with exported data from NCR, and want to import that data to were EE will use it. As I expressed EE is using the MySQL database native to WordPress.

So back to the question, hopefully with more clarity:
With the understanding data has been exported from NCR into csv for user registrations which identifies events.

Is there a way to use the NCR csv exports to CREATE the events in EE?
(yes, I understand this goes into the MySQL database).


Tony

  • Support Staff

June 9, 2021 at 5:03 am

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:

With the understanding data has been exported from NCR into csv for user registrations which identifies events.

Is there a way to use the NCR csv exports to CREATE the events in EE?

No, you’ll need to manually create the events within Event Espresso and then import the registrations.

However, with regards to this:

(yes, I understand this goes into the MySQL database).

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:

https://eventespresso.com/product/eea-importer/

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.


denisemorgan

June 9, 2021 at 12:59 pm

No, I planned on using a tool of EE to import the csv, not attempting to create the relationships myself.
I had found this, and thought it was the right approach: https://eventespresso.com/topic/export-and-import-of-events-and-registrations/

Is the importer included in the Everything Support License?


Tony

  • Support Staff

June 10, 2021 at 2:41 am

Yes, the EE4 everything license includes all of our EE4 add-ons.

It’s available in the downloads section on your account page.

You must be logged in to reply to this support post. Sign In or Register for an Account

Event Espresso