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

Deva - pobox.deva at outlook.in
Sun Aug 8 00:14:27 EDT 2021


Ashok,

You can check/try the following -

a. In the security editor, confirm that INDIAMUTUAL is in fact the namespace used for those 2 MF ISINs.
b. I use the CSV importer every month to do just what you are trying to do. Only difference from your data is that I use the date format in yyyy-mm-dd format (in the data file) and in the import screen, I choose the y-m-d option instead.
c. Actually, this might be your problem because your dates in the CSV file are dd/mm/yy, whereas the importer is expecting d-m-y. (separator is -, but you have /).

Otherwise, your settings and data looks ok.

Cheers,
Deva
----------------------------------------------------------------------------------------------
Date: Sat, 7 Aug 2021 21:35:30 +0100
From: Ashok Sinha <ashok.sinha at gmail.com>
To: gnucash-user at gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
        not be understood"
Message-ID:
        <CAJTyECziwksgwA=Ak3MiDN-nJ3qkXOb-NV1SVBEGitTKZx+kJQ at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

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.

Thanks,
Ashok


Sent from Outlook<http://aka.ms/weboutlook>

________________________________

Date: Sat, 7 Aug 2021 21:35:30 +0100
From: Ashok Sinha <ashok.sinha at gmail.com>
To: gnucash-user at gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
        not be understood"
Message-ID:
        <CAJTyECziwksgwA=Ak3MiDN-nJ3qkXOb-NV1SVBEGitTKZx+kJQ at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

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.

Thanks,
Ashok

_______________________________________________

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.




More information about the gnucash-user mailing list