[GNC] Example of importing Stock transactions from CSV

Jon Schewe jpschewe at mtu.net
Tue Jul 12 09:45:28 EDT 2022


That looks similar to what I'm doing, except all of my data is on a
single line in the CSV file. The biggest problem seems to be how to
convince GnuCash to use 2 different commodities for the transaction
when importing from CSV.


On Tue, 2022-07-12 at 13:04 +1000, Geoff wrote:
> Hi Jon
> 
> This isn't exactly what you are asking for, but it may give you some 
> clues.  Importing Dividends from CSV:-
> 
> https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092768.html
> 
> 
> Good luck!
> 
> Geoff
> =====
> 
> On 12/07/2022 12:35 pm, Jon Schewe wrote:
> > Does anyone have an example of importing stock transactions from
> > CSV?
> > 
> > I have matched columns to Date, Description, Account, Price,
> > Deposit,
> > Transfer Account.
> > The "Account" column is the mutual fund account.
> > The "Transfer Account" column is the currency account.
> > 
> > When I start the import process all of my transactions need an
> > account
> > to transfer from, despite specifying the Transfer Account. When I
> > try
> > and select my currency account I'm told that it has the wrong
> > commodity.
> > 
> > I have another column for the currency amount, but I don't know
> > what to
> > map that to in the importer.
> > 
> > I tried checkout out
> > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
> > 
> >   but it doesn't seem to address this.
> > Suggestions on where I'm going wrong.
> > 
> > Jon
> > 
> > 
> > _______________________________________________
> > 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
> > 
> > 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.



More information about the gnucash-user mailing list