This post is from the https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112463.html thread with discussion moving in a different direction.
https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112470.html Greg Julius <greg.jul...@outtacyte.com> wrote: > FWIW, I really struggled with this to figure out what was wrong with my > imports. There is a Commodity field and there is a Currency field. I had > to repeatedly fill in fields until I found the issue was Currency. Greg, Are you suggesting this is a Commodity/Currency field issue? I've added the full process from the linked bug report - see RIO near the end. My GnuCash file has transactions from previous years that were imported properly. https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102562.html > >> The three lines below *work* using a Multi-split import - based on >> https://bugs.gnucash.org/show_bug.cgi?id=797450 >> Save *PP-Demo_Transactions_Minimal_Priced2.csv*: >> Date,Description,Action,Account,Deposit,Rate/Price >> 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53 >> ,,Buy,Assets:Broker:Shares:RIO,89,8900/991253 > > GnuCash (brackets at end of line show changes for V5.8) > File, New > Cancel > Tools, Security Editor > Securities: Add > New security > Full Name: RIO > Symbol: RIO > Type: ASX (Namespace) > OK > Close > File, Import, Transactions from CSV > Next, PP-Demo_Transactions_Minimal.csv, Next > Multi-split, DateFormat, Leading Lines to Skip 1, > Date, Description, Action, Account, Deposit, Price (Amount instead of > Deposit) > Next > Map Account ID to Account Name > Change GnuCash Account, New Account > > Manually parse the accounts at ":" Creating new accounts until they are > done. > RIO is Account Type: Stock, Security: RIO, OK (Note security Namespace: > ASX) > Next (If New Book Options is displayed just Close), Next > Ignore UNBALANCED, Apply, Close > If it was UNBALANCED then Import was not successful. Interestingly, this previously working file now has three field errors (Date, Amount, Price): > Save PP-Demo_Transactions_Minimal_Priced.csv > Date,Description,Action,Account,Deposit,Rate/Price > 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53 > ,,Buy,Assets:Broker:Shares:RIO,89,111 + 3353/8900 Regards _______________________________________________ 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.
