Synthesis AG - SyncML Discussion Forum  

Go Back   Synthesis AG - SyncML Discussion Forum > Synthesis SyncML Products (english) > SyncML Clients for classic PDAs (WindowsMobile, PalmOS)

Reply
 
Thread Tools Display Modes
  #1  
Old 2007-02-06, 19:53
ajpurkiss ajpurkiss is offline
Junior Member
 
Join Date: 2007-01
Posts: 17
Default DTStart problem with Treo 650

I am having a bizarre problem with our mapping of dates.


Due to me not being able to get date and timeafterdate working and the fact that one of our date fields is split up over about 3 or 4 fields I had to rework my sql to the following:

<map name="DATE_ADD(DATE_ADD(date_start, INTERVAL MINUTE(time_start) minute), INTERVAL HOUR(time_start) hour)" references="DTSTART" type="timestamp" mode="r"/>
<map name="DATE_ADD(DATE_ADD(DATE_ADD(DATE_ADD(date_sta rt, INTERVAL MINUTE(time_start) minute), INTERVAL HOUR(time_start) hour), INTERVAL duration_hours hour), INTERVAL duration_minutes minute)" references="DTEND" type="timestamp" mode="r"/>

However where as the Outlook client we use gets the right stuff the Treo 650 is given dates 47 days in the future and I notice that the timestamps are missing the Z at the end (So I suspect the server is manipulating the dates from the database somehow) - DOes anyone know what is going on and if there is something I need to set to in the server config to stop this date change going on ?

Logs to show what the outlook and treo get:


Log for Outlook
Generating....
Item LocalID='m845b18fd-29ab-8432-7cf7-45883bc1a984', RemoteID='', operation=wants-add, size: [maxlocal,maxremote,actual]
- 0 : timestamp DMODIFIED [ 0, 0, 16] : 20061219T192149Z
- 1 : timestamp DCREATED [ 0, 0, 16] : 20061219T192112Z
- 2 : multiline SUMMARY [ 254, 0, 16] : Kick off meeting
- 3 : multiline DESCRIPTION [ 0, 0, 7] : <empty>
- 4 : multiline LOCATION [ 63, 0, 7] : <empty>
- 5 : timestamp DTSTART [ 0, 0, 16] : 20070103T153000Z
- 6 : timestamp DTEND [ 0, 0, 16] : 20070103T163000Z
Generated:
BEGIN:VCALENDAR
VERSION:1.0
BEGIN:VEVENT
LAST-MODIFIED:20061219T192149Z
DCREATED:20061219T192112Z
SUMMARY:Kick off meeting
DESCRIPTION:
DTSTART:20070103T153000Z
DTEND:20070103T163000Z
END:VEVENT
END:VCALENDAR

Log for Treo

Generating....
Item LocalID='m845b18fd-29ab-8432-7cf7-45883bc1a984', RemoteID='', operation=wants-add, size: [maxlocal,maxremote,actual]
- 0 : timestamp DMODIFIED [ 0, n/a, 16] : 20061219T192149Z
- 1 : timestamp DCREATED [ 0, n/a, 16] : 20061219T192112Z
- 2 : multiline SUMMARY [ 254, 255, 16] : Kick off meeting
- 3 : multiline DESCRIPTION [ 0,4096, 7] : <empty>
- 4 : multiline LOCATION [ 63, 255, 7] : <empty>
- 5 : timestamp DTSTART [ 0, 0, 16] : 20070103T153000Z
- 6 : timestamp DTEND [ 0, 0, 16] : 20070103T163000Z
Generated:
BEGIN:VCALENDAR
VERSION:1.0
BEGIN:VEVENT
SUMMARY:Kick off meeting
DESCRIPTION:
DTSTART:20070218T034700
DTEND:20070218T044700
END:VEVENT
Reply With Quote
  #2  
Old 2007-02-06, 22:32
ajpurkiss ajpurkiss is offline
Junior Member
 
Join Date: 2007-01
Posts: 17
Default Re: DTStart problem with Treo 650

I just noticed that the default distributed config has a flaw in it and it deletes 47 days (or whatever the exact amount is) from all time stamps and then adds it back on when it generates the Treo 650 message (but not for out Outlook client)

Most strange - surprised this has not been spotted before - 47 days is a lot of time to be out.
Reply With Quote
  #3  
Old 2007-02-07, 00:19
ajpurkiss ajpurkiss is offline
Junior Member
 
Join Date: 2007-01
Posts: 17
Default Re: DTStart problem with Treo 650

More information from the war front.

The exact difference is 45d 17h 17m every time without fail

???

Oh and the last sync time is out as well so I always get updates......

I guess this is a server problem now - so appologies that this is in the wrong forum
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 08:10.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.