[GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"

Ashok Sinha ashok.sinha at gmail.com
Sat Aug 7 19:55:57 EDT 2021


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 <jralls at ceridwen.us> wrote:

>
>
> > On Aug 7, 2021, at 1:35 PM, Ashok Sinha <ashok.sinha at 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
>
>


More information about the gnucash-user mailing list