Re: [coldsync-hackers] Design logic of Sync conduits

[Marco van Beek <marco at 84andahalf dot com>]

Hi,

For various work related reasons (33% of the company off with chronic illness, then the office got flooded...) I have 
lagged behind on a revised version using SPC, but the older code is available at http://ssis.sourceforge.net/

I am hoping to start using Sourceforges' CVS server soon to try and move ahead a bit. I have part written a new sync 
conduit which links directly to the MySQL server, and simply lacks the actual data conversion code. The new version uses 
a "glue" table that tracks both the MySQL record ID and the Palm ID, which means we can restrict the number of records 
that get synced (in case we end up with more than 6000 address in the MySQL databases, etc).

The server the test version is on got packaged away when the office got flooded, but we are moving in to our new office 
next weekend, so hopefully by the middle of the following week, i should be able to get that code up and running as well.

I would really welcome any help. The project is GPL, and the idea is to link a single database into many other sources.

Regards,

Marco.

Ed Davison wrote:

> I am VERY interested in your SQL code and the sync code.  I want to be
> able to get my palm info into MySQL as well and you are working on
> something like this.
>
> Any chance I can get the code?
>
>
>
> Ed
>
>
> On Sun, 2004-02-22 at 17:19, Marco van Beek wrote:
>
> > >   "Secondly, there is a remote chance that two Handhelds
> > >   would create a new record with the same {id}, so the Server
> > >   MUST control the issuing of {id} numbers."
> >
> > Hi Christophe,
> >
> > I have managed to change the {id} number of a palm record. What I do at 
> > the moment is if a record is created by  the palm, it is added to the 
> > MySQL database where it picks up a new ID number. When the sync next 
> > runs, the record is added to the Palm as a new record, and the old one 
> > is deleted (assuming it hasn't been changed).
> >
> > When I create the record, I am able to specify the {id}, which means 
> > that the records stay in sync across many (so far four) PDA's.
> >
> > Regards,
> >
> > Marco.
> > This message was sent through the coldsync-hackers mailing list.  To remove
> > yourself from this mailing list, send a message to majordomo@thedotin.net
> > with the words "unsubscribe coldsync-hackers" in the message body.  For more
> > information on Coldsync, send mail to coldsync-hackers-owner@thedotin.net.
>
>
> This message was sent through the coldsync-hackers mailing list.  To remove
> yourself from this mailing list, send a message to majordomo@thedotin.net
> with the words "unsubscribe coldsync-hackers" in the message body.  For more
> information on Coldsync, send mail to coldsync-hackers-owner@thedotin.net.

This message was sent through the coldsync-hackers mailing list.  To remove
yourself from this mailing list, send a message to majordomo@thedotin.net
with the words "unsubscribe coldsync-hackers" in the message body.  For more
information on Coldsync, send mail to coldsync-hackers-owner@thedotin.net.