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

[Deva -]

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 -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 
To: gnucash-user@gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
not be understood"
Message-ID:

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



Date: Sat, 7 Aug 2021 21:35:30 +0100
From: Ashok Sinha 
To: gnucash-user@gnucash.org
Subject: [GNC] Mutual Fund - Price Import from csv, "Namespace could
not be understood"
Message-ID:

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.

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

[David Carlson]

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"

[Ashok Sinha]

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"

[John Ralls]

> 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"

[David Carlson]

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.

[GNC] Printing customer statements, two copies, two-up

[rmomxtx]

We are running GnuCash 3.11 on a Windows 10 computer in Spanish. 

 

We print out a current month customer statement in two copies two-up on a
horizontal page orientation. That gives us two copies by cutting the sheet
in half, one for the customer and one for our files. Since moving to a new
computer and updating GnuCash the printer kicks out a blank page first
before printing two copies of the statement on a single page. The printer is
an Epson L4150 series inkjet. 

 

Could it be that we need to adjust the margins on the report somehow in the
customer statement in the GnuCash 3.11? We use letter size paper, not A4 as
is customary in much of the rest of Latin America. Is there a way to adjust
the margins so a short report that only takes up half a page will print
without kicking out an empty page? Any new features in 4.6 that might help?

 

Is there a way to make one of the other stylesheets the default report
format? The default customer statement is very small print and a very small
table when printed two-up. Default in the Spanish version is called "por
omisión." I’ve researched the manuals, FAQ’s and the wiki. I’m not quite
getting how the adjustments in edit/style sheets/tables work. 

 

Thanks,

Roger Oliver

___
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.

[GNC] Income statement report change

[Gerald]

Hello

I am trying to modify the standard Income statement report to show the
account code.  This option is available in the standard Account Summary
report but not the Income Statement.

With a lot of help from the wiki I got as far as replicating the standard
report and adding a boolean option to show account code.  But it is only a
tickbox option that doesn't actually do anything!

I have now reached the limit of my technical ability and need some help
with making the option actually change the report produced.

Ideally the result will be just like the Account Summary report, ie the
account code is the first column then the account title.  However, it could
be any column as long as it is tabular.

Is anyone able to help with the report code change required?


Many thanks
___
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] Fwd: Re: Creating a customer report by location

[Samantha Payn]

   I could certainly do that moving forwards, but it won't create a
   retrospective report as of now.

   On 06/08/2021 23:48 Derek Atkins  wrote:

   Actually, couldn't you make multiple Income accounts per region? Eg
   Income:Region:Type..  That might work, but would mean you need to enter
   the right region when building the invoice instead of having it
   automated.
   -derek
   Sent using my mobile device. Please excuse any typos.
   On August 6, 2021 5:44:19 PM Samantha Payn
wrote:

   As there are comprehensive address fields for the customer database it
   would be wonderful if these could be used to compile a report.

   I could, working forward, categorise sales by location/product but that
   would mean duplicating each product for each location, and doesn’t
   solve the issue of a retrospective review.

   On 6 Aug 2021, at 22:10, Greg Feneis  wrote:

   Perhaps use of jobs could help?

   If jobs were named per location, or included location in the job name
   or

   description?

   A customer could have multiple locations indicated by job.

   The thing I don't know is whether reports can sort on job names or

   descriptions 🤔

   Kind regards, Greg Feneis

   (Pixel 3)

   On Fri, Aug 6, 2021, 12:51 Derek Atkins  wrote:

   David,

   I'm not sure how you would do that.  Customers are just a flat
   database, a

   list; there is no Customer Hierarchy.

   -derek

   On Fri, August 6, 2021 3:34 pm, David H wrote:

   Samantha,

   Like David Carlson I'm not a business features user so I'm only
   guessing

   here but can you setup your customers or Sales in a heirarchy - i.e

   Customers, Customers UK, Customers Local, Customers Non UK OR Sales,

   Sales

   UK, Sales Local, Sales Non UK and report on them that way ?

   Cheers David H.

   On Sat, 7 Aug 2021 at 03:36, Samantha Payn

   

   wrote:

   Sorry, I replied to Derek only and I meant to include the list.

   Here is my response to Derek's question.

   -- Original Message --

   From: Samantha Payn 

   To: Derek Atkins 

   Date: 06/08/2021 16:26

   Subject: Re: [GNC] Creating a customer report by location

   I am a freelance translator in the UK with clients all over the

   world. In applying for advice and grants from a local

   government-run

   business support agency they want to know the proportion of my

   sales

   to local (county) customers, to the wider UK and as “exports”.

   Location by country for me would be sufficient (I don’t yet have any

   clients in my actual locality).

   In fact, for my purposes, a custom text field with A, B, C, D or E

   would be sufficient.

   I hope this helps and would love it if someone could come up with

   something.

   Many thanks for any pointers

   Samantha

   On 6 Aug 2021, at 15:25, Derek Atkins  wrote:

   Hi Samantha,

   As far as I know, there is no report like that.  Indeed, I can't even

   think of a way that you could collate customers by location within

   GnuCash.  Are you thinking by State?  By Zip Code?  By some other

   means?

   Once you figure that out, then one could write a routine that sorted

   and

   collated based on that.  But to my knowledge, no such thing exists.

   I'm curious what your actual use-case is here?

   -derek

   On Fri, August 6, 2021 9:11 am, David Carlson wrote:

   No, not unnoticed, but I do not use business features, so I waited

   to see

   if a business user would step up.

   GnuCash has no geographical data feature to use for such a report.

   You

   would have to somehow manually add appropriate information in a

   text

   field,

   but reports generally only have rudimentary sorting  on text

   fields,

   so

   maybe at best you could come up with a manually implemented zip

   code

   scheme.

   Short answer, no.

   On Fri, Aug 6, 2021 at 7:43 AM Samantha Payn <

   saman...@boorertranslations.com> wrote:

Is this not possible, or has this request slipped through

   unnoticed?

Cheers

On 05/08/2021 14:26 Samantha Payn

   <[1]saman...@boorertranslations.com>

wrote:

Can anyone tell me how to set up a report on income by customer

location, please?

Many thanks

Samantha Payn

___

gnucash-user mailing list

[2]gnucash-user@gnucash.org

To update your subscription preferences or to unsubscribe:

[3]https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see

[4]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.

   References

1. mailto:saman...@boorertranslations.com

2. mailto:gnucash-user@gnucash.org

3. https://lists.gnucash.org/mailman/listinfo/gnucash-user

4. https://wiki.gnucash.org/wiki/Mailing_Lists

   ___