[GNC] How to bulk import about 130 Securities entries?

[David T.]

flywire,

You're crossing up threads here. Jim specifically needs to create 
Security entries in his GnuCash file (and has stated this on several 
occasions) so that he can add transactions for those securities later. 
Your advice regarding adding commodity transactions using csv import 
tools is besides his point and off his topic.

It would be preferable for you to add your comments to a new thread, so 
that others can focus on Jim's problem here while more directly helping 
you address the issues that you have encountered on a separate thread.

David T.

On 8/16/2022 6:13 AM, flywire wrote:
> I haven't used GnuCash securities before the last week and I'm still not
> clear about them. I understood importing security entries were
> transactions. Further to my last post with minimal security information the
> fraction traded is not required.
>
> I hadn't realised importing transactions with securities was failing
> because the securities hadn't been created. Anyway, that's done now.
>
> File, Import, Transactions from CSV
> Next, PP-Demo_Transactions.csv, Next
> Multi-split, DateFormat, Leading Lines to Skip 1,
>   Date, Description, Action, Account, Deposit, Price
> Next
> Map Account ID to Account Name, Next, Next
>
> In contrast to importing accounts from csv, which runs nicely, the header
> line is not recognised. The mapping process is still a meaningless chore
> that would be worth automating.
>
> Unfortunately, it fails on security capital gains as shown in the
> screenshot, so the imbalance has to be manually moved back to the security.
> With that, the portfolio is fully loaded.
>
> [image: image.png]
>
>
> _______________________________________________
> 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.