Budgets ... again
Wm Tarr
wm.tarr at gmail.com
Sun Sep 11 21:24:30 EDT 2011
On 2011-09-11 17:44, Tiago Neiva wrote:
> I myself have been considering some sort of extraction tool, not for
> budgeting but for mining the data. most of us use spreadsheets to do the
> graphs and to have the data closed up in gnucash is my biggest problem.
>
> I will check your project for sure, use it and probably translate it if I
> see a possible use in PT.
Are you using XML or one of the SQL formats?
The XML to SQL stuff (written before the SQL backends became available)
is a messy mix of shell scripts, perl, sed, awk, sql and so on. I
wouldn't expect someone else to use it without me adding a lot of comments.
Extracting data from an SQL backend is much cleaner and just involves
one sql script. Essentially what it does is "normalise" GnuCash's
sometimes obscure tables into ones that humans can easily understand,
i.e. accounts become viewable as accounts, transactions become viewable
as transactions, etc.
I'm new to this list so I'm not sure if it is good manners to post the
script here or provide a link. Hopefully someone will let me know.
--
Wm ...
More information about the gnucash-devel
mailing list