[Plugin: Events Manager] Injecting XML data into EM Tables – EM5 beta

  • Resolved rontarson

    (@rontarson)


    13 years, 2 months 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??

    https://www.ads-software.com/extend/plugins/events-manager/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    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)

    rontarson

    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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Events Manager] Injecting XML data into EM Tables – EM5 beta’ is closed to new replies.