On Wed, 3 Jan 2018 12:40:13 +0100 Paul Neuwirth <m...@paul-neuwirth.nl> wrote:
> 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 exasperating... glad qif import works.. but (compared to csv import, with very helfull aditional screen..) correlation is not done.. bunch of duplicates now.. but i do not give up hope.. best way right now is doing csv import account by account.. :-/ _______________________________________________ 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.