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

David Carlson david.carlson.417 at gmail.com
Sat Aug 7 20:34:13 EDT 2021


Yes!

On Sat, Aug 7, 2021 at 6:57 PM Ashok Sinha <ashok.sinha at 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 <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
> >
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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


More information about the gnucash-user mailing list