Bulk upload locations

  • Resolved minisaez

    (@minisaez)


    7 years, 6 months ago

    I have a list of over 100K locations. I would like to bulk insert them to events manager, perhaps just directly to the sql table. Is there any reason why i shouldn’t do this? Is there a recommendation on best practice to upload bulk locations?

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Stonehenge Creations

    (@duisterdenhaag)

    7 years, 6 months ago

    No, you could… I did the same thing with 200 coupons 🙂

    Stonehenge Creations

    (@duisterdenhaag)

    7 years, 6 months ago

    Hang on.. I’ll look up my code for that. You have to let WP increment automatically 😉 But also make sure that it doesn’t get stuck in a loop, making about 10000 locations

    Been there.. Had that… 🙁

    Stonehenge Creations

    (@duisterdenhaag)

    7 years, 6 months ago

    Sorry… I tested it on my localhost for you, but failed. You can create a new row in wp_em_locations, but then no new post ID is created, so WP will not see the inserted data, nor can any of it be called. Hence, your Dashboard Locations remains empty…

    An EM Location is a custom post type (just like event). So you would have to create a post id with all the info. Then in wp_em_locations point that location_id back to the post_id.

    I’m sure it can be done, but you really need to know what you’re doing in the sql.

    Adding my 200 coupons was easy, but those are only in one SQL Table and all data is called from there. They are not individually linked with other tables.

    Thread Starter minisaez

    (@minisaez)

    7 years, 6 months ago

    hmmm…. Thanks for trying that. I created a single location manually, and am allowing all users to see each others locations, which addresses everything except the post ID. There must be a way to force a join on the two tables…. (still chewing on this…)

    Thread Starter minisaez

    (@minisaez)

    7 years, 6 months ago

    so the location information is split between the post and the location table.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    7 years, 6 months ago

    yes, but that’s because EM is using custom post types that is why you also have entries in wp_posts

    https://codex.ww.wp.xz.cn/Post_Types

    also, haven’t tried this yet but maybe this user shared can help you get started – https://github.com/soixantecircuits/wp-events-manager-importer

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Bulk upload locations’ is closed to new replies.