Import Venues via CSV File?

WordPress Event Management, Calendars & Registration › Forums › General Question › Import Venues via CSV File?

This topic contains 7 replies, has 2 voices, and was last updated by  Lorie Travis 7 years, 1 month ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • March 15, 2017 at 2:58 am #26531

    Hi Stephen,

    I’ve read everything on the forum and installed the CSV Import plugin.<br />
    However, it doesn’t
    seem to import venues, only events?

    We are a canoe club and have 70+ sections of rivers I need to add to the EO venues.<br />
    I have
    a csv file I used to import them into the Modern Tribe Events Calendar,
    can you let me know how I go about importing these
    into Event Organiser please.

    Also note that the lat/long are very important.

    Thanks!

    Lorie

    Lorie Travis
    March 16, 2017 at 3:06 pm #26555

    Hi Lorie,

    The CSV plug-in can import venues (though not by default – see this page for details), however it does not import any meta data.

    It would be possible to modify the script support venue address details, however. What is the format of your CSV file? Can you give an example row?

    Stephen Harris
    March 17, 2017 at 6:39 pm #26576

    Hi Stephen,

    Here is the example row you requested.

    VENUE NAME VENUE DESCRIPTION VENUE CITY VENUE STATE/PROVINCE VENUE COUNTRY VENUE LATITUDE VENUE LONGITUDE
    Bow River – Clubhouse to Fish Creek Park Novice, Class I Calgary Alberta Canada 51.223767 -114.700769

    Thanks!

    Lorie

    Lorie Travis
    March 18, 2017 at 11:12 pm #26587

    Ah, so it’s just a CSV of venues, rather than events (with venue data)? The Event Organiser CSV plug-in was only designed to import events, so that plug-in will not work.

    Are you familiar with, and comfortable using, wp-cli? I will be happy to write up a quick wp-cli command for you to import those venues. Unfortunately I’m not in a position where I’m able to develop something with a GUI for you to import venues.

    Stephen Harris
    March 19, 2017 at 5:13 pm #26591

    A wp-cli command would be great, yes please! I do work with a web developer and with her help I am
    sure I can make it work.

    Thanks!
    Lorie

    Lorie Travis
    March 21, 2017 at 11:15 am #26628

    Hi Lorie,

    The plug-in for adding a WP-CLI command and documentation can be found here: https://gist.github.com/stephenharris/00a6a601b274b38a59cc82c146a95688

    Please run the command with --dry-run to see how the venues would be created, just to make sure everything is correct.

    Stephen Harris
    March 21, 2017 at 1:31 pm #26631

    Wow, that’s great Stephen. It’ll take me a couple of days to get this done, we are doing other dev
    work right now. Will let you know how it goes!
    Thanks so much!
    Lorie

    Lorie Travis
    March 23, 2017 at 5:53 pm #26692

    Hi Stephen,

    The WP-CLI command worked great! Our web developer took care of it for me as it was a bit beyond
    my skills. Saved us/me HOURS of work!

    Thanks!
    Lorie

    Lorie Travis
  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
To enable me to focus on Pro customers, only users who have a valid license for the Pro add-on may post new topics or replies in this forum. If you have a valid license, please log-in or register an account using the e-mail address you purchased the license with. If you don't you can purchase one here. Or there's always the WordPress repository forum.