Title: CSV import Last modified: August 30, 2016 --- # CSV import * Resolved [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 8 months ago](https://wordpress.org/support/topic/csv-import-21/) * I am struggling to get the CSV format right to import into my website. I have downloaded the template and tried uploading it. I’ve gone through [this help page](http://time.ly/document/user-guide/manage-add-ons/csv-import/) but it give links to outside sites which aren’t that helpful. * I found another [help article here](https://theeventscalendar.com/knowledgebase/using-the-events-calendars-csv-importer/) which tells me to import venues, organisers and events separately ([examples here](https://theeventscalendar.com/knowledgebase/csv-files-options-and-examples/#dl_field-type-string))– when I try to import that example CSV into my site that also doesn’t work. * Are you able to provide me with an up to date CSV example that might work please? * I have a large number of events to set up and need this functionality. I’ve paid for the CSV importer as part of the Core+ and it would be great to have this feature. * Thank you. Rob * [https://wordpress.org/plugins/all-in-one-event-calendar/](https://wordpress.org/plugins/all-in-one-event-calendar/) Viewing 12 replies - 1 through 12 (of 12 total) * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823847) * My apologies, the links in the second paragraph above reference another calendar tool. I am still struggling to get this going and need help. * I have found that I can [import the test calendar](https://time.ly/wp-timely/assets/timely-test.csv) event provided by Time.ly, but when I add my own events underneath the CSV, I get this error: * > All-in-One Event Calendar has been disabled due to an error: > Argument 1 passed > to Ai1ec_Ics_Import_Export_Engine::_is_timeless() must be of the type array, > null given, called in /home/learni67/public_html/wordpress/wp-content/plugins/ > all-in-one-event-calendar/lib/import-export/ics.php on line 256 and defined * …with a very long set of errors thus: * > Error Details: > #0 /home/learni67/public_html/wordpress/wp-content/plugins/ > all-in-one-event-calendar/lib/import-export/ics.php(102): Ai1ec_Exception_Handler- > >handle_error(4096, ‘Argument 1 pass…’, ‘/home/learni67/…’, 102, Array) #1 / > home/learni67/public_html/wordpress/wp-content/plugins/all-in-one-event-calendar/ > lib/import-export/ics.php(256): Ai1ec_Ics_Import_Export_Engine->_is_timeless( > NULL) #2 /home/learni67/public_html/wordpress/wp-content/plugins/all-in-one- > event-calendar-csv-feed/lib/calendar-feeds/csv.php(238): Ai1ec_Ics_Import_Export_Engine- > >add_vcalendar_events_to_db(Object(vcalendar), Array) #3 /home/learni67/public_html/ > wordpress/wp-content/plugins/all-in-one-event-calendar-csv-feed/lib/calendar- > feeds/csv.php(56): Ai1eccf_Plugin->import_from_file() #4 /home/learni67/public_html/ > wordpress/wp-content/plugins/all-in-one-event-calendar/app/controller/calendar- > feeds.php(57): Ai1eccf_Plugin->handle_feeds_page_post() #5 /home/learni67/public_html/ > wordpress/wp-content/plugins/all-in-one-event-calendar/app/view/admin/calendar- > feeds.php(89): Ai1ec_Controller_Calendar_Feeds->handle_feeds_page_post() #6[ > internal function]: Ai1ec_View_Calendar_Feeds->display_meta_box(NULL, Array)# > 7 /home/learni67/public_html/wordpress/wp-admin/includes/template.php(1037): > call_user_func(Array, NULL, Array) #8 /home/learni67/public_html/wordpress/ > wp-content/plugins/all-in-one-event-calendar/public/admin/settings.php(15): > do_meta_boxes(‘ai1ec_event_pag…’, ‘left’, NULL) #9 /home/learni67/public_html/ > wordpress/wp-content/plugins/all-in-one-event-calendar/lib/theme/file/php.php( > 74): require(‘/home/learni67/…’) #10 /home/learni67/public_html/wordpress/wp- > content/plugins/all-in-one-event-calendar/lib/theme/loader.php(333): Ai1ec_File_Php- > >process_file() #11 /home/learni67/public_html/wordpress/wp-content/plugins/ > all-in-one-event-calendar/app/view/admin/calendar-feeds.php(72): Ai1ec_Theme_Loader- > >get_file(‘settings.php’, Array, true) #12 [internal function]: Ai1ec_View_Calendar_Feeds- > >display_page(”) #13 /home/learni67/public_html/wordpress/wp-includes/plugin. > php(525): call_user_func_array(Array, Array) #14 /home/learni67/public_html/ > wordpress/wp-admin/admin.php(236): do_action(‘ai1ec_event_pag…’) #15 /home/ > learni67/public_html/wordpress/wp-admin/edit.php(10): require_once(‘/home/learni67/…’)# > 16 {main} Request Uri: /wordpress/wp-admin/edit.php?post_type=ai1ec_event&page > =all-in-one-event-calendar-feeds * HELP! I urgently need to get this going as it is a key aspect of my business. * [Benjamin](https://wordpress.org/support/users/bsokic/) * (@bsokic) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823848) * Hi Rob, * Can you please provide a CSV file you were trying to import. * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823849) * Hi Benjamin, * Here is [the CSV file](https://drive.google.com/open?id=1U4VN9Y67TU3rC7bDqOtg_FDBY1BE8lchIJ8k3u-3E3U)– it’s taken straight from the demo one provided on the Time.ly site. * I’ve left the sample data in there of Iron Man which is importing well. The other two lines starting with description CES aren’t though and I can’t figure out why… yet it is saying that 3 events were imported! * [[screenshot here…](https://drive.google.com/open?id=0B8kUA4BFB4dvWjhzVXd4TUpweWs)] * The only way I can get the import to work at all is if I copy/paste data into the sample CSV without changing it at all. For example, if I [create my own spreadsheet](https://drive.google.com/open?id=1nQZZG-r3bdtvDjjbuTZs-pDL_BsVxJq9ict916Ele0I) with the same data using the same headings, then save as a CSV, it won’t accept it. * I am using Microsoft Office for Mac, so am wondering if I need to save the CSV as something else such as Windows comma separated or MS-DOS comma separated? * If I try to copy/paste from the CSV that doesn’t work either. * [Benjamin](https://wordpress.org/support/users/bsokic/) * (@bsokic) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823850) * I need permission to access your files. * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823851) * Done, you should be able to access them now Ben. * Rob * [Calvin](https://wordpress.org/support/users/calvinyeh/) * (@calvinyeh) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823852) * Hi robcnz! * I’ve just requested access to your CSV file. I will take care of this issue. * Thanks! * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823853) * done thanks Calvin * [Calvin](https://wordpress.org/support/users/calvinyeh/) * (@calvinyeh) * [10 years, 7 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823854) * Hi robcnz! * I opened the Google Spreadsheet and downloaded as CSV file. I tried to import in my calendar and all 3 events were imported successfully. * Can you give me more details about your environment so I can simulate here? * I need the versions you are running of: * – WordPress – PHP – All in one event calendar plugin – All in one event calendar CVS feed plugin * Thanks! * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 6 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823855) * Would it be easier to just give you access to my site? I’ll check the WP/database details and get back to you tomorrow. * [Calvin](https://wordpress.org/support/users/calvinyeh/) * (@calvinyeh) * [10 years, 6 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823856) * Hi robcnz! * Sure, we can try that! Please, create an account and send the credentials to my email. * Thanks! * Thread Starter [robcnz](https://wordpress.org/support/users/robcnz/) * (@robcnz) * [10 years, 6 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823857) * Done, thanks Calvin! * [aristotel_timely](https://wordpress.org/support/users/aristotel_timely/) * (@aristotel_timely) * [10 years, 6 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823867) * hey [@robcnz](https://wordpress.org/support/users/robcnz/), in our recent 2.3.9 release we’ve made the CSV import process smoother. You escalation drove us to add automatically detection of line ending style and fixed CSV import issues for files created in Mac OS X. * Thanks for your help, Aristotel Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘CSV import’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/all-in-one-event-calendar.svg) * [Timely All-in-One Events Calendar](https://wordpress.org/plugins/all-in-one-event-calendar/) * [Support Threads](https://wordpress.org/support/plugin/all-in-one-event-calendar/) * [Active Topics](https://wordpress.org/support/plugin/all-in-one-event-calendar/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-event-calendar/unresolved/) * [Reviews](https://wordpress.org/support/plugin/all-in-one-event-calendar/reviews/) * 12 replies * 4 participants * Last reply from: [aristotel_timely](https://wordpress.org/support/users/aristotel_timely/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/csv-import-21/#post-6823867) * Status: resolved