View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001524Funambol SOGo Connectorpublic2011-12-03 18:042012-08-27 20:27
ReporterJopa Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version1.0.8 
Summary0001524: SOGo / Funambol / Blackberry Allday events synchronization
Description

SOGo / Funambol / Blackberry Allday events synchronization

A positioning problem appear when I want to synchronize Allday event between SOGo and a Blackberry Phone, using Funambol.

I noticed this problem on older version of SOGo, current stable version 1.3.9 and on the ZEG 2.0 beta3

All timezones (SOGo, Sogo user profile, funambol device and Blackberry) are set to Europe/Paris (GMT+1).

First, when I entered a new Allday event using the SOGo web interface ( December, 5th for exemple), the event is displayed on two days on the phone : The day and the day after (December 5th and 6 for my exemple).

The event looks like this on the Funambol logs :

BEGIN:VCALENDAR

VERSION:2.0

PRODID:-//Inverse inc./SOGo 2.0.0//EN

BEGIN:VEVENT

UID:3A2-4EDA5900-1-27140C00

SUMMARY:Nouvel Evènement journée complète

CREATED:20111203T171536Z

DTSTAMP:20111203T171536Z

LAST-MODIFIED:20111203T171536Z

DTSTART:20111205

DTEND:20111206

TRANSP:0

END:VEVENT

END:VCALENDAR

I have temporarily bypassed the problem by changing the Funambol message postprocessing for Blackberry (Funambol/config/com/funambol/server/engine/pipeline/phones-support/bsh/BlackberryPIMout.bsh) to substract one day to the DTEND value for AllDay events.

Second, in the other direction, when I entered a new Allday event using the Phone (December, 5th for exemple), the event is not displayed in the SOGo calendar view (web), but appear in the event list in the top of the screen, with a start date and a end date displayed the Day before (December, 4).

(See Screencapture : 2-Blackberry2SOGo.png)

In the SOGo database, the event look to be good (table sogosogo10011c3228f2 on ZEG).

And when I edit the event on the Sogo web interface, all fields are good (See screen capture : 3-Blackberry2SOGo.png).

The simple way to open the event and save it again using SOGo (Save and Close button) make it correct.

The only difference I've seen before and after the edition is in the “quick” table, where we see a difference of 3600 on the c_startdate value and 89999 on the c_enddate

sogosogo10011c3228f2_quick

Before :
c_startdate : 1323039600
c_enddate : 1323039600

After :
c_startdate : 1323043200
c_enddate : 1323043200

Thank you for your help ...

I am at your disposal to make all the tests you need.

TagsNo tags attached.

Activities

2011-12-03 18:05

 

1-SOGo2Blackberry.jpg (26,938 bytes)   
1-SOGo2Blackberry.jpg (26,938 bytes)   

2011-12-03 18:05

 

2-Blackberry2SOGo.png (102,076 bytes)   
2-Blackberry2SOGo.png (102,076 bytes)   

2011-12-03 18:05

 

3-Blackberry2SOGo.png (47,174 bytes)   
3-Blackberry2SOGo.png (47,174 bytes)   
Jopa

Jopa

2011-12-04 15:59

reporter   ~0003102

The issue is similar with a Nokia (N658MP).

AllDay event synchronized from SOGo to Nokia (via Funambol) is showed on 2 days on the phone :

  • Between 01:00 am and 11:59 pm the first day,
  • Between 00:00 am and 01:00 am the second.

regards
bm

bm

2011-12-04 16:16

reporter   ~0003103

"The issue is similar with a Nokia (N658MP)."

The issue is similar with Nokia N86 8MP
Christian Mack

Christian Mack

2011-12-05 09:36

developer   ~0003106

What timezones are set on these phones?
The same as in SOGo for these accounts?
Jopa

Jopa

2011-12-05 10:30

reporter   ~0003107

I confirm that the Blackberry Timezone is the same as in SOGO account. SOGo main timezone and Funambol device timezone is set to the same too.

The timezone is : Europe/Paris (GMT+1).
Jopa

Jopa

2011-12-05 10:36

reporter   ~0003108

I would add that classic events (not Alldays) are properly synchronized. Start et End times are good.
bm

bm

2011-12-05 10:49

reporter   ~0003109

The Nokia N86 8MP timezone is Europe/Paris (GMT+1)
The SOGo server is Europe/Paris (GMT+1)
Jopa

Jopa

2011-12-06 20:27

reporter   ~0003125

When I synchronize in the direction : Blackberry -> SOGo

c_startdate = c_enddate value in the "personal calendar"_quick table of the sogo database and the event is not visible in the web calendar.

If i update the c_enddate values to have c_startdate < c_enddate, the event become visible.

I should add at least 3600 (1 hour) to the start date for making event correctly positioned.

2012-08-27 20:26

 

funambol-sogo-1.0.9.s4j (74,675 bytes)
ludovic

ludovic

2012-08-27 20:27

administrator   ~0004384

This should be fixed in the attached s4j.

We'll move our code to github in the next couple of days, because Funambol's forge is down again. They suck.

Issue History

Date Modified Username Field Change
2011-12-03 18:04 Jopa New Issue
2011-12-03 18:05 Jopa File Added: 1-SOGo2Blackberry.jpg
2011-12-03 18:05 Jopa File Added: 2-Blackberry2SOGo.png
2011-12-03 18:05 Jopa File Added: 3-Blackberry2SOGo.png
2011-12-04 15:59 Jopa Note Added: 0003102
2011-12-04 16:16 bm Note Added: 0003103
2011-12-05 09:36 Christian Mack Note Added: 0003106
2011-12-05 10:30 Jopa Note Added: 0003107
2011-12-05 10:36 Jopa Note Added: 0003108
2011-12-05 10:49 bm Note Added: 0003109
2011-12-06 20:27 Jopa Note Added: 0003125
2012-08-27 20:26 ludovic File Added: funambol-sogo-1.0.9.s4j
2012-08-27 20:27 ludovic Note Added: 0004384
2012-08-27 20:27 ludovic Status new => closed
2012-08-27 20:27 ludovic Resolution open => fixed