Easy Export / Import

  • Resolved pasamike

    (@pasamike)


    5 years, 9 months ago

    Is there an easy export / import option hiding some where? I have been working on a staging site that I need to take live. In the meantime events have been added and modified. Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter pasamike

    (@pasamike)

    UPDATE: I tried to export/import the data to staging site, and the data is in a table with same name but the plug-in cannot find the event data.

    No easy import! Tables are linked together:
    wp_posts, wp_postmeta, wp_em_events, wp_em_bookings, wp_em_locations, etc.

    Thread Starter pasamike

    (@pasamike)

    Wow. Thats a real problem moving forward. I didn’t realize I couldn’t make use of my staging site for multiple changes anymore as using the posts table will override the newer content on pages. Yuck!

    Thanks

    You could first try using the native WordPress Importer/Exporter (Dashboard > Tools), but you cannot be selective to only events and locations, for example.

    If you’re not afraid of SQL and do not care about the post ID, you can also export all wp_em_ tables and wp_posts and wp_postmeta as SQL format from your test server. On your new server: delete those (empty?) tables and import the old ones.

    I did that myself last week when I had to suddenly move from provider. Worked great, but it takes the post ID and metas from the original server. It really clones it.

    Thread Starter pasamike

    (@pasamike)

    I tried export / import in PHPmyAdmin, cloned all _em_ tables listed and imported successfully. But when I open plugin it does not show any event data, like it has to be relinked to the tables? I made sure the tables are named the same in terms of prefix and still nothing. Is there just another step I don’t know about?

    You need to clone wp_posts and wp_postmeta as well, because that is where WordPress actually looks for the info in the Dashboard. It there is nothing in those tables, WP will show nothing.

    Thread Starter pasamike

    (@pasamike)

    Can I “insert new only?” or do i have to manually merge the table and then import all? I dont mess with sql enough, and Im trying to avoid erasing the posts I do want to keep.

    o, I tried that.. DOesn’t work. It’ll give lots of errors.

    Thread Starter pasamike

    (@pasamike)

    Okay @duisterdenhaag where is the face palm GIF??
    I just realized this problem is showing on all events after Daylight Savings (March 10th). It does show correct on the site if i go to the event page, but do you know of a way to have the ical feed show the actual start time as opposed to an adjusted time for the events on ical feeds and such?

    Thanks so much for all your help! Youre awesome.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    another way maybe is looking for ical template at events-manager/templates/templates/ical.php

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Easy Export / Import’ is closed to new replies.