CSV import

  • Resolved robcnz

    (@robcnz)


    9 years, 3 months ago

    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 but it give links to outside sites which aren’t that helpful.

    I found another help article here which tells me to import venues, organisers and events separately (examples here) – 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://www.ads-software.com/plugins/all-in-one-event-calendar/

Viewing 12 replies - 1 through 12 (of 12 total)
  • Thread Starter robcnz

    (@robcnz)

    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 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.

    Hi Rob,

    Can you please provide a CSV file you were trying to import.

    Thread Starter robcnz

    (@robcnz)

    Hi Benjamin,

    Here is the CSV file – 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…]

    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 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.

    I need permission to access your files.

    Thread Starter robcnz

    (@robcnz)

    Done, you should be able to access them now Ben.

    Rob

    Hi robcnz!

    I’ve just requested access to your CSV file. I will take care of this issue.

    Thanks!

    Thread Starter robcnz

    (@robcnz)

    done thanks Calvin

    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

    (@robcnz)

    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.

    Hi robcnz!

    Sure, we can try that! Please, create an account and send the credentials to my email.

    Thanks!

    Thread Starter robcnz

    (@robcnz)

    Done, thanks Calvin!

    hey @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.