Support

Home Forums Event Espresso Premium EE3 – EE4 Data Migration

EE3 – EE4 Data Migration

Posted: July 16, 2014 at 4:14 pm


Ian Whilden

July 16, 2014 at 4:14 pm

I having difficulty exporting event data from a production site running EE3 and moving that data into and EE4 development site. I have no add ons running on either.


Josh

  • Support Staff

July 16, 2014 at 4:49 pm

Hi Ian,

I’m sorry to hear this. Can you outline how the database was migrated from the production site? It may help to use a plugin like wp-migrate-db or wp migrate db pro if the issue stems from how data was migrated from live to dev.

Can you forward any error message(s) that displayed when you ran the Event Espresso 4 data migration?


Ian Whilden

July 16, 2014 at 8:53 pm

Hello,

I got a Core Data Migration to version 4.1.0 need to update. Does EE provide migration services? In the tasks simplest its export from EE3 to EE4 including all events, questions, question groups, existing event data.


Ian Whilden

July 17, 2014 at 7:34 am

Will someone be picking up this thread this morning?


Josh

  • Support Staff

July 17, 2014 at 7:40 am

Hi Ian,

Yes, we’re here to help. Can you let us know of there were any errors displayed when you tried the automatic data migration? Did you try the automatic data migration?


Ian Whilden

July 17, 2014 at 7:54 am

Josh,

I’d like to export the event data from a site that is running EE3, then take that data and place in a dev site running EE4. On the dev site I’m currently stuck in Maintenance Mode on the dev EE4 site. There is no event data in the dev site, all currently living on the production site. When I click “migrate” I receive an upgrade “Core Data Migration to version 4.2.0” message. Can you help me extract the data from the production site (ee3) and place in development site (ee4)?

Automatic data migration is not relevant seeing that I am running two separate sites.


Josh

  • Support Staff

July 17, 2014 at 8:21 am

Hi Ian,

We can, but it will likely take more time than 30 minutes depending on how large the database tables are in size. Along with that, we will need WP admin access and FTP access to both sites so that we can install database export and import tools.

Automatic migration is still relevant because once the data is moved from the live site, it will still need to be migrated (or more accurately in this case, converted) for Event Espresso 4.


Ian Whilden

July 17, 2014 at 8:37 am

Going over 30 mins at this point is not an issue. Where can I securely email you the credentials?


Josh

  • Support Staff

July 17, 2014 at 9:05 am

You can send them over the secure form by going to your account page and clicking the link where it says “To redeem your token(s) please complete this form”.


Ian Whilden

July 17, 2014 at 9:37 am

I’ve filled out the forms again with dev and live credentials. Please reference and let me know if there is anything else you require.


Ian Whilden

July 17, 2014 at 11:03 am

Josh,

Are you available to help? This request is rather urgent with a looming deadline. If you are unable can you please reassign to another member of the support team.


Josh

  • Support Staff

July 17, 2014 at 11:27 am

Hi there,

I’m in the middle of working on this. Right now I’m setting up a plugin to push the data from your live site to dev. This isn’t exactly something you can rush through, it needs to be done correctly.

I’ll update this post once the ee3 data is moved over to your dev site. From there, you’ll have the option to run the Event Espresso 4 data migration tool yourself, or purchase another token and we will run it.


Ian Whilden

July 17, 2014 at 11:33 am

Josh,

Here’s a little more background on the issue we are encountering:

We have setup a development site so that in the event we encounter issues migrating our existing EE 3.1.36.5.P event data to the latest EE4 version we don’t take down the live site. After setting up the dev site we tried importing an XML file of all content that is currently on the live site into the dev site and received an Error 500 – Internal Server Error. We were able to import an XML file with only “Pages” content, but that doesn’t contain any event data.

We are looking for the most efficient (and most compatible with EE4) way to get our EE3 event data migrated to EE4. Any help is greatly appreciated in getting this matter resolved as fast as possible


Josh

  • Support Staff

July 17, 2014 at 12:11 pm

Did you try using the built in WordPress XML import/export to move the data to the other site? If so, the reason that the event data wasn’t moved to the other site is because the built in WordPress XML import tool will ignore all custom tables (including Event Espresso’s). The WordPress import tool will only handle native WP tables.

The most efficient way to migrate data from one site to another is with the Migrate DB Pro plugin. I’m running into an issue with your site when I try to use it because it appears there are some errors being triggered by mod_security. I’m going to plan b now.


Josh

  • Support Staff

July 17, 2014 at 12:51 pm

Hi there,

I just finished up copying the _events_ database tables over to your dev site and the automatic data migration from EE3 to EE4 is currently running and is at 18%. It will take a few moments for it to finish. Once that’s done, you’ll be able to test Event Espresso 4 on your dev site using the event data copied over from your live site.

Please note: The add-ons you have active on your live site are not compatible with Event Espresso 4. We are working on building new add-ons for Event Espresso 4 that will replace the old ones.


Josh

  • Support Staff

July 17, 2014 at 1:05 pm

Update: The migration is finished, but unfortunately there was a mistake on the live site that I didn’t catch. It turns out when the original events on the live site were created, start and end times were not entered for all of the events. Can you or someone on your team add start times and end times to the events on the live site? This will ensure that everything will work as expected.

In the meantime, I can add some example start times to the dev site and re-run the migrations so you’ll at least be able to test things out there.


Ian Whilden

July 17, 2014 at 1:18 pm

Thanks Josh. Are you talking about registration start/end times or event start/end times?


Josh

  • Support Staff

July 17, 2014 at 1:42 pm

Event start and end times. If you look at any of the events in the editor on the live site, you’ll see that there are empty fields where the event’s start/end times need to be entered.

I updated the dev site with example start/end times and the migration completed as expected this time.


Ian Whilden

July 17, 2014 at 2:07 pm

Great thanks. Events seem to be assigned RO their categories but the categories are not filling in the pages where they are tagged. Accademia section for example returns “the requested route 1 could not be mapped to any registered modules” CR-MDLRQSRTR-RESROU-136


Josh

  • Support Staff

July 17, 2014 at 2:27 pm

Hi there,

This is because those are hardcoded links in the navigation menu that are pointing to URLs that use the EE3 event URL structure. Along with that, the shortcodes from EE3 are not compatible with EE4.

EE4 uses custom post types, so the new routes look like this:

Accademia category archive:

http://dev.register.lamborghinievents.com/event-category/accademia/

single event example:

http://dev.register.lamborghinievents.com/events/laguna-seca-intensivo-session-2-1/

Event Espresso 4 integrates into the WP menu manager where you can select events and event category archives right from the WP Menu Manager and assign menu items to them.

If you want to use shortcodes instead of native event archives, the new shortcode format for ee4 is as follows:

[ESPRESSO_EVENTS category_slug=”your-category-slug”]


Ian Whilden

July 17, 2014 at 3:24 pm

I can’t seem to get the [ESPRESSO_CHECKOUT] command to work. Did this change in EE4?


Josh

  • Support Staff

July 17, 2014 at 3:54 pm

Yes, [ESPRESSO_CHECKOUT] is new to Event Espresso 4 (it partially replaces Event Espresso 3’s [ESPRESSO_EVENTS] shortcode, specifically the registration functionality).

You can see how it works by going to a single event, selecting a quantity, then proceeding to the next step.

The support post ‘EE3 – EE4 Data Migration’ 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.

Event Espresso