Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"
Yes! On Sat, Aug 7, 2021 at 6:57 PM Ashok Sinha 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 wrote: > > > > > > > > On Aug 7, 2021, at 1:35 PM, Ashok Sinha 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.
Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"
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 wrote: > > > > On Aug 7, 2021, at 1:35 PM, Ashok Sinha 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.
Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"
> On Aug 7, 2021, at 1:35 PM, Ashok Sinha 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.
Re: [GNC] Mutual Fund - Price Import from csv, "Namespace could not be understood"
Hi, I have not tried that particular method to import prices but I would suggest verifying that you created the csv file using the the same encoding that you are using for the import and that the namespace, symbol and currency already exist in your data file. Good Luck On Sat, Aug 7, 2021 at 3:37 PM Ashok Sinha 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. > > Thanks, > Ashok > > [image: image.png] > ___ > 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.
