Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Good morning Geoff - I'm now back in the office and have run through your
suggestions with the following result:
a) C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=[MYKEY]
> LOOKS OK
b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
[MYKEY]
> RETURNS KEY CORRECTLY
c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") |
perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
> RETURNS ERROR STRING:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD"
"GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
Can't open ((USD: No such file or directory at
gnc-fq-helper line 331.
Can't open (symbol: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open USD): No such file or directory at
gnc-fq-helper line 331.
Can't open (gnc:time-no-zone: No such file or
directory at gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open 2021-03-10 08:40:01): Invalid argument at
gnc-fq-helper line 331.
Can't open (last: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open #e0.72002): No such file or directory at
gnc-fq-helper line 331.
Can't open (currency: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open GBP))): No such file or directory at
gnc-fq-helper line 331.
Unfortunately I'm not a PERL coder but the code block starting at line 331
is the following:
while(<>) {
my $result = parse_input_line($_);
if(!$result) {
print STDERR "$prgnam: bad input line ($_)\n";
exit 1;
}
-Original Message-
From: Geoff
Sent: 18 July 2021 13:55
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David
Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get Quotes on
Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
> I'm having a problem with GNC-FQ not being able to retrieve currency
> data for the GBP / EUR currency pair.
>
>
>
> I had previously used FQ back when the data source was Yahoo, but when
> the Yahoo died I stopped using it.
>
>
>
> I now need to pick up GBP and EUR rates so I've installed the
> components required to get the Alphavantage feed to work - or so I hoped!
>
>
>
> Here's where I've got to so far:
>
>
>
> 1.I updated GNU Cash to current 4.6.
> 2.I installed Strawberry Perl version 5.32.1.1
> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
> 4.I added my aphhavantage key in Preferences \ Online Quotes
> 5.I ran perl gnc-fq-check and got the following result:
>
>
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>
>
>
> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia"
> "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada"
"canadamutual"
> "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies"
> "fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds"
> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
> "tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds"
> "usa" "usfedbonds" "yahoo_json" "za")
>
>
>
> 6.I ran perl gnc-fq-update a
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Good Morning Chris,
Many thanks for this, which I've just worked through with the results as
below - I've also worked through Geoff's suggestions.
The results are not encouraging though!
You are right that I'm running FC 1.51
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.51).
C:\>perl -v
This is perl 5, version 32, subversion 1 (v5.32.1) built for
MSWin32-x86-multi-thread-64int (I think this is the latest version.)
1. cpan upgrade DONE
cpan> upgrade
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
C:\>cpan -v
Loading internal logger. Log::Log4perl recommended
for better logging
>(info): C:\Strawberry\perl\bin/cpan script version
1.676, CPAN.pm version 2.28
2. gnc-fq-dump
After setting the alphavantage key (and confirming with echo) this fails as
follows:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency USD EUR
> RETURNS ERROR STRING:
syswrite() on unopened filehandle GEN0 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
syswrite() on unopened filehandle GEN1 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
1 USD = EUR
However, gnc-fq is still not working so maybe it's an issue with FC 1.51 or
maybe I have some issue with Perl that I don't understand.
-Original Message-
From: Chris Good
Sent: 19 July 2021 01:48
To: gnucash-user@gnucash.org
Cc: david.rom...@davidjromano.com
Subject: RE: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David,
>From memory Finance::Quote 1.51 is broken and the nice maintainer is working
on 1.52.
The problems were to do with missing dependencies for some cpan modules.
In the meantime you might try, from a cmd.exe window:
cpan upgrade
to upgrades all modules.
Note that the correct syntax to use gnc-fq-dump to get an exchange rate is:
cd C:\Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
perl gnc-fq-dump currency USD EUR
See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
Another thing to check is your version of Strawberry perl. Use perl -v to
check the version.
Maybe you need to upgrade to the latest Strawberry perl.
You can uninstall your current Strawberry perl from Start, Settings, Apps.
Regards, Chris Good
Message: 2
Date: Sun, 18 Jul 2021 15:30:43 +0100
From: "david.rom...@davidjromano.com"
To: Geoff
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com>
Content-Type: text/plain; charset=us-ascii
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the
problem.
David
Sent from my iPhone
> On 18 Jul 2021, at 13:55, Geoff wrote:
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment
> variable
when testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
> gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
> 08:45:05") (last . #e4.8841) (currency . "RON")))
>
>
> Also, it is normal to get the blank command window when doing Get
> Quotes
on Windows.
>
> Regards
>
> Geoff
> =
>
>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>> I'm having a problem with GNC-FQ not being able to retrieve currency
>> data for the GBP / EUR currency pair.
>> I had previously used FQ back when the data source was Yahoo, but
>> when the Yahoo died I stopped using it.
>> I now need to pick up GBP and EUR rates so I've installed the
>> components required to get the Alphavantage feed to work - or so I hoped!
>> Here's where I've got to so far:
>> 1.I updated GNU Cash to current 4.6.
>> 2.I installed Strawberry Perl version 5.32.1.1
>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>> 5.I ran perl gnc-fq-check and got the following result:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check ("1.51" "aex"
>> "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia"
>> "bamosz" "bet" "bloomberg" "bourso" "bse" "bse
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi David
This problem is because you are pasting not just the command itself, but
also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com wrote:
Good morning Geoff - I'm now back in the office and have run through your
suggestions with the following result:
a) C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=[MYKEY]
> LOOKS OK
b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
[MYKEY]
> RETURNS KEY CORRECTLY
c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") |
perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
> RETURNS ERROR STRING:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD"
"GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
Can't open ((USD: No such file or directory at
gnc-fq-helper line 331.
Can't open (symbol: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open USD): No such file or directory at
gnc-fq-helper line 331.
Can't open (gnc:time-no-zone: No such file or
directory at gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open 2021-03-10 08:40:01): Invalid argument at
gnc-fq-helper line 331.
Can't open (last: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open #e0.72002): No such file or directory at
gnc-fq-helper line 331.
Can't open (currency: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open GBP))): No such file or directory at
gnc-fq-helper line 331.
Unfortunately I'm not a PERL coder but the code block starting at line 331
is the following:
while(<>) {
my $result = parse_input_line($_);
if(!$result) {
print STDERR "$prgnam: bad input line ($_)\n";
exit 1;
}
-Original Message-
From: Geoff
Sent: 18 July 2021 13:55
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David
Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get Quotes on
Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
I'm having a problem with GNC-FQ not being able to retrieve currency
data for the GBP / EUR currency pair.
I had previously used FQ back when the data source was Yahoo, but when
the Yahoo died I stopped using it.
I now need to pick up GBP and EUR rates so I've installed the
components required to get the Alphavantage feed to work - or so I hoped!
Here's where I've got to so far:
1. I updated GNU Cash to current 4.6.
2. I installed Strawberry Perl version 5.32.1.1
3. I'm Running Windows 10 Professional 21H1 build 19043.110
4. I added my aphhavantage key in Preferences \ Online Quotes
5. I ran perl gnc-fq-check and got the following result:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia"
"bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada"
"canadamutual"
"comdirect" "cse" "deka" "dutch" "dwsfunds" "europe"
"fetch_live_currencies"
"fidelity" "fidelity_direct" "finanzpartner" "fondsweb" "fool" "ftfunds"
"fundata" "fundlibrary" "g
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hi David
This problem is because you are pasting not just the command itself, but also
its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37") (last .
#e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm,
david.rom...@davidjromano.com wrote:
> Good morning Geoff - I'm now back in the office and have run through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP")
> |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No such file or
> directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No such file
> or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open USD): No such file or
> directory at
> gnc-fq-helper line 331.
> Can't open (gnc:time-no-zone: No
> such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10 08:40:01):
> Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No such file or
> directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002): No such
> file or directory at
> gnc-fq-helper line 331.
> Can't open (currency: No such
> file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open GBP))): No such file
> or directory at
> gnc-fq-helper line 331.
>
> Unfortunately I'm not a PERL coder but the code block starting at line 331
> is the following:
>
> while(<>) {
>
> my $result = parse_input_line($_);
>
> if(!$result) {
>print STDERR "$prgnam: bad input line ($_)\n";
> exit 1;
>}
>
>
> -Original Message-
> From: Geoff < cleanoutmys...@gmail.com>
> Sent: 18 July 2021 13:55
> To: david.rom...@davidjromano.com;
> gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
> to collect data
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment variable
> when testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
> gnc-fq-helper (("EUR" (symbol . "EUR"
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi again David
Here is an easy way to determine if Perl and Finance::Quote are working
correctly, independently of GnuCash itself.
Set your Alphavantage key as before, and type in this one liner:
perl -MFinance::Quote -e "my $q = Finance::Quote->new(); print
$q->currency(q/USD/,q/GBP/);"
Expected result:
0.72953
[Note to other readers - the above is the syntax for Windows]
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 9:04 pm, david.rom...@davidjromano.com wrote:
Good Morning Chris,
Many thanks for this, which I've just worked through with the results as
below - I've also worked through Geoff's suggestions.
The results are not encouraging though!
You are right that I'm running FC 1.51
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.51).
C:\>perl -v
This is perl 5, version 32, subversion 1 (v5.32.1) built for
MSWin32-x86-multi-thread-64int (I think this is the latest version.)
1. cpan upgrade DONE
cpan> upgrade
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
C:\>cpan -v
Loading internal logger. Log::Log4perl recommended
for better logging
>(info): C:\Strawberry\perl\bin/cpan script version
1.676, CPAN.pm version 2.28
2. gnc-fq-dump
After setting the alphavantage key (and confirming with echo) this fails as
follows:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency USD EUR
> RETURNS ERROR STRING:
syswrite() on unopened filehandle GEN0 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
syswrite() on unopened filehandle GEN1 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
1 USD = EUR
However, gnc-fq is still not working so maybe it's an issue with FC 1.51 or
maybe I have some issue with Perl that I don't understand.
-Original Message-
From: Chris Good
Sent: 19 July 2021 01:48
To: gnucash-user@gnucash.org
Cc: david.rom...@davidjromano.com
Subject: RE: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David,
From memory Finance::Quote 1.51 is broken and the nice maintainer is working
on 1.52.
The problems were to do with missing dependencies for some cpan modules.
In the meantime you might try, from a cmd.exe window:
cpan upgrade
to upgrades all modules.
Note that the correct syntax to use gnc-fq-dump to get an exchange rate is:
cd C:\Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
perl gnc-fq-dump currency USD EUR
See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
Another thing to check is your version of Strawberry perl. Use perl -v to
check the version.
Maybe you need to upgrade to the latest Strawberry perl.
You can uninstall your current Strawberry perl from Start, Settings, Apps.
Regards, Chris Good
Message: 2
Date: Sun, 18 Jul 2021 15:30:43 +0100
From: "david.rom...@davidjromano.com"
To: Geoff
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com>
Content-Type: text/plain; charset=us-ascii
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the
problem.
David
Sent from my iPhone
On 18 Jul 2021, at 13:55, Geoff wrote:
Hi David
Did you remember to set your alphavantage key as an environment
variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get
Quotes
on Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
I'm having a problem with GNC-FQ not being able to retrieve currency
data for the GBP / EUR currency pair.
I had previously used FQ back when the data source was Yahoo, but
when the Yahoo died I stopped using it.
I now need to pick up GBP and EUR rates so I've installed the
components required to get the Alphavantage feed to work - or so I hoped!
Here's where I've got to so far:
1.I updated GNU Cash to current 4.6.
2.I inst
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Hi David
This problem is because you are pasting not just the command itself, but
also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
wrote:
> Good morning Geoff - I'm now back in the office and have run through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo
%ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency
"USD" "GBP") |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo
(currency "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No such
file or directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open USD): No such
file or directory at
> gnc-fq-helper line 331.
> Can't open
(gnc:time-no-zone: No such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10
08:40:01): Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No such
file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002): No
such file or directory at
> gnc-fq-helper line 331.
> Can't open (currency: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open GBP))): No
such file or directory at
> gnc-fq-helper line 331.
>
> Unfortunately I'm not a PERL coder but the code block starting at
line 331
> is the following:
>
> while(<>) {
>
> my $result = parse_input_line($_);
>
> if(!$result) {
> print STDERR "$prgnam: bad input line ($_)\n";
> exit 1;
> }
>
>
> -Original Message-
> From: Geoff mailto:cleanoutmys...@gmail.com>>
> Sent: 18 July 2021 13:55
> To: david.rom...@davidjromano.com
; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ
Not able
> to collect data
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment variable
> when testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.720
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open 2021-03-10
> 08:40:01): Invalid argument at
>
> > gnc-fq-helper line 331.
>
> > Can't open (last: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open #e0.72002):
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (currency:
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open GBP))): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> >
>
> > Unfortunately I'm not a PERL coder but the code block starting at
> line 331
>
> > is the following:
>
> >
>
> > while(<>) {
>
> >
>
> > my $result = parse_input_line($_);
>
> >
>
> > if(!$result) {
>
> >print STDERR "$prgnam: bad input line ($_)\n";
>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Geoff,
I forgot to add the screenshot.
After hitting enter there is a short pause and the CMD window reverts to it's
state prior to the command
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open 2021-03-10
> 08:40:01): Invalid argument at
>
> > gnc-fq-helper line 331.
>
> > Can't open (last: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open #e0.72002):
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (currency:
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open GBP))): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> >
>
> > Unfortunately I'm not a PERL coder but the code block starting at
> line 331
>
> > is the following:
>
> >
>
> > while(<>) {
>
> >
>
> > my $result = parse_input_line($_);
>
> >
>
> > if(!$result) {
>
> >print STDERR "$prgnam: bad input line ($_)\n";
>
> > exit 1;
>
> >}
>
> >
>
> >
>
> > -Original
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
OK, I have been testing using Finance::Quote version 1.49. As a
*workaround* you could try downgrading to that version?
It is getting late here, I'll try and upgrade to a later version of
Finance::Quote and see if I can reproduce your problem later this week.
Meantime someone else may have a suggestion.
Regards
Geoff
=
On 19/07/2021 10:04 pm, david.rom...@davidjromano.com wrote:
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Hi David
This problem is because you are pasting not just the command itself,
but also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
wrote:
> Good morning Geoff - I'm now back in the office and have run
through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo
%ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency
"USD" "GBP") |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo
(currency "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No
such file or directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open USD): No
such file or directory at
> gnc-fq-helper line 331.
> Can't open
(gnc:time-no-zone: No such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10
08:40:01): Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002):
No such file or directory at
> gnc-fq-helper line 331.
> Can't open (currency:
No such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open GBP))): No
such file or directory at
> gnc-fq-helper line 331.
>
> Unfortunately I'm not a PERL coder but the code block starting at
line 331
> is the following:
>
> while(<>) {
>
> my $result = parse_input_line($_);
>
> if(!$result) {
>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Thanks Geoff - I thought you were west of me (London time) not east!
I'll try to work out how to downgrade.
-Original Message-
From: Geoff
Sent: 19 July 2021 13:12
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
OK, I have been testing using Finance::Quote version 1.49. As a
*workaround* you could try downgrading to that version?
It is getting late here, I'll try and upgrade to a later version of
Finance::Quote and see if I can reproduce your problem later this week.
Meantime someone else may have a suggestion.
Regards
Geoff
=
On 19/07/2021 10:04 pm, david.rom...@davidjromano.com wrote:
> I think your right - does not look good - no output at all
>
> C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
> Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
>
> C:\Program Files (x86)\gnucash\bin>
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call:
> David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 13:01
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hmmm, something is definitely broken there.
>
> Let me know what you get with my second email.
>
> Geoff
> =
>
> On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
>> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>>
>> I’ve attached the screenshot
>>
>> Best regards,
>>
>> David Romano,
>>
>> UK Direct line: +44 (0) 23 9234 1647
>>
>> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>>
>> Skype Video Call: David.J.Romano
>>
>> -Original Message-
>> From: Geoff
>> Sent: 19 July 2021 12:41
>> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
>> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ
>> Not able to collect data
>>
>> Hi David
>>
>> This problem is because you are pasting not just the command itself,
>> but also its expected output.
>>
>> This is the command:
>>
>> echo (currency "USD" "GBP") | perl gnc-fq-helper
>>
>> And this is the expected output:
>>
>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
>> (last . #e0.72922) (currency . "GBP")))
>>
>> See attached screenshot.
>>
>> Hope this helps.
>>
>> Regards
>>
>> Geoff
>>
>> =
>>
>> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
>> wrote:
>>
>> > Good morning Geoff - I'm now back in the office and have run
>> through your
>>
>> > suggestions with the following result:
>>
>> >
>>
>> >
>>
>> > a) C:\Program Files (x86)\gnucash\bin>set
>>
>> > ALPHAVANTAGE_API_KEY=[MYKEY]
>>
>> >
>>
>> > > LOOKS OK
>>
>> >
>>
>> > b) C:\Program Files (x86)\gnucash\bin>echo
>> %ALPHAVANTAGE_API_KEY%
>>
>> > [MYKEY]
>>
>> >
>>
>> > > RETURNS KEY CORRECTLY
>>
>> >
>>
>> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
>> "USD" "GBP") |
>>
>> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>> "2021-03-10
>>
>> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>>
>> >
>>
>> > > RETURNS ERROR STRING:
>>
>> >
>>
>> > C:\Program Files (x86)\gnucash\bin>echo
>> (currency "USD"
>>
>> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>>
>> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>>
>> >
>>
>> > Can't open ((USD: No
>> such file or directory at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't open (symbol: No
>> such file or directory at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't do inplace edit: .
>> is not a regular file at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't open USD): No
>> such file or directory at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't open
>> (gnc:time-no-zone: No such file or
>>
>> > directory at gnc-fq-helper line 331.
>>
>> > Can't do inplace edit: .
>> is not a regular file at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't open 2021-03-10
>> 08:40:01): Invalid argument at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't open (last: No
>> such file or directory at
>>
>> > gnc-fq-helper line 331.
>>
>> > Can't do inplace edit: .
>> is not a regular file at
>>
>> > gnc-fq-helper line
Re: [GNC] Python Error
I should have mentioned that.
I built from source with "cmake -DCMAKE_INSTALL_PREFIX=/usr/local
-DWITH_AQBANKING=OFF -DWITH_PYTHON=ON"
On Sun, Jul 18, 2021 at 6:05 PM David Cousens
wrote:
> Robin
>
> Did you build GnuCash from source or use the flatpack? If the former did
> you
> include the switch "-DWITH_PYTHON=ON" in the cmake command when building?
>
> David Cousens
>
> On Sun, 2021-07-18 at 17:29 -0500, Robin Chattopadhyay wrote:
> > Ubuntu 20.04 LTS
> > Gnucash 4.6
> >
> > After upgrading to 4.6 my Python script broke and I'm not sure what to do
> > to fix it.
> >
> > It's failing at "import gnucash" with:
> >
> > Traceback (most recent call last):
> > File
> >
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> > line 14, in swig_import_helper
> > return importlib.import_module(mname)
> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
> > import_module
> > return _bootstrap._gcd_import(name[level:], package, level)
> > File "", line 1014, in _gcd_import
> > File "", line 991, in _find_and_load
> > File "", line 975, in
> _find_and_load_unlocked
> > File "", line 657, in _load_unlocked
> > File "", line 556, in module_from_spec
> > File "", line 1166, in
> create_module
> > File "", line 219, in
> > _call_with_frames_removed
> > ImportError:
> >
> /home/robin/.local/lib/python3.8/site-packages/gnucash/_gnucash_core_c.so:
> > undefined symbol: gnc_pricedb_lookup_latest_before_t64
> >
> > During handling of the above exception, another exception occurred:
> >
> > Traceback (most recent call last):
> > File "", line 1, in
> > File
> > "/home/robin/.local/lib/python3.8/site-packages/gnucash/__init__.py",
> line
> > 6, in
> > from gnucash.gnucash_core import *
> > File
> > "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core.py",
> > line 34, in
> > from gnucash import gnucash_core_c
> > File
> >
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> > line 17, in
> > _gnucash_core_c = swig_import_helper()
> > File
> >
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> > line 16, in swig_import_helper
> > return importlib.import_module('_gnucash_core_c')
> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
> > import_module
> > return _bootstrap._gcd_import(name[level:], package, level)
> > ModuleNotFoundError: No module named '_gnucash_core_c'
> > ___
> > 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] Python Error
HI,
Did you remove any older versions of GnuCash? It is possible that the
engine is finding *older* libraries causing the wrong code to be loaded.
-derek
On Mon, July 19, 2021 8:42 am, Robin Chattopadhyay wrote:
> I should have mentioned that.
>
> I built from source with "cmake -DCMAKE_INSTALL_PREFIX=/usr/local
> -DWITH_AQBANKING=OFF -DWITH_PYTHON=ON"
>
>
>
> On Sun, Jul 18, 2021 at 6:05 PM David Cousens
> wrote:
>
>> Robin
>>
>> Did you build GnuCash from source or use the flatpack? If the former did
>> you
>> include the switch "-DWITH_PYTHON=ON" in the cmake command when
>> building?
>>
>> David Cousens
>>
>> On Sun, 2021-07-18 at 17:29 -0500, Robin Chattopadhyay wrote:
>> > Ubuntu 20.04 LTS
>> > Gnucash 4.6
>> >
>> > After upgrading to 4.6 my Python script broke and I'm not sure what to
>> do
>> > to fix it.
>> >
>> > It's failing at "import gnucash" with:
>> >
>> > Traceback (most recent call last):
>> > File
>> >
>> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
>> > line 14, in swig_import_helper
>> > return importlib.import_module(mname)
>> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
>> > import_module
>> > return _bootstrap._gcd_import(name[level:], package, level)
>> > File "", line 1014, in _gcd_import
>> > File "", line 991, in _find_and_load
>> > File "", line 975, in
>> _find_and_load_unlocked
>> > File "", line 657, in _load_unlocked
>> > File "", line 556, in module_from_spec
>> > File "", line 1166, in
>> create_module
>> > File "", line 219, in
>> > _call_with_frames_removed
>> > ImportError:
>> >
>> /home/robin/.local/lib/python3.8/site-packages/gnucash/_gnucash_core_c.so:
>> > undefined symbol: gnc_pricedb_lookup_latest_before_t64
>> >
>> > During handling of the above exception, another exception occurred:
>> >
>> > Traceback (most recent call last):
>> > File "", line 1, in
>> > File
>> > "/home/robin/.local/lib/python3.8/site-packages/gnucash/__init__.py",
>> line
>> > 6, in
>> > from gnucash.gnucash_core import *
>> > File
>> > "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core.py",
>> > line 34, in
>> > from gnucash import gnucash_core_c
>> > File
>> >
>> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
>> > line 17, in
>> > _gnucash_core_c = swig_import_helper()
>> > File
>> >
>> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
>> > line 16, in swig_import_helper
>> > return importlib.import_module('_gnucash_core_c')
>> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
>> > import_module
>> > return _bootstrap._gcd_import(name[level:], package, level)
>> > ModuleNotFoundError: No module named '_gnucash_core_c'
>> > ___
>> > 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.
>
--
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] Python Error
I did not try removing the previous versions, the only one on this VM is
4.4.
I removed both 4.4 and 4.6 then rebuilt 4.6 and that didn't change anything
BUT I did figure out based on your suggestion that the engine was looking
at the libraries at /usr/lib/python3/dist-packages/. Once I updated the
PYTHONPATH variable to look at /usr/local/lib/python3/dist-packages/
instead it started working again.
Thanks!
Robin
On Mon, Jul 19, 2021 at 8:02 AM Derek Atkins wrote:
> HI,
>
> Did you remove any older versions of GnuCash? It is possible that the
> engine is finding *older* libraries causing the wrong code to be loaded.
>
> -derek
>
> On Mon, July 19, 2021 8:42 am, Robin Chattopadhyay wrote:
> > I should have mentioned that.
> >
> > I built from source with "cmake -DCMAKE_INSTALL_PREFIX=/usr/local
> > -DWITH_AQBANKING=OFF -DWITH_PYTHON=ON"
> >
> >
> >
> > On Sun, Jul 18, 2021 at 6:05 PM David Cousens
> > wrote:
> >
> >> Robin
> >>
> >> Did you build GnuCash from source or use the flatpack? If the former did
> >> you
> >> include the switch "-DWITH_PYTHON=ON" in the cmake command when
> >> building?
> >>
> >> David Cousens
> >>
> >> On Sun, 2021-07-18 at 17:29 -0500, Robin Chattopadhyay wrote:
> >> > Ubuntu 20.04 LTS
> >> > Gnucash 4.6
> >> >
> >> > After upgrading to 4.6 my Python script broke and I'm not sure what to
> >> do
> >> > to fix it.
> >> >
> >> > It's failing at "import gnucash" with:
> >> >
> >> > Traceback (most recent call last):
> >> > File
> >> >
> >>
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> >> > line 14, in swig_import_helper
> >> > return importlib.import_module(mname)
> >> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
> >> > import_module
> >> > return _bootstrap._gcd_import(name[level:], package, level)
> >> > File "", line 1014, in _gcd_import
> >> > File "", line 991, in _find_and_load
> >> > File "", line 975, in
> >> _find_and_load_unlocked
> >> > File "", line 657, in _load_unlocked
> >> > File "", line 556, in module_from_spec
> >> > File "", line 1166, in
> >> create_module
> >> > File "", line 219, in
> >> > _call_with_frames_removed
> >> > ImportError:
> >> >
> >>
> /home/robin/.local/lib/python3.8/site-packages/gnucash/_gnucash_core_c.so:
> >> > undefined symbol: gnc_pricedb_lookup_latest_before_t64
> >> >
> >> > During handling of the above exception, another exception occurred:
> >> >
> >> > Traceback (most recent call last):
> >> > File "", line 1, in
> >> > File
> >> > "/home/robin/.local/lib/python3.8/site-packages/gnucash/__init__.py",
> >> line
> >> > 6, in
> >> > from gnucash.gnucash_core import *
> >> > File
> >> >
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core.py",
> >> > line 34, in
> >> > from gnucash import gnucash_core_c
> >> > File
> >> >
> >>
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> >> > line 17, in
> >> > _gnucash_core_c = swig_import_helper()
> >> > File
> >> >
> >>
> "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py",
> >> > line 16, in swig_import_helper
> >> > return importlib.import_module('_gnucash_core_c')
> >> > File "/usr/lib/python3.8/importlib/__init__.py", line 127, in
> >> > import_module
> >> > return _bootstrap._gcd_import(name[level:], package, level)
> >> > ModuleNotFoundError: No module named '_gnucash_core_c'
> >> > ___
> >> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de
Re: [GNC] piecharts/linecharts turned blank in reports after upgrade
Thank you John. I can confirm that 4.x works with Ubuntu 21.04. As for release 3.11, the problem exists with the unstable version of 3.11 (4064c58cd) only. The stable 3.11 (0fe8ba79e) release works just fine. | * | | 0fe9ba79e21d0545f4c1f9eb373a9450803a83c4 Release GnuCash 3.11 * | | | | | | 4064c58cd03b7f7fb613d593c93569048adb Release GnuCash 3.11 I guess issue lies in it's one of the 163 shared libs that GNC uses that came with Ubuntu 20.04. > Dong Lin, > > You've already demonstrated that the problem doesn't happen on 3.11 so > there's no point going backwards in 3.x. > According to https://repology.org/project/gnucash/versions Ubuntu 21.04 > provides GnuCash 4.5. I suggest that you clean up your system and install > GnuCash 4.4 from apt. If it has trouble displaying charts then raise a bug > on Ubuntu and let their packager figure out what's going on. > > Regards, > John Ralls > >> On Jul 18, 2021, at 6:24 PM, Dong Lin wrote: >> >> >> Thanks for the instructions John. I tried it on a Ubuntu 20.04 system >> with >> no GNC installed. The problem still exists in 4.x. It seems the 3.x >> stable branch works. The issue happens in the unstable branch only. >> >> I also tried running 4.x on a Mac, I can see the plot. Not sure if the >> issue is Linux only or Ubuntu only. >> >> unstable 2455071 bad >> stable 3.6-d42695e75 good >> unstable 3.5-b7479e8fb bad >> >> I cannot build 3.4 or anything older. The fix for >> G_TYPE_INSTANCE_GET_PRIVATE does not apply cleanly on older commits. >> Compile still fails after resolving all conflicts. >> >> So it seems a very old bug that hasn't been fixed in the unstable >> branch. >> I believe running 4.x or any 3.x unstable build on standard issue Ubuntu >> 20.04 should easily reproduce. >> >> >>> It turns out that bisecting between 63232f and 8024f4 flat won't work, >>> they're on different branches. 63232f is on the 3.x branch which is why >>> it >>> works. 2c637a is from 2019 where the master branch splits off from the >>> maint branch (we had a pull request merge mishap at aa53c23 that >>> temporarily collapsed them together, but there hadn't been any >>> development >>> on master at that point anyway). 2c637a is actually the first commit >>> where >>> the two branches start to diverge. >>> >>> Since the failing 8024f4 is on master I looked at the changes leading >>> up >>> to that in a graphical history viewer. One particular change stands >>> out, >>> 2455071 where we start the conversion from jqplot to chartjs. That >>> would >>> be a good place to test. >>> >>> HOWEVER >>> The problem may well be that there are remnants of the Ubuntu-provided >>> GnuCash 3.8 that are interfering with the 4.x chartjs-based chart >>> rendering, so before you do any more bisecting I suggest that you >>> completely remove all GnuCash shared libraries, loadable modules, and >>> Scheme caches from your system, then reinstall GnuCash 4.6 with apt. >>> The >>> shared libraries will be /usr/lib/libgnc* and you can get rid of the >>> shared modules and system cached guile by `sudo rm -rf >>> /usr/lib/gnucash/`. >>> Remove ~/.cache/guile/ccache as well if it exists. That may fix the >>> problem with no more troubleshooting required. If it doesn't `sudo >>> apt-get >>> remove gnucash` to have a clean system before doing any test builds. >>> Guile >>> is exceptionally stupid about what it loads and trying to build GnuCash >>> when there's a package-manager version installed seldom comes out well. >>> >>> If more bisecting is in order, try 2455071. If it works, try 598c37; >>> that's the end of the chartjs upgrades. If that works then check 8024f4 >>> again to make sure that that still fails, then `git bisect >>> --first-parent >>> start 8024f4 598c37` to find the problem commit (which may well be a >>> merge). >>> >>> Regards, >>> John Ralls >>> >>> On Jul 17, 2021, at 8:01 PM, Dong Lin wrote: I see two 3.11 release commits in maint. 3.11-4064c58cd bad 3.11-0fe9ba79e good bisecting in this range pointed to 2c637a971. bisecting in 63232f388..8024f44bc also singled out 2c637a971. But it cannot be as it's just a version update. Reverting it did not produce a good run. > > That the problem seems to have arisen during the transition between > 3.x > and 4.0 does make it a bit more complicated. There are 391 commits > between > 63232f and 8024f4 including 57 merges from maint and 8 feature > branches. > That makes knowing that the problem exists in the latter commit and > not > in > the former less helpful than it might be. > > You can test your hypothesis that a merge caused the regression by > testing > 3.11, the last release on the 3.x maint branch. If that fails you can > bisect between it and 63232f. Use `git bisect`, it's the quickest and > easiest way to find the commit that caused the problem. > > If 3.11 is go
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Out of curiosity, have you tried reinstalling Finance::Quote from the menu
option? I recently resumed use of F::Q, but found it non functional. I
reinstalled from the menu, and things started working again...
Original Message
From: david.rom...@davidjromano.com
Sent: Mon Jul 19 08:04:11 EDT 2021
To: 'Geoff' , gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open 2021-03-10
> 08:40:01): Invalid argument at
>
> > gnc-fq-helper line 331.
>
> > Can't open (last: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open #e0.72002):
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (currency:
> No such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> >
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hello all,
Chris G,
1.51 is not broken. We missed a bug in the F::Q 1.50 release that caused
testing of at least one module to fail for some. 1.51 was pushed to CPAN
a week later. F::Q v1.52 is likely at least a few months out.
David R (and Geoff),
The Windows system I used for testing F::Q 1.51 before pushing it to
CPAN was deleted a few days ago, so under VirtualBox running on OSX
Catalina I created a new Windows 10 Pro (64-bit) virtual machine as to
install GnuCash and F::Q on a completely clean OS.
Windows 10 Pro
Version 21H1
OS Build 19043.928
64-bit operating system, x64-based processor
Installed Strawberry Perl 5.32.1 MSWin32-64-multi-thread
Installed GnuCash 4.6
Installed F::Q 1.51 using cpanm.
C:\Users\bschuck> cpanm Finance::Quote
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "print
$Finance::Quote::VERSION"
1.51
Set my ALPHAVANTAGE_API_KEY.
Tested using gnc-fq-helper:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 13:24:43")
(last . #e0.73157) (currency . "GBP")))
Tested using the one-liner Geoff suggested:
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
0.73132
- Bruce S.
___
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.
