The main difference is that I am using release 3.8. At the matching step after I touch add so it won't erase the text in the existing transactions it declares that the four non-zero value dividend transactions are already balanced and it won't let me assign an income account.
Then I touch Next and it accepts them without an imbalance transfer account and I cannot manually edit them to add an income account. That throws the brokerage account out of balance and the transaction repair feature cannot fix it either. I n other accounts the matching step will behave similarly on occasional zero value transactions but I have been able to assign a special account that I use exclusively for comments. As you have seen in other threads here it is still an error-prone process to upgrade Ubuntu LTS to Gnucash release 4.9. I would want to try it in a disposable virtual machine before committing my only working instance to the upgrade. On Sat, Dec 25, 2021, 12:15 PM john <jra...@ceridwen.us> wrote: > Your example worked fine for me in GnuCash 4.9. I set it to ignore the > first 5 rows, set the date field to Date, the description field to > Description, and the Amount Field to deposit and ignored the rest. I used > Assets:Investment:Brokerage Account for the target account. On import the > matcher window came up with the several transactions. I clicked OK without > bothering with matching and all were created with splits in Brokerage > Account and Imbalance-USD. > > What did you do? > > Regards, > John Ralls > > > On Dec 25, 2021, at 8:26 AM, David Carlson <david.carlson....@gmail.com> > wrote: > > I have created a test csv import file and I can replicate the single line > out-of-balance imported transactions. . Reminder, I am still using release > 3.8 in Llnux Lite [Ubuntu 20.04]. > > The test file is pure text, I will quote it to be sure that it gets > through. Alas, that adds spurious carriage returns. There should only be > five transaction lines beginning with the date and no cr's until just > before the next date. I will try attaching it as well. > I set it to import into the brokerage account skipping the header lines, > assign import columns Date to Date, Memo to Type, Description to > Description, Deposit to Amount, Transaction Commodity to Symbol and Price > to Price. Then I make all five transactions new in the match step as there > are existing similar transactions. The dividend transaction does get a > transfer to the correct account. > > [Transactions > Account: DianeIRA (*****574) > > Time Period: 07/01/2021 to 12/22/2021 > Transaction type: All transactions without Cash Sweep Activity > > Date,Type,Description,Quantity,Amount,Symbol,Price,Check number > 08/02/2021,Dividend,"Bristol Myers Squibb Co > Cash Div On 475 Shs > Rec 07/02/21 Pay 08/02/21",,232.75,BMY,, > 08/02/2021,Dividend,"Pimco Corporate & Income > Opportunity Fund > Cash Div On 600 Shs",,78,PTY,, > 07/26/2021,Interest,"RBC Insured Deposits > Monthly Interest 06/28-07/25 > Apye#: 00.01 %",,0.02,,, > 07/09/2021,Dividend,"American Tower Corporation > Reit > Cash Div On 150 Shs",,190.5,AMT,, > 07/01/2021,Dividend,"Pimco Corporate & Income > Opportunity Fund > Cash Div On 600 Shs",,78,PTY,,] > > On Thu, Dec 23, 2021 at 12:58 PM David Carlson < > david.carlson....@gmail.com> wrote: > >> It will be a while before I can find an adequate time window to test and >> post an example csv with instructions to duplicate the single line >> transactions that I saw the other day. I still have the csv file and the >> import configuration so I should be able to do it. In the meantime have a >> nice holiday. >> >> On Thu, Dec 23, 2021 at 11:44 AM john <jra...@ceridwen.us> wrote: >> >>> >>> >>> On Dec 22, 2021, at 8:58 PM, David Carlson <david.carlson....@gmail.com> >>> wrote: >>> >>> I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04 >>> under a different label. I think that the CSV transaction import has not >>> been changed, between 3.8 and 4.9. If that is not correct, then some of >>> my >>> issues may be bugs that have been fixed. >>> >>> I have read the current help manual section on importing transactions in >>> csv format <https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help> >>> which >>> gave me a start, but there are some things that I cannot make work >>> correctly. >>> >>> I have come to the conclusion that my brokerage house World Equity Group >>> CSV exports probably need to be massaged, and possibly split up but there >>> are a couple of issues that I need to understand in order to determine >>> how >>> to fix the import data and to assign the proper names to the various >>> fields. >>> >>> One issue is that in one test many transactions were imported as single >>> line unbalanced transactions with no transfer account, not even an >>> assignment to an unbalance account. Why did GnuCash accept unbalanced >>> transactions containing amounts? Applying Check and Repair to some of >>> those >>> transactions did not balance them to an unbalance account. >>> >>> Another issue is that I have not figured out which column name should be >>> used for the number of shares in a purchase or sale transaction. >>> >>> Yet another issue would be whether I can import everything into the >>> brokerage account or do I need to do something special to get stock >>> transactions assigned to the proper security account when appropriate? >>> >>> A fourth issue would be whether I need to use the Multi-Split feature >>> and, >>> if so, how to format the CSV file to make it assign the correct split >>> lines >>> to the correct base transaction, and save it in CSV format if I built the >>> spreadsheet in LibreOffice Calc or equivalent >>> >>> >>> Your premise might be mistaken: There have been 40 commits in >>> gnucash/import-export/csv since 3.8 including several bug-fixes. However >>> none of the summaries say anything about creating single-split >>> transactions. You're right that that shouldn't be possible. Can you post an >>> example or two of CSV rows that do that? >>> >>> There isn't a column name for amount (see >>> https://bugs.gnucash.org/show_bug.cgi?id=797368), just for price, but >>> even that apparently doesn't work well: >>> https://bugs.gnucash.org/show_bug.cgi?id=793306 and >>> https://bugs.gnucash.org/show_bug.cgi?id=796955. >>> >>> If you root the import on the brokerage cash account you should be able >>> to designate the transfer accounts to the various stock's accounts in the >>> matcher if importing stock trades worked, see previous item. >>> >>> The easiest way to learn the format for multi-split CSV files is to do >>> File>Export>Export Transactions to CSV and examine the resulting >>> spreadsheet. >>> >>> Regards, >>> John Ralls >>> >>> >>> >>> >>> >>> >>> >>> >> >> -- >> David Carlson >> > > > -- > David Carlson > <Test_Transactions_without_Cash_Sweep_Activity_2021-12-22.csv> > > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
