Export Clients programmatically / from the cmd line

[TaylorH]

Is it possible to export client data to xml via the command line (a switch or what not)

[K Software]

No, it isn't.

[TaylorH]

I know the database is "proprietary" i'm just not sure if that means you built an inhouse database type, or used somebody elses "proprietary" database scheme.

If you used someone elses, what kind?

also, i know that in the future the kbilling database will be non-proprietary, i was curious when that version is slated for release?

[K Software]

The database is (at it's core), SQLite 2. Modifications have been made that prevent the standard SQLite libraries from opening the files.

The open standards database will come with Pro (or version 2). No ETA on that yet..

[TaylorH]

Is there any possibility of getting a command line export in the future? It would make things a lot easier for what i am trying to do.

BTW, i have written a script to import clients from kbilling into MS exchange 2003 as contacts (either for an individual mailbox, or into a public folder). if anyone is interested in this script, just drop me a line.

[K Software]

Hi Taylor, drop the script to support@ksoftware.net - I'd love to have a look!

Command line export is very possible. In fact, there already exists an XML framework for exporting every bit of data in the database. I'll look at turning all that on and publishing how to access it for power users like yourself.

[K Software]

Hi Taylor, are you looking for just customer data or for customer and invoice data?

[TaylorH]

just customer data. everything that you would get from the current client export, but in a command line format.

[mbodea]

Hello,

you mentioned before that
"open standards database will come with Pro (version 2). "
I just got the latest version today 2.0.4

is there a way to access the customer database?
need for example to modify multiple entries at the same time, edit the customer database...

I have 840 customers and I have to create a new company after each import.
I do an import, create some invoices, than find out that some clients do not have all info correctly entered... need to start over.
Would make it easier if can use Microsoft Access or other means to access the database.

thx.
Marius

[K Software]

The database (or company file) is an SQLite file. Any of the utilities available at http://sqlite.org should enable you direct access to the data.

However, I cannot recommend anyone try this. It is VERY easy to make one false step and render the file unusable inside the software itself. If you're comfortable doing this and assuming the risk (IE, I wont' be able to help if something goes haywire), then you're more than welcome to give it a go!