[GNC-dev] [GNC] importing csv multisplit multicurrency problems
christopher.lck at gmail.com
Fri Mar 6 07:16:50 EST 2020
Check out xaccDisableDataScrubbing and xaccEnableDataScrubbing pair, seems
to be appropriate while importing CSV/OFX/QIF etc, and should make them
On Thu, 5 Mar 2020 at 17:03, Geert Janssens <geert.gnucash at kobaltwit.be>
> There are several bugs with multi-currency csv imports. I don't think it's
> currently possible to do such imports. Sorry.
> Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> > I'm encountering problems with importing transactions in csv when
> > have different currencies.
> > I've been reading the debates. So this is not about definitions of
> > multi-split or terminology.
> > I did a test with a sample csv with the following contents:
> > Date,Description,Account,Deposit,Withdrawal
> > 1/3/2019,Description,test_foreign,,200
> > ,,Trading:CURRENCY:PHP,,10013
> > ,,Trading:CURRENCY:USD,200,
> > ,,test_local,10013,
> > gnucash imported successfully but it created an extra line Imbalance-USD.
> > See results below:
> > Date Description Account Deposit Withdrawal
> > 1/3/2019 Description 200
> > Trading:CURRENCY:USD 197.78
> > test_local 10013
> > Imbalance-USD 2.22
> > test_foreign 200
> > Trading:CURRENCY:PHP 10013
> > 1. Why does it do that when imported transactions is already balanced in
> > the first place?
> > 2. When I try to manually correct in gnucash (197.78->200), it wouldn't
> > allow me. It keeps the imbalance no matter what I do.
> > 3. How do I solve this?
> > Thanks,
> > gio
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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-devel