Export from GnuCash to Gnumeric
04 Mar 2002 16:28:18 -0500
You might want to write this in Scheme and supply it as a Gnucash
Zach Garner <email@example.com> writes:
> I have spent a couple hours learning some XML and hacked an XSL file to
> convert from a GnuCash Account file to a Gnumeric spreadsheet. It is
> very rough at this point. Downloaded it at
> http://www.neurosoft.org/gnucash/gnumeric_xsl , or get it from the
> A couple of obvious (and major) problems:
> 1. Gnucash does not define its Namespaces properly. For XSL to work, you
> have to edit the Account file, and change <gnc-v2> to:
> <gnc-v2 xmlns:act="http://www.gnucash.org/act"
> These are just bogus values. The Gnucash project needs to properly
> define the namespaces; this has been mentioned before on this list.
> 2. I haven't been able to properly connect the Account Name and the
> Account ID within the spreadsheet. This causes the transactions to be
> listed by the ID instead of by the name.
> To use with Apache Xalan, execute
> $ java org.apache.xalan.xslt.Process -in Accounts.gnucash -xsl
> gnumeric.xsl -out Accounts.gnumeric
> Suggestions/Criticism/etc welcome.
> I'm doing this for my own benefit, but I would like to know if this
> would be useful to the project. I'm curious if this might be better
> implemented as a SXSL (scheme XSL: http://okmij.org/ftp/Scheme/xml.html)
> Zach Garner
> p.s. I sent a similar message little while back, but it apparently
> didn't make it because the maintainer is behind. (that's OK though!)
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord@MIT.EDU PGP key available