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+gnuc...@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 > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
