GnuCash Accounts XML Format

This looks good:

2  ISO4217  USD  US Dollar  840  100    currency    test  99dd5b22e2ed19873f52eb6a87f31268  BANK      ISO4217    USD    100  123444            notes      test      

This is a surprisingly complicated model for a simple account, and I'm betting a lot of that info is part and parcel with the QOF system, as the format is the serialization of qof xml data, aka qsf. This looks cool:

XML::QOFQSF - convert personal data to and from QSF XML files - Support for the QOF SQLite backend will be added in a separate module in due course. NICE!

I feel like a SQL Lite back-end is the right choice for a desktop app, because the model could be shared with web apps, and other database engines, like Postgres (which I believe Gnucash is potentially supporting, or now supports), MySQL, or... you decide!

From what I can understand about QOF, it can act as a data object cache for desktop apps. I just posted a question to the GnuCash wiki about this topic, as I think it would be so cool to have a desktop application for fast access to data and highly interactive reports, as well as have "anywhere access" via a webapp like PBooks. This would be kind of like email clients and webmail.

By on May 25, 2007 9:33 PM

Categories: