Alois Correction to my previous post
check Neue not Abgl to force the import David On Mon, 2025-02-24 at 10:34 +0100, alois müller wrote: > See this attached picture of the import process! > > I don't understand why the first transaction is not imported > > > --- Ursprüngliche Nachricht --- > Von: David Cousens <davidcousen...@gmail.com> > Datum: 24.02.2025 02:13:21 > An: "\"alois" müller" > <m...@eclipso.at>, gnucash-user@gnucash.org > Betreff: Re: [GNC] Import troubles > > Alois, > > I set up a dummy data file in GnuCash 5.10 with Asset accounts > "Bargeld" and "Girokonto" and expense accounts "Essen", > "Extras, and > "Katzen" then put the data from your post into a CSV file and > imported > > it without any problems. I assigned the headers > > Date, Description, Memo, Amount Negated, Amount, Account, Transfer > Account > > to the fields in the data in that order. The Amount Negated and > Amount > were applied to those specific columns so that the debits and credit > were made to the correct accounts (credits to the asset accounts and > debits to the expense accounts) assuming I have translated the German > account names correctly. > > With that setup these imported correctly with no problems. > > There is a step in the import process where you will have to match > the > account names to the internal account names the first time you do an > import even if the names in the CSV Account and Transfer Account > fields > > are exactly the same as the account names you have used internally in > GnuCash. Once that assignment has been made it will be remembered in > subsequent imports. > > Hope this helps. > > David Cousens > > On Mon, 2025-02-24 at 01:11 +0100, "alois müller" via gnucash-user > > wrote: > > I have a large CSV-File with transactions. > > My problem is, that about 10% of this transaction will not > > import > > > correct!! > > See these 4 examples: > > "2007-03-28","Billa","","5.1100","-5.1100","Girokonto","Essen" > > > "2021-06-14","Spar","Karte: 98","4.00","- > > 4.00","Bargeld","Extras" > > > "2007-03-28","Billa","","0.8500","-0.8500","Girokonto","Katzen" > > > "2021-06-14","Spar","Karte: 98","6.00","- > > 6.00","Bargeld","Katzen" > > > the FIRST will not import!! > > > > [BZzO5Da6OkOXWi5VFolOEo3elod13b6p42qAuQJAAAAAAAAAEmt6hEXWASjp3Uk26W > > DV > > > FA > > > > vufydKXVVZIEKAAAAAAAAAFg+NFygLKOni9MDdXR0qOOIfFMEYWlk9p9XFQ62AAAAAA > > AA > > > AI > > > > BUmCoKAAAAAAAAAABUDUZcAAAAAAAAAACAqkHDBQAAAAAAAAAAqBo0XAAAAAAAAAAAg > > Kp > > > Bw > > wUAAAAAAAAAAKgaNFwAAAAAAAAAAICq8f8HMyISB+fFYscAAAAASUVORK5CYII=] > > > Why does the importer NOT take the correct debit account as it > > does > > with the 3 others?? > > I have about 30 000 transactions. > > I can impossibly correct all not working transactions manually. > > Please help > > > > __________________________________________________________________ > > > > > Your E-Mail. Your Cloud. Your Office. [1]eclipso Mail Europe. > > > > References > > > > 1. https://www.eclipso.at/ > > _______________________________________________ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > 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. > > > > ________________________________________________________ > Your E-Mail. Your Cloud. Your Office. eclipso Mail Europe. > https://www.eclipso.at _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
