Events Manager
[resolved] Injecting XML data into EM Tables - EM5 beta (3 posts)

  1. rontarson
    Posted 3 years ago #

    Probably for Marcus-

    I have been injecting XML data directly into the EM tables to automate the import of large amounts of event data from 3rd parties. I then use the below SQL statement to align locations with events using the location_id column.

    UPDATE wp_em_events a, wp_em_locations b
       SET a.location_id = b.location_id
     WHERE a.venueid = b.venueid

    However with EM ver 5 latest beta the locations/events no longer get linked using this statement (even though the statement is working and updating wp_em_events location_id column).

    There must be another area where the location_id is used to link events to locations??


  2. Marcus
    NetWebLogic Support
    Plugin Author

    Posted 3 years ago #

    Yes, you need to also add a post meta to the corresponding post_id in the wp_em_events table

    Event info is now saved in two places, 1. Post meta (which is where EM_Event objects are loaded from, 2. The em_events table (serves more as an index now compared to before)

  3. Oestee
    Posted 2 years ago #


    I'm thinking of using event-manager for a new project, but the ability to import data is one of the crucial points.

    Would you like to share your solution for importing xml?

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Events Manager
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic