[GNC] Difficulty with online price retrieval
Samantha Payn
samantha at boorertranslations.com
Tue Aug 25 08:18:21 EDT 2020
Thanks Geoff! Sleep well!
On 25 August 2020 13:17 Geoff < [1]cleanoutmyshed at 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]cleanoutmyshed at gmail.com
<mailto: [3]cleanoutmyshed at 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]cleanoutmyshed at gmail.com
>> <mailto: [5]cleanoutmyshed at gmail.com>
>> >> <mailto: [6]cleanoutmyshed at gmail.com
>> <mailto: [7]cleanoutmyshed at 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 <gnc.scm> handling-request: (currency USD GBP)
>> >> * 10:15:31 DEBUG <gnc.scm> results: #<eof>
>> >> * 10:15:31 DEBUG <gnc.scm> handling-request: (currency EUR GBP)
>> >> * 10:15:31 ERROR <gnc.scm> 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.
>> >>>
>> >>> #<eof> 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 <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >>> when 'never round' specified.
>> >>> * 14:34:32 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >>> when 'never round' specified.
>> >>> * 14:34:57 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Yours>
>> >>> * 14:34:57 DEBUG <gnc.scm> handling-request: (currency CAD USD)
>> >>> * 14:35:04 DEBUG <gnc.scm> results: ((CAD (symbol . CAD)
>> >>> (gnc:time-no-zone . 2020-08-24 14:34:58) (last . 15127/20000)
>> >>> (currency . USD)))
>> >>> * 14:35:04 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >>> when 'never round' specified.
>> >>> * 14:35:04 WARN <qof> [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 <
>> >>>> [8]samantha at boorertranslations.com
>> <mailto: [9]samantha at boorertranslations.com>
>> >>>> <mailto: [10]samantha at boorertranslations.com
>> <mailto: [11]samantha at 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 < [12]samantha at boorertranslations.com
>> <mailto: [13]samantha at boorertranslations.com>
>> >> <mailto: [14]samantha at boorertranslations.com
>> <mailto: [15]samantha at boorertranslations.com>>>
>> >> >>> To: John Ralls < [16]jralls at ceridwen.us <mailto:
[17]jralls at ceridwen.us>
>> <mailto: [18]jralls at ceridwen.us <mailto: [19]jralls at ceridwen.us>>>
>> >> >>> CC: Gnucash Users < [20]gnucash-user at gnucash.org
>> <mailto: [21]gnucash-user at gnucash.org>
>> >> <mailto: [22]gnucash-user at gnucash.org <mailto:
[23]gnucash-user at 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 <gnc.scm>
rpt-subdir=gnucash/reports/standard
>> >> >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
>> >> >>> * 10:13:32 DEBUG <gnc.scm> 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 <gnc.scm> rpt-subdir=gnucash/reports/example
>> >> >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
>> >> >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(welcome-to-gnucash
>> >> sample-graphs hello-world daily-reports average-balance)
>> >> >>> * 10:13:32 DEBUG <gnc.scm>
>> >> rpt-subdir=gnucash/reports/locale-specific/us
>> >> >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >>
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
>> >> >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(taxtxf)
>> >> >>> * 10:13:32 DEBUG <gnc.scm>
rpt-subdir=gnucash/report/stylesheets
>> >> >>> * 10:13:32 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
>> >> >>> * 10:13:32 DEBUG <gnc.scm> dir-files=(plain head-or-tail
footer
>> css)
>> >> >>> * 10:13:33 DEBUG <gnc.scm> 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 <gnc.scm> Found Finance::Quote version 1.49
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:30 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:31 DEBUG <gnc.scm> ALPHAVANTAGE_API_KEY=<Key>
>> >> >>> * 10:15:31 DEBUG <gnc.scm> handling-request: (currency USD
GBP)
>> >> >>> * 10:15:31 DEBUG <gnc.scm> results: #<eof>
>> >> >>> * 10:15:31 DEBUG <gnc.scm> handling-request: (currency EUR
GBP)
>> >> >>> * 10:15:31 ERROR <gnc.scm> There was a system error while
>> >> retrieving the price quotes.
>> >> >>> * 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>> * 10:15:37 WARN <qof> [gnc_numeric_to_decimal()] Rounding
required
>> >> when 'never round' specified.
>> >> >>>> On 15 August 2020 19:20 John Ralls < [24]jralls at ceridwen.us
>> <mailto: [25]jralls at ceridwen.us>
>> >> <mailto: [26]jralls at ceridwen.us <mailto:
[27]jralls at 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
>> >> >>>> Get-ChildItem -Path $Env:USERPROFILE\AppData\Local\Temp
-filter
>> >> gnucash.trace.* | Sort-Object -Property Date
>> >> >>>> figure out which is the latest one (the guidance about that
is
>> >> still at the bottom of the quoted text in this message if you've
>> >> forgotten)
>> >> >>>> Display the contents
>> >> >>>> Get-Content
>> >> $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log
>> >> >>>> (That'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 <
>> >> [28]samantha at boorertranslations.com
>> <mailto: [29]samantha at boorertranslations.com>
>> >> <mailto: [30]samantha at boorertranslations.com
>> <mailto: [31]samantha at 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 <
[32]jralls at ceridwen.us
>> <mailto: [33]jralls at ceridwen.us>
>> >> <mailto: [34]jralls at ceridwen.us <mailto:
[35]jralls at 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.XXXXXX.log.
>> >> >>>>>>
>> >> >>>>>> Regards,
>> >> >>>>>> John Ralls
>> >> >>>>>>
>> >> >>>>>>
>> >> >>>>>>> On Aug 12, 2020, at 6:54 AM, Samantha Payn <
>> >> [36]samantha at boorertranslations.com
>> <mailto: [37]samantha at boorertranslations.com>
>> >> <mailto: [38]samantha at boorertranslations.com
>> <mailto: [39]samantha at 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 <
[40]jralls at ceridwen.us
>> <mailto: [41]jralls at ceridwen.us>
>> >> <mailto: [42]jralls at ceridwen.us <mailto:
[43]jralls at 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 <
>> >> [44]samantha at boorertranslations.com
>> <mailto: [45]samantha at boorertranslations.com>
>> >> <mailto: [46]samantha at boorertranslations.com
>> <mailto: [47]samantha at 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 <
[48]jralls at ceridwen.us
>> <mailto: [49]jralls at ceridwen.us>
>> >> <mailto: [50]jralls at ceridwen.us <mailto:
[51]jralls at 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 <
>> >> [52]samantha at boorertranslations.com
>> <mailto: [53]samantha at boorertranslations.com>
>> >> <mailto: [54]samantha at boorertranslations.com
>> <mailto: [55]samantha at 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 <gnc.scm>
>> >> rpt-subdir=gnucash/reports/standard
>> >> >>>>>>>>>>> * 11:46:06 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard
>> >> >>>>>>>>>>> * 11:46:06 DEBUG <gnc.scm> 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 <gnc.scm>
>> rpt-subdir=gnucash/reports/example
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/reports/example
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
dir-files=(welcome-to-gnucash
>> >> sample-graphs hello-world daily-reports average-balance)
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
>> >> rpt-subdir=gnucash/reports/locale-specific/us
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >>
(x86)\gnucash\share/guile/site/2.2\gnucash/reports/locale-specific/us
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> dir-files=(taxtxf)
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm>
>> >> rpt-subdir=gnucash/report/stylesheets
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> mod-dir=C:\Program Files
>> >> (x86)\gnucash\share/guile/site/2.2\gnucash/report/stylesheets
>> >> >>>>>>>>>>> * 11:46:07 DEBUG <gnc.scm> dir-files=(plain
head-or-tail
>> >> footer css)
>> >> >>>>>>>>>>> * 11:46:10 DEBUG <gnc.scm> 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 <gnc.scm> Found Finance::Quote
version
>> 1.49
>> >> >>>>>>>>>>> PS C:\Users\User>
>> >> >>>>>>>>>>>
>> >> >>>>>>>>>>> Cheers
>> >> >>>>>>>>>>> Samantha
>> >> >>>>>>>>>>>> On 10 August 2020 16:37 John Ralls <
>> [56]jralls at ceridwen.us <mailto: [57]jralls at ceridwen.us>
>> >> <mailto: [58]jralls at ceridwen.us <mailto:
[59]jralls at ceridwen.us>>> wrote:
>> >> >>>>>>>>>>>>
>> >> >>>>>>>>>>>>
>> >> >>>>>>>>>>>>> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger <
>> >> [60]frank.h.ellenberger at gmail.com
>> <mailto: [61]frank.h.ellenberger at gmail.com> <mailto:
>> [62]frank.h.ellenberger at gmail.com <mailto:
[63]frank.h.ellenberger at 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
>> >>> _______________________________________________
>> >>> gnucash-user mailing list
>> >>> [64]gnucash-user at gnucash.org <mailto:
[65]gnucash-user at gnucash.org>
>> <mailto: [66]gnucash-user at gnucash.org <mailto:
[67]gnucash-user at gnucash.org>>
>> >>> To update your subscription preferences or to unsubscribe:
>> >>> [68]https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >>> If you are using Nabble or Gmane, please see
>> >>> [69]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:cleanoutmyshed at gmail.com
2. mailto:cleanoutmyshed at gmail.com
3. mailto:cleanoutmyshed at gmail.com
4. mailto:cleanoutmyshed at gmail.com
5. mailto:cleanoutmyshed at gmail.com
6. mailto:cleanoutmyshed at gmail.com
7. mailto:cleanoutmyshed at gmail.com
8. mailto:samantha at boorertranslations.com
9. mailto:samantha at boorertranslations.com
10. mailto:samantha at boorertranslations.com
11. mailto:samantha at boorertranslations.com
12. mailto:samantha at boorertranslations.com
13. mailto:samantha at boorertranslations.com
14. mailto:samantha at boorertranslations.com
15. mailto:samantha at boorertranslations.com
16. mailto:jralls at ceridwen.us
17. mailto:jralls at ceridwen.us
18. mailto:jralls at ceridwen.us
19. mailto:jralls at ceridwen.us
20. mailto:gnucash-user at gnucash.org
21. mailto:gnucash-user at gnucash.org
22. mailto:gnucash-user at gnucash.org
23. mailto:gnucash-user at gnucash.org
24. mailto:jralls at ceridwen.us
25. mailto:jralls at ceridwen.us
26. mailto:jralls at ceridwen.us
27. mailto:jralls at ceridwen.us
28. mailto:samantha at boorertranslations.com
29. mailto:samantha at boorertranslations.com
30. mailto:samantha at boorertranslations.com
31. mailto:samantha at boorertranslations.com
32. mailto:jralls at ceridwen.us
33. mailto:jralls at ceridwen.us
34. mailto:jralls at ceridwen.us
35. mailto:jralls at ceridwen.us
36. mailto:samantha at boorertranslations.com
37. mailto:samantha at boorertranslations.com
38. mailto:samantha at boorertranslations.com
39. mailto:samantha at boorertranslations.com
40. mailto:jralls at ceridwen.us
41. mailto:jralls at ceridwen.us
42. mailto:jralls at ceridwen.us
43. mailto:jralls at ceridwen.us
44. mailto:samantha at boorertranslations.com
45. mailto:samantha at boorertranslations.com
46. mailto:samantha at boorertranslations.com
47. mailto:samantha at boorertranslations.com
48. mailto:jralls at ceridwen.us
49. mailto:jralls at ceridwen.us
50. mailto:jralls at ceridwen.us
51. mailto:jralls at ceridwen.us
52. mailto:samantha at boorertranslations.com
53. mailto:samantha at boorertranslations.com
54. mailto:samantha at boorertranslations.com
55. mailto:samantha at boorertranslations.com
56. mailto:jralls at ceridwen.us
57. mailto:jralls at ceridwen.us
58. mailto:jralls at ceridwen.us
59. mailto:jralls at ceridwen.us
60. mailto:frank.h.ellenberger at gmail.com
61. mailto:frank.h.ellenberger at gmail.com
62. mailto:frank.h.ellenberger at gmail.com
63. mailto:frank.h.ellenberger at gmail.com
64. mailto:gnucash-user at gnucash.org
65. mailto:gnucash-user at gnucash.org
66. mailto:gnucash-user at gnucash.org
67. mailto:gnucash-user at gnucash.org
68. https://lists.gnucash.org/mailman/listinfo/gnucash-user
69. https://wiki.gnucash.org/wiki/Mailing_Lists
More information about the gnucash-user
mailing list