|
W4Designs
|
September 4, 2019 at 2:29 pm
We have EE 4.10.0 and are building a new site. We need to be able to export events, attendee info and transaction info so when we go to the new site, we have not lost all of that historical info from past events and so we don not have to recreate all of our events since typically we copy and rename them from year to year, making slight changes to tickets.
How can this be done?
|
|
Josh
|
September 4, 2019 at 2:53 pm
Hi,
You can use a plugin like WP Migrate DB Pro to transfer the database from one site to another site. Please note, the database also has posts and other settings. If your sites involve a scenario where:
– The original site has Event Espresso data, and the new site doesn’t have Event Espresso data
– You want to preserve the new site’s posts & pages, because they’re different than the original site’s posts & pages
You could:
1. Run the WP export tool on the new site, then set that backup aside for now
2. Migrate the original site’s database to the new site (minimum of wp_posts table & all wp_esp_* tables). The WP Migrate DB plugins are recommended for this step
3. Then delete all standard WP posts/pages on the new site
4. Then run the WordPress import tool to import the WP posts/pages (restoring the new site’s posts & pages)
5. If there are other custom things like theme options those would need to be re-imported too
This is best done on a staging server before moving the data to a live server.
|
|
W4Designs
|
September 5, 2019 at 11:13 am
I cannot believe that a paid plugin as popular and well liked as Event Espresso that there is not built in functionality for migrating it to a new site. In many cases, the steps you provide are simply not practical. Many equally as popular plugins (different functionality) offer simple export as csv or json and then an import to bring all of that data back in quickly and easily.
I did a search in the forum and there are MANY posts spanning years back asking about how to do this. Is this not even on the road map of functionality to be included out of the box?
|
|
Josh
|
September 5, 2019 at 11:22 am
Hi,
There isn’t something on the roadmap in the way you describe it. I’m curious about why you write that it’s not practical to use the WordPress bulk importer or a tool like WP Migrate DB. They’re quite excellent tools actually.
|
|
W4Designs
|
September 5, 2019 at 11:30 am
It isn’t practical because many times when someone is designing a new site, they have the entire site built and wrapped up from a design standpoint. Then it becomes time to start installing the additional plugins, like Event Espresso. In other cases, as in mine, my original site since it is older, has become to drag for various reasons. Exporting a DB from an old site and laying it over a brand new install doesn’t make sense and could potentially transfer problems from the old site to the new. Lastly, while many people are perfectly capable of downloading your plugin, installing it and configuring it, using the steps you provide to migrate it to a new site are simply not user friendly, expose you to the possibility of screwing something up and are time consuming whereas a simple export/import function would have the user on there way in a matter of minutes.
|
|
W4Designs
|
September 5, 2019 at 11:33 am
Oh, and not to mention that it costs at a minimum of $99 for WP Migrate DB Pro on top of what an annual EE license already costs.
|
|
Josh
|
September 5, 2019 at 12:17 pm
I’ve added your idea to the roadmap, we can track how much interest it captures.
https://trello.com/c/b3qlrONH/251-a-simple-export-import-function-for-everything-ee-related
|
|
W4Designs
|
September 5, 2019 at 12:23 pm
If I type “migrate new site” in the forum search, there are 426 results that come back. Obviously some of those are other things like migrating from one version to another. But, most at the top are referring to what I’m asking here. So, there is a need. Unfortunately, I’m not sure how many people actually go browse Trello to see what there is to vote on.
|
|
Josh
|
September 5, 2019 at 9:15 pm
Most of those results are about other things, but I do agree that this isn’t the first time someone has asked about this.
What we actually do is when anyone in the forums asks/requests/inquires about a feature that also has a card on the Public Roadmap, we invite them to vote for/comment on the feature’s trello card.
|
