Hi,
I'm trying to import a calendar from google. The google calendar is shared
publicly, the URL is like this:
http://www.google.com/calendar/ical/u...@domain.com/public/basic.ics
The calendar publishs free busy information.
When i add the calendar to the sogo web interface, I see the following in the
logs:
127.0.0.1 - - [08/Sep/2011:08:28:09 GMT] "POST
/SOGo/so/sebastia/Calendar//addWebCalendar?url=http%3A//www.google.com/calendar/feeds/user%2540domain.com/public/basic
HTTP/1.1" 200 16/0 10.202 - - -
2011-09-08 08:30:34.628 sogod[7513] <0x0x85f43908[PostgreSQL72Channel]:
connection=<0x0x803879c8[PGConnection]: connection=0x0x828b5000>>: message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"sogosebastia0025b1fcff7_pkey" for table "sogosebastia0025b1fcff7"
2011-09-08 08:30:34.639 sogod[7513] <0x0x85f43908[PostgreSQL72Channel]:
connection=<0x0x803879c8[PGConnection]: connection=0x0x828b5000>>: message:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"sogosebastia0025b1fcff7_quick_pkey" for table "sogosebastia0025b1fcff7_quick"
Sep 08 08:30:34 sogod [7513]: <0x0x839b9aa8[NGSendMail]> wrote 1, length 764
2011-09-08 08:30:34.733 sogod[7513] <0x0x8590e308[PostgreSQL72Channel]:
connection=<0x0x83605638[PGConnection]: connection=0x0x8bb49800>>: message:
WARNING: nonstandard use of \\ in a string literal
LINE 1: UPDATE sogo_user_profile SET c_settings = '{"folderINBOX...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
2011-09-08 08:30:34.744 sogod[7513] <0x0x85f43908[PostgreSQL72Channel]:
connection=<0x0x803879c8[PGConnection]: connection=0x0x828b5000>>: message:
WARNING: nonstandard use of \\ in a string literal
LINE 1: UPDATE sogo_user_profile SET c_settings = '{"folderINBOX...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Sep 08 08:30:35 sogod [7513]: <0x0x7e81d3c8[OCSiCalFieldExtractor]> ERROR:
unexpected iCalendar parse result: <0x834a3008[iCalFreeBusy]:VFREEBUSY
6 children: {
<0x80386e88[iCalDateTime]:DTSTART
1 values: {
20110908T113000Z
}>
<0x84a1e308[iCalDateTime]:DTEND
1 values: {
20110908T123000Z
}>
<0x80386668[iCalDateTime]:DTSTAMP
1 values: {
20110908T063034Z
}>
<0x80386ee8[CardElement]:UID
1 values: {
1D59-4E686100-5-6B8B4580
}>
<0x80386cc8[iCalPerson]:ATTENDEE
1 attributes: {
X-NUM-GUESTS: (0)
}
1 values: {
mailto:u...@domain.com
}>
<0x80386ac8[CardElement]:SUMMARY
1 values: {
Busy
}>
}>
Sep 08 08:30:35 sogod [7513]: [ERROR]
<0x876B1E08[SOGoAppointmentObject]:1D59-4E686100-5-6B8B4580> write failed:
<NSException: 0x84f24a88> NAME:GCSExtractFailed REASON:Quickfield extractor did
not return a result! INFO:{GCSContent = "BEGIN:VCALENDAR
BEGIN:VFREEBUSY
DTSTART:20110908T113000Z
DTEND:20110908T123000Z
DTSTAMP:20110908T063034Z
UID:1D59-4E686100-5-6B8B4580
ATTENDEE;X-NUM-GUESTS=0:mailto:u...@domain.com
SUMMARY:Busy
END:VFREEBUSY
END:VCALENDAR"; GCSExtractor = "<OCSiCalFieldExtractor: 0x7e81d3c8>"; GCSFolder
= "<0x0x810c30c8[GCSFolder]: id=15
path=/Users/sebastia/Calendar/1D59-4E686100-3-6B8B4580 type=Appointment
loc=postgresql://_sogo:sogo@localhost:5432/sogo/sogosebastia0025b1fcff7>"; }
127.0.0.1 - - [08/Sep/2011:08:30:35 GMT] "POST
/SOGo/so/sebastia/Calendar//addWebCalendar?url=http%3A//www.google.com/calendar/ical/user%2540domain.com/public/basic.ics
HTTP/1.1" 200 75/0 0.499 - - -
127.0.0.1 - - [08/Sep/2011:08:30:35 GMT] "POST
/SOGo/so/sebastia/Calendar/1D59-4E686100-3-6B8B4580/canAccessContent HTTP/1.1"
204 0/0 0.018 - - -
2011-09-08 08:30:39.576 sogod[7513] <0x0x8590e308[PostgreSQL72Channel]:
connection=<0x0x83605638[PGConnection]: connection=0x0x8bb49800>>: message:
WARNING: nonstandard use of \\ in a string literal
LINE 1: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"Dr...
^
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] "POST
/SOGo/so/sebastia/Calendar/eventslist?asc=true&sort=start&day=20110908&filterpopup=view_thismonth
HTTP/1.1" 200 2/0 0.031 - - -
127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] "POST
/SOGo/so/sebastia/Calendar/alarmslist?browserTime=1315463424 HTTP/1.1" 200 2/0
0.016 - - -
127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] "POST
/SOGo/so/sebastia/Calendar/monthview?day=20110908 HTTP/1.1" 200 1210/0 0.029
6535 81% -
127.0.0.1 - - [08/Sep/2011:08:30:39 GMT] "POST
/SOGo/so/sebastia/Calendar/taskslist?show-completed=0 HTTP/1.1" 200 2/0 0.016 -
- -
127.0.0.1 - - [08/Sep/2011:08:30:40 GMT] "POST
/SOGo/so/sebastia/Calendar/eventsblocks?sd=20110829&ed=20111002&view=monthview
HTTP/1.1" 200 288/0 0.021 - - -
I don't get an error popup, but also nothing is shown in the sogo web calendar.
googling, I found this older thread from March this year, regarding importing
holiday calendar served from google::
http://www.mail-archive.com/users@sogo.nu/msg04355.html
Also for me its not working.
Is there anything I might do wrong, or any hints to get it to work?
Sebastian
--
users@sogo.nu
https://inverse.ca/sogo/lists
