Export from GnuCash to Gnumeric

Derek Atkins warlord@MIT.EDU
04 Mar 2002 16:28:18 -0500

You might want to write this in Scheme and supply it as a Gnucash


Zach Garner <zach@neurosoft.org> 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
> attachment.
> 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"
>         xmlns:gnc="http://www.gnucash.org/gnc"
>         xmlns:trn="http://www.gnucash.org/trn"
>         xmlns:ts="http://www.gnucash.org/ts"
>         xmlns:split="http://www.gnucash.org/split">
> 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)
> thanks,
> 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