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 ...
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
