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