On Sat, 30 Dec 2017 17:03:13 +0100 Geert Janssens <geert.gnuc...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.