[GNC] Import troubles

[David Cousens]

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 <davidcousens49 at gmail.com>
> Datum: 24.02.2025 02:13:21
> An: "\"alois" müller"
> <mue at eclipso.at>, 	gnucash-user at 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 at 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