I'm not sure if this is the right forum to use, since the description only mentions F-Script (what's that?) and AppleScript, but here goes anyways:

Are there any hooks for scripting Daylite using Perl, or is the only solution the generic OpenBase one of connecting via DBD:JDBC through a JDBC proxy? Has anyone successfully tried the latter? And is there any documentation of the schemas that Daylite uses?

TIA,

Sweth.

You can get direct access to the raw database using a 'Direct Access' license with an upgraded OpenBase license. At the point, you can pretty much do anything.

There is a problem:
1) We do some optimization when we write to the database and you would have to take that into account. Some of the things are pretty hairy - (i.e permissions access).

What do you plan to do or want to do?

quote:

Originally posted by AJ:
You can get direct access to the raw database using a 'Direct Access' license with an upgraded OpenBase license. At the point, you can pretty much do anything.

How much do those licenses cost? Searching for "Direct Access" on the Daylite site, I see a page that basically says "ask us for more info about pricing".

quote:

There is a problem:
1) We do some optimization when we write to the database and you would have to take that into account. Some of the things are pretty hairy - (i.e permissions access).

What do you plan to do or want to do?

I don't have any specific plans, but I spent 10 years as a DBA and perl programmer prior to getting into my current field (real estate), so I'm always frustrated by apps where I know that I could accomplish my goal in 10 minutes with a quick SQL query or perl script, so the appeal of having raw access is very large for me. (Quick example: I'd love to be able to write an app that could pull my call history from my cell phone, correlate each call w/ a contact in Daylite or create a contact if one didn't exist, and then create a note for each call.) I could in theory probably do most of what I want in Applescript, but I've never been able to get my head contorted enough to map what I want to do in Perl and/or SQL into the bizarre chicken-shaking voodoo rituals that that language seems to require to do even the most basic tasks.

-- Sweth.

The old cost was about $3995 all in. We've worked out a new deal with OpenBase but we haven't implemented our end of things so it's in limbo until we get to it (well the old deal works still).

We are hoping to do our end by the time Macworld rolls around.

In the meantime, you can use F-Script to execute direct SQL and work with NSDictionary, NSArray, NSNumber, NSString and NSData.

Download the Daylite Developer Kit to learn more.

Learn more about F-Script at www.fscript.org (F-Script was a recent recipient of an Apple Design Award).