Hi David, thanks. Verified that: - csv file encoding same as for the import. --> UTF-8 encoding - namespace + symbol + currency already exist in your data file. --> These are already in the price database, where I updated manually till so far. Now trying importer to add prices.
Hi John, Removed leading spaces. --> This resolved it! Now it imports beautifully! Thanks, Ashok On Sat, 7 Aug 2021 at 22:24, John Ralls <jra...@ceridwen.us> wrote: > > > > On Aug 7, 2021, at 1:35 PM, Ashok Sinha <ashok.si...@gmail.com> wrote: > > > > Hello everyone, trying this list for the first time, I hope I am > following > > the instructions. > > > > I have downloaded and prepared an import.csv file with 2 lines as: > > 05/08/21, INDIAMUTUAL,INF209KA12Z1, INR,143.021 > > 05/08/21, INDIAMUTUAL,INF209K01546, INR,27.1064 > > > > Where the columns are Date, Namespace, From Symbol, To Currency, Amount > > > > The 'Namespace', & 'Currency To' dropdown comes up with an error > > respectively as: > > Error 1: Column 'From Namespace' could not be understood. Value can't be > > parsed into a valid namespace. > > Error 2: Column 'Currency To' could not be understood. Value can't be > > parsed into a valide commodity. > > > > Could somebody please explain to me how to import the prices? I think I'm > > doing it right - there's a screenshot below. > > > > The above example has 2 different mutual funds. Once the concept is > proved, > > I plan to update many (~20) mutual fund prices from a single import csv > > file on a weekly basis. > > Try removing the leading spaces from the namespace and currency columns. > > Regards, > John Ralls > > _______________________________________________ gnucash-user mailing list gnucash-user@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.