Menu
▾
▴
Re: [funambol-users] All Day Appointments using Outlook Plug-in off by 4 Hours
|
From: Evan R. <eva...@he...> - 2008-04-16 19:44:01
|
Hey Guys, For the all day appointments, are the start and end times stored in GMT, or should they be corrected with the timezone in their EPOCH time entry in the DB? I synced these two appointments. The first piece is the start time in Outlook, the second is EPOCH time in the DB, and the third is the EPOCH time, converted back to my timezone: 1. All Day Event: 4/17/2008 All Day, 1208390400, Wednesday, April 16, 2008 8:00:00 PM 2. Timed Event 4/17/200/ 930am, 1208439000, Thursday, April 17, 2008 9:30:00 AM I guess my big question is why there is this difference in the EPOCH times, as they're handled by Funambol. Is this just the rule for all day events or is there some other issue that I'm not fully understanding? Thanks for all your help, Evan -----Original Message----- From: syn...@li... [mailto:syn...@li...] On Behalf Of Evan Ruff Sent: Thursday, April 10, 2008 4:14 PM To: syn...@li... Subject: Re: [funambol-users] All Day Appointments using Outlook Plug-in off by 4 Hours Hey Andrea, The appointments are showing up properly in the webdemo. I get the four hour offset when looking at the entries in the DB. For instance, April 12th is my birthday. I have two events. My Birthday (All Day) and My Birthday Party (4pm - 6pm) When I view the entries in the DB (MySQL using HeidiSQL): My Birthday Party (dstart and dend) is 2008-04-12 16:00:00 / 2008-04-12 17:00:00 My Birthday Party is 2008-04-11 20:00:00 / 2008-04-12 19:59:00 That four hour offset is making life tough on the web client I'm writing. It seems that maybe my query is wrong? Is the EPOCH time conversion not being done in the same fashion? When I pull out the dates as a unix_timestamp it still gives me the time with the -4 hr offset. (EST) Thanks for your help on this. It's really throwing me off. E -----Original Message----- From: syn...@li... [mailto:syn...@li...] On Behalf Of Andrea Toccalini Sent: Thursday, April 10, 2008 12:03 PM To: syn...@li... Subject: Re: [funambol-users] All Day Appointments using Outlook Plug-in off by 4 Hours Hi Evan, I took a look to your log and everything seems fine to me. The all-day events are transferred correctly to the Server, so for example if you should see them as all-day in the Server webdemo. Where do you see those events shifted by 4 hours exactly? Can you confirm that, if you modify one of those appointment on the Server and sync back to Outlook, they are still all-day events? Bye, Toccy > Hey guys, > > I figured I'd toss my own thread out here about a curious syncing behavior I'm having. When I sync via the Outlook Funambol plugin, my All Day Appointments time seems to be off by 4 hours. I'm at EST, so I figure that it might have something to do with that. > > All regular appointments are fine, but All Day ones are off. I upped the logging to debug, but I don't exactly understand what's going on with the data provided. The log is available here: > > http://teledini.com/evanslog.txt > > Thanks for all your help, > > Evan > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Sync4j-users mailing list > Syn...@li... > https://lists.sourceforge.net/lists/listinfo/sync4j-users > > -- Andrea Toccalini funambol :: mobile open source :: http://www.funambol.com ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Sync4j-users mailing list Syn...@li... https://lists.sourceforge.net/lists/listinfo/sync4j-users ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Sync4j-users mailing list Syn...@li... https://lists.sourceforge.net/lists/listinfo/sync4j-users |
