sync with SQL database?

I would like to synchronize Address Book and a SQL database bidirectionally; the database is accessible 24/7 through Java servlets. Is there an API for Address Book? I've searched these Discussions and the Apple Dev Center and found nothing, which seems pretty amazing. Can anyone point me in the right direction?

MacBook Pro, Mac OS X (10.5.3)

Posted on Jun 20, 2008 4:34 AM

Reply
4 replies

Jul 13, 2008 10:46 AM in response to Michael Lafferty

I really appreciate your pointing me to the Address Book programming information at Apple Dev Connection. However, this is not yet what I'm looking for.

What I need to be able to do as a normal user, i.e. without recourse to Objective C or otherwise programming the Address Book:

- Add a field with a name of my choosing (e.g. "myfield") to the fields available in Address Book. (This would be the equivalent, in Objective C, of adding a property of my own to people in the Address Book.)

- Specify for Address Book that myfield has no non-null duplicates -- in other words, that it is a unique identifier when not null.

- I could then import hundreds of contacts from a sql database, in each case setting myfield equal to a unique identified maintained in the sql database.

- Address Book would henceforth, i.e. in future imports, use myfield, when non-null, to match imported contacts with existing contacts.

- The time-stamp of the most recent change should determine, for a particular contact, which information prevails, that already in the Address Book or that in the import file.

- From here, it would be easy to write scripts to handle the bidirectional importing/exporting between the Address Book and the sql database.

Can this be done?

Jul 22, 2008 5:16 AM in response to herbharrell

You could use Address Book Server ( http://www.addressbookserver.com) which I developed. It allows you to sync your Address Book with a central Address Book Server, which in turn can be configured to use most modern relational databases. It used H2 by default, but several users are using MySQL.

Disclaimer : This software is developed and marketed by myself.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

sync with SQL database?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.