[GNC] Import CSV Multi-currency

[David Carlson]

GTI,

Whenever there is more than one currency in a transaction GnuCash creates a
split to record the exchange between currencies, so there is a separate
split line for each currency.  When a multi-currency transaction is
imported, there will be two split lines, not one.  That is an artifact of
double entry accounting as implemented in GnuCash  See chapter 12 if the
tutorial <https://www.gnucash.org/viewdoc.phtml?rev=3&lang=C&doc=guide>.
As explained therein, you need to have some account that is denominated in
the other currency to use in the transaction, occupying the second split
line and triggering the exchange rate dialog.  Stock purchases and sales
are accounted in a similar way.

The old CSV importer would choke on security purchase transactions which
have a currency and a commodity which is handled roughly similarly to a
currency.  I do not know whether the improved CSV importer still has this
issue, but as Geert, the developer notes, the issue may be in the part that
he has not addressed yet.

On Fri, Nov 23, 2018 at 9:23 PM GTI .H <gti9070h at gmail.com> wrote:

> Em sex, 23 de nov de 2018 às 05:08, Geert Janssens <
> geert.gnucash at kobaltwit.be> escreveu:
>
> > I think you're right this is currently not possible.
> >
> > In the csv importer rewrite only the csv specific parts have been redone.
> > However once all the info is gathered from the csv file this info is
> > passed on
> > to the generic import matcher, which handles final evaluation of the
> > transactions. This is not yet rewritten as it is used by all importers.
> It
> > looks like this generic import matcher can't cope with the multi-currency
> > data
> > it receives from the csv parser.
> >
> > Can you file a bug report for this please and add your example csv
> snippet
> > from above ?
> >
> > At some point I will continue the work on the importers, though there are
> > currently more pressing matters to handle first.
> >
> > Regards,
> >
> > Geert
> >
>
> Thank you Geert,
>
> Your answer clarifies and directed my next actions.
>
> Well, my import jobs I started to do stopped here and went back to the "To
> Do" list.
>
> It's unfortunate that currently we can't import Single-line two-currency
> transactions. I have transactions waiting since 2008 to enter GnuCash.
>
> Bug report openned: https://bugs.gnucash.org/show_bug.cgi?id=796955
>
>
> The importer is the gateway of new immigrant users from other financial SW,
> the more users, the larger the project, the greater its importance.
> We hope you can dedicate to the importer soon.
>
>
> --
> Regards
> GTI
> _______________________________________________
> 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.