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.si...@gmail.com>
To: gnucash-user@gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
not be understood"
Message-ID:
<CAJTyECziwksgwA=ak3midn-nj3qkxob-nv1svbegittkzx+...@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.si...@gmail.com>
To: gnucash-user@gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
not be understood"
Message-ID:
<CAJTyECziwksgwA=ak3midn-nj3qkxob-nv1svbegittkzx+...@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@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.
_______________________________________________
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.
