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

David T. sunfish62 at yahoo.com
Tue Aug 16 10:15:48 EDT 2022


Actually, it was clear to me. Jim's point was that if you do these steps 130 times in a row, your brain will explode. Certainly it would be nice to be able to import them.

On Aug 16, 2022, 14:05, at 14:05, flywire <flywire0 at gmail.com> wrote:
>Obviously it wasn't clear that the post copied below identifies the
>keystroke operations from opening GnuCash through the Security Editor
>with
>*** as user input. The Import accounts was an aside comment. (Thanks
>David
>for start the account tree comments.) Interestingly New security is one
>of
>the few GnuCash forms specifically requiring a name, yet many people
>wouldn't recognise the name of a share but would recognise the security
>code.
>
>The bleeding obvious is, "Why can't securities be imported by csv"? OFX
>is
>a good suggestion. It generally seems much more automated than csv so
>it
>would be worth investigating..
>
>https://www.gnucash.org/docs/v4/C/gnucash-guide/appendixa_xmlconvert1.html
>> An enterprising individual could go so far as to write a stylesheet
>to
>transform the *GnuCash* data file to an *Apache
>OpenOffice*/*LibreOffice* Calc
>(or vice-versa, for that matter).
>
>Does it follow it could be written directly into an existing file?
>(Note
>the guid issue
>https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102422.html
>). The
>two examples only output data from GnuCash.
>
>btw A lot (the majority?) of
>https://wiki.gnucash.org/wiki/Published_tools
>are so old they won't work.
>
>
>https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102438.html
>
>> Once share securities are created the share accounts can be created
>with
>> File, Import, Import accounts from CSV.
>>
>> File, New
>> Cancel
>>
>> Tools, Security Editor
>>
>> Securities: Add
>> New security
>> Full Name: ***
>> Symbol: ***
>> Type: *** - Sticky
>> Fraction Traded: ***
>> OK
>>
>> File, Import, Import Accounts from CSV
>> Next, DemoAccountTree.csv Next, Apply, Apply, Close
>>
>>>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>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.


More information about the gnucash-user mailing list