Hello,
I have SOGo 1.3.17, Funambol 10.0.3, Funambol Windows Sync Client 10.1.6
and MS Outlook 2007. Synchronization works well. If I create an event in
SOGo it gets synchronized to Outlook and vice versa. The problem is in
the synchronized content when the event contains some Czech characters.
All events (containing Czech characters) created in SOGo using its web
interface are synchronized correctly to MS Outlook, these events remain
correctly stored in the database. If I create such event containing some
Czech characters in Outlook then it gets synchronized improperly - some
Czech characters replaced by ”?”.
Sample event created and synchronized from Outlook to SOGo - SUMMARY and
DESCRIPTION have this suffix - ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8.
Funambol log - ds-server.log:
[2012-08-09 14:37:15,462] [funambol.engine.strategy] [INFO]
[64BF1FD082CEABDFC3E911A7318D862C] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] Synchronizing...
[2012-08-09 14:37:15,463] [funambol.sogo] [INFO]
[64BF1FD082CEABDFC3E911A7318D862C] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal]
addSyncItem(00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E40620
[2012-08-09 14:37:15,463] [funambol.sogo] [INFO]
[64BF1FD082CEABDFC3E911A7318D862C] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] addSyncItem -
type: text/x-vcalendar
[2012-08-09 14:37:15,463] [funambol.sogo] [INFO]
[64BF1FD082CEABDFC3E911A7318D862C] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal]
getSyncItemFromId( { keyValue: 00000000F2F2EB8CB69BAC46AEA
[2012-08-09 14:37:15,470] [funambol.sogo] [INFO]
[64BF1FD082CEABDFC3E911A7318D862C] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] addSyncItem -
content: BEGIN:VCALENDAR
VERSION:1.0
BEGIN:VEVENT
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-FUNAMBOL-ALLDAY:0
DTSTART:20120808T093000Z
DTEND:20120808T100000Z
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
CATEGORIES:
DESCRIPTION;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:Event contents
LOCATION:
PRIORITY:2
STATUS:0
X-MICROSOFT-CDO-REPLYTIME:
SUMMARY;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:Test from Outlook
=C4=9B=C5=A1=C4=8D=C5=99=C5=BE=C3=BD=C3=A1=C3=AD=C3=A9
CLASS:PUBLIC
AALARM:
RRULE:
X-FUNAMBOL-BILLINGINFO:
X-FUNAMBOL-COMPANIES:
X-FUNAMBOL-MILEAGE:
X-FUNAMBOL-NOAGING:0
END:VEVENT
END:VCALENDAR
...
The event dumped from the sogo database, note the “?”:
INSERT INTO `sogoknovak001701503f3_quick` (`c_name`, `c_uid`,
`c_startdate`, `c_enddate`, `c_cycleenddate`, `c_title`,
`c_participants`, `c_isallday`, `c_iscycle`, `c_cycleinfo`,
`c_classification`, `c_isopaque`, `c_status`, `c_priority`,
`c_location`, `c_orgmail`, `c_partmails`, `c_partstates`, `c_category`,
`c_sequence`, `c_component`, `c_nextalarm`) VALUES
('00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000',
'00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000', 1344418200,
1344420000, NULL, 'Test from Outlook ?š??žýáíé', NULL, 0, 0, NULL, 0, 0,
0, 0, '', NULL, '', '', NULL, NULL, 'vevent', NULL);
INSERT INTO `sogoknovak001701503f3` (`c_name`, `c_content`,
`c_creationdate`, `c_lastmodified`, `c_version`, `c_deleted`) VALUES
('00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000',
'BEGIN:VCALENDAR\r\nVERSION:2.0\r\nBEGIN:VTIMEZONE\r\nTZID:Europe/Prague\r\nBEGIN:DAYLIGHT\r\nDTSTART:20110327T020000\r\nRRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3\r\nTZOFFSETFROM:+0100\r\nTZOFFSETTO:+0200\r\nTZNAME:Europe/Prague\r\nEND:DAYLIGHT\r\nBEGIN:STANDARD\r\nDTSTART:20111030T030000\r\nRRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10\r\nTZOFFSETFROM:+0200\r\nTZOFFSETTO:+0100\r\nTZNAME:Europe/Prague\r\nEND:STANDARD\r\nEND:VTIMEZONE\r\nBEGIN:VEVENT\r\nUID:00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000\r\nSUMMARY:Test
from Outlook ?š??žýáíé\r\nDESCRIPTION:Event
contents\r\nLOCATION:\r\nCATEGORIES:\r\nCLASS:PUBLIC\r\nDTSTART;TZID=Europe/Prague:20120808T113000\r\nDTEND;TZID=Europe/Prague:20120808T120000\r\nPRIORITY:5\r\nSTATUS:0\r\nX-FUNAMBOL-FOLDER:DEFAULT_FOLDER\r\nX-FUNAMBOL-ALLDAY:0\r\nX-FUNAMBOL-FOLDER:DEFAULT_FOLDER\r\nX-MICROSOFT-CDO-BUSYSTATUS:2\r\nX-MICROSOFT-CDO-REPLYTIME:\r\nX-FUNAMBOL-BILLINGINFO:\r\nX-FUNAMBOL-COMPANIES:\r\nX-FUNAMBOL-MILEAGE:\r\nX-FUNAMBOL-NOAGING:0\r\nEND:VEVENT\r\nEND:VCALENDAR\r\n',
1344515833, 1344515833, 0, NULL);
After next synchronization the event gets back to Outlook with the
modified contents – some Czech national characters are replaced by “?”,
the excerpt from ds-server.log:
2012-08-09 15:00:09,372] [funambol.sogo] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal]
getSyncItemFromId( { keyValue: 00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E40
[2012-08-09 15:00:09,375] [funambol.sogo] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] Preferred item
type: 3
[2012-08-09 15:00:09,375] [funambol.sogo] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] must secure? false
[2012-08-09 15:00:09,375] [funambol.sogo] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] About to convert
vCalendar (from v2 to v1): BEGIN:VCALENDAR
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Prague
BEGIN:DAYLIGHT
DTSTART:20110327T020000
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:Europe/Prague
END:DAYLIGHT
BEGIN:STANDARD
DTSTART:20111030T030000
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:Europe/Prague
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000
SUMMARY:Test from Outlook ?š??žýáíé
DESCRIPTION:Event contents
LOCATION:
CATEGORIES:
CLASS:PUBLIC
DTSTART;TZID=Europe/Prague:20120808T113000
DTEND;TZID=Europe/Prague:20120808T120000
PRIORITY:5
STATUS:0
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-FUNAMBOL-ALLDAY:0
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-MICROSOFT-CDO-BUSYSTATUS:2
X-MICROSOFT-CDO-REPLYTIME:
X-FUNAMBOL-BILLINGINFO:
X-FUNAMBOL-COMPANIES:
X-FUNAMBOL-MILEAGE:
X-FUNAMBOL-NOAGING:0
END:VEVENT
END:VCALENDAR
...
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [sogo-cal] BEGIN:VCALENDAR
VERSION:1.0
TZ:+0100
DAYLIGHT:TRUE;+0200;20110327T020000;20111030T030000;Europe/Prague;Europe/Prague
DAYLIGHT:TRUE;+0200;20120325T020000;20121028T030000;Europe/Prague;Europe/Prague
DAYLIGHT:TRUE;+0200;20130331T020000;20131027T030000;Europe/Prague;Europe/Prague
DAYLIGHT:TRUE;+0200;20140330T020000;20141026T030000;Europe/Prague;Europe/Prague
BEGIN:VEVENT
UID:00000000F2F2EB8CB69BAC46AEAC67C530AC59C2E4062000
SUMMARY;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:Test from Outlook
?=C5=A1??=C5=BE=C3=BD=C3=A1=C3=AD=C3=A9
DESCRIPTION:Event contents
LOCATION:
CATEGORIES:
CLASS:PUBLIC
DTSTART:20120808T093000Z
DTEND:20120808T100000Z
PRIORITY:2
STATUS:0
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-FUNAMBOL-ALLDAY:0
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-FUNAMBOL-FOLDER:DEFAULT_FOLDER
X-MICROSOFT-CDO-BUSYSTATUS:2
X-MICROSOFT-CDO-REPLYTIME:
X-FUNAMBOL-BILLINGINFO:
X-FUNAMBOL-COMPANIES:
X-FUNAMBOL-MILEAGE:
X-FUNAMBOL-NOAGING:0
END:VEVENT
END:VCALENDAR
[2012-08-09 15:00:09,403] [funambol.handler] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [] moving to state:
STATE_PKG1_RECEIVING
[2012-08-09 15:00:09,405] [funambol.transport.http] [INFO]
[2BD7E5531E5744050195066EE3980614] [192.168.253.5]
[fol-Tlg3NDAwOm5vcHJpdmlsZWdlcw==] [knovak] [] Request processed
Does anybody know where the mistake happens or what to change to avoid
the mistake?
Thank you,
Michal Kminek
--
users@sogo.nu
https://inverse.ca/sogo/lists