The GnuCash import process is designed for manual operation of the matching step. An attempt to import 30,000 transactions is not likely to ever be automated. At least not with anywhere near an acceptable level of accuracy.
I would review my plan and goals and modify them to be more doable. In fact, I myself am planning to keep old records in their original program format instead of importing them into GnuCash. On Mon, Feb 24, 2025 at 3:51 PM David Cousens <davidcousen...@gmail.com> wrote: > 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. > -- David Carlson _______________________________________________ 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.
