[GNC] Import troubles

["alois müller"]

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!!
>   
> [BZzO5Da6OkOXWi5VFolOEo3elod13b6p42qAuQJAAAAAAAAAEmt6hEXWASjp3Uk26WDV

> FA
>   
> vufydKXVVZIEKAAAAAAAAAFg+NFygLKOni9MDdXR0qOOIfFMEYWlk9p9XFQ62AAAAAAAA

> AI
>   
> BUmCoKAAAAAAAAAABUDUZcAAAAAAAAAACAqkHDBQAAAAAAAAAAqBo0XAAAAAAAAAAAgKp

> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2025-02-24 102137.jpg
Type: image/jpeg
Size: 79510 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20250224/5479a799/attachment-0001.jpg>