Re: Syncing addresses with an external file.

[Carl Makin <carl@xxxxxxxxxxxxxxxxxxxxxxx>]

On Thu, 16 Dec 1999, Alan Harder wrote:

> > In the windows hotsync manager there is the facility to take an external
> > file and import it into a new category in your address book. I use this to

> Adding records to the CSV file is as easy as appending new lines to the
> file.. the only slightly tricky bit is making sure you give each new
> record a unique id number.

I think it was the unique id number that was causing me problems.  What I
was doing was deleting all old entries in that category, then appending
new ones.  I'd renumber the id's including the other categories so each
was unique.  What I *wasn't* doing was mainting the id's in relation to
the entries that were already there.  I suspect that was where I was
getting the dupes.

> To do what you have subscribed I suspect you'd need to first remove all
> existing records from the given category and then add in the new records.
> If you don't remove the old records first that would be why you see
> duplicates.

That is what I'm doing now.  I run pilot-addresses to delete all records
in that category, then I run it again to insert all the new records.  I
can attach the scripts I'm using if anyone is interested.

I was wondering if someone had modified SyncAB to do that. (In the new
year I may have time to have a stab at it.)



Carl.