[GNC] importing csv multisplit multicurrency problems

[Gio Bacareza]

Hi Geert, thanks for the feedback.

Questions:
Is it advisable then to convert csvs to another format?
What is the preferred format for multicurency imports?
Any other tips on doing multicurrency imports?

Thanks!

On Fri, Mar 6, 2020 at 1:01 AM Geert Janssens <geert.gnucash at kobaltwit.be>
wrote:

> There are several bugs with multi-currency csv imports. I don't think it's
> currently possible to do such imports. Sorry.
>
> Geert
>
> Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza:
> > I'm encountering problems with importing transactions in csv when
> accounts
> > 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
>
>
>
>
>

-- 
cheers,

Gio