RE: [Phpgroupware-developers] Palm synchro

[Mark A Peters (Skeeter)]

On Mon, 15 Apr 2002, Guillaume Courtois wrote:

> >I think I understand your syncing concept (it's a little different than
> >mine) - you want a modification time for each phpgw record so that you can
> >check the Palm's last sync time against the record's last modification time
> >and add/update any records that have changed
> 
> That's the way SyncML works too, so if we want one day to have SyncML in 
> phpGW, someone will have to add that last mod field ...

To let you know, remembering from the .14 development, the calendar does
have a last modification time (phpgw_cal.mdatetime) that is stored as a
time epoch value of GMT.  Also, the calendar does have a unique id field
(phpgw_cal.uid) that is carried over when importing [IV]cal entries, or
created internally when adding a new event through the phpGW interface.

All time values in phpGW calendar entries are stored in GMT.  So, if you
are looking at reading directly from the datastore to find the users
local time, you will need to apply the users timezone setting (3600 *
[timezone setting]) to each value.

Or, if you were looking for something easier, I have the [IV]cal generator
as a php function in the calendar app
(calendar/inc/class.boicalendar.inc.php). To use it, just pass a record_id, 
or an array of record_id's, to the function and it can generate
you a single [IV]cal file for those record_id(s) identified.  I believe
that function is available via XML-RPC/SOAP.

If you have any other questions, let me know.

Hope that helps,
Mark A Peters (Skeeter)