Events Manager
[resolved] [closed] Bulk CSV Import (Mass Upload) (43 posts)

  1. steve098
    Posted 2 years ago #

    @thatsgame1 I copied your pastebin and saved as csv.
    Test import file: http://pastebin.com/S73MSTFX
    importer: http://em.cm/importer-exporter (modified as per this thread)
    most events were imported fine for me, including the correct time, so long as I added them one at a time, except for the final event which failed at "and performance focus". within the description, which is after various commas.
    I know that the field was surrounded by double quotes, but it appears to be confusing it with such a long comment field and numerous commas.

    I would try changing the delimiter to something other than CSV,e.g. tab delimited (another output format supported by Excel is text(tab delimited)) allowing greater relief from commas within your event comment.

    I think you would do this by editing class.EM_ImpExpImport.php in two places:

    line 363
    change from
    $header = fgetcsv($fp);
    $header = fgetcsv($fp,1000,"\t"))
    (this changes the header detection to read the first 1000 characters only and adds the tab as a delimiter)

    line 380
    $csv = new parseCSV();
    add after:
    $csv->delimiter = "\t";

    now someone with more coding knowledge might be able to amend the plugin so you can choose to override the delimiter from within wordpress, but it's beyond me.

  2. steve098
    Posted 2 years ago #

    @thatsgame1 just a note of caution, for http://em.cm/importer-exporter I imported 20 events and it took around 20 seconds. I import one single event and it takes just a few seconds. I don't know how well the importer would scale to several thousand events in one csv file!

  3. gabrielstuff
    Posted 2 years ago #

    @steve098 are you talking about EMI or the other one ?


  4. steve098
    Posted 2 years ago #

    @gabrielstuff, sorry I was talking about the other one http://em.cm/importer-exporter
    I have edited my posts to make it clear.

  5. Marketing Master
    Posted 2 years ago #

    I made some tests with http://em.cm/importer-exporter and generally works fine for me except two things:

    1). If I import date (dtstart, dtend) without time everything is OK, but if I also input time only current time is imported without date (field is empty)?

    2). I cant import locations, I tray all possible variants and every time only location_name is imported?

    3). I'm interested how to import more then one category per event?

    Thx, BR

  6. jhetrick62
    Posted 2 years ago #

    Marketing Master,

    Not sure why you are having so much trouble with the em.com/importer-exporter. As I stated in posts on Pg#1, I did add the modification for date/time that Steve098 suggested and had no issues after that. I'm able to import locations no issues. It seems to import them IF they are properly defined as the same in WP where it creates another location that is blank if you have a name that isn't in your WP directory.

    Do yourself a favor and use Open Office or Libre Office to create your csv file. I used open office. It's just that much easier and more predictable that Excel. I was struggling to keep the date/times correct in Excel. No issue at all in Open Office. This should solve your date/time issues as long as you use the patch Steve had and use the proper formatting for it. Mine worked like a snap.

    As far as Categories, I'm betting that based upon my limited knowledge of databases and how they work, you can't import more than 1 category as if there is only 1 category header, it will fail and either grab the 1st one or the last one. Meaning if there are headers for cat1, cat2, cat 3 ect. then it would work. There is only 1 heading for categories inside the import template, so I'm confident that won't work.


  7. Marketing Master
    Posted 2 years ago #

    jhetrick62 I'm using notepad for saving as csv.

    I don't need to input time, I just mentioned this because I notice this problem (input format in .csv is 15/09/2013 12:00:00).

    But I would like to solve location problem. I manage to import location only if the location name already exist in locations. Location is imported with data from existing location no mater what address, town, state... I input. Am I missing something here?

    Thx, Br

  8. Marketing Master
    Posted 2 years ago #

    OK now I manage to import location also, but no mater what location I import location is always shown as not found on map. If I input same data manually everything is OK?

    Thx, BR

  9. gabrielstuff
    Posted 2 years ago #

    Sorry, it took times, now EMI got examples folder, for those who wondering.
    Mapping the table to the name is in progress.

    Examples here :

  10. thatsgame1
    Posted 2 years ago #

    I had to go with another plugin... http://time.ly/. Had to pay for it and support is helpful too.

  11. c.walter
    Posted 2 years ago #

    hi gabrielstuff

    first, thanks for this great plugin. unfortunately, for me it just works with an xls file. when trying with the example file "emi-import.csv", i get the error message "Extension type not supported". Do you have an idea what could be wrong...?

    best regards, christoph

  12. gabrielstuff
    Posted 2 years ago #

    yup, maybe I forget to add the extension in the upload script... Sorry for that, try to upload not using drag and drop ?
    I'll check tonight (8hours.)

  13. c.walter
    Posted 2 years ago #

    thanks for the quick reply - yes I tried to upload it. now i also tried to drag and drop it (in chrome browser), but nothing happens at all. thanks anyway for checking tonight.

Topic Closed

This topic has been closed to new replies.

About this Plugin

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

About this Topic