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 
> <mailto: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 
> <mailto:jra...@ceridwen.us>> wrote:
> 
> 
>> On Dec 22, 2021, at 8:58 PM, David Carlson <david.carlson....@gmail.com 
>> <mailto: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 
>> <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 
> <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 
> <https://bugs.gnucash.org/show_bug.cgi?id=793306> and 
> https://bugs.gnucash.org/show_bug.cgi?id=796955 
> <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.

Reply via email to