WordPress.org

Ready to get started?Download WordPress

Forums

Event Organiser
[resolved] Cannot import ICAL feed to Google Calendar (7 posts)

  1. mameha
    Member
    Posted 7 months ago #

    In Google Calendar, when I do "Add by URL" and add my ICAL feed, Google returns an error that it cannot parse the file. If I save the ical file to my PC and try to import that the Google Calendar, it gives the same error.

    My Feed URL is:
    http://www.telfordjs.org.uk/feed/eo-events

    The ical feed validates with 99/100 score here:
    http://icalvalid.cloudapp.net/

    The events are written in Japanese which may be causing the problem.

    I am using the latest version of WP and Events Organiser. But I also had this same problem one year ago with an older version of WP and this plugin. It has never worked.

    http://wordpress.org/plugins/event-organiser/

  2. Stephen Harris
    Member
    Plugin Author

    Posted 7 months ago #

    Mmm, not come across this before. You mention that it might be the language the events are written in. Have you been able to test it without Japanese characters? Perhaps there's an encoding issue here.

  3. mameha
    Member
    Posted 7 months ago #

    I have the blog mirrored on a test server. There, I did the following tests:

    1) Remove all events and add a new event in english
    -> google cant parse the calendar
    -> looking in the .ics file, it has some japanese characters still for the blogname and username

    2) Change blogname to English
    -> google cant parse the calendar

    3) Change username to english
    -> google cant parse the calendar
    -> google CAN import the ics file using 'import calendar'

    The ics file looks like this now:

    BEGIN:VCALENDAR
    VERSION:2.0
    PRODID:-////NONSGML Events //EN
    CALSCALE:GREGORIAN
    X-WR-CALNAME:(Telford Japanese School) - Events
    X-ORIGINAL-URL:http://tjs2.zaccraven.co.uk/events/event
    X-WR-CALDESC:(Telford Japanese School) - Events
    BEGIN:VEVENT
    UID:20140131T1020Z-1391163648.69-EO-1757-1@95.142.159.173
    STATUS:CONFIRMED
    DTSTAMP:20140131T102525Z
    CREATED:20140131T101948Z
    LAST-MODIFIED:20140131T101948Z
    DTSTART;VALUE=DATE:20140205
    DTEND;VALUE=DATE:20140206
    SUMMARY: TEST EVENT
    DESCRIPTION: test
    ORGANIZER: zaccraven
    END:VEVENT
    END:VCALENDAR

    Weird.

    The database is utf8.

    All my blog webpages have this in the head:
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

  4. mameha
    Member
    Posted 7 months ago #

    I just tried again to import the calendar manually using 'import a calendar'. This time I could import a file that had Japanese text inside too:

    BEGIN:VCALENDAR
    VERSION:2.0
    PRODID:-////NONSGML Events //EN
    CALSCALE:GREGORIAN
    X-WR-CALNAME:テルフォード補習授業校 - Events
    X-ORIGINAL-URL:http://tjs2.zaccraven.co.uk/events/event
    X-WR-CALDESC:テルフォード補習授業校 - Events
    BEGIN:VEVENT
    UID:20140130T1020Z-1391163648.69-EO-1757-1@95.142.159.173
    STATUS:CONFIRMED
    DTSTAMP:20140130T102048Z
    CREATED:20140130T101948Z
    LAST-MODIFIED:20140130T101948Z
    DTSTART;VALUE=DATE:20140206
    DTEND;VALUE=DATE:20140207
    SUMMARY: TEST ZZZEVENT
    DESCRIPTION: tmmmmest
    ORGANIZER: クレイバン
    END:VEVENT
    END:VCALENDAR

    Its strange. It seems like the .ics file might be OK but for some reason google cant parse the feed directly.

  5. mameha
    Member
    Posted 7 months ago #

    Some further info in case it helps...

    I just tried to import the live calendar, full of Japanese events, into Google Calendar using the .ics file (not the feed). It gave the following error:

    Processed zero events.

    Failed to import events: Unable to process your ical/CSV file..

    Error at line 16:For input string: "UNT"

    Which means there is a problem near the text "UNTIL" in the record below:

    BEGIN:VCALENDAR
    VERSION:2.0
    PRODID:-////NONSGML Events //EN
    CALSCALE:GREGORIAN
    X-WR-CALNAME:テルフォード補習授業校 - Events
    X-ORIGINAL-URL:http://www.telfordjs.org.uk/events/event
    X-WR-CALDESC:テルフォード補習授業校 - Events
    BEGIN:VEVENT
    UID:20130626T0150Z-1372211403.6623-EO-739-1@10.229.73.205
    STATUS:CONFIRMED
    DTSTAMP:20140131T203854Z
    CREATED:20130407T175901Z
    LAST-MODIFIED:20130407T180551Z
    DTSTART;VALUE=DATE:20121221
    DTEND;VALUE=DATE:20121222
    RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=;UNTIL=20121221T000000Z
    SUMMARY: 正月お休み
    DESCRIPTION: 12月15日:学校 12月22日:お休み 12月29日 :お休み 2013年1月5日:学校
    
    ORGANIZER: クレイバン
    END:VEVENT
  6. Stephen Harris
    Member
    Plugin Author

    Posted 7 months ago #

    The value for BYDAY= is missing. What is the recurrence schedule for that event? "Every 1 week, on the ?".

    I'll do a bit of testing to see why that isn't showing up. It should be impossible to create an event recurring weekly without specifying the weekday(s) it repeats on...

  7. mameha
    Member
    Posted 7 months ago #

    Thanks for that.

    The problem seems to have been the first event that I created in 2012. After deleting that old event, the calendar feed imported to Google.

    Something maybe corrupted that record, either due to upgrading the plugin version or migrating server etc.

Reply

You must log in to post.

About this Plugin

About this Topic