[GNC] Importing a CSV with transactions in another currency

[David Cousens]

There is really no way GnuCash can do that at least at the moment. The
easiest way to achieve it would be to use the multiline multisplit import
mode and prior to import into GnuCash import the data into a spreadsheet and
add the additional information in a Rate/Price column for each split.  

If you export a typical transaction of the currency conversion type you want
to import from GnuCash and don't choose the Simple Layout option you will
get a CSV file which will give you the format you need for import. You can
use the copy command to change the rate/price for the splits to the expense
accounts to the desired conversion rate.  One problem is that GnuCash
exports  currency conversion rates in a "3+ 144456/238798" format and my
experience is that it does not parse this correctly on import in some
circumstances.  I haven't confirmed yet that if you convert the rational
rate to a decimal number that it always imports correctly but I suspect it
might.

This is probably easier than duplicating the expense accounts.

David Cousens



-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html