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

flywire flywire0 at gmail.com
Tue Aug 16 07:03:38 EDT 2022


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
>
>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PP-DemoAccountTree.csv
Type: text/csv
Size: 1388 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20220816/e85dea4f/attachment.csv>


More information about the gnucash-user mailing list