[Kmymoney-devel] Import from GnuCash

[aga]

On Thu, 18 Apr 2013 15:41:33 +0530
CA G Rajesh <ca.grajesh at gmail.com> wrote:

> Hello All,
> I am using KDE for all my needs, except for accounts - for which I
> use GnuCash (for a long time, since Kde4 was consdered unstable
> then). GnuCash is a good software, but I want a KDE equivalent. I
> have tested KMyMoney and I like to switch to it. 
> However, when I tried to import GnuCash file, the
> narration/descriptions of GnuCash are imported as Payees in KMyMoney.
> I have filed a bug report/feature request in this regard - a dialog
> box which gives an option to choose where to map the narrations will
> suffice. It seems that such implementation will take time.
> Now, to my question. I know, KMyMoney saves the accounts as a xml
> file, which can be edited with Kate/Kwrite. Can some editing to this
> file (like, find and replace) will put all the narration/description
> to description/memo field? Rest, like payees, can be edited later -
> from inside KMyMoney itself. Any help in this regard will be
> appreciated. Thanks in advance. Regards,
> Rajesh
> 

Just a couple of questions, and a possible idea.

Are you able/willing to compile from source?  The reason I ask that is
that there might be another way to achieve your requirement, and
bearing in mind that developer time is very limited.

Presumably, at the moment, you would have to undertake a possibly
arduous manual editing exercise.  Might a free-standing (sort of), two
pass, program help?

What I'm thinking of is that I have recently written a plugin to export
a .kmy file as a CSV file, and there already exists another plugin to
import from CSV, which allows the user to choose (within reason) how to
allocate the various fields, or even to allocate  a payee field to be
copied to the memo field, or vice-versa.

So, you would import your Qnucash file, export to a CSV file, then
import that file as CSV, allocating the columns to your requirement.
There can be multiple columns allocated to a single memo field.

Allan