Greetings,

I am developing a Rails application for a client, and would like to be able to plug into their Daylite database to access their contacts and notes information. Using my OpenBase Solo license, I am not able to access the Daylite database directly it seems. Does anyone have any experience doing something like this, or have any ideas about how to go about getting to this data outside of Daylite?

Thank you.

-
Justin Williams
Owner, Second Gear
http://www.secondgearllc.com/
-
Check out Porchlight: bug tracking for small teams <http://www.porchlightnow.com>

There are several issues here.

1) A solo license will not do, you would need the equivalent of a PowerCenter license otherwise certain things needed for Daylite will be disabled (notably offline synching).

2) We have a special license for direct access, but even so, we are discouraging it for writing to the database. The reason being is that we do a lot of opimization in our BL (Business Logic) layer. If you write to the database without taking those into account (and there are many and more to come), the app will behave erratically. A read only situation is ok.

As of OpenBase 10.0, you can get away with the license that comes with Daylite in terms of OpenBase(I have to double check), but you will need our direct access license (US $995) to gain access to the raw tables.

Are you doing a read only solution?

Its a readonly solution. A $1000 license for a one time export seems a bit pricey for my needs. Do you have any other suggestions for how to easily export the data?

- j

If you just need to export, then yes that $995 is way too expensive.

I assume you've looked at our canned export stuff (using the multi-column lists) and that those are not good enough for you.

If that is the case, then you have 2 no-cost choices:

1) Create an F-Script that extracts the data you need

2) Create a plugin that does the same

With either of these, you can export to text, XML(plist) or whatever you want.

To get an XML representation of an object is pretty easy.
Look in the Dev Kit under Daylite Remote Test, there we show how to get XML representations. I believe there are two profiles - shallow and deep. Shallow travels just a few relationships while deep goes a lot deeper and get a lot more related data.

AJ has said "With either of these, you can export to text, XML(plist) or whatever you want.

To get an XML representation of an object is pretty easy.
Look in the Dev Kit under Daylite Remote Test, there we show how to get XML representations. I believe there are two profiles - shallow and deep. Shallow travels just a few relationships while deep goes a lot deeper and get a lot more related data."

I am needing to do a similar thing... a one time grab of data.. what is the Dev Kit?
thanks