WordPress.org

Ready to get started?Download WordPress

Forums

Events Manager
[resolved] Bulk Import Event Upload (28 posts)

  1. Elizabeth Hannan
    Member
    Posted 2 years ago #

    Hi I am trying to upload a year's worth of events to the calendar. We are using it as a community calendar.

    How/Where do I go to upload the CSV file that I have? Is there a different location or type of file to upload. I have 75 events to upload and will go crazy with manually entering each one.

    Thanks!
    -E

    http://wordpress.org/extend/plugins/events-manager/

  2. Marcus
    NetWebLogic Support
    Plugin Author

    Posted 2 years ago #

    we don't have any import features atm but we're planning on adding an ical importer soon. csv will probably not come along for a while.

  3. KirstenMUC
    Member
    Posted 1 year ago #

    Hey there.
    First of all, let me say: Events Manager is a great tool and such a big help! I'm new to WordPress' world and now searching for a solution how to handle lots of events in Events Manager. ...

    I'm working for a NGO offering no-charge tickets for theatre, concerts and so on for people with low income. We want to implement a calendar on our website which shows all the events with free entry in one city - and serendipitously these are a lot.

    So is there any possibility to import e.g. Excel tables or something else to Events Manager?

    Thanking you in anticipation.

    Cheers!

  4. agelonwl
    Member
    Posted 1 year ago #

    @KirstenMUC

    this isn't available at the moment however someone in pro forum share this snippet and maybe this will give you an idea.

    http://pastebin.com/3UDjZ8Le

  5. guibo
    Member
    Posted 1 year ago #

    Hi
    I can't understand that this function hasn't been developped yet...
    I think (may be I'm wrong !) that a lot of EM users have thousands of events to edit...
    I believe in miracles... !

  6. cocopops67
    Member
    Posted 1 year ago #

    Yes we would love to use this but an upload systen would be essential, typing it in for so many clients is a real pain.

  7. Marcus
    NetWebLogic Support
    Plugin Author

    Posted 1 year ago #

    it won't be a xmas miracle, but we'll get there eventually

  8. davargas
    Member
    Posted 1 year ago #

    I agree this would be a great feature.

  9. tashmina
    Member
    Posted 1 year ago #

    Hi - what is the latest status in being able to import an ical file? Thanks

  10. Marcus
    NetWebLogic Support
    Plugin Author

    Posted 1 year ago #

    no eta atm, but given it's a popular request we'll be looking into this asap

  11. tashmina
    Member
    Posted 1 year ago #

    Great - thanks - much appreciated! I love the software btw but can't really move forward without being able to import a file of events as lots already on our system!

  12. agelonwl
    Member
    Posted 1 year ago #

    hi @tashmina,

    if you can code you can try the snippet above - http://pastebin.com/3UDjZ8Le (it's using rss but maybe you can convert it to support ical)

  13. tashmina
    Member
    Posted 1 year ago #

    That's kind of you, but sadly no I don't code, and would not know where to start with this....! Thanks anyway!

  14. tashmina
    Member
    Posted 1 year ago #

    Dear Marcus

    You mentioned previously that "no eta atm, but given it's a popular request we'll be looking into this asap" - can I just ask whether you think we are talking days, weeks, months or years? Sorry to press you for more of a clue but I am just trying to work out a plan for my business....also, I guess there would need to be a simple upload for venues in a file (sorry,. locations) with their address details first as I don;t think one could have them stored in the ical file for each event before it is uploaded? Then a manual job to link them??!

  15. guibo
    Member
    Posted 1 year ago #

    I've tried a lot of mass import plugins and I can tell that WP Ultimate CSV Importer works great to bulk import events !
    If this can save time to everybody... :-)

  16. tashmina
    Member
    Posted 1 year ago #

    Thanks! I will try it.

  17. tashmina
    Member
    Posted 1 year ago #

    Wow guibo! That is totally amazing! I owe you! All I need to do now is to figure out how to map the event start date and time - couldn't see how to map this (and therefore what fields I need in my csv file for date and time).... but can see it defaults to adding the import date and time - any clues welcome!!

  18. tashmina
    Member
    Posted 1 year ago #

    Marcus and Guibo - I have had another look at this. Essentially I cannot see (when the list of fields is listing for mapping purposes) a field for time or location. So I cannot eg map the event time in the csv file to the event time in the event record it will create. I do however see there is a custom field creator - but do I need to know the exact format to use in each case for this to work? I believe I need
    Start date
    End date
    Start Time
    End Time
    Location name
    Location address
    Location town
    particularly as without some of the above I cannot make a event live anyway. Also, what format of date is required to be accepted?

    Masses of questions but this MAY, if it can work, be an incredibly useful partner to your won excellent software and avoid the need for your own development work??? And useful to many people too?

  19. Marcus
    NetWebLogic Support
    Plugin Author

    Posted 1 year ago #

    take a look at our wp_em_... tables

    the field names match those, but with a _ prefixed, so e.g.

    Start Date = _event_start_date

  20. tashmina
    Member
    Posted 1 year ago #

    Thanks very much and once I know this can work I will happily buy the pro version of course.
    I do not know where to find the "our wp_em_... tables" (pointer?) but I tested the start date in the meantime. First problem was that dates are assumed to be in American format (WP Ultimate CSV Importer is American maybe) but I was able to resolve that by changing the format round in the source csv file. It worked! BUT, although it shows the start date correctly on the list of events imported, it doesn't seem to have been added correctly into the record itself, which still shows a blank start date. ie when I try to "publish" (setting aside the absence of location details for the moment!) it prompts me to use the date picker.......
    Should I give up or keep trying? Obv need to pay for your time at some point too!!

  21. tashmina
    Member
    Posted 1 year ago #

    Further to the above - I have now tested start and end TIME and theywork beautifully and update the record correctly..

  22. texhost
    Member
    Posted 1 year ago #

    tashminia-
    I assumed you were able to bulk upload? If so, how did you handle the post_id and event_id columns?

  23. tashmina
    Member
    Posted 1 year ago #

    Hi - no I am afraid I gave up because I didn't know what to do about the dates not being added properly..... I am now trying a different plugin which has an auto upload from an ics file url but that has problems too! I will get there in the end!!

  24. FemmeFM
    Member
    Posted 1 year ago #

    It is a great plugin with all the formatting features etc. But if you don't use the booking part and can't upload a slew of events for readers, it seems to just create more work. But it is nice to cross reference entries throughout your blog with shortcodes.

    I once tried to use another very cool calendar with smooth info transitions and pop ups etc., but unfortunately it clashed with something else and broke my site (be careful which calendar you add!)

    So yes, please please get an import feature.
    But still a great plugin otherwise.

  25. gabrielstuff
    Member
    Posted 1 year ago #

    Using xlsx and some php please find a work in progress plugin here :

    https://github.com/soixantecircuits/wp-events-manager-importer

    Please watchout this is a alpha and does not support lots of "import" features... stills it allow to be faster on importing events.

    Cheers..

    p.s: not in the wordpress depot because code not fully cleaned up and tested.

  26. agelonwl
    Member
    Posted 1 year ago #

    thanks for sharing;

  27. Matze23
    Member
    Posted 1 year ago #

    @gabrielstuff
    Do you have any documentation about your importer?

    I want to know which fields are imported?
    A - Title
    B - Place?
    C - Date?

  28. Matze23
    Member
    Posted 1 year ago #

    Your plugin breaks RSS-Feeds.

    I'm getting the error: ""line 1, column 1: Blank line before XML declaratio"" when validating my rss feed.

    Found the solutiong edit wp-events-manager-importer-master/emi.php:
    and delete last 2 empty lines

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic