Title: Cannot import event dates Last modified: August 21, 2016 --- # Cannot import event dates * Resolved [ukremmin](https://wordpress.org/support/users/ukremmin/) * (@ukremmin) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/) * Hi, * I lost several days trying all kinds of permutations, but cannot get the import to work. Please help! * I am using this importer: [http://em.cm/importer-exporter](http://em.cm/importer-exporter) * With this csv-file: * summary,post_content,location_address,location_town,location_name,location_country, location_postcode,event_start_date,event_end_date,event_start_time,event_end_time, event_all_day,event_owner Event_1,post content text,Hauptstr. 5,Bremen,Stadthalle, Deutschland,12345,”2013-07-27″,”2013-07-27″,”00:00:00″,”00:00:00″,1,1 * I tried several date and time formats, but when opening the imported event, the dates, times and all_day_event check box are empty. * These did not work for example: “2013-07-27” 2013-07-27 “2013-07-27 00:00:00” 09.12.2013 * Everything else can be imported (location or event name for example), just not the date and time related entries. * Any ideas? What is the correct date and time format? Or am I missing a database field? * [http://wordpress.org/plugins/events-manager/](http://wordpress.org/plugins/events-manager/) Viewing 8 replies - 1 through 8 (of 8 total) * [Philip John](https://wordpress.org/support/users/philipjohn/) * (@philipjohn) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957220) * Hiya, * Where has the importer you’re using come from? I’m not aware of one so if it’s not working the chances are you’d need to contact the original developer to work out any issues. * Cheers, Phil * Plugin Support [angelo_nwl](https://wordpress.org/support/users/angelo_nwl/) * (@angelo_nwl) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957238) * haven’t tried this one but will do try it and update you here though can’t promise it today. * Thread Starter [ukremmin](https://wordpress.org/support/users/ukremmin/) * (@ukremmin) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957246) * Hi Phil, * this importer was mentioned by Marcus: [http://wordpress.org/support/topic/bulk-csv-import-mass-upload](http://wordpress.org/support/topic/bulk-csv-import-mass-upload) * He did not say if he tested it, though. * Plugin Author [Marcus (aka @msykes)](https://wordpress.org/support/users/netweblogic/) * (@netweblogic) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957251) * i didn’t. you’d need to figure that one out by playing with it yourself atm. * [steve098](https://wordpress.org/support/users/steve098/) * (@steve098) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957289) * for the events manager bulk importer mentioned at [http://em.cm/importer-exporter](http://em.cm/importer-exporter)( WebAware.com.au?) The code out-of-the-box is hardcoded to start each event at midnight. edit this file: /wp-content/plugins/events-manager-import-export-0.0.3- alpha/class.EM_ImpExpImport.php * corrected code is here (a bodge; I don’t really know php) * [http://pastebin.com/SCd33zCT](http://pastebin.com/SCd33zCT) * The fix is at line 480. You will see I have commented out the old regexp date match search, and also the line where the time of the event was hardcoded – for both the start and end date. Your CSV can then contain a start/end date in the format ,28/08/2013 18:00:00,28/08/2013 21:00:00, and this imports very well. * (the regexp is now searching for dd/mm/yyyy hh:mm:ss) * Thread Starter [ukremmin](https://wordpress.org/support/users/ukremmin/) * (@ukremmin) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957297) * Thank you! Thank you! Thank you! * It works. What a relieve…. * For everybody else who needs to import from csv with this importer here’s one hint: In the headline of your csv don’t use the words “event_start_date” and“ event_end_date” (as a look into the database would suggest), but just use “start” and “end” as column headings for the start and end dates of the event. * Also use “summary” for the event’s title. * For the location it is different: here you use the same names as in the database( I am using a plugin called “Database Peek” to look them up). For example a column in your csv called “location_town” will map correctly to the location_town in the database.) * [steve098](https://wordpress.org/support/users/steve098/) * (@steve098) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957298) * an example csv is here [http://pastebin.com/TaEB9GBQ](http://pastebin.com/TaEB9GBQ) note that the column locations are not important (I think) as the importer converts the data to a named array; it is the name of the column headings (the first row) that are crucial and must match that as defined in the class.EM_ImpExpImport. php file. * I admire this import utility’s ability to handle custom event attributes and to look up existing locations * Thread Starter [ukremmin](https://wordpress.org/support/users/ukremmin/) * (@ukremmin) * [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957299) * Ups, I produced a typo in my post above and your csv reminded me: * This is wrong: “but just use “start” and “end” as column headings for the start and end dates of the event.” * Instead of “start” and “end” it is “dtstart” and “dtend” * Sorry for that (I’m tired) * I can confirm that the column locations are not relevant. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Cannot import event dates’ is closed to new replies. * ![](https://ps.w.org/events-manager/assets/icon-256x256.png?rev=3550347) * [Events Manager - Calendar, Bookings, Tickets, and more!](https://wordpress.org/plugins/events-manager/) * [Frequently Asked Questions](https://wordpress.org/plugins/events-manager/#faq) * [Support Threads](https://wordpress.org/support/plugin/events-manager/) * [Active Topics](https://wordpress.org/support/plugin/events-manager/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/events-manager/unresolved/) * [Reviews](https://wordpress.org/support/plugin/events-manager/reviews/) * 8 replies * 5 participants * Last reply from: [ukremmin](https://wordpress.org/support/users/ukremmin/) * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/cannot-import-event-dates/#post-3957299) * Status: resolved