Problem with import of Outlook-Invitations

[Hans-Jurgen_Tappe]

Hi!

I got the following invitation:

BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:hjtappe@localhost
ORGANIZER:MAILTO:webmaster@localhost
DTSTART:20081125T160000Z
DTEND:20081125T161500Z
TRANSP:OPAQUE
SEQUENCE:0
UID:040000008200E00074C5B7101A82E00800000000B0633F9AFD44C9010000000000000000100
0000009826B9AC6E7284B9AD57A9DD6943FCC
DTSTAMP:20081112T183356Z
DESCRIPTION:Zeit: Dienstag, 25. November 2008 17:00-17:15 (GMT+01:00)
Amsterdam, Berlin, Bern, Rom, Stockholm,
Wien.\n\n*~~~~~~~~~*\n\n\n
SUMMARY:Follow-Up discussion
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

During import by the web frontend, it says “Successfully imported” but
the data does not show up. The same for Lightning; while this even
produces a database error.

These are the messages from the error log.
==> Web-UI:
VALARM field:ACTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import
VALARM field:DESCRIPTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import

==> Lightning via caldav.php:
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
Database error: db::column_data_implode(’ AND ‘,Array\n(\n [uid] =>
null\n [0] => (cal_user_type=‘u’ AND cal_user_id IN
(‘5’,’-1’,’-2’))\n [1] => recur_type IS NULL AND
cal_recur_date=0\n)\n,‘1’,

Array\n(\n    [cal_id] => Array\n

(\n            [type] => auto\n            [nullable] => \n

)\n\n    [cal_uid] => Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n        )\n\n

[cal_owner] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n        )\n\n

[cal_category] => Array\n        (\n            [type] => varchar\n

[precision] => 30\n        )\n\n    [cal_modified] => Array\n

(\n            [type] => int\n            [precision] => 8\n

)\n\n    [cal_priority] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [nullable] => \n

[default] => 2\n        )\n\n    [cal_public] => Array\n        (\n

[type] => int\n            [precision] => 2\n

[nullable] => \n            [default] => 1\n        )\n\n    [cal_title]

=> Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n      [Thu Nov 13

09:36:48 2008] [error] [client 127.0.0.1]       [default] => 1\n

)\n\n    [cal_description] => Array\n        (\n            [type] =>

text\n        )\n\n    [cal_location] => Array\n        (\n

[type] => varchar\n            [precision] => 255\n        )\n\n

[cal_reference] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n            [default]

=> 0\n        )\n\n    [cal_modifier] => Array\n        (\n

[type] => int\n            [precision] => 4\n        )\n\n

[cal_non_blocking] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_special] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_etag] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [default] => 0\n

)\n\n)\n

nothing known about column ‘uid’!
#0 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1447):
egw_db->halt(‘db::column_data…’)
#1 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1883):
egw_db->column_data_implode(’ AND ‘, Array, true, false, Array)
#2 [internal function]: egw_db->select(‘egw_cal’,
‘egw_cal_repeats…’, Array, false, false, false, NULL, ‘calendar’, 0,
‘JOIN egw_cal_da…’, NULL)
#3 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1939):
call_user_func_array(Array, Array)
#4 /var/www/groupware/calendar/inc/class.calendar_so.inc.php(340):
egw_db->union(Array, 340, ‘/var/www/groupw…’, ‘cal_start’, false, 0)
#5 /var/www/groupware/calendar/inc/class.calendar_bo.inc.php(376):
calendar_so->search(NULL, NULL, Array, 0, ‘all’, Array, false, 0, NULL,
true)
#6
/var/www/groupware/calendar/inc/class.calendar_groupdav.inc.php(95):
calendar_bo->search(Array)
#7 /var/www/groupware/phpgwapi/inc/class.groupdav.inc.php(215):
calendar_groupdav->propfind(’/calendar/null’, Array, Array, 5, ‘null’)
#8 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(555):
groupdav->PROPFIND(Array, Array)
#9 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(216):
HTTP_WebDAV_Server->http_PROPFIND()
#10 /var/www/groupware/groupdav.php(70):
HTTP_WebDAV_Server->ServeRequest()
#11 {main}
PHP Warning: Header may not contain more than a single header, new
line detected. in
/var/www/groupware/phpgwapi/inc/common_functions.inc.php on line 1446
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
VALARM field:DESCRIPTION: HAS NO CONVERSION YET
VALARM field:ACTION: HAS NO CONVERSION YET

What could cause this and how could we probably become Outlook-aware in
this direction, too?

Regards,
Hans-Jürgen

BadBadOtherOs

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Hans-Jurgen_Tappe]

Hi!

… do we have several, unrelated problems here:

A)
When accessing the caldav calendar with lightning, I see the following
messages (which seems minor to me. Are they?):
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
VALARM field:ACTION: HAS NO CONVERSION YET, referer:
http:// … calendar.calendar_uiforms.import
VALARM field:DESCRIPTION: HAS NO CONVERSION YET, referer:
http:// … calendar.calendar_uiforms.import

B)
When importing an invitation which was created in Outlook, it contains
the following ATTENDEE line, which leads to “iCal successful imported”,
which is not the case; it doesn’t show up in the calendar.
What’s blocking the import without further notice when the following
line is read? can we make eGroupware handle / ignore this?
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:hjtappe@localhost

C)
When re-importing an iCal file (received via eGroupware mail) to
eGroupware, using Lightning via caldav.php, the following backtrace
shows up in the error log:

Database error: db::column_data_implode(’ AND ‘,Array
(
[uid] => null
[0] => (cal_user_type=‘u’ AND cal_user_id IN (‘5’,’-1’,’-2’))
[1] => recur_type IS NULL AND cal_recur_date=0
)
,‘1’,

Array

(

[cal_id] => Array

(

[type] => auto

[nullable] =>

)
[cal_uid] => Array
    (
        [type] => varchar
        [precision] => 255
        [nullable] =>
    )

[cal_owner] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] =>
    )

[cal_category] => Array
    (
        [type] => varchar
        [precision] => 30
    )

[cal_modified] => Array
    (
        [type] => int
        [precision] => 8
    )

[cal_priority] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] =>
        [default] => 2
    )

[cal_public] => Array
    (
        [type] => int
        [precision] => 2
        [nullable] =>
        [default] => 1
    )

[cal_title] => Array
    (
        [type] => varchar
        [precision] => 255
        [nullable] =>
        [default] => 1
    )

[cal_description] => Array
    (
        [type] => text
    )

[cal_location] => Array
    (
        [type] => varchar
        [precision] => 255
    )

[cal_reference] => Array
    (
        [type] => int
        [precision] => 4
        [nullable] =>
        [default] => 0
    )

[cal_modifier] => Array
    (
        [type] => int
        [precision] => 4
    )

[cal_non_blocking] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
    )

[cal_special] => Array
    (
        [type] => int
        [precision] => 2
        [default] => 0
    )

[cal_etag] => Array
    (
        [type] => int
        [precision] => 4
        [default] => 0
    )

)

nothing known about column ‘uid’!
D)

I’d assume thet the “METHOD:request” should be capitalized in the iCal

files (“METHOD:REQUEST”), right?
Thanks a lot,

Hans-Jürgen
P.S.: Would be very nice if you could please take a look at these (some

decisionmakers really focus on the interoperability with the other

tools)… 

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge

Build the coolest Linux based applications with Moblin SDK & win great prizes

Grand prize is a trip for two to an Open Source event anywhere in the world

http://moblin-contest.org/redirect.php?banner_id=100&url=/

eGroupWare-developers mailing list

eGroupWare-developers@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_6]

Hi Hans-Jürgen,

just commited two fixes:

1. for the SQL error, thought I dont think that query leads anywhere

2. when you import an iCal with ATTENDEE’s, which not include the
   current users email address (the one known by eGroupware), the event is
   owned by the current user, but because he’s no participant, it is not
   shown to him. I’m now checking for importing new events via iCal (or
   GroupDAV) that the current user get’s a participant.

Ralf

Hans-Juergen Tappe schrieb:

Hi!

I got the following invitation:

BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:hjtappe@localhost
ORGANIZER:MAILTO:webmaster@localhost
DTSTART:20081125T160000Z
DTEND:20081125T161500Z
TRANSP:OPAQUE
SEQUENCE:0
UID:040000008200E00074C5B7101A82E00800000000B0633F9AFD44C9010000000000000000100
0000009826B9AC6E7284B9AD57A9DD6943FCC
DTSTAMP:20081112T183356Z
DESCRIPTION:Zeit: Dienstag, 25. November 2008 17:00-17:15 (GMT+01:00)
Amsterdam, Berlin, Bern, Rom, Stockholm,
Wien.\n\n*~~~~~~~~~*\n\n\n
SUMMARY:Follow-Up discussion
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

During import by the web frontend, it says “Successfully imported” but
the data does not show up. The same for Lightning; while this even
produces a database error.

These are the messages from the error log.
==> Web-UI:
VALARM field:ACTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import
VALARM field:DESCRIPTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import

==> Lightning via caldav.php:
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
Database error: db::column_data_implode(’ AND ‘,Array\n(\n [uid] =>
null\n [0] => (cal_user_type=‘u’ AND cal_user_id IN
(‘5’,’-1’,’-2’))\n [1] => recur_type IS NULL AND
cal_recur_date=0\n)\n,‘1’,

Array\n(\n    [cal_id] => Array\n

(\n            [type] => auto\n            [nullable] => \n

)\n\n    [cal_uid] => Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n        )\n\n

[cal_owner] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n        )\n\n

[cal_category] => Array\n        (\n            [type] => varchar\n

[precision] => 30\n        )\n\n    [cal_modified] => Array\n

(\n            [type] => int\n            [precision] => 8\n

)\n\n    [cal_priority] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [nullable] => \n

[default] => 2\n        )\n\n    [cal_public] => Array\n        (\n

[type] => int\n            [precision] => 2\n

[nullable] => \n            [default] => 1\n        )\n\n    [cal_title]

=> Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n      [Thu Nov 13

09:36:48 2008] [error] [client 127.0.0.1]       [default] => 1\n

)\n\n    [cal_description] => Array\n        (\n            [type] =>

text\n        )\n\n    [cal_location] => Array\n        (\n

[type] => varchar\n            [precision] => 255\n        )\n\n

[cal_reference] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n            [default]

=> 0\n        )\n\n    [cal_modifier] => Array\n        (\n

[type] => int\n            [precision] => 4\n        )\n\n

[cal_non_blocking] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_special] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_etag] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [default] => 0\n

)\n\n)\n

nothing known about column ‘uid’!
#0 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1447):
egw_db->halt(‘db::column_data…’)
#1 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1883):
egw_db->column_data_implode(’ AND ‘, Array, true, false, Array)
#2 [internal function]: egw_db->select(‘egw_cal’,
‘egw_cal_repeats…’, Array, false, false, false, NULL, ‘calendar’, 0,
‘JOIN egw_cal_da…’, NULL)
#3 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1939):
call_user_func_array(Array, Array)
#4 /var/www/groupware/calendar/inc/class.calendar_so.inc.php(340):
egw_db->union(Array, 340, ‘/var/www/groupw…’, ‘cal_start’, false, 0)
#5 /var/www/groupware/calendar/inc/class.calendar_bo.inc.php(376):
calendar_so->search(NULL, NULL, Array, 0, ‘all’, Array, false, 0, NULL,
true)
#6
/var/www/groupware/calendar/inc/class.calendar_groupdav.inc.php(95):
calendar_bo->search(Array)
#7 /var/www/groupware/phpgwapi/inc/class.groupdav.inc.php(215):
calendar_groupdav->propfind(’/calendar/null’, Array, Array, 5, ‘null’)
#8 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(555):
groupdav->PROPFIND(Array, Array)
#9 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(216):
HTTP_WebDAV_Server->http_PROPFIND()
#10 /var/www/groupware/groupdav.php(70):
HTTP_WebDAV_Server->ServeRequest()
#11 {main}
PHP Warning: Header may not contain more than a single header, new
line detected. in
/var/www/groupware/phpgwapi/inc/common_functions.inc.php on line 1446
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
VALARM field:DESCRIPTION: HAS NO CONVERSION YET
VALARM field:ACTION: HAS NO CONVERSION YET

What could cause this and how could we probably become Outlook-aware in
this direction, too?

Regards,
Hans-Jürgen

BadBadOtherOs

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
cell +49 (0) 170 7815917
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

---

Geschäftsführer Andre Keller, Nigel John Vickers,
Gudrun K. Müller und Ralf Becker
Registergericht Kaiserslautern HRB 12087

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_6]

About the ‘HAS NO CONVERSION YET’ message: If I read the code correct,
the iCal parser does not understand:

TRIGGER:-PT15M

It would understand someting like:

TRIGGER;VALUE=DURATION:-15

or

TRIGGER;VALUE=DATE-TIME:20081411T120000

The processing is done in calendar_ical::valarm2egw() at line 1054 in
calendar/inc/class.calendar_ical.inc.php

Ralf

Ralf Becker schrieb:

Hi Hans-Jürgen,

just commited two fixes:

1. for the SQL error, thought I dont think that query leads anywhere

2. when you import an iCal with ATTENDEE’s, which not include the
   current users email address (the one known by eGroupware), the event is
   owned by the current user, but because he’s no participant, it is not
   shown to him. I’m now checking for importing new events via iCal (or
   GroupDAV) that the current user get’s a participant.

Ralf

Hans-Juergen Tappe schrieb:

Hi!

I got the following invitation:

BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:hjtappe@localhost
ORGANIZER:MAILTO:webmaster@localhost
DTSTART:20081125T160000Z
DTEND:20081125T161500Z
TRANSP:OPAQUE
SEQUENCE:0
UID:040000008200E00074C5B7101A82E00800000000B0633F9AFD44C9010000000000000000100
0000009826B9AC6E7284B9AD57A9DD6943FCC
DTSTAMP:20081112T183356Z
DESCRIPTION:Zeit: Dienstag, 25. November 2008 17:00-17:15 (GMT+01:00)
Amsterdam, Berlin, Bern, Rom, Stockholm,
Wien.\n\n*~~~~~~~~~*\n\n\n
SUMMARY:Follow-Up discussion
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

During import by the web frontend, it says “Successfully imported” but
the data does not show up. The same for Lightning; while this even
produces a database error.

These are the messages from the error log.
==> Web-UI:
VALARM field:ACTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import
VALARM field:DESCRIPTION: HAS NO CONVERSION YET, referer:
http://localhost/groupware/index.php?menuaction=calendar.calendar_uiforms.import

==> Lightning via caldav.php:
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
Database error: db::column_data_implode(’ AND ‘,Array\n(\n [uid] =>
null\n [0] => (cal_user_type=‘u’ AND cal_user_id IN
(‘5’,’-1’,’-2’))\n [1] => recur_type IS NULL AND
cal_recur_date=0\n)\n,‘1’,

Array\n(\n    [cal_id] => Array\n

(\n            [type] => auto\n            [nullable] => \n

)\n\n    [cal_uid] => Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n        )\n\n

[cal_owner] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n        )\n\n

[cal_category] => Array\n        (\n            [type] => varchar\n

[precision] => 30\n        )\n\n    [cal_modified] => Array\n

(\n            [type] => int\n            [precision] => 8\n

)\n\n    [cal_priority] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [nullable] => \n

[default] => 2\n        )\n\n    [cal_public] => Array\n        (\n

[type] => int\n            [precision] => 2\n

[nullable] => \n            [default] => 1\n        )\n\n    [cal_title]

=> Array\n        (\n            [type] => varchar\n

[precision] => 255\n            [nullable] => \n      [Thu Nov 13

09:36:48 2008] [error] [client 127.0.0.1]       [default] => 1\n

)\n\n    [cal_description] => Array\n        (\n            [type] =>

text\n        )\n\n    [cal_location] => Array\n        (\n

[type] => varchar\n            [precision] => 255\n        )\n\n

[cal_reference] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [nullable] => \n            [default]

=> 0\n        )\n\n    [cal_modifier] => Array\n        (\n

[type] => int\n            [precision] => 4\n        )\n\n

[cal_non_blocking] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_special] => Array\n        (\n            [type] => int\n

[precision] => 2\n            [default] => 0\n        )\n\n

[cal_etag] => Array\n        (\n            [type] => int\n

[precision] => 4\n            [default] => 0\n

)\n\n)\n

nothing known about column ‘uid’!
#0 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1447):
egw_db->halt(‘db::column_data…’)
#1 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1883):
egw_db->column_data_implode(’ AND ‘, Array, true, false, Array)
#2 [internal function]: egw_db->select(‘egw_cal’,
‘egw_cal_repeats…’, Array, false, false, false, NULL, ‘calendar’, 0,
‘JOIN egw_cal_da…’, NULL)
#3 /var/www/groupware/phpgwapi/inc/class.egw_db.inc.php(1939):
call_user_func_array(Array, Array)
#4 /var/www/groupware/calendar/inc/class.calendar_so.inc.php(340):
egw_db->union(Array, 340, ‘/var/www/groupw…’, ‘cal_start’, false, 0)
#5 /var/www/groupware/calendar/inc/class.calendar_bo.inc.php(376):
calendar_so->search(NULL, NULL, Array, 0, ‘all’, Array, false, 0, NULL,
true)
#6
/var/www/groupware/calendar/inc/class.calendar_groupdav.inc.php(95):
calendar_bo->search(Array)
#7 /var/www/groupware/phpgwapi/inc/class.groupdav.inc.php(215):
calendar_groupdav->propfind(’/calendar/null’, Array, Array, 5, ‘null’)
#8 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(555):
groupdav->PROPFIND(Array, Array)
#9 /var/www/groupware/egw-pear/HTTP/WebDAV/Server.php(216):
HTTP_WebDAV_Server->http_PROPFIND()
#10 /var/www/groupware/groupdav.php(70):
HTTP_WebDAV_Server->ServeRequest()
#11 {main}
PHP Warning: Header may not contain more than a single header, new
line detected. in
/var/www/groupware/phpgwapi/inc/common_functions.inc.php on line 1446
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11; U;
Linux i686; en-US; rv:1.8.1.17) Gecko/20080925 Thunderbird/2.0.0.17’!
VALARM field:DESCRIPTION: HAS NO CONVERSION YET
VALARM field:ACTION: HAS NO CONVERSION YET

What could cause this and how could we probably become Outlook-aware in
this direction, too?

Regards,
Hans-Jürgen

BadBadOtherOs

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
cell +49 (0) 170 7815917
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

---

Geschäftsführer Andre Keller, Nigel John Vickers,
Gudrun K. Müller und Ralf Becker
Registergericht Kaiserslautern HRB 12087

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Hans-Jurgen_Tappe]

Hi Ralf!

Ralf Becker schrieb:

just commited two fixes:

1. for the SQL error, thought I dont think that query leads anywhere

Yes, the invitations were imported, but still this error… Now it’s
fixed. Thanks!

2. when you import an iCal with ATTENDEE’s, which not include the
   current users email address (the one known by eGroupware), the event is
   owned by the current user, but because he’s no participant, it is not
   shown to him. I’m now checking for importing new events via iCal (or
   GroupDAV) that the current user get’s a participant.

Good to have that problem broken down. Yes, now it works fine.

It’s usually the user who imports who is also is the participant. But -
from the lists we know that it’s often that some office adds invitations
for another user (teacher, boss, whoever). I think, this might be the
same “problem” as for adding dates over the Web-UI.

Should I add a feature request to have the calendar / user / group
selectable during import (select participants) - because it does not
automatically match the data in the iCal file?

About the
VALARM field:ACTION: HAS NO CONVERSION YET
VALARM field:DESCRIPTION: HAS NO CONVERSION YET
Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11;
U;Linux i686; en-US; rv:1.8.1.17) Gecko/20080925
Thunderbird/2.0.0.17’!
messages and the capitalizing of “METHOD:REQUEST”: They all don’t seem
critical to me.

Thanks and best regards,
Hans-Jürgen

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_6]

Hi Hans-Jürgen,

Hans-Juergen Tappe schrieb:

Hi Ralf!

Ralf Becker schrieb:

just commited two fixes:

1. for the SQL error, thought I dont think that query leads anywhere

Yes, the invitations were imported, but still this error… Now it’s
fixed. Thanks!

2. when you import an iCal with ATTENDEE’s, which not include the
   current users email address (the one known by eGroupware), the event is
   owned by the current user, but because he’s no participant, it is not
   shown to him. I’m now checking for importing new events via iCal (or
   GroupDAV) that the current user get’s a participant.

Good to have that problem broken down. Yes, now it works fine.

It’s usually the user who imports who is also is the participant. But -
from the lists we know that it’s often that some office adds invitations
for another user (teacher, boss, whoever). I think, this might be the
same “problem” as for adding dates over the Web-UI.

Should I add a feature request to have the calendar / user / group
selectable during import (select participants) - because it does not
automatically match the data in the iCal file?

You can do that.

About the
VALARM field:ACTION: HAS NO CONVERSION YET
VALARM field:DESCRIPTION: HAS NO CONVERSION YET

It only means the ALARMS are not understood and therefore not imported.

Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (X11;
U;Linux i686; en-US; rv:1.8.1.17) Gecko/20080925
Thunderbird/2.0.0.17’!

Did you used Lightning?

The message is only a diagnostic stating the HTTP_USER_AGENT header. It
means that the standard GroupDAV field mappings are used, which is
perfectly fine with Lightning.

Ralf

messages and the capitalizing of “METHOD:REQUEST”: They all don’t seem
critical to me.

Thanks and best regards,
Hans-Jürgen

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
cell +49 (0) 170 7815917
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

---

Geschäftsführer Andre Keller, Nigel John Vickers,
Gudrun K. Müller und Ralf Becker
Registergericht Kaiserslautern HRB 12087

---

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Pierre_PINTARIC]

I trying to configure the synchronization between Thunderbird and EGW using sogo-connector-0.91

But with the calendar and the addressbook, I have the following error in the server logs:
[Wed Feb 11 01:20:54 2009] [error] [client xxx.xxx.xxx.xxx] Unrecogniced GroupDAV client: HTTP_USER_AGENT=‘Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.3) Gecko/20070326 Thunderbird/2.0.0.0 Mnenhy/0.7.5.666’!

And nothing appear in the calendar (lightning-0.9-tb-win) or the addressbook.

Any idea?

thanks