import transactions from CSV with mutiple accounts

Paul Neuwirth mail at paul-neuwirth.nl
Wed Jan 3 06:40:13 EST 2018


On Sat, 30 Dec 2017 17:03:13 +0100
Geert Janssens <geert.gnucash at kobaltwit.be> wrote:

> Op zaterdag 30 december 2017 16:20:53 CET schreef Paul Neuwirth:
> > Hi List,
> > 
> > I hope someone can give me a hint. Is it a bug of the importer or
> > am I doing something wrong? Or is there a tool which converts csv
> > to qif or other advanced format?
> > I have a CSV file with transactions of different bank accounts (ca.
> > 12 bank accounts, export from banking software moneyplex).
> > If I import csv files with only transactions of one account, gnucash
> > selects (automatically) the correct account (slot 'online-id' of
> > account is identically to account number in csv).
> > But if I do import transactions belonging to different accounts, all
> > transactions are being imported into the account of the first line
> > in the csv.
> > This does not make any sense for me, as you can select account as a
> > column...
> > 
> > It would be quiet unconvinient to do seperate imports for every
> > account. On the other side (moneyplex) does have advanced export
> > functions, but not for transactions of multiple accounts (therefor
> > only search results can be exported to csv or xml)..  
> 
> Hi Paul,
> 
> I don't think the csv importer was designed with your use case in
> mind. I believe it was written to import transactions one bank
> account at the time.
> 
> So for the 2.6 series unfortunately you will have to live with this 
> limitation. There are some tools floating around on the net for
> converting csv files to qif, or more exactly LibreOffice Calc to qif
> or Excel to qif (but both applications should be able to open csv
> files just fine).
> 
> For gnucash 3.0 (to be released in a couple of months) the csv
> importer has been rewritten and the new one should be able to handle
> csv files in your format just fine.
> 
> Regards,
> 
> Geert

thank you very much for the hints. I am about gnucash 3.0..
Just wrote a script to generate a QIF file from moneyplex search result
csvs.. pretty simple and working :)

I whis you a prosperous new year 

Paul


More information about the gnucash-user mailing list