Migrating to wordpress, need to import events

  • OscarGonzalez

    (@oscargonzalez-1)


    9 years, 7 months ago

    Hi, I’m currently in the process of migrating a website based on Sharepoint to WordPress. We realized that sharepoint was an overcomplicated solution to our problem and are now int he process of migrating it’s content into a wordpress site.

    We have decided to use the All In One Event Calendar since it’s perfect for the level of event tracking and display we are looking for, but there are a series of old competitions that need to be represented in the new website.

    Checking the MySql tables, I’m not really sure how I would go into inserting them directly into MySql (can’t even find where the event description is saved and I still have no idea how the start and end time are formatted) and I’m pretty sure AI1EC does quite a few more things when creating an event and it’s dedicated page than just inserting in the database.

    Basically, could I get some help on how I could prepare a migration into the event calendar? I’m also very new to PHP, but I suppose that knowing the function I have to call to do a full insert and preparing an auxiliary table in the db to feed the content into the insert method would be the way to approach it, though I’ll also need to know the correct format…

    Anyway, thanks to anybody that can help me with this.

    https://wordpress.org/plugins/all-in-one-event-calendar/

Viewing 2 replies - 1 through 2 (of 2 total)
  • cefiar

    (@cefiar)

    9 years, 6 months ago

    Can you get the events into .ICS format? The calendar supports importing events from .ICS feeds, so you could import it once, then delete the feed but not the events.

    Thread Starter OscarGonzalez

    (@oscargonzalez-1)

    9 years, 6 months ago

    Thanks for the suggestion, but I think I already have it almost figured out. I’ve noticed that aside from the 3 dedicated tables in mySQL for the plugin that the rest is basically just creating a post with the All in one type identifier.

    So I’m basically creating a post with the wp_insert_post method, getting the post ID and then using that to fill out the data I have/need in the wp_ai1ec_events and wp_ai1ec_event_instances tables.

    From initial testing it does seem to be enough and I’m able to interact and delete events, so at a first glance, that seems to cover it.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migrating to wordpress, need to import events’ is closed to new replies.