Re: [GNC] Fetch rate crashing gnucash
Thank you, Frank! --- Samantha Payn On 2022-08-15 16:32, Frank H. Ellenberger wrote: Hi Samantha, usually Bruce sends teh announcement to the list. The last has been https://lists.gnucash.org/pipermail/gnucash-user/2022-July/101772.html Regards Frank Am 15.08.22 um 17:24 schrieb Samantha Payn: Thanks Frank! I only joined the list just now so didn't see John's earlier post. Will the fix be flagged here, do you know? --- Samantha Payn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fetch rate crashing gnucash
Thanks Frank! I only joined the list just now so didn't see John's earlier post. Will the fix be flagged here, do you know? --- Samantha Payn On 2022-08-15 16:21, Frank H. Ellenberger wrote: Hello Samantha, John mentioned already this morning the by alphavantage broken online update of currencies: https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102424.html We track it as https://bugs.gnucash.org/show_bug.cgi?id=798599 and a fix is pending at finance-quote: https://github.com/finance-quote/finance-quote/pull/230 Am 15.08.22 um 16:59 schrieb Samantha Payn: Hello all! I am operating Windows 11 Home, Version 21H2, OS build 22000.856 I have just updated Gnucash to Version: 4.11, Build ID: 4.11+(2022-06-25), Finance::Quote: 1.49 I use fetch rate for USD (and occasionally EUR) conversions as some of my clients pay me in these currencies. My home currency is GBP. Unfortunately, since the most recent update (only installed today by me as I've been away), Fetch Rate crashes Gnucash and I cannot record any exchange rate for my transactions (invoices, payments). Do I understand you right, you are fetching quotes on all foreign currency transactions — several times a day? And the crash happens in the "Transfer Funds" dialog? I have tried reinstalling Online Price Retrieval, and a number of the "test" lines said "skipped", but I don't really know what I'm doing. And I'm still having the same problem. You will have to wait for the next F::Q release or apply the patch yourself on your current F::Q module. Very grateful for any assistance you can offer! Regards Frank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fetch rate crashing gnucash
Hello all! I am operating Windows 11 Home, Version 21H2, OS build 22000.856 I have just updated Gnucash to Version: 4.11, Build ID: 4.11+(2022-06-25), Finance::Quote: 1.49 I use fetch rate for USD (and occasionally EUR) conversions as some of my clients pay me in these currencies. My home currency is GBP. Unfortunately, since the most recent update (only installed today by me as I've been away), Fetch Rate crashes Gnucash and I cannot record any exchange rate for my transactions (invoices, payments). I have tried reinstalling Online Price Retrieval, and a number of the "test" lines said "skipped", but I don't really know what I'm doing. And I'm still having the same problem. Very grateful for any assistance you can offer! -- Samantha Payn ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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
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/M
Re: [GNC] Fwd: Re: Creating a customer report by location
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 throug
[GNC] Fwd: Re: Creating a customer report by location
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
___
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.
--
Derek Atkins 617-623-3745
de...@ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
___
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] Creating a customer report by location
Thank you for your reply, David. > On 6 Aug 2021, at 14:11, 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 >> 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 >> ___ >> 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] Creating a customer report by location
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 ___ 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] Creating a customer report by location
Can anyone tell me how to set up a report on income by customer location, please? Many thanks Samantha Payn ___ 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] Version 4.3 update
Have just found the .exe of version 4.4 online. Sorry to have troubled you all :) Thank you! On 27/01/2021 15:17 Samantha Payn <[1]saman...@boorertranslations.com> wrote: Hello, I'm just catching up with updates. Is there a reason why the update to version 4.3 is "gnucash-4.3.tar.bz2"? All my previous updates were just .exe files. Or can you please advise what I need to unzip a file like this. Many thanks Samantha ___ 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 ___ 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] Version 4.3 update
Hello, I'm just catching up with updates. Is there a reason why the update to version 4.3 is "gnucash-4.3.tar.bz2"? All my previous updates were just .exe files. Or can you please advise what I need to unzip a file like this. Many thanks Samantha ___ 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] UK specific: MTD - Making Tax Digital
If this is relevant to someone running a small business in the UK then I'm interested. -- Samantha Payn [1]www.boorertranslations.com http://www.proz.com/profile/947767 [2]https://uk.linkedin.com/in/samanthapayn On 15/01/2021 11:19 Alain D D Williams <[3]a...@phcomp.co.uk> wrote: On Thu, Jan 14, 2021 at 03:26:01AM -0600, [4]chr...@floatdene.com wrote: Hi, Is anyone interest in having a MTD bridge for GnuCash for VAT submissions? I have developed a bridge and would be happy to integrate it with GnuCash if there is still any interest. That would be of interest to me. I also know others for who a GPL submission bridge would be of interest - ie they have home grown accounting and need to submit to Making Tax Difficult. -- Alain Williams Linux/GNU Consultant - Mail systems, Web sites, Networking, Programmer, IT Lecturer. +44 (0) 787 668 0256 [5]https://www.phcomp.co.uk/ Parliament Hill Computers Ltd. Registration Information: [6]https://www.phcomp.co.uk/Contact.html #include ___ gnucash-user mailing list [7]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [8]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [9]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. http://www.boorertranslations.com/ 2. https://uk.linkedin.com/in/samanthapayn 3. mailto:a...@phcomp.co.uk 4. mailto:chr...@floatdene.com 5. https://www.phcomp.co.uk/ 6. https://www.phcomp.co.uk/Contact.html 7. mailto:gnucash-user@gnucash.org 8. https://lists.gnucash.org/mailman/listinfo/gnucash-user 9. https://wiki.gnucash.org/wiki/Mailing_Lists ___ 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] bulk operations?
Yes, I agree that the exchange rate has to be input. Whether you fetch the rate (also permitted by HMRC as I understand it) or input the rate manually it still has to be confirmed for each invoice when posting in Gnucash. Christopher Lam wrote >But it's crucial to input the exchange rate - and IIUC you are encouraged >to use >https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly > >On Mon, 7 Dec 2020 at 22:47, Samantha Payn >wrote: > >> >> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into >> Gnucash down to a fine art (especially with the recent “predictive text” >> input in my “product” fields! Thanks again for that, whoever it was!). It >> is specifically the step to confirm the exchange rate when posting an >> invoice which is the time consuming point. >> Samantha Payn >> >> > On 7 Dec 2020, at 22:25, Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> > >> > Samantha, you can import invoice data. >> > >> > Thus, if you have a way to easily create that data in a spreadsheet, you >> can save it as CSV, then import them to GnuCash. >> > >> > See the Help/Guide about importing business data for the required >> columns. >> > >> > I'm not certain if it works well with a foreign currency however. >> > >> > Regards, >> > Adrien >> > >> >> On 12/7/20 4:11 PM, Samantha Payn wrote: >> >> I’d find a “batch post invoice” function enormously helpful. I have a >> foreign currency client who insists on a separate invoice for each >> (sometimes inconsequential) amount and the multiple clicks to post the >> invoice and confirm the exchange rate for each one are time consuming. >> >> Currently the quickest I’ve got it is to create each invoice but not >> post it, then use “find invoice” criteria to call all the invoices up, >> highlight them all and then click “post” which prompts the exchange rate >> dialogue (for every invoice). I use “fetch rate” for the first invoice, and >> just “accept rate” for all the others, but that’s still three clicks per >> invoice (I think). >> >> Please could Santa bring me a “batch post invoice” function for >> Christmas? >> > >> > ___ >> > 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. >> ___ 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] bulk operations?
Thanks for the suggestion, Adrien. I’ve got entering the invoice data into Gnucash down to a fine art (especially with the recent “predictive text” input in my “product” fields! Thanks again for that, whoever it was!). It is specifically the step to confirm the exchange rate when posting an invoice which is the time consuming point. Samantha Payn > On 7 Dec 2020, at 22:25, Adrien Monteleone > wrote: > > Samantha, you can import invoice data. > > Thus, if you have a way to easily create that data in a spreadsheet, you can > save it as CSV, then import them to GnuCash. > > See the Help/Guide about importing business data for the required columns. > > I'm not certain if it works well with a foreign currency however. > > Regards, > Adrien > >> On 12/7/20 4:11 PM, Samantha Payn wrote: >> I’d find a “batch post invoice” function enormously helpful. I have a >> foreign currency client who insists on a separate invoice for each >> (sometimes inconsequential) amount and the multiple clicks to post the >> invoice and confirm the exchange rate for each one are time consuming. >> Currently the quickest I’ve got it is to create each invoice but not post >> it, then use “find invoice” criteria to call all the invoices up, highlight >> them all and then click “post” which prompts the exchange rate dialogue (for >> every invoice). I use “fetch rate” for the first invoice, and just “accept >> rate” for all the others, but that’s still three clicks per invoice (I >> think). >> Please could Santa bring me a “batch post invoice” function for Christmas? > > ___ > 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] bulk operations?
I’d find a “batch post invoice” function enormously helpful. I have a foreign currency client who insists on a separate invoice for each (sometimes inconsequential) amount and the multiple clicks to post the invoice and confirm the exchange rate for each one are time consuming. Currently the quickest I’ve got it is to create each invoice but not post it, then use “find invoice” criteria to call all the invoices up, highlight them all and then click “post” which prompts the exchange rate dialogue (for every invoice). I use “fetch rate” for the first invoice, and just “accept rate” for all the others, but that’s still three clicks per invoice (I think). Please could Santa bring me a “batch post invoice” function for Christmas? Samantha PAYN Mob: +44 7977 150053 > On 7 Dec 2020, at 22:01, Weiwu Zhang wrote: > > This issue comes up regularly with new users. The short answer to the > question is, "no, there is not a bulk edit." > > Instead of discouraging people to ask this because it's already discussed and > some suggestions are already archived, I feel starting the conversation again > is the only way to call out the importance of this feature so we might have a > formal solution that we can put into the document section. Gnucash cuts into > the prosumer market where users do need such "advanced" features. > > In fact I'm a bit disheartened that this question stopped reappearing sincer > 2017. Previously it showed up roughly yearly. It might be a sign that there > are less new users discovering gnucash, instead of people being more mature > and stopped asking without searching into the archives. > > The following is just an exmaple in 2017, the last year people still asked > for this. > >> On Sun, May 7, 2017 at 8:07, Eric Theise wrote: >> >> Suppose I'm in the "Search Results" window resulting from an "Edit > >> Find..." operation. Is there any way to apply a change to every >> transaction that appears? > >> Say that, due to history and multiple credit card accounts, a >> grocer's Description appears as "HI HO", "hi ho grocery", "hi-ho >> market", and permutations thereof. Is there any way to standardize >> the name for everything in the result set besides manually changing >> each line? > >> I'd also like to be able to perform bulk operations against >> "Imbalance-USD" transactions. > >> If it's not possible through the GUI, how about via issuing SQL >> statements to a database backend? > > ___ > 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] New User - can't modify inoice notes.
I have modified and saved the invoice format to suit my requirements as a Saved Report. Unfortunately when I upgrade to the newest version of Gnucash it loses all my saved reports. How can I prevent this happening in future, please? Samantha > On 26 Aug 2020, at 21:17, Derek Atkins wrote: > > Hi, > > Please be sure to CC gnucash-user on all your replies using your mailer's > reply-to-list or reply-all functionality so everyone can see your > responses and continue to help... > >> On Wed, August 26, 2020 4:02 pm, Lester Bennett wrote: >> I had already done that. I modify the Notes then click apply and the >> changes appear on the printable invoice screen. I then click Save Config >> but the next time I open the same invoice or create a new one it comes >> back to the default Notes. I want this to be the same for all future >> invoices. > > You would need to save it as a custom invoice, and then when you want to > print a new invoice you would need to run the custom version and then > choose the new invoice to print. You won't be able to do it from the > "Print Invoice" button. > > Another option is to just keep the configured printable invoice tab open, > and then again just select the new invoice from the options of that report > when you want to print a new invoice. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > > ___ > 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] Difficulty with online price retrieval
HURRAH! Thank you so much Geoff and John for your patience while I struggled with this. Geoff seems to have found the solution and I am enormously grateful to him, and to John Ralls who supported me in the earlier phases of this mystery. I hope not to trouble you again for a very long time! THANK YOU! Samantha On 26 August 2020 11:24 Geoff < [1]cleanoutmys...@gmail.com> wrote: Hi Samantha I see nothing wrong there - the SET command does not return any output. Please try the 3rd command - it should show you your key: echo %ALPHAVANTAGE_API_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter a problem trying to enter my API key at the CMD prompt. Way (way!) back John gave me two routes to start investigating the problem and the CMD prompt route didn't work so we stuck with the Powershell route. At that time I thought it was my inability to type commands correctly, but I have since been copy/pasting everything into Powershell, and today into the CMD prompt window. Please see attachment which shows a different result to the one your example does. Samantha On 26 August 2020 05:39 Geoff < [2]cleanoutmys...@gmail.com > wrote: >> >> Good morning Samantha >> >> Today's task is to repair your perl installation (specifically the >> missing "Date::Manip" module) so that gnucash can use the perl >> Finance::Quote module to retrieve currency exchange rates for you. >> >> I have tested this on my Windows 10 PC today by manually deleting the >> Date::Manip module then reinstalling it using the steps below. Note >> that instead of using Powershell as you have been doing to date, you >> will use the DOS Command Shell to enter the necessary commands. Please >> refer to the attached screenshots as you proceed. >> >> Screenshot: gnucsh_date_manip_1_command_prompt.jpg >> The objective here is to open a DOS Command Shell running with >> Administrator privileges. There several ways to do this, the one I have >> shown involves typing "cmd" into the search box on the left of the >> Windows task bar at the bottom of your screen. A new window will open >> titled "Administrator: Command Prompt". Type these 4 commands into that >> window - obviously using your own API Key: >> cd "C:\Program Files (x86)\gnucash\bin" >> set ALPHAVANTAGE_API_KEY=your_actual_key >> echo %ALPHAVANTAGE_API_KEY% >> install-fq-mods.cmd >> >> Screenshot: gnucsh_date_manip_2_installation.jpg >> The gnucash perl installation script is now running and you will see a >> heap of gobbledygook on your screen like this. >> >> Screenshot: gnucsh_date_manip_3_long_delay.jpg >> After a few minutes the installation will appear to "freeze" at this >> point. Just be patient and wait, I have seen it take over 30 minutes in >> some cases. >> >> Screenshot: gnucsh_date_manip_4_completion.jpg >> This is what it should look like after a successful installation. If >> you don't see this, please send details including a screenshot and we >> will decide the next steps. >> >> Screenshot: gnucsh_date_manip_5_testing.jpg >> Assuming you do have a successful installation, let's test it out by >> typing (or pasting) these 3 commands into the window: >> echo (currency "GBP" "EUR") | perl gnc-fq-helper >> echo (currency "USD" "GBP") | perl gnc-fq-helper >> echo (currency "USD" "EUR") | perl gnc-fq-helper >> >> >> Good luck! >> >> Geoff >> = >> >> On 25/08/2020 10:18 pm, Samantha Payn wrote: >>> Thanks Geoff! Sleep well! >>>> On 25 August 2020 13:17 Geoff < [4]cleanoutmys...@gmail.com >>>> >>>> >>> >> wrote: >> >> >> >> Ah hah! This could be the cause of all your problems. >> >> >> >> That error message says that your perl installation is missing a key >> >> component - the "Date::Manip" module. >> >> >> >> Explaining how to fix this will take a bit of effort, and as it is now >> >> bedtime in my part of the world, I will try to knock up some >> >> instructions for you tomorrow. >>
Re: [GNC] Difficulty with online price retrieval
Thanks very much for your quick response. I am totally out of my depth in the CMD window! On 26 August 2020 11:24 Geoff < [1]cleanoutmys...@gmail.com> wrote: Hi Samantha I see nothing wrong there - the SET command does not return any output. Please try the 3rd command - it should show you your key: echo %ALPHAVANTAGE_API_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter a problem trying to enter my API key at the CMD prompt. Way (way!) back John gave me two routes to start investigating the problem and the CMD prompt route didn't work so we stuck with the Powershell route. At that time I thought it was my inability to type commands correctly, but I have since been copy/pasting everything into Powershell, and today into the CMD prompt window. Please see attachment which shows a different result to the one your example does. Samantha On 26 August 2020 05:39 Geoff < [2]cleanoutmys...@gmail.com > wrote: >> >> Good morning Samantha >> >> Today's task is to repair your perl installation (specifically the >> missing "Date::Manip" module) so that gnucash can use the perl >> Finance::Quote module to retrieve currency exchange rates for you. >> >> I have tested this on my Windows 10 PC today by manually deleting the >> Date::Manip module then reinstalling it using the steps below. Note >> that instead of using Powershell as you have been doing to date, you >> will use the DOS Command Shell to enter the necessary commands. Please >> refer to the attached screenshots as you proceed. >> >> Screenshot: gnucsh_date_manip_1_command_prompt.jpg >> The objective here is to open a DOS Command Shell running with >> Administrator privileges. There several ways to do this, the one I have >> shown involves typing "cmd" into the search box on the left of the >> Windows task bar at the bottom of your screen. A new window will open >> titled "Administrator: Command Prompt". Type these 4 commands into that >> window - obviously using your own API Key: >> cd "C:\Program Files (x86)\gnucash\bin" >> set ALPHAVANTAGE_API_KEY=your_actual_key >> echo %ALPHAVANTAGE_API_KEY% >> install-fq-mods.cmd >> >> Screenshot: gnucsh_date_manip_2_installation.jpg >> The gnucash perl installation script is now running and you will see a >> heap of gobbledygook on your screen like this. >> >> Screenshot: gnucsh_date_manip_3_long_delay.jpg >> After a few minutes the installation will appear to "freeze" at this >> point. Just be patient and wait, I have seen it take over 30 minutes in >> some cases. >> >> Screenshot: gnucsh_date_manip_4_completion.jpg >> This is what it should look like after a successful installation. If >> you don't see this, please send details including a screenshot and we >> will decide the next steps. >> >> Screenshot: gnucsh_date_manip_5_testing.jpg >> Assuming you do have a successful installation, let's test it out by >> typing (or pasting) these 3 commands into the window: >> echo (currency "GBP" "EUR") | perl gnc-fq-helper >> echo (currency "USD" "GBP") | perl gnc-fq-helper >> echo (currency "USD" "EUR") | perl gnc-fq-helper >> >> >> Good luck! >> >> Geoff >> = >> >> On 25/08/2020 10:18 pm, Samantha Payn wrote: >>> Thanks Geoff! Sleep well! >>>> On 25 August 2020 13:17 Geoff < [4]cleanoutmys...@gmail.com >>>> >>>> >>> >> wrote: >> >> >> >> Ah hah! This could be the cause of all your problems. >> >> >> >> That error message says that your perl installation is missing a key >> >> component - the "Date::Manip" module. >> >> >> >> Explaining how to fix this will take a bit of effort, and as it is now >> >> bedtime in my part of the world, I will try to knock up some >> >> instructions for you tomorrow. >> >> >> >> Stay tuned. >> >> >> >> Geoff >> >> = >> >> >> >> On 25/08/2020 9:24 pm, Samantha Payn wrote: >> >>> Hi Geoff &
Re: [GNC] Difficulty with online price retrieval
Thanks Geoff! Sleep well! On 25 August 2020 13:17 Geoff < [1]cleanoutmys...@gmail.com> wrote: Ah hah! This could be the cause of all your problems. That error message says that your perl installation is missing a key component - the "Date::Manip" module. Explaining how to fix this will take a bit of effort, and as it is now bedtime in my part of the world, I will try to knock up some instructions for you tomorrow. Stay tuned. Geoff = On 25/08/2020 9:24 pm, Samantha Payn wrote: Hi Geoff Thanks for your suggestoins. This is what I get: PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = 'mykey' PS C:\Users\User> echo '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> echo '(currency "USD" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> echo '(currency "GBP" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> Thanks for taking up the cudgels on this one. Samantha On 25 August 2020 12:13 Geoff < [2]cleanoutmys...@gmail.com > wrote: >> >> Hi Samantha >> >> There were a couple of typos in the powershell command John asked you to >> run, which is why there was no output. >> >> Would you mind trying the following 4 powershell command lines please - >> with your actual API Key of course - and note the single quote at the >> end of each line: >> $Env:ALPHAVANTAGE_API_KEY = 'your_actual_key' >> echo '(currency "USD" "GBP")' | perl 'c:\Program Files >> (x86)\gnucash\bin\gnc-fq-helper' >> echo '(currency "USD" "EUR")' | perl 'c:\Program Files >> (x86)\gnucash\bin\gnc-fq-helper' >> echo '(currency "GBP" "EUR")' | perl 'c:\Program Files >> (x86)\gnucash\bin\gnc-fq-helper' >> >> >> I have attached a screenshot of the same commands on my Windows 10 PC. >> Fingers crossed they work on yours! >> >> Thanks for your patience. >> >> Geoff >> = >> >> On 25/08/2020 8:44 pm, Samantha Payn wrote: >>> Hi Geoff >>> My locale currency is GBP. As it was when this feature of Gnucash used >>> to work for me. >>> Thanks for taking the time to get involved. >>> Samantha >> On 25/08/2020 8:43 pm, Samantha Payn wrote: >> > Please do not apologise, John. I appreciate that you have other >> things >> > to do than help me :) >> > >> > This is what I get (I substituted my API key for xxx): >> > >> > PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = "xxx" >> > PS C:\Users\User> '(currency "USD" "GBP")' | perl 'c:\Program Files >> > (x86)\gnucash\bin\gnc-fq-helper >> > >> >> > >> > Thanks again for your time. >> > >> > Samantha >> > >> >> On 25 August 2020 09:42 Geoff < [4]cleanoutmys...@gmail.com >> >> >> > >> wrote: >> >> >> >> >> >> <<< Please excuse me for jumping in late on this thread >>> >> >> >> >> Samantha reported: ""when I click it I get an error window that says: >> >> "There was a system error while retrieving the pric
Re: [GNC] Difficulty with online price retrieval
Hi Geoff Thanks for your suggestoins. This is what I get: PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = 'mykey' PS C:\Users\User> echo '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> echo '(currency "USD" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> echo '(currency "GBP" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/vendor/lib C:/Strawberry/perl/lib) at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. BEGIN failed--compilation aborted at c:\Program Files (x86)\gnucash\bin\gnc-fq-helper line 29. PS C:\Users\User> Thanks for taking up the cudgels on this one. Samantha On 25 August 2020 12:13 Geoff < [1]cleanoutmys...@gmail.com> wrote: Hi Samantha There were a couple of typos in the powershell command John asked you to run, which is why there was no output. Would you mind trying the following 4 powershell command lines please - with your actual API Key of course - and note the single quote at the end of each line: $Env:ALPHAVANTAGE_API_KEY = 'your_actual_key' echo '(currency "USD" "GBP")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' echo '(currency "USD" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' echo '(currency "GBP" "EUR")' | perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-helper' I have attached a screenshot of the same commands on my Windows 10 PC. Fingers crossed they work on yours! Thanks for your patience. Geoff = On 25/08/2020 8:44 pm, Samantha Payn wrote: Hi Geoff My locale currency is GBP. As it was when this feature of Gnucash used to work for me. Thanks for taking the time to get involved. Samantha On 25/08/2020 8:43 pm, Samantha Payn wrote: > Please do not apologise, John. I appreciate that you have other things > to do than help me :) > > This is what I get (I substituted my API key for xxx): > > PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = "xxx" > PS C:\Users\User> '(currency "USD" "GBP")' | perl 'c:\Program Files > (x86)\gnucash\bin\gnc-fq-helper > >> > > Thanks again for your time. > > Samantha > >> On 25 August 2020 09:42 Geoff < [2]cleanoutmys...@gmail.com >> > wrote: >> >> >> <<< Please excuse me for jumping in late on this thread >>> >> >> Samantha reported: ""when I click it I get an error window that says: >> "There was a system error while retrieving the price quotes"."" >> >> Samantha's debug output shows the error message: >> >> * 10:15:31 DEBUG handling-request: (currency USD GBP) >> * 10:15:31 DEBUG results: # >> * 10:15:31 DEBUG handling-request: (currency EUR GBP) >> * 10:15:31 ERROR There was a system error while retrieving the >> price quotes. >> >> But *only* when two non-USD currencies are involved - EUR/GBP in this >> case. >> >> John - when you said you can't reproduce the problem your log only shows >> CAD/USD. Have you tried EUR/GBP? I have the same problem as Samantha >> when I try this, even though both gnc-fq-dump and gnc-gfq-helper are >> working OK. >> >> Samantha - would you mind checking in gnucash under "Edit / Preferences >> / Accounts" and telling us what your Default Currency setting is please? >> See attached screenshot for my settings - DO NOT change yours to mine. >> >> Thanks >> >> Geoff >> =
Re: [GNC] Difficulty with online price retrieval
Hi Geoff
My locale currency is GBP. As it was when this feature of Gnucash used
to work for me.
Thanks for taking the time to get involved.
Samantha
On 25 August 2020 09:42 Geoff < [1]cleanoutmys...@gmail.com> wrote:
<<< Please excuse me for jumping in late on this thread >>>
Samantha reported: ""when I click it I get an error window that says:
"There was a system error while retrieving the price quotes".""
Samantha's debug output shows the error message:
* 10:15:31 DEBUG handling-request: (currency USD GBP)
* 10:15:31 DEBUG results: #
* 10:15:31 DEBUG handling-request: (currency EUR GBP)
* 10:15:31 ERROR There was a system error while retrieving
the
price quotes.
But *only* when two non-USD currencies are involved - EUR/GBP in this
case.
John - when you said you can't reproduce the problem your log only
shows
CAD/USD. Have you tried EUR/GBP? I have the same problem as Samantha
when I try this, even though both gnc-fq-dump and gnc-gfq-helper are
working OK.
Samantha - would you mind checking in gnucash under "Edit / Preferences
/ Accounts" and telling us what your Default Currency setting is
please?
See attached screenshot for my settings - DO NOT change yours to mine.
Thanks
Geoff
=
<<< Feeel free to tell me to butt out if this isn't helpful >>>
On 25/08/2020 8:04 am, John Ralls wrote:
Samantha,
Sorry, yes, I got busy on other work.
# means that no quote information made it in to the code that
handles the quotes.
I can't reproduce the problem. Since you revealed your key I even used
that, worked fine:
* 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:34:57 DEBUG ALPHAVANTAGE_API_KEY=
* 14:34:57 DEBUG handling-request: (currency CAD USD)
* 14:35:04 DEBUG results: ((CAD (symbol . CAD)
(gnc:time-no-zone . 2020-08-24 14:34:58) (last . 15127/2) (currency
. USD)))
* 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
It does occur to me the US markets are closed at 10:15 BST, but I
suppose that you also checked with gnc-fq-dump around the same time and
that worked OK.
There's one other thing to try in Powershell but it would be odd if
gnc-fq-dump works and this doesn't:
$Env:ALPHAVANTAGE_API_KEY = 'xxx'
'(currency "USD" "GBP")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper
Should produce something like
(("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25")
(last . #e0.7658) (currency . "GBP")))
Regards,
John Ralls
On Aug 24, 2020, at 3:16 AM, Samantha Payn <
[2]saman...@boorertranslations.com> wrote:
>> Dear John and list
>> I think this response of mine from a week ago must have fallen
through the net?
>> Any assistance gratefully received
>> Samantha Payn
>>> -- Original Message --
>>> From: Samantha Payn < [3]saman...@boorertranslations.com>
>>> To: John Ralls < [4]jra...@ceridwen.us>
>>> CC: Gnucash Users < [5]gnucash-user@gnucash.org>
>>> Date: 17 August 2020 10:19
>>> Subject: Re: [GNC] Difficulty with online price retrieval
>>>
>>>
>>> John, thank you for your continued patience!
>>> This is what I got:
>>> * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard
>>> * 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
>>> * 10:13:32 DEBUG dir-files=(view-column trial-balance
transaction taxinvoice register reconcile-report receivables receipt
price-scatter portfolio payables owner-report new-owner-report
new-aging net-charts lot-viewer job-report invoice income-statement
income-gst-statement general-ledger general-journal equity-statement
dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
balance-forecast advanced-portfolio account-summary account-piecharts)
>>> * 10:13:32 DEBUG rpt-subdir=gnucash/reports/example
>>> * 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
>>> * 10:13:32 DEBUG dir-files=(welcome-to-gnucash
sample-graphs hello-world daily-reports average-b
Re: [GNC] Difficulty with online price retrieval
Please do not apologise, John. I appreciate that you have other things
to do than help me :)
This is what I get (I substituted my API key for xxx):
PS C:\Users\User> $Env:ALPHAVANTAGE_API_KEY = "xxx"
PS C:\Users\User> '(currency "USD" "GBP")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper
>>
Thanks again for your time.
Samantha
On 24 August 2020 23:04 John Ralls < [1]jra...@ceridwen.us> wrote:
Samantha,
Sorry, yes, I got busy on other work.
# means that no quote information made it in to the code that
handles the quotes.
I can't reproduce the problem. Since you revealed your key I even used
that, worked fine:
* 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:34:32 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:34:57 DEBUG ALPHAVANTAGE_API_KEY=
* 14:34:57 DEBUG handling-request: (currency CAD USD)
* 14:35:04 DEBUG results: ((CAD (symbol . CAD)
(gnc:time-no-zone . 2020-08-24 14:34:58) (last . 15127/2) (currency
. USD)))
* 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
* 14:35:04 WARN [gnc_numeric_to_decimal()] Rounding required when
'never round' specified.
It does occur to me the US markets are closed at 10:15 BST, but I
suppose that you also checked with gnc-fq-dump around the same time and
that worked OK.
There's one other thing to try in Powershell but it would be odd if
gnc-fq-dump works and this doesn't:
$Env:ALPHAVANTAGE_API_KEY = 'xxx'
'(currency "USD" "GBP")' | perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-helper
Should produce something like
(("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25")
(last . #e0.7658) (currency . "GBP")))
Regards,
John Ralls
On Aug 24, 2020, at 3:16 AM, Samantha Payn <
[2]saman...@boorertranslations.com> wrote:
Dear John and list
I think this response of mine from a week ago must have fallen through
the net?
Any assistance gratefully received
Samantha Payn
-- Original Message --
From: Samantha Payn < [3]saman...@boorertranslations.com>
To: John Ralls < [4]jra...@ceridwen.us>
CC: Gnucash Users < [5]gnucash-user@gnucash.org>
Date: 17 August 2020 10:19
Subject: Re: [GNC] Difficulty with online price retrieval
John, thank you for your continued patience!
This is what I got:
* 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard
* 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 10:13:32 DEBUG dir-files=(view-column trial-balance
transaction taxinvoice register reconcile-report receivables receipt
price-scatter portfolio payables owner-report new-owner-report
new-aging net-charts lot-viewer job-report invoice income-statement
income-gst-statement general-ledger general-journal equity-statement
dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
balance-forecast advanced-portfolio account-summary account-piecharts)
* 10:13:32 DEBUG rpt-subdir=gnucash/reports/example
* 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
* 10:13:32 DEBUG dir-files=(welcome-to-gnucash sample-graphs
hello-world daily-reports average-balance)
* 10:13:32 DEBUG
rpt-subdir=gnucash/reports/locale-specific/us
* 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
* 10:13:32 DEBUG dir-files=(taxtxf)
* 10:13:32 DEBUG rpt-subdir=gnucash/report/stylesheets
* 10:13:32 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
* 10:13:32 DEBUG dir-files=(plain head-or-tail footer css)
* 10:13:33 DEBUG gnc:fq-check-sources results: (1.49 adig aex
aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet
bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest
cse deka dutch dwsfunds europe fetch_live_currencies fidelity
fidelity_direct fidelityfixed financecanada finanzpartner finland fool
france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney
greece hex hu hufund hungary hustock iexcloud indiamutual
known_currencies lerevenu maninv morningstar morningstarau
morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania
seb_funds sixfunds sixshares stockhousecanada_fund tdefunds
tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp
tsx uk_unit_trusts ukfunds unionfunds usa u
[GNC] Fwd: Re: Difficulty with online price retrieval
Dear John and list I think this response of mine from a week ago must have fallen through the net? Any assistance gratefully received Samantha Payn -- Original Message -- From: Samantha Payn To: John Ralls CC: Gnucash Users Date: 17 August 2020 10:19 Subject: Re: [GNC] Difficulty with online price retrieval John, thank you for your continued patience! This is what I got: * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 10:13:32 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 10:13:32 DEBUG rpt-subdir=gnucash/reports/example * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 10:13:32 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 10:13:32 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 10:13:32 DEBUG dir-files=(taxtxf) * 10:13:32 DEBUG rpt-subdir=gnucash/report/stylesheets * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets * 10:13:32 DEBUG dir-files=(plain head-or-tail footer css) * 10:13:33 DEBUG gnc:fq-check-sources results: (1.49 adig aex aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct fidelityfixed financecanada finanzpartner finland fool france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney greece hex hu hufund hungary hustock iexcloud indiamutual known_currencies lerevenu maninv morningstar morningstarau morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania seb_funds sixfunds sixshares stockhousecanada_fund tdefunds tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd yahoo_json yahoo_yql za za_unittrusts) * 10:13:33 MESSG Found Finance::Quote version 1.49 * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:30 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:31 DEBUG ALPHAVANTAGE_API_KEY=7HZ0P6PV6VC2GODA * 10:15:31 DEBUG handling-request: (currency USD GBP) * 10:15:31 DEBUG results: # * 10:15:31 DEBUG handling-request: (currency EUR GBP) * 10:15:31 ERROR There was a system error while retrieving the price quotes. * 10:15:37 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. * 10:15:37 WARN [gnc_numeric_to_decimal()] Rounding required when 'never round' specified. On 15 August 2020 19:20 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Run GnuCash from Powershell as you did before: & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug (The last time the command was & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that last command, --nofile, tells GnuCash to not open the previous data file. Last time I didn't need to see anything from a data file and starting GnuCash without one is faster. This time I do want you to have access to your data file.) This time edit an exchange rate on an existing multi-currency transaction and use the Fetch Rate button to attempt to get an online quote. Dismiss the error dialog, cancel the edit, and quit GnuCash. Then list the log files
Re: [GNC] Difficulty with online price retrieval
hat's the file name from last time, you'll replace VEQEP0 with whatever is in the latest file's name.) And copy and paste them into a reply. Regards, John Ralls On Aug 15, 2020, at 6:42 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: I am sorry John, do what? I am afraid I just do not understand "Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file." I am such a beginner with the Powershell window stuff, all I can do is copy/paste what you provide. This problem has been so drawn out that we both lost sight of the fact that I had originally raised the issue over "Fetch Rates" for foreign currency transactions in my business. Yours apologetically Samantha On 13 August 2020 01:30 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, OK. Please do it when running GnuCash from Powershell with the --log gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log. Regards, John Ralls On Aug 12, 2020, at 6:54 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which returns the error message. I only use Gnucash for my business accounts and have no need of the "Get Quotes" button. On 11 August 2020 18:54 John Ralls < [5]jra...@ceridwen.us> wrote: Samantha, Sorry, I lost that in the ensuing conversation about how to work Powershell and got hung up on the previous no Get Rate button issue. The Fetch Rate and Get Quotes buttons work a bit differently from each other: The first looks only at the currencies involved in the transaction you're entering and the latter tries to retrieve rates for all of the currencies in your book. Can you try the Fetch Rate button? You can do that most easily by editing the rate on a foreign currency split. (Open a foreign currency transaction, put it in split view, select a split in the "other" currency, right-click and pick Edit Exchange Rate from the context menu. Note that which currency is the "other" one depends on which account you started the transaction from so it might be GBP if you created the transaction starting from an account denominated in, say, EUR.) Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file. Regards, John Ralls On Aug 11, 2020, at 5:00 AM, Samantha Payn < [6]saman...@boorertranslations.com> wrote: I'm afraid the problem has not been solved. The Get Quotes button does light up (as I mentioned in an email to the list just after I first reported the problem), but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". Thank you for your persisitance and continued support. Samantha On 11 August 2020 00:51 John Ralls < [7]jra...@ceridwen.us> wrote: Good. It succeeded in finding Finance::Quote from the command line. That should be sufficient to enable the Fetch Rate button. Was it enabled? Regards, John Ralls On Aug 10, 2020, at 12:06 PM, Samantha Payn < [8]saman...@boorertranslations.com> wrote: Hi John I did what you suggest and this is what I got: PS C:\Users\User> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log * 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard * 11:46:06 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 11:46:06 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/example * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 11:46:07 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 11:46:07 DEBUG dir-
Re: [GNC] Difficulty with online price retrieval
I am sorry John, do what? I am afraid I just do not understand "Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file." I am such a beginner with the Powershell window stuff, all I can do is copy/paste what you provide. This problem has been so drawn out that we both lost sight of the fact that I had originally raised the issue over "Fetch Rates" for foreign currency transactions in my business. Yours apologetically Samantha On 13 August 2020 01:30 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, OK. Please do it when running GnuCash from Powershell with the --log gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log. Regards, John Ralls On Aug 12, 2020, at 6:54 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which returns the error message. I only use Gnucash for my business accounts and have no need of the "Get Quotes" button. On 11 August 2020 18:54 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, Sorry, I lost that in the ensuing conversation about how to work Powershell and got hung up on the previous no Get Rate button issue. The Fetch Rate and Get Quotes buttons work a bit differently from each other: The first looks only at the currencies involved in the transaction you're entering and the latter tries to retrieve rates for all of the currencies in your book. Can you try the Fetch Rate button? You can do that most easily by editing the rate on a foreign currency split. (Open a foreign currency transaction, put it in split view, select a split in the "other" currency, right-click and pick Edit Exchange Rate from the context menu. Note that which currency is the "other" one depends on which account you started the transaction from so it might be GBP if you created the transaction starting from an account denominated in, say, EUR.) Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file. Regards, John Ralls On Aug 11, 2020, at 5:00 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: I'm afraid the problem has not been solved. The Get Quotes button does light up (as I mentioned in an email to the list just after I first reported the problem), but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". Thank you for your persisitance and continued support. Samantha On 11 August 2020 00:51 John Ralls < [5]jra...@ceridwen.us> wrote: Good. It succeeded in finding Finance::Quote from the command line. That should be sufficient to enable the Fetch Rate button. Was it enabled? Regards, John Ralls On Aug 10, 2020, at 12:06 PM, Samantha Payn < [6]saman...@boorertranslations.com> wrote: Hi John I did what you suggest and this is what I got: PS C:\Users\User> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log * 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard * 11:46:06 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 11:46:06 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/example * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 11:46:07 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 11:46:07 DEBUG dir-files=(taxtxf) * 11:46:07 DEBUG rpt-subdir=gnucash/report/stylesheets * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets * 11:46:07 DEBUG dir-files=(plain head-or-tail footer css) * 11:46:10 DEBUG gn
Re: [GNC] Difficulty with online price retrieval
John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which returns the error message. I only use Gnucash for my business accounts and have no need of the "Get Quotes" button. On 11 August 2020 18:54 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Sorry, I lost that in the ensuing conversation about how to work Powershell and got hung up on the previous no Get Rate button issue. The Fetch Rate and Get Quotes buttons work a bit differently from each other: The first looks only at the currencies involved in the transaction you're entering and the latter tries to retrieve rates for all of the currencies in your book. Can you try the Fetch Rate button? You can do that most easily by editing the rate on a foreign currency split. (Open a foreign currency transaction, put it in split view, select a split in the "other" currency, right-click and pick Edit Exchange Rate from the context menu. Note that which currency is the "other" one depends on which account you started the transaction from so it might be GBP if you created the transaction starting from an account denominated in, say, EUR.) Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file. Regards, John Ralls On Aug 11, 2020, at 5:00 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: I'm afraid the problem has not been solved. The Get Quotes button does light up (as I mentioned in an email to the list just after I first reported the problem), but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". Thank you for your persisitance and continued support. Samantha On 11 August 2020 00:51 John Ralls < [3]jra...@ceridwen.us> wrote: Good. It succeeded in finding Finance::Quote from the command line. That should be sufficient to enable the Fetch Rate button. Was it enabled? Regards, John Ralls On Aug 10, 2020, at 12:06 PM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Hi John I did what you suggest and this is what I got: PS C:\Users\User> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log * 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard * 11:46:06 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 11:46:06 DEBUG dir-files=(view-column trial-balance transaction taxinvoice register reconcile-report receivables receipt price-scatter portfolio payables owner-report new-owner-report new-aging net-charts lot-viewer job-report invoice income-statement income-gst-statement general-ledger general-journal equity-statement dashboard customer-summary category-barchart cashflow-barchart cash-flow budget budget-income-statement budget-flow budget-barchart budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet balance-forecast advanced-portfolio account-summary account-piecharts) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/example * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example * 11:46:07 DEBUG dir-files=(welcome-to-gnucash sample-graphs hello-world daily-reports average-balance) * 11:46:07 DEBUG rpt-subdir=gnucash/reports/locale-specific/us * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us * 11:46:07 DEBUG dir-files=(taxtxf) * 11:46:07 DEBUG rpt-subdir=gnucash/report/stylesheets * 11:46:07 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets * 11:46:07 DEBUG dir-files=(plain head-or-tail footer css) * 11:46:10 DEBUG gnc:fq-check-sources results: (1.49 adig aex aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest cse deka dutch dwsfunds europe fetch_live_currencies fidelity fidelity_direct fidelityfixed financecanada finanzpartner finland fool france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney greece hex hu hufund hungary hustock iexcloud indiamutual known_currencies lerevenu maninv morningstar morningstarau morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania seb_funds sixfunds sixshares stockhousecanada_fund tdefunds tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd yahoo_json yahoo_yql za za_unittrusts) * 11:46:10 MESSG Found Finance::Quote version 1.49 PS C:\Users\User> Cheers Samantha On 10 August 2020 16:37 Joh
Re: [GNC] Difficulty with online price retrieval
I'm afraid the problem has not been solved.
The Get Quotes button does light up (as I mentioned in an email to the
list just after I first reported the problem), but when I click it I
get an error window that says: "There was a system error while
retrieving the price quotes".
Thank you for your persisitance and continued support.
Samantha
On 11 August 2020 00:51 John Ralls < [1]jra...@ceridwen.us> wrote:
Good. It succeeded in finding Finance::Quote from the command line.
That should be sufficient to enable the Fetch Rate button. Was it
enabled?
Regards,
John Ralls
On Aug 10, 2020, at 12:06 PM, Samantha Payn <
[2]saman...@boorertranslations.com> wrote:
Hi John
I did what you suggest and this is what I got:
PS C:\Users\User> Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
* 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard
* 11:46:06 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 11:46:06 DEBUG dir-files=(view-column trial-balance
transaction taxinvoice register reconcile-report receivables receipt
price-scatter portfolio payables owner-report new-owner-report
new-aging net-charts lot-viewer job-report invoice income-statement
income-gst-statement general-ledger general-journal equity-statement
dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
balance-forecast advanced-portfolio account-summary account-piecharts)
* 11:46:07 DEBUG rpt-subdir=gnucash/reports/example
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
* 11:46:07 DEBUG dir-files=(welcome-to-gnucash sample-graphs
hello-world daily-reports average-balance)
* 11:46:07 DEBUG
rpt-subdir=gnucash/reports/locale-specific/us
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
* 11:46:07 DEBUG dir-files=(taxtxf)
* 11:46:07 DEBUG rpt-subdir=gnucash/report/stylesheets
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
* 11:46:07 DEBUG dir-files=(plain head-or-tail footer css)
* 11:46:10 DEBUG gnc:fq-check-sources results: (1.49 adig aex
aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet
bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest
cse deka dutch dwsfunds europe fetch_live_currencies fidelity
fidelity_direct fidelityfixed financecanada finanzpartner finland fool
france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney
greece hex hu hufund hungary hustock iexcloud indiamutual
known_currencies lerevenu maninv morningstar morningstarau
morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania
seb_funds sixfunds sixshares stockhousecanada_fund tdefunds
tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp
tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd
yahoo_json yahoo_yql za za_unittrusts)
* 11:46:10 MESSG Found Finance::Quote version 1.49
PS C:\Users\User>
Cheers
Samantha
On 10 August 2020 16:37 John Ralls < [3]jra...@ceridwen.us> wrote:
On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
[4]frank.h.ellenber...@gmail.com> wrote:
Samanta,
Am 10.08.20 um 12:53 schrieb Samantha Payn:
But you lost me at the next bit.
PS C:\Users\User> Get-ChildItem -Path
$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
Sort-Object -Property Date
Directory: C:\Users\User\AppData\Local\Temp
Mode LastWriteTime Length Name
- --
-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
PS C:\Users\User>
Where do I substitute the most recent file name from my listing? Which
listing?
Awaiting further guidance and thanks again.
Samantha
In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46
Samantha,
Specifically, run
Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQ
Re: [GNC] Difficulty with online price retrieval
Hi John
I did what you suggest and this is what I got:
PS C:\Users\User> Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
* 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard
* 11:46:06 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
* 11:46:06 DEBUG dir-files=(view-column trial-balance
transaction taxinvoice register reconcile-report receivables receipt
price-scatter portfolio payables owner-report new-owner-report
new-aging net-charts lot-viewer job-report invoice income-statement
income-gst-statement general-ledger general-journal equity-statement
dashboard customer-summary category-barchart cashflow-barchart
cash-flow budget budget-income-statement budget-flow budget-barchart
budget-balance-sheet balsheet-pnl balsheet-eg balance-sheet
balance-forecast advanced-portfolio account-summary account-piecharts)
* 11:46:07 DEBUG rpt-subdir=gnucash/reports/example
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
* 11:46:07 DEBUG dir-files=(welcome-to-gnucash sample-graphs
hello-world daily-reports average-balance)
* 11:46:07 DEBUG
rpt-subdir=gnucash/reports/locale-specific/us
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
* 11:46:07 DEBUG dir-files=(taxtxf)
* 11:46:07 DEBUG rpt-subdir=gnucash/report/stylesheets
* 11:46:07 DEBUG mod-dir=C:\Program Files
(x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
* 11:46:07 DEBUG dir-files=(plain head-or-tail footer css)
* 11:46:10 DEBUG gnc:fq-check-sources results: (1.49 adig aex
aiahk alphavantage amfiindia asegr asx aufunds australia bamosz bet
bmonesbittburns bourso bse bsero canada canadamutual citywire cominvest
cse deka dutch dwsfunds europe fetch_live_currencies fidelity
fidelity_direct fidelityfixed financecanada finanzpartner finland fool
france ftfunds ftportfolios ftportfolios_direct fundlibrary goldmoney
greece hex hu hufund hungary hustock iexcloud indiamutual
known_currencies lerevenu maninv morningstar morningstarau
morningstarch morningstarjp mstaruk nasdaq nyse nz nzx platinum romania
seb_funds sixfunds sixshares stockhousecanada_fund tdefunds
tdwaterhouse tiaacref tnetuk troweprice troweprice_direct trustnet tsp
tsx uk_unit_trusts ukfunds unionfunds usa usfedbonds vanguard vwd
yahoo_json yahoo_yql za za_unittrusts)
* 11:46:10 MESSG Found Finance::Quote version 1.49
PS C:\Users\User>
Cheers
Samantha
On 10 August 2020 16:37 John Ralls < [1]jra...@ceridwen.us> wrote:
On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
[2]frank.h.ellenber...@gmail.com> wrote:
Samanta,
Am 10.08.20 um 12:53 schrieb Samantha Payn:
But you lost me at the next bit.
PS C:\Users\User> Get-ChildItem -Path
$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
Sort-Object -Property Date
Directory: C:\Users\User\AppData\Local\Temp
Mode LastWriteTime Length Name
- --
-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
PS C:\Users\User>
Where do I substitute the most recent file name from my listing? Which
listing?
Awaiting further guidance and thanks again.
Samantha
In this case it is the 2nd: gnucash.trace.VEQEP0.log created 10/08/2020
11:46
Samantha,
Specifically, run
Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
and paste the results into a reply.
Regards,
John Ralls
References
1. mailto:jra...@ceridwen.us
2. mailto:frank.h.ellenber...@gmail.com
___
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] Difficulty with online price retrieval
Hi John
Thank you for your continued support.
This is the path displayed for Strawberry Perl.
PS C:\Users\User> [Environment]::GetEnvironmentVariable('PATH',
'MACHINE')
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syst
em32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Strawberry
\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin
And doing this did start Gnucash.
PS C:\Users\User> & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe'
--log gnc.scm=debug --nofile
PS C:\Users\User>
It opened it as though I'd never used it before, inviting me to create
files. As I closed it I did see that my accounts file was listed.
But you lost me at the next bit.
PS C:\Users\User> Get-ChildItem -Path
$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* |
Sort-Object -Property Date
Directory: C:\Users\User\AppData\Local\Temp
Mode LastWriteTime Length Name
- --
-a 05/08/2020 11:18 1576 gnucash.trace.WQ4HO0.log
-a 10/08/2020 11:46 2448 gnucash.trace.VEQEP0.log
-a 04/08/2020 15:12 0 gnucash.trace.SH4XO0.log
-a 04/08/2020 12:26 0 gnucash.trace.ZJ8NO0.log
-a 08/08/2020 12:54 0 gnucash.trace.XLZHO0.log
-a 07/08/2020 13:19 196 gnucash.trace.WZBOO0.log
-a 07/08/2020 08:23 0 gnucash.trace.DSTNO0.log
-a 07/08/2020 08:38 265 gnucash.trace.AH40O0.log
-a 08/08/2020 13:33 0 gnucash.trace.4DLHO0.log
-a 05/08/2020 10:02 0 gnucash.trace.QBQJO0.log
-a 08/08/2020 14:46 3615 gnucash.trace.NZUWO0.log
-a 07/08/2020 15:58 20233 gnucash.trace.GFEZO0.log
PS C:\Users\User>
Where do I substitute the most recent file name from my listing? Which
listing?
Awaiting further guidance and thanks again.
Samantha
On 8 August 2020 21:28 John Ralls < [1]jra...@ceridwen.us> wrote:
Samantha,
So Finance::Quote is correctly installed. Maybe GnuCash isn't finding
perl. Run the following in Poweshell:
[Environment]::GetEnvironmentVariable('PATH', 'MACHINE')
Make sure that it lists the correct Strawberry Perl path. Those square
brackets around Environment are part of the command.
Next, start GnuCash from Powershell as follows:
& 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug
--nofile
Just quit when it finishes starting. Find the most recent trace file
Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp -filter
gnucash.trace.* | Sort-Object -Property Date
and display it (substitute the most recent file name from your listing)
Get-Content
$Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.RSHPO0.log
Regards,
John Ralls
On Aug 8, 2020, at 6:00 AM, Samantha Payn <
[2]saman...@boorertranslations.com> wrote:
John, thank you for these corrections. In Powershell they brought
results as below:
PS C:\Users\User> cd "C:\Program Files (x86)\gnucash\bin\"
PS C:\Program Files (x86)\gnucash\bin> $Env:ALPHAVANTAGE_API_KEY = "
APIKEY"
PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-dump' currency USD GBP
1 USD = 0.76587 GBP
PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files
(x86)\gnucash\bin\gnc-fq-dump' currency EUR GBP
1 EUR = 0.9031 GBP
PS C:\Program Files (x86)\gnucash\bin>
(In the CMD window I still had a syntax error, but let's just carry on
with Powershell).
But Gnucash still doesn't fetch the rate for me.
And by the way I love the predictive text infill - such a time saver!
Best regards
Samantha
On 7 August 2020 20:08 John Ralls < [3]jra...@ceridwen.us> wrote:
Samantha,
Pardon the inlining:
On Aug 7, 2020, at 6:00 AM, Samantha Payn <
[4]saman...@boorertranslations.com> wrote:
John, I appreciate why you wish to keep this on list and so thank you
and everyone for your patience while I stumble through.
Sorry but I am such a beginner with CMD and Powershell environment that
initially I took your references to CMD and Powershell as part of the
code I should be typing.
Background: running Windows 10 home, regularly updated. Updated to the
most recent version of Gnucash: Gnucash Version: 4.1, Build ID:
4.1+(2020-07-25), Finance::Quote: 1.49. Problem started when I changed
my PC and reinstalled gnucash. Prior to this I had been using Gnucash
for transactions in three currencies without problem.
Now, when posting invoices in “foreign” currency the Get Quotes button
lights up, but when I click it I get an error window that says: "There
was a system error while retrieving the price quotes". The invoice then
appears to be posted but I have no confidence the currency exchange has
been handled correctly.
These are the results I get from following John’s guidance for testing:
I
Re: [GNC] Difficulty with online price retrieval
John, thank you for these corrections. In Powershell they brought results as below: PS C:\Users\User> cd "C:\Program Files (x86)\gnucash\bin\" PS C:\Program Files (x86)\gnucash\bin> $Env:ALPHAVANTAGE_API_KEY = " APIKEY" PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump' currency USD GBP 1 USD = 0.76587 GBP PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump' currency EUR GBP 1 EUR = 0.9031 GBP PS C:\Program Files (x86)\gnucash\bin> (In the CMD window I still had a syntax error, but let's just carry on with Powershell). But Gnucash still doesn't fetch the rate for me. And by the way I love the predictive text infill - such a time saver! Best regards Samantha On 7 August 2020 20:08 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Pardon the inlining: On Aug 7, 2020, at 6:00 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, I appreciate why you wish to keep this on list and so thank you and everyone for your patience while I stumble through. Sorry but I am such a beginner with CMD and Powershell environment that initially I took your references to CMD and Powershell as part of the code I should be typing. Background: running Windows 10 home, regularly updated. Updated to the most recent version of Gnucash: Gnucash Version: 4.1, Build ID: 4.1+(2020-07-25), Finance::Quote: 1.49. Problem started when I changed my PC and reinstalled gnucash. Prior to this I had been using Gnucash for transactions in three currencies without problem. Now, when posting invoices in “foreign” currency the Get Quotes button lights up, but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". The invoice then appears to be posted but I have no confidence the currency exchange has been handled correctly. These are the results I get from following John’s guidance for testing: In powershell window: PS C:\Users\User> cd "C:\Program Files (x86)\gnucash\bin\" PS C:\Program Files (x86)\gnucash\bin> $Env:ALPHAVANTAGE_API_KEY = " APIKEY" PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP ^ The marked quote is in the wrong place. It needs to go at the end of dump, as in ...gnc-fq-dump' currency USD GBP Can't open perl script "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency": No such file or directory So that Windows doesn't think that it's part of the perl script's name. PS C:\Program Files (x86)\gnucash\bin> Type is variously yellow (cd, perl), lime green ($Env:ALPHAVANTAGE_API_KEY ) and sea green (after the lime green text) or white at the start of each line. In CMD window: C:\Users\User>cd C:\Program Files (x86)\gnucash\bin C:\Program Files (x86)\gnucash\bin>set ALPHAVANTAGE_API_KEY The syntax of the command is incorrect. Sorry, that should be set ALPHAVANTAGE_API_KEY= Note no spaces between the variable name, equal sign, and value. Regards, John Ralls In an effort not to mistype anything I mostly copy and paste from John's guidance. I will attempt to follow up on any advice given from now on more promptly and thanks in advance for all assistance offered. Samantha On 7 August 2020 00:56 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, I'd prefer to keep everything on the list. I'm not regularly a Windows user and someone who is might be able to chime in with more help. I think you have a CMD shell there rather than a Powershell. Powershell would color $Env:ALPHAVANTAGE_API_KEY bright green no matter what else you typed and it puts a space between the prompt and your input. CMD doesn't color anything and doesn't separate the prompt from the input with a space. To set an environment variable in CMD you do SET ALPHAVANTAGE_API_KEY making the obvious substitution. No quotes are needed, and the angle braces are part of the substitution. Regards, John Ralls On Aug 5, 2020, at 2:17 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Hi John Sorry for my lengthy silence. I have attempted to follow your instructions but so far without success. This is as far as I have got: C:\Program Files (x86)\gnucash\bin>$Env:ALPHAVANTAGE_API_KEY = "[my alphavantage key" The filename, directory name, or volume label syntax is incorrect. All text in white. If you are willing to help me further, John, perhaps we should take this off the mailing list as at the moment the problems are with my inexperience in the Powershell environment, rather than with gn
Re: [GNC] Difficulty with online price retrieval
John, I appreciate why you wish to keep this on list and so thank you and everyone for your patience while I stumble through. Sorry but I am such a beginner with CMD and Powershell environment that initially I took your references to CMD and Powershell as part of the code I should be typing. Background: running Windows 10 home, regularly updated. Updated to the most recent version of Gnucash: Gnucash Version: 4.1, Build ID: 4.1+(2020-07-25), Finance::Quote: 1.49. Problem started when I changed my PC and reinstalled gnucash. Prior to this I had been using Gnucash for transactions in three currencies without problem. Now, when posting invoices in “foreign” currency the Get Quotes button lights up, but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". The invoice then appears to be posted but I have no confidence the currency exchange has been handled correctly. These are the results I get from following John’s guidance for testing: In powershell window: PS C:\Users\User> cd "C:\Program Files (x86)\gnucash\bin\" PS C:\Program Files (x86)\gnucash\bin> $Env:ALPHAVANTAGE_API_KEY = " APIKEY" PS C:\Program Files (x86)\gnucash\bin> perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP Can't open perl script "c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency": No such file or directory PS C:\Program Files (x86)\gnucash\bin> Type is variously yellow (cd, perl), lime green ($Env:ALPHAVANTAGE_API_KEY ) and sea green (after the lime green text) or white at the start of each line. In CMD window: C:\Users\User>cd C:\Program Files (x86)\gnucash\bin C:\Program Files (x86)\gnucash\bin>set ALPHAVANTAGE_API_KEY The syntax of the command is incorrect. In an effort not to mistype anything I mostly copy and paste from John's guidance. I will attempt to follow up on any advice given from now on more promptly and thanks in advance for all assistance offered. Samantha On 7 August 2020 00:56 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, I'd prefer to keep everything on the list. I'm not regularly a Windows user and someone who is might be able to chime in with more help. I think you have a CMD shell there rather than a Powershell. Powershell would color $Env:ALPHAVANTAGE_API_KEY bright green no matter what else you typed and it puts a space between the prompt and your input. CMD doesn't color anything and doesn't separate the prompt from the input with a space. To set an environment variable in CMD you do SET ALPHAVANTAGE_API_KEY making the obvious substitution. No quotes are needed, and the angle braces are part of the substitution. Regards, John Ralls On Aug 5, 2020, at 2:17 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Hi John Sorry for my lengthy silence. I have attempted to follow your instructions but so far without success. This is as far as I have got: C:\Program Files (x86)\gnucash\bin>$Env:ALPHAVANTAGE_API_KEY = "[my alphavantage key" The filename, directory name, or volume label syntax is incorrect. All text in white. If you are willing to help me further, John, perhaps we should take this off the mailing list as at the moment the problems are with my inexperience in the Powershell environment, rather than with gnucash itself? Many thanks for your assistance so far and hoping for your continued patience. Samantha On 27 July 2020 20:16 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, Regardless of the shell you must enclose paths with spaces in quotes, e.g. cd "c:\Program Files (86)\gnucash\bin" You can use ' instead of " if you like. You can also start typing and use tab completion, for example type cd c:\prog and the shell will change it to cd 'C:\Program Files\' You can then backspace out the \', type a space and again and it will fill in the (x86)\' for you. Regards, John Ralls On Jul 27, 2020, at 12:01 PM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Sorry John (and everyone). I can't get it to accept (x86) now: C:\Users\User> cd C:\Program Files (x86)\gnucash\bin x86 : The term 'x86' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:22 + cd C:\Program Files (x86)\gnucash\bin + ~~~ + CategoryInfo : ObjectNotFound: (x86:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException So sorry. Instead of bothering you guys should I try to get local help? Best wishe
Re: [GNC] Difficulty with online price retrieval
Hi John Sorry for my lengthy silence. I have attempted to follow your instructions but so far without success. This is as far as I have got: C:\Program Files (x86)\gnucash\bin>$Env:ALPHAVANTAGE_API_KEY = "[my alphavantage key" The filename, directory name, or volume label syntax is incorrect. All text in white. If you are willing to help me further, John, perhaps we should take this off the mailing list as at the moment the problems are with my inexperience in the Powershell environment, rather than with gnucash itself? Many thanks for your assistance so far and hoping for your continued patience. Samantha On 27 July 2020 20:16 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Regardless of the shell you must enclose paths with spaces in quotes, e.g. cd "c:\Program Files (86)\gnucash\bin" You can use ' instead of " if you like. You can also start typing and use tab completion, for example type cd c:\prog and the shell will change it to cd 'C:\Program Files\' You can then backspace out the \', type a space and again and it will fill in the (x86)\' for you. Regards, John Ralls On Jul 27, 2020, at 12:01 PM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Sorry John (and everyone). I can't get it to accept (x86) now: C:\Users\User> cd C:\Program Files (x86)\gnucash\bin x86 : The term 'x86' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:22 + cd C:\Program Files (x86)\gnucash\bin + ~~~ + CategoryInfo : ObjectNotFound: (x86:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException So sorry. Instead of bothering you guys should I try to get local help? Best wishes and thanks again Samantha On 27 July 2020 19:30 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, Sorry I wasn't more explicit: Yes, each command is a line on its own, followed by . You need to use quotes around your API key, so $Env:ALPHAVANTAGE_API_KEY = "[my API key]" I see that I left off the second quote in the perl command line, it should be perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP The Powershell terminal color-codes errors in red on black, variables and special values (e.g. $true, $false) in green, and command names in yellow. Regards, John Ralls On Jul 27, 2020, at 2:30 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Hi John I am sorry to have to come back to you for more support on this and thanks again for your patience. After some fumbling (am I right that I should type each line you have typed followed by the "Enter" key? I really am that much of a newb at this), I got an error message in red type as follows: [my API key] : The term '[my API key]' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:29 + $Env:ALPHAVANTAGE_API_KEY = [my API key] + ~~~ + CategoryInfo : ObjectNotFound: ([my API key]:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException (In the text above I have switched out my 16 digit API key for the words "[my API key]"). Please also explain what the significance of green and yellow text is in this environment. Many thanks Samantha On 25 July 2020 20:04 John Ralls < [5]jra...@ceridwen.us> wrote: Samantha, Powershell (Admin) just means Powershell with admin privilege. Starting it will raise a User Authorization Escalation dialog box asking if you're sure that you want Powershell to "make changes to your device". You don't need it for this test, plain Powershell is fine. Yes, Powershell. I don't think that there is a Poweshell, please excuse my hasty typing. Since you use only those 3 currencies try all three combinations, i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. Regards, John Ralls On Jul 25, 2020, at 10:27 AM, Samantha Payn < [6]saman...@boorertranslations.com> wrote: John, thank you for your continued support. Before I try this can I just clarify two points: I have a choice of Windows Powershell and Windows Powershell (Admin): which should I choose? And in the middle of your email I presume you mean "Powershell" (not Poweshell as typed)? Finally, in response to your question I have no securities in my Gnucash accounts. I am a freelance translator with a hom
Re: [GNC] Bravo! 4.x type-ahead search enhancement
Wow! Sounds brilliant! Samantha Payn > On 4 Aug 2020, at 21:03, Jeff Albrecht wrote: > > Thank you GNU developers! > > This feature is saving me so much time in my workflow. > > "New type-ahead search added to sequential search when selecting an account > in the register: Instead of typing the first few characters of a top level > account, the separator, the first few characters of the next level account > and so on you may instead type a few characters of any part of a full account > name and the drop-list will be filtered to contain only matching accounts. > Once you have a small enough list you can use the arrow keys to select the > account that you want." > > Thanks again! - Jeff > > -- > Jeff Albrecht > KF7CRU @jhalbrecht > > ___ > 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] Difficulty with online price retrieval
Sorry John (and everyone). I can't get it to accept (x86) now: C:\Users\User> cd C:\Program Files (x86)\gnucash\bin x86 : The term 'x86' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:22 + cd C:\Program Files (x86)\gnucash\bin + ~~~ + CategoryInfo : ObjectNotFound: (x86:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException So sorry. Instead of bothering you guys should I try to get local help? Best wishes and thanks again Samantha On 27 July 2020 19:30 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Sorry I wasn't more explicit: Yes, each command is a line on its own, followed by . You need to use quotes around your API key, so $Env:ALPHAVANTAGE_API_KEY = "[my API key]" I see that I left off the second quote in the perl command line, it should be perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency' USD GBP The Powershell terminal color-codes errors in red on black, variables and special values (e.g. $true, $false) in green, and command names in yellow. Regards, John Ralls On Jul 27, 2020, at 2:30 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Hi John I am sorry to have to come back to you for more support on this and thanks again for your patience. After some fumbling (am I right that I should type each line you have typed followed by the "Enter" key? I really am that much of a newb at this), I got an error message in red type as follows: [my API key] : The term '[my API key]' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:29 + $Env:ALPHAVANTAGE_API_KEY = [my API key] + ~~~ + CategoryInfo : ObjectNotFound: ([my API key]:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException (In the text above I have switched out my 16 digit API key for the words "[my API key]"). Please also explain what the significance of green and yellow text is in this environment. Many thanks Samantha On 25 July 2020 20:04 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, Powershell (Admin) just means Powershell with admin privilege. Starting it will raise a User Authorization Escalation dialog box asking if you're sure that you want Powershell to "make changes to your device". You don't need it for this test, plain Powershell is fine. Yes, Powershell. I don't think that there is a Poweshell, please excuse my hasty typing. Since you use only those 3 currencies try all three combinations, i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. Regards, John Ralls On Jul 25, 2020, at 10:27 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: John, thank you for your continued support. Before I try this can I just clarify two points: I have a choice of Windows Powershell and Windows Powershell (Admin): which should I choose? And in the middle of your email I presume you mean "Powershell" (not Poweshell as typed)? Finally, in response to your question I have no securities in my Gnucash accounts. I am a freelance translator with a home currency of GBP and clients who pay me (and a very occasional purchase) in EUR and USD and use Gnucash for my business accounts. These are the currency rates I am trying to access. Best wishes Samantha On 25 July 2020 17:12 John Ralls < [5]jra...@ceridwen.us> wrote: Samantha, Next, some command-line testing. You can use CMD if you like, but I find Powershell to be a bit friendlier and easier to get to: Just right-click in the Start menu and it's in the middle. Once you have a shell, cd to C:\Program Files (x86)\gnucash\bin. First you'll need to set your ALPHAVANTAGE_API_KEY in the environment: CMD set ALPHAVANTAGE_API_KEY xxx... Poweshell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls On Jul 25
Re: [GNC] Difficulty with online price retrieval
Hi John I am sorry to have to come back to you for more support on this and thanks again for your patience. After some fumbling (am I right that I should type each line you have typed followed by the "Enter" key? I really am that much of a newb at this), I got an error message in red type as follows: [my API key] : The term '[my API key]' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:29 + $Env:ALPHAVANTAGE_API_KEY = [my API key] + ~~~ + CategoryInfo : ObjectNotFound: ([my API key]:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException (In the text above I have switched out my 16 digit API key for the words "[my API key]"). Please also explain what the significance of green and yellow text is in this environment. Many thanks Samantha On 25 July 2020 20:04 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Powershell (Admin) just means Powershell with admin privilege. Starting it will raise a User Authorization Escalation dialog box asking if you're sure that you want Powershell to "make changes to your device". You don't need it for this test, plain Powershell is fine. Yes, Powershell. I don't think that there is a Poweshell, please excuse my hasty typing. Since you use only those 3 currencies try all three combinations, i.e. USD->GBP, EUR->GBP, and EUR->USD with gnc-fq-dump. Regards, John Ralls On Jul 25, 2020, at 10:27 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: John, thank you for your continued support. Before I try this can I just clarify two points: I have a choice of Windows Powershell and Windows Powershell (Admin): which should I choose? And in the middle of your email I presume you mean "Powershell" (not Poweshell as typed)? Finally, in response to your question I have no securities in my Gnucash accounts. I am a freelance translator with a home currency of GBP and clients who pay me (and a very occasional purchase) in EUR and USD and use Gnucash for my business accounts. These are the currency rates I am trying to access. Best wishes Samantha On 25 July 2020 17:12 John Ralls < [3]jra...@ceridwen.us> wrote: Samantha, Next, some command-line testing. You can use CMD if you like, but I find Powershell to be a bit friendlier and easier to get to: Just right-click in the Start menu and it's in the middle. Once you have a shell, cd to C:\Program Files (x86)\gnucash\bin. First you'll need to set your ALPHAVANTAGE_API_KEY in the environment: CMD set ALPHAVANTAGE_API_KEY xxx... Poweshell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls On Jul 25, 2020, at 5:22 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Thank you for your help John. I have done as you instruct (including restarting Gnucash after the install) but there is now a different problem. The Gnucash about info now does show version 1.49 for Finance::Quote The Get Quotes button does light up, but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". I have tried restarting my computer to see if that helps but it made no difference. The last two lines of the installing text in the CPAN window, before the cpan prompt reappeared were *slightly* different to what you showed in your email. As far as I can recall they said: Appending installation info to C:\strawberry\perl\lib/perllocal.pod ECOCODE/Finance-Quote-1.49.tar.gz C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK Can you please give me guidance on what to do now? Very many thanks! Samantha On 24 July 2020 21:12 John Ralls < [5]jra...@ceridwen.us> wrote: On Jul 24, 2020, at 4:33 AM, Samantha Payn < [6]saman...@boorertranslations.com> wrote: Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval some
Re: [GNC] Difficulty with online price retrieval
John, thank you for your continued support. Before I try this can I just clarify two points: I have a choice of Windows Powershell and Windows Powershell (Admin): which should I choose? And in the middle of your email I presume you mean "Powershell" (not Poweshell as typed)? Finally, in response to your question I have no securities in my Gnucash accounts. I am a freelance translator with a home currency of GBP and clients who pay me (and a very occasional purchase) in EUR and USD and use Gnucash for my business accounts. These are the currency rates I am trying to access. Best wishes Samantha On 25 July 2020 17:12 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Next, some command-line testing. You can use CMD if you like, but I find Powershell to be a bit friendlier and easier to get to: Just right-click in the Start menu and it's in the middle. Once you have a shell, cd to C:\Program Files (x86)\gnucash\bin. First you'll need to set your ALPHAVANTAGE_API_KEY in the environment: CMD set ALPHAVANTAGE_API_KEY xxx... Poweshell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls On Jul 25, 2020, at 5:22 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Thank you for your help John. I have done as you instruct (including restarting Gnucash after the install) but there is now a different problem. The Gnucash about info now does show version 1.49 for Finance::Quote The Get Quotes button does light up, but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". I have tried restarting my computer to see if that helps but it made no difference. The last two lines of the installing text in the CPAN window, before the cpan prompt reappeared were *slightly* different to what you showed in your email. As far as I can recall they said: Appending installation info to C:\strawberry\perl\lib/perllocal.pod ECOCODE/Finance-Quote-1.49.tar.gz C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK Can you please give me guidance on what to do now? Very many thanks! Samantha On 24 July 2020 21:12 John Ralls < [3]jra...@ceridwen.us> wrote: On Jul 24, 2020, at 4:33 AM, Samantha Payn < [4]saman...@boorertranslations.com> wrote: Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently computer literate to correct this. My problem is that when I go to post an invoice in a "foreign" currency the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method John Ralls directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK Does this mean that online price retrieval has been installed? When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able
Re: [GNC] Difficulty with online price retrieval
Thank you for your help John. I have done as you instruct (including restarting Gnucash after the install) but there is now a different problem. The Gnucash about info now does show version 1.49 for Finance::Quote The Get Quotes button does light up, but when I click it I get an error window that says: "There was a system error while retrieving the price quotes". I have tried restarting my computer to see if that helps but it made no difference. The last two lines of the installing text in the CPAN window, before the cpan prompt reappeared were *slightly* different to what you showed in your email. As far as I can recall they said: Appending installation info to C:\strawberry\perl\lib/perllocal.pod ECOCODE/Finance-Quote-1.49.tar.gz C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK Can you please give me guidance on what to do now? Very many thanks! Samantha On 24 July 2020 21:12 John Ralls < [1]jra...@ceridwen.us> wrote: On Jul 24, 2020, at 4:33 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently computer literate to correct this. My problem is that when I go to post an invoice in a "foreign" currency the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method John Ralls directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK Does this mean that online price retrieval has been installed? When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able to help me. I am stepping way out of my comfort zone when I enter the cmd window but willing to give it a go. It looks like Finance::Quote is not getting installed. Try this: Find the Strawberry Perl group in the Start menu (windows logo at the bottom left of the screen). Open it and start CPAN Client. You'll get something that looks sort of like a CMD window. At the prompt there type install Finance::Quote It will probably take a while and should eventually finish with Appending installation info to C:\strawberry\perl\lib/perllocal.pod ECOCODE/Finance-Quote-1.49.tar.gz C:\strawberry\c\bin\dmake.exe install UNINST=1 -- OK If GnuCash is running restart it, after which it should report version 1.49 for Finance::Quote and light up the Get Quotes button. Regards, John Ralls References 1. mailto:jra...@ceridwen.us 2. mailto:saman...@boorertranslations.com ___ 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] Difficulty with online price retrieval
Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently computer literate to correct this. My problem is that when I go to post an invoice in a "foreign" currency the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method John Ralls directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK Does this mean that online price retrieval has been installed? When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able to help me. I am stepping way out of my comfort zone when I enter the cmd window but willing to give it a go. Best regards Samantha ___ 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] Difficulty with online price retrieval (John Ralls)
Thank you for your response, John, and I am sorry for the long delay but I have had an avalanche of work to do. My problem is that when I go to post an invoice the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method you directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done several times now. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able to help me. I am stepping way out of my comfort zone when I enter the cmd window but willing to give it a go. Best regards Samantha On 16 July 2020 18:14 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Have you tried price retrieval from the command line as explained in [2]https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Does that work? You haven't actually told us exactly what doesn't work. Please elaborate. Note that trading accounts has nothing to do with it, nor do previously created prices. Note that while rates used for transactions are recorded in the pricedb to ensure that there's an entry to make reports work properly, each foreign currency split has its own exchange rate, the ratio between the amount in the foreign currency and the value in the home currency, so the only thing you'd affect by clearing the pricedb is reports on past dates, especially time series reports. You may also enter prices manually as a temporary measure until you get online quotes working properly. Regards, John Ralls On Jul 16, 2020, at 5:08 AM, Samantha Payn < [3]saman...@boorertranslations.com> wrote: Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation and cannot see where I am going wrong. In addition to having installed Online Price Retrieval and entered my API key, I have now also double checked that the "use trading accounts" option is checked which it is. In the price database window the currencies I use are listed. There is an option to delete all previous prices but I presume I don't want to do that as they record the currency exchange rates used for each of my past transactions. I am beginning to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. References 1. mailto:jra...@ceridwen.us 2. https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting 3. mailto:saman...@boorertranslations.com ___ 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] Difficulty with online price retrieval (John Ralls)
Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation and cannot see where I am going wrong. In addition to having installed Online Price Retrieval and entered my API key, I have now also double checked that the "use trading accounts" option is checked which it is. In the price database window the currencies I use are listed. There is an option to delete all previous prices but I presume I don't want to do that as they record the currency exchange rates used for each of my past transactions. I am beginning to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. -- Samantha Payn On 16 July 2020 11:38 [1]gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to [2]gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to [4]gnucash-user-requ...@gnucash.org You can reach the person managing the list at [5]gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Difficulty with online price retrieval (Samantha Payn) 2. Re: Reconcile also opens Interest Payment box? (Jean Laroche) 3. Re: Difficulty with online price retrieval (Eric Coates) 4. GnuCash 4.0 printing on MacOS (Flyeta) 5. Re: Difficulty with online price retrieval (John Ralls) 6. Re: GnuCash 4.0 printing on MacOS (John Ralls) 7. Get Online Quotes (Ruaraidh Sackville Hamilton) 8. gnucash cannot see printer (Gio Bacareza) -- Message: 1 Date: Wed, 15 Jul 2020 17:24:49 +0100 (BST) From: Samantha Payn < [6]saman...@boorertranslations.com> To: " [7]gnucash-user@gnucash.org" < [8]gnucash-user@gnucash.org> Subject: [GNC] Difficulty with online price retrieval Message-ID: < [9]1218599278.968.1594830289...@privateemail.com> Content-Type: text/plain; charset="UTF-8" I did post this question before but am still having the same problem. I have successfully used Gnucash for a couple of years for multicurrency invoice processing using the Strawberry perl plug in (by clicking on Install online price retrieval in the Gnucash section of the start menu) and an #Alpha Vantage access key. I use Windows 10. Recently I had to upgrade my hardware and since installing gnucash on the new machine I've not been able to make the price retrieval work. I have tried installing gnucash, adding the API key, and then adding Strawberry perl; and I have tried uninstalling everything and then installing gnucash, adding Strawberry perl and then adding the API key. No joy. Where am I going wrong? All help gratefully received. Thanks. -- Message: 2 Date: Wed, 15 Jul 2020 09:39:43 -0700 From: Jean Laroche < [10]rip...@gmail.com> To: [11]gnucash-user@gnucash.org Subject: Re: [GNC] Reconcile also opens Interest Payment box? Message-ID: < [12]40aabd76-e146-8fab-b54a-56beeb731...@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed I'd like a preference somewhere to activate/inactivate the Interest Payment pop-up appearing automatically on an account by account basis. I'd like the "Enter Interest Payment ..." button to remain as I have used it a couple of times, but that when it has been used it won't then mean it appears automatically the next time, which would remove the need for the "No Automatic Interest Payment" button. Just my two penny worth. Alan A Holmes BTW, that's exactly what the current Pull Request implements: per account option, and the option isn't set silently if you decide to click "enter interest payment". [13]https://github.com/Gnucash/gnucash/pull/753 I think it's a reasonable compromise that keeps the feature around, but much better behaved. -- Message: 3 Date: Wed, 15 Jul 2020 17:44:33 +0100 From: Eric Coates < [14]twistedw...@talktalk.net> To: [15]gnucash-user@gnucash.org Subject: Re: [GNC] Difficulty with online price retrieval Message-ID: < [16]a9519fec-f78e-9ca9-83e0-4277468c6...@talktalk.net> Content-Type: text/plain; charset=utf-8; format=flowed A few days ago it was reported that AlphaVantage was no longer serving price information (something to do with them not having the appropriate licences app
[GNC] Difficulty with online price retrieval
I did post this question before but am still having the same problem. I have successfully used Gnucash for a couple of years for multicurrency invoice processing using the Strawberry perl plug in (by clicking on Install online price retrieval in the Gnucash section of the start menu) and an #Alpha Vantage access key. I use Windows 10. Recently I had to upgrade my hardware and since installing gnucash on the new machine I've not been able to make the price retrieval work. I have tried installing gnucash, adding the API key, and then adding Strawberry perl; and I have tried uninstalling everything and then installing gnucash, adding Strawberry perl and then adding the API key. No joy. Where am I going wrong? All help gratefully received. 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] Accessing online currency rates
Thanks for your interest and suggestion. Yes, I did that (it installs the strawberry perl program, I think?). But still no joy. -- Samantha Payn Tel: 01852 300723 Mob: 07977 150053 On 3 July 2020 00:14 John Ralls < [1]jra...@ceridwen.us> wrote: Did you remember to run Install Online Price Retrieval for GnuCash from the GnuCash group in the Start Menu? Regards, John Ralls On Jul 2, 2020, at 4:29 AM, Samantha Payn < [2]saman...@boorertranslations.com> wrote: I have had to change computers and have installed my existing Gnucash set-up (in which I could access online currency rates using the "fetch rate" button) on my new computer but I cannot now access online currency rates. I have installed Strawberry Perl, and added my API key at the right place but I cannot get the currencies to update. Sorry to be a dunce: what am I missing? Many thanks for any assistance. Samantha ___ gnucash-user mailing list [3]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [5]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:jra...@ceridwen.us 2. mailto:saman...@boorertranslations.com 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. https://wiki.gnucash.org/wiki/Mailing_Lists ___ 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] Accessing online currency rates
I have had to change computers and have installed my existing Gnucash set-up (in which I could access online currency rates using the "fetch rate" button) on my new computer but I cannot now access online currency rates. I have installed Strawberry Perl, and added my API key at the right place but I cannot get the currencies to update. Sorry to be a dunce: what am I missing? Many thanks for any assistance. Samantha ___ 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] Batch posting of foreign currency invoices
Thank you, Adrien. On 4 April 2020 21:05 [1]gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to [2]gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to [4]gnucash-user-requ...@gnucash.org You can reach the person managing the list at [5]gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: Batch posting of foreign currency invoices (Adrien Monteleone) 2. GNU 3.9 WIn 10 menus completely disconnected from app ( [6]fci...@gmail.com) 3. Re: How To Set Tax Report Options (Adrien Monteleone) 4. FW: GNU 3.9 WIn 10 menus completely disconnected from app in dual monitor mode ( [7]fci...@gmail.com) 5. Re: How To Set Tax Report Options (Adrien Monteleone) 6. Re: Badly formed URL (Bruce Irving) 7. Re: How To Set Tax Report Options (D.) 8. Re: How To Set Tax Report Options (D.) 9. Re: How To Set Tax Report Options (Alex Aycinena) 10. Re: How To Set Tax Report Options (Keith Fetterman) 11. Re: GNU 3.9 WIn 10 menus completely disconnected from app in dual monitor mode (John Ralls) ___ gnucash-user mailing list [8]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [9]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [10]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. That is an interesting problem. There isn’t a batch posting feature, so you still have to post them individually, but I can see how removing lots of extra clicks would help the workflow. Somewhere in the process, GnuCash needs to confirm with the user what the exchange rate will be. Outside of a separate batch posting function, I don’t see how this could be implemented presently. If a batch posting function were added, it should include an *option* to only confirm an exchange rate once per currency per run. Regards, Adrien On Apr 4, 2020 w14d95, at 9:09 AM, Samantha Payn < [11]saman...@boorertranslations.com> wrote: Hi Rob No, I'm not referring to importing bills. I issue invoices in various currencies. If I am issuing a number of invoices at once, all in the same currency which is not my own, I currently have to click ok for the currency conversion for each invoice when I post them, even if I post them all at once. Is there a way to OK the conversion rate for a number of invoices in a foreign currency all at once when they are posted together? Cheers Hi I upgraded to 3.9 on Wins 10. The app menu items do not appear in a drop-down. They are totally disconnected from the app off to the side. Not sure how this happened. Thanks Frank Sadly, it is one account at a time. (unless there is a trick I don’t know about) Regards, Adrien On Apr 4, 2020 w14d95, at 10:30 AM, Keith Fetterman < [12]keithfetter...@gmail.com> wrote: Is there documentation on how to set tax report options for multiple accounts? I am trying to set the income tax classifications (TXF Categories) for multiple expense and income accounts, but it doesn’t seem to be able to do more than one account at a time. Here is what I am doing. Set income tax identity to “Individual, Joint …” Select an expense account Click the Tax Related checkbox Select a TXF Category Select another expense account Click the Tax Related checkbox Select a TXF Category etc. When I return to a previous expense account, the Tax Related checkbox is unchecked and the TXF Category assignment is cleared. Do you have to run the “Tax Report Options” assignment separately for each account? By this I mean, perform the steps above for a single account then click the “OK” button to close the dialog? Thanks Keith I have an update - the menu items appear normal when the application is on my primary monitor. However, if the main app is on my secondary monitor, the menu items appear on the primary monitor. So there is an issue with the use of dual monitors. Frank From: [13]fci...@gmail.com < [14]fci...@gmail.com> Sent: Saturday, April 4, 2020 12:25 PM To: [15]'gnucash-de...@gnucash.org' < [16]gnucash-user@gnucash.org> Subject: GNU 3.9 WIn 10 menus completely disconnected from app Hi I upgraded to 3.9 on Wins 10. The app menu items do not appear in a drop-down.
Re: [GNC] Batch posting of foreign currency invoices
Hi Rob No, I'm not referring to importing bills. I issue invoices in various currencies. If I am issuing a number of invoices at once, all in the same currency which is not my own, I currently have to click ok for the currency conversion for each invoice when I post them, even if I post them all at once. Is there a way to OK the conversion rate for a number of invoices in a foreign currency all at once when they are posted together? Cheers On 3 April 2020 16:48 Chello < [1]rob.l...@chello.nl> wrote: Hi Samantha, If you are referring to the ‘Import Bills/Invoices” function, the answer is no. This function will only post an invoice if a single currency is involved. If posting the invoice requires a currency conversion, then this function will register but not post the invoice. Regards, Rob On 2 Apr 2020, at 17:08, Samantha Payn < [2]saman...@boorertranslations.com> wrote: Is it possible to batch post foreign currency invoices instead of having to review and confirm the exchange rate for each invoice? Thanks for any guidance you can give. -- Samantha Payn Tel: 01852 300723 Mob: 07977 150053 ___ gnucash-user mailing list [3]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [5]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:rob.l...@chello.nl 2. mailto:saman...@boorertranslations.com 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. https://wiki.gnucash.org/wiki/Mailing_Lists ___ 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] Batch posting of foreign currency invoices
Is it possible to batch post foreign currency invoices instead of having to review and confirm the exchange rate for each invoice? Thanks for any guidance you can give. -- Samantha Payn Tel: 01852 300723 Mob: 07977 150053 ___ 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] Finance::Quote still not working with alphavantage
Hi Maf/ Windows 10 64 bit with all the updates etc GNUcash Version: 3.1 Build ID: 3.0-118-gd2ef5fd0f+ (2018-04-28) Finance::Quote: 1.47 Yes I have the API Key and quotes (I just need two currencies) were updating nicely until about a week ago. Any help gratefully received. -- Samantha On 23 July 2018 at 16:24 "Maf. King" wrote: On Monday, 23 July 2018 15:55:01 BST Samantha Payn wrote: Hello all! I see the thread about online currency quotes not working in the mailing list archive and the helpful replies. However I am not a coder/programmer so am unable to fathom what I, a mere mortal, should be doing to re-enable the online currency fetch feature. Can anyone spell it out to me in words of one syllable please? Very many thanks :) Hi Samantha, I'm not sure I can get you all the way, but you'll need to get us to a start point - which OS platform and version of GC are you using? Have you registered with Alphavantage and got your ID number? (Also called "API Key" - but keep it secret! no one needs to know it, but we do need to know that it exists!) just a start, someone else may be able to help more with the actual set up in due course. Maf/ ___ 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] Finance::Quote still not working with alphavantage
Hello all! I see the thread about online currency quotes not working in the mailing list archive and the helpful replies. However I am not a coder/programmer so am unable to fathom what I, a mere mortal, should be doing to re-enable the online currency fetch feature. Can anyone spell it out to me in words of one syllable please? Very many thanks :) -- Samantha Payn Tel: 01770 820655 Mob: 07977 150053 ___ 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] Crash on start up
Thank you! > On 23 April 2018 at 15:11 John Ralls <jra...@ceridwen.us> wrote: > > > > > > On Apr 23, 2018, at 5:40 AM, Samantha Payn <saman...@boorertranslations.com> wrote: > > > > I am running GNUcash 3 on Windows 10. seem to have done something to > > corrupt my experimental GNUcash accounts file. It crashes on start-up. > > I have tried uninstalling and reinstalling GNUcash but that hasn't > > helped. > > > > Once it has crashed I get the locked file warning, and whether I choose > > "open anyway" or "open as read only" the file crashes. I am able to > > open the app only by clicking on "create new file". > > > > I am able to open an earlier version of the damaged file but would like > > to know how I have caused this problem. > > > > The initial Trace File after the first crash says: > > > > "* 07:12:40 CRIT gnc_date_edit_set_time_internal: assertion > > 'mytm != NULL' failed > > * 07:14:21 CRIT gnc_date_edit_set_time_internal: assertion > > 'mytm != NULL' failed > > * 07:15:49 WARN [gnc_print_time64()] Error processing > > time64 9223372036854775807: Time value is outside the supported year > > range. > > * 07:17:17 WARN [gnc_print_time64()] Error processing > > time64 9223372036854775807: Time value is outside the supported year > > range. > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:17:40 WARN invalid uninstantiatable type '(NULL)' > > in cast to 'QofInstance' > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:17:40 WARN [qof_print_date_buff()] Error processing > > time64 527765583310712933: Time value is outside the supported year > > range. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:17 CRIT [gnc_price_get_value()] price NULL. > > * 07:21:30 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:23:52 CRIT gnc_date_edit_set_time_internal: assertion > > 'mytm != NULL' failed > > * 07:34:34 CRIT gnc_date_edit_set_time_internal: assertion > > 'mytm != NULL' failed > > * 07:36:35 CRIT gnc_date_edit_set_time_internal: assertion > > 'mytm != NULL' failed > > * 07:37:19 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:37:19 CRIT [gnc_price_get_value()] price NULL. > > * 07:37:19 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:37:19 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:37:19 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:38:14 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:38:14 CRIT [gnc_price_get_value()] price NULL. > > * 07:38:14 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:38:14 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:38:14 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:38:32 WARN [gnc_numeric_to_decimal()] Rounding required > > when 'never round' specified. > > * 07:42:10 WARN [qof_print
[GNC] "Unable to retrieve quotes for these items: CURRENCY:USD"
I have searched the mailing list database of queries and see that there have been issues with fetching prices/currencies online before. I am a novice GnuCash user and before I proceed further I need to be sure that I can get live online USD and EUR to GBP and vice versa prices. I have installed the Strawberry Perl tool and am attempting to set up currencies for business use. When I click the "get quotes" button in the Price Database I get the error message: Unable to retrieve quotes for these items: CURRENCY:USD There is no error message regarding EUR which I have set up in the same way as a currency. Can anyone help, please? -- Samantha Payn ___ 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.
