[GNC] Importing CSV exchange rate prices

[Andrew Beattie]

Thanks Jim. that solved it.  

I tried Currencies and Currency as namespace, but not CURRENCY which as you noted was given in the import routine instructions and the capitalisation mattered.  I will put something in the Wiki if I get write access as penance for not reading the import dialogue properly!

Kind regards

Andrew

> On 2 Nov 2024, at 22:22, Jim DeLaHunt <list+gnucash at jdlh.com> wrote:
> 
> Andrew:
> 
> On 2024-11-02 05:27, Andrew Beattie wrote:
>> Hi all
>> 
>> I’m successfully importing stock prices in multiple currencies into gnucash, but can’t seem to find a way to import exchange rates.  I’ve tried setting namespace to “Currencies” which is what’s used in the price editor, but the import routine highlights any line with namespace Currencies in red and says not all fields could be parsed.  
>> 
>> Is it possible to import exchange rates in this way - I’ve down quite a bit of googling on it and not found an solution.
> Simple, just look in the GnuCash tutorial and guide, section 9.6. Setting Share Price <https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide> <https://gnucash.org/viewdoc.phtml?rev=5&lang=C&doc=guide>... oh, nothing there about importing prices.
> 
> Ah well, at least the GnuCash wiki has an article "CSV Import/Export", with section 1.3 "Importing Prices" <https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices> <https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices>... oh, that section is empty.
> 
> Well, I know that I used to import currency exchange rates from my currency to a couple of other major currencies in the past, but I don't have notes at hand about exactly how I did it.
> 
> You are using the menu item File… Import… Import prices from a CSV file…, right?
> 
> The first page of the price import assistant has an example currency import table: 
> CURRENCY;USD:2016-11-21;1.56;GBP
> 
> Do your CSV file lines have those columns? Do the instructions on that page help?
> 
> If you do figure something out, I encourage you to write instructions in the above Wiki page on CSV Import/Export. Whatever you can contribute, it will be better than literally nothing.
> 
> Best regards,
>      —Jim DeLaHunt
> 
>