Yes! On Sat, Aug 7, 2021 at 6:57 PM Ashok Sinha <ashok.si...@gmail.com> wrote:
> 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. > -- David Carlson _______________________________________________ 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.
