Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[Mitch Hausman via gnucash-user]

Gentlemen,
I did try 32 bit strawberry perl in one of my many install scenarios because 
GnuCash is 32bit, and I considered both apps might need to be consistently 
storedthat probably got lost in the sauce of my long emailssorry about that... 
i'll try to keep this short
today, I tried the "normal path" install on a friend's win 10 (home) 64bit 
machineit worked perfectly (though a message flashed by about suspicious 
behavior that Sonar noticed)Sonar is a Norton product
so there's something different about the machines (I hope it's that and not 
user madness)
I have win 10 pro, they have win 10 homeI have Avast free antivirus, they have 
Norton
My first install on my machine failed (same "normal" path) I didn't see any 
Avast notifications
I reinstalled GnuCash and Strawberry perl (64 bit and 32 bit), F-Q via cpanm, 
many times, many different waysI did not risk cleaning out the registry, so the 
new installs weren't really clean
I'm tired of experimenting with install scenariosI'd rather be learning how to 
use the software
So, I withdraw the request for help
The win 10 GnuCash install works fine (just not on my box)(BTY Linux install 
works fine as well)
My install solution was ugly, but I eventually got F-Q  working within GnuCash
Thanks for the time and effort!
Stay Healthy,
Mitch
 




-Original Message-
From: David H 
To: Mitchell Hausman 
Cc: Gnucash Users 
Sent: Fri, Mar 13, 2020 5:34 pm
Subject: Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 
3.8b+(2019-12-29) on windows 10 64 bit

Ah forget that, I found your comment in that long email you sent Frank :-)
Cheers David.
On Sat, 14 Mar 2020 at 07:30, David H  wrote:

Mitchell,
You haven't explained what your issue was with trying to install it originally 
as per the gnucash instructions - please clarify as this might have a bearing 
on what you are experiencing as per your following emails.
 On Win 10 Pro you need to click the Windows Start Menu icon, then All Apps, 
then go to the "G" group where you should find a"Gnucash" group. If you expand 
this you should find the "Install Online Price Retrieval" which you click on to 
install Strawberry Perl and the rest of the price retrieval app.
So did you find this OK and get some sort of error when you ran it or what ?
Cheers David.


On Thu, 12 Mar 2020 at 06:47, Mitchell Hausman via gnucash-user 
 wrote:

Hello,

I'm testing GnuCash software on windows 10 64bit, to see if it is useful 
for me (as opposed to buying Quicken!)


I wasn't able to install Finance::Quote successfully using this procedure:

Microsoft Windows:
??? Close GnuCash.
??? Run Install Online Price Retrieval which can be found in the GnuCash 
???Start??? menu entry.

===


So, i downloaded and installed Strawberry Perl 5.30.q.q-*64 bit* 
(successfully), then used cpan to install Finance::Quote, which also 
installed successfully

my windows environment has the correct Alpha Vantage?? key, as does 
GnuCash in edit/preferences/online quotes

i don't know if it is working properly, though, and, i couldn't figure 
out how to run gnu-fq-dump (unless i have to do it in the session in 
which i installed Finance::Quote)


i tried in the CMD window:


C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump
Loading internal logger. Log::Log4perl recommended for better logging
CPAN: CPAN::SQLite loaded ok (v0.217)
CPAN: LWP::UserAgent loaded ok (v6.42)
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
CPAN: YAML::XS loaded ok (v0.80)
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Database was generated on Sat, 07 Mar 2020 16:00:43 GMT
Updating database file ... Done!
 >(error): Could not expand [gnc-fq-dump]. Check the module name.
 >(info): I can suggest names if you install one of 
Text::Levenshtein::XS, Text::Levenshtein::Damerau::XS, 
Text::Levenshtein, and Text::Levenshtein::Damerau::PP
 >(info): and you provide the -x option on invocation.
 >(error): Skipping gnc-fq-dump because I couldn't find a matching 
namespace.

===

i added a fund to security editor (it isn't in my investments accounts 
as a sub account--- is that a problem???), and checked get quotes


when i?? execute get quotes function (in price database, not price 
"editor", with or without funds added), GnuCash closes/crashes and i 
have a .LCK file

from the GnuCash guide:

You may occasionally see .LNK and .LCK files appear. These do not store 
any data, but they are created
to prevent more than one user from opening the same file at the same 
time. These files are aut

Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[John Ralls]

That shouldn't matter at all, we're not linking libperl. prices.scm popens perl 
to run gnc-fq-helper, hooking to its stdout to get scheme-formatted strings 
that prices.scm parses.

Regards,
John Ralls


> On Mar 13, 2020, at 2:47 PM, Frank H. Ellenberger 
>  wrote:
> 
> I would suspect the crash happens because of mixing 32-bit Gnucash with
> 64-bit perl, but I am no Windows user.
> 
> ~Frank
> 
>  Weitergeleitete Nachricht ----
> Betreff: Re: [GNC] problems with Finance::Quote 1.49 and and gnucash
> Build ID: 3.8b+(2019-12-29) on windows 10 64 bit
> Datum: Fri, 13 Mar 2020 13:54:02 -0400
> Von: Mitchell Hausman 
> An: Frank H. Ellenberger 
> 
> Hello Frank,
> 
> I still think there's a windows f-q install problem when using GnuCash
> to invoke it
> 
> Unfortunately,
> 
> 1)  because i'm such a muddler, it's hard to isolate variables and
> determine the actual correct path to a "normal" windows install of
> Finance::Quote for GnuCash use
> 
> 2)  i'm just beginning to understand how to use GnuCash, so some of the
> errors might be between the screen and the keyboard, (as they used to
> say), but i don't think so
> 
> 
> I have a 57 page LibreOffice document showing the steps to a successful
> install in windows (it's that many pages because i copied all the
> complete perl scripts into it)
> 
> IMHO, it shouldn't require so many steps by the user
> 
> The Windows install steps should be (again, IMHO):
> 
> 1) install Gnucash
> 
> 2) select install online price retrieval from windows start menu (image
> below)
> 
> done!
> 
> *those steps don't appear to work (f-q install fails, or, get quote call
> crashes GnuCash)!*
> 
> 
> *Bottom Line:*
> 
> *Manjaro Linux 19.0 64 bit:*
> 
> Using Octopi to install Gnucash, you have the option of adding
> dependencies, including Finance::Quote
> 
> I previously thought "get quote" function wasn't working on Linux, but
> maybe i was setting up the security editor, or price database/price
> editor incorrectly
> 
> rechecking today, get quote within GnuCash succeeds,  with a normal install!
> 
> 
> *Win 10 64 bit:*
> 
> from gnucash-guide (downloaded from https://gnucash.org/docs.phtml, for
> windows users),  if you want online price retrieval for GnuCash, you do
> have to install F-Q separately as a gnucash sub menu from the windows
> start menu:
> 
> 
> *that did not work (Gnucash calls to F-Q caused crash)*
> 
> **
> 
> what worked for me (summarized from my install documentation mentioned
> above), is:
> 
> 3/12/2020 6:11 pm
> 
> after uninstalling straberryperl and gnucash (without registry cleanup)
> 
> 1. installed strawberry perl 64 bit
> 
> 
> 2. used cpanm Module::Name  to install finance::quote in admin cmd window:
> 
> C:\WINDOWS\system32>cpanm Finance::Quote
> 
> .
> 
> .
> 
> .
> 
> *Successfully installed Finance-Quote-1.49*
> 
> 9 distributions installed
> 
> 3. install GnuCash 3.8
> 
> 
> 4. because it blew up (crashed) with "get quote" call, i installed F-Q
> from the windows start menu (see image above)
> 
> it succeeded:
> 
> .
> 
> .
> 
> .
> 
> Appending installation info to C:\STRAWB~1\perl\lib/perllocal.pod
> 
> SBECK/Date-Manip-6.81.tar.gz
> 
> C:\STRAWB~1\c\bin\gmake.exe install UNINST=1 -- OK
> 
> *Finance::Quote is up to date (1.49).*
> 
> 
> * Check environment variable ALPHAVANTAGE_API_KEY
> 
> 
> ***
> 
> *** You need an API key (from https://www.alphavantage.co)
> 
> *** to run the Perl module Finance::Quote.
> 
> ***
> 
> *** Make it available to GnuCash by
> 
> *** - setting the environment variable ALPHAVANTAGE_API_KEY (done) or
> 
> *** - starting GnuCash and adding the Alpha Vantage api key in
> 
> *** Edit->Preferences->Online Quotes
> 
> ***
> 
> 
> * Run gnc-fq-check   //shows available quote sources
> 
> 
> ("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"
> "fin

Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[David H]

Ah forget that, I found your comment in that long email you sent Frank :-)

Cheers David.

On Sat, 14 Mar 2020 at 07:30, David H  wrote:

> Mitchell,
>
> You haven't explained what your issue was with trying to install it
> originally as per the gnucash instructions - please clarify as this might
> have a bearing on what you are experiencing as per your following emails.
>
> On Win 10 Pro you need to click the Windows Start Menu icon, then All
> Apps, then go to the "G" group where you should find a"Gnucash" group. If
> you expand this you should find the "Install Online Price Retrieval" which
> you click on to install Strawberry Perl and the rest of the price retrieval
> app.
>
> So did you find this OK and get some sort of error when you ran it or what
> ?
>
> Cheers David.
>
>
>
> On Thu, 12 Mar 2020 at 06:47, Mitchell Hausman via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>> Hello,
>>
>> I'm testing GnuCash software on windows 10 64bit, to see if it is useful
>> for me (as opposed to buying Quicken!)
>>
>>
>> I wasn't able to install Finance::Quote successfully using this procedure:
>>
>> Microsoft Windows:
>> ??? Close GnuCash.
>> ??? Run Install Online Price Retrieval which can be found in the GnuCash
>> ???Start??? menu entry.
>>
>>
>> ===
>>
>>
>> So, i downloaded and installed Strawberry Perl 5.30.q.q-*64 bit*
>> (successfully), then used cpan to install Finance::Quote, which also
>> installed successfully
>>
>> my windows environment has the correct Alpha Vantage?? key, as does
>> GnuCash in edit/preferences/online quotes
>>
>> i don't know if it is working properly, though, and, i couldn't figure
>> out how to run gnu-fq-dump (unless i have to do it in the session in
>> which i installed Finance::Quote)
>>
>>
>> i tried in the CMD window:
>>
>>
>> C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump
>> Loading internal logger. Log::Log4perl recommended for better logging
>> CPAN: CPAN::SQLite loaded ok (v0.217)
>> CPAN: LWP::UserAgent loaded ok (v6.42)
>> Fetching with LWP:
>> http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
>> CPAN: YAML::XS loaded ok (v0.80)
>> Fetching with LWP:
>> http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
>> Fetching with LWP:
>> http://cpan.strawberryperl.com/modules/03modlist.data.gz
>> Database was generated on Sat, 07 Mar 2020 16:00:43 GMT
>> Updating database file ... Done!
>>  >(error): Could not expand [gnc-fq-dump]. Check the module name.
>>  >(info): I can suggest names if you install one of
>> Text::Levenshtein::XS, Text::Levenshtein::Damerau::XS,
>> Text::Levenshtein, and Text::Levenshtein::Damerau::PP
>>  >(info): and you provide the -x option on invocation.
>>  >(error): Skipping gnc-fq-dump because I couldn't find a matching
>> namespace.
>>
>>
>> ===
>>
>> i added a fund to security editor (it isn't in my investments accounts
>> as a sub account--- is that a problem???), and checked get quotes
>>
>>
>> when i?? execute get quotes function (in price database, not price
>> "editor", with or without funds added), GnuCash closes/crashes and i
>> have a .LCK file
>>
>> from the GnuCash guide:
>>
>> You may occasionally see .LNK and .LCK files appear. These do not store
>> any data, but they are created
>> to prevent more than one user from opening the same file at the same
>> time. These files are automatically
>> created when you open the file, to lock it so no one else can access it.
>> When you close your GnuCash
>> session or open another file, GnuCash unlocks the first data file by
>> deleting the .LCK and .LNK files.
>>
>> If GnuCash crashes while you have a data file open, the .LCK and .LNK
>> files are not deleted. The next
>> time you try to open GnuCash, you will get a warning message that the
>> file is locked. The warning message
>> appears because the .LNK and .LCK files are still in your directory. It
>> is safe to choose Yes to open the
>> file, but you should delete the .LNK and .LCK files (using a terminal
>> window or your file manager). Once
>> those files are deleted, you will not get the warning message again
>> unless GnuCash crashes.
>>
>>
>> So, I think GnuCash believes Finance::Quote is another user, maybe,
>> because I installed GnuCash manually (couldn't succeed any other way),
>> and they aren't properly linked
>>
>> how do i get Finance::Quote integrated with my GnuCash install, so i can
>> use it (i.e., doesn't crash)?
>>
>>
>> Thanks!
>>
>>
>>
>> --
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> ___
>> 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 

Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[David H]

Mitchell,

You haven't explained what your issue was with trying to install it
originally as per the gnucash instructions - please clarify as this might
have a bearing on what you are experiencing as per your following emails.

On Win 10 Pro you need to click the Windows Start Menu icon, then All Apps,
then go to the "G" group where you should find a"Gnucash" group. If you
expand this you should find the "Install Online Price Retrieval" which you
click on to install Strawberry Perl and the rest of the price retrieval app.

So did you find this OK and get some sort of error when you ran it or what ?

Cheers David.



On Thu, 12 Mar 2020 at 06:47, Mitchell Hausman via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> I'm testing GnuCash software on windows 10 64bit, to see if it is useful
> for me (as opposed to buying Quicken!)
>
>
> I wasn't able to install Finance::Quote successfully using this procedure:
>
> Microsoft Windows:
> ??? Close GnuCash.
> ??? Run Install Online Price Retrieval which can be found in the GnuCash
> ???Start??? menu entry.
>
>
> ===
>
>
> So, i downloaded and installed Strawberry Perl 5.30.q.q-*64 bit*
> (successfully), then used cpan to install Finance::Quote, which also
> installed successfully
>
> my windows environment has the correct Alpha Vantage?? key, as does
> GnuCash in edit/preferences/online quotes
>
> i don't know if it is working properly, though, and, i couldn't figure
> out how to run gnu-fq-dump (unless i have to do it in the session in
> which i installed Finance::Quote)
>
>
> i tried in the CMD window:
>
>
> C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump
> Loading internal logger. Log::Log4perl recommended for better logging
> CPAN: CPAN::SQLite loaded ok (v0.217)
> CPAN: LWP::UserAgent loaded ok (v6.42)
> Fetching with LWP:
> http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
> CPAN: YAML::XS loaded ok (v0.80)
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
> Fetching with LWP:
> http://cpan.strawberryperl.com/modules/03modlist.data.gz
> Database was generated on Sat, 07 Mar 2020 16:00:43 GMT
> Updating database file ... Done!
>  >(error): Could not expand [gnc-fq-dump]. Check the module name.
>  >(info): I can suggest names if you install one of
> Text::Levenshtein::XS, Text::Levenshtein::Damerau::XS,
> Text::Levenshtein, and Text::Levenshtein::Damerau::PP
>  >(info): and you provide the -x option on invocation.
>  >(error): Skipping gnc-fq-dump because I couldn't find a matching
> namespace.
>
>
> ===
>
> i added a fund to security editor (it isn't in my investments accounts
> as a sub account--- is that a problem???), and checked get quotes
>
>
> when i?? execute get quotes function (in price database, not price
> "editor", with or without funds added), GnuCash closes/crashes and i
> have a .LCK file
>
> from the GnuCash guide:
>
> You may occasionally see .LNK and .LCK files appear. These do not store
> any data, but they are created
> to prevent more than one user from opening the same file at the same
> time. These files are automatically
> created when you open the file, to lock it so no one else can access it.
> When you close your GnuCash
> session or open another file, GnuCash unlocks the first data file by
> deleting the .LCK and .LNK files.
>
> If GnuCash crashes while you have a data file open, the .LCK and .LNK
> files are not deleted. The next
> time you try to open GnuCash, you will get a warning message that the
> file is locked. The warning message
> appears because the .LNK and .LCK files are still in your directory. It
> is safe to choose Yes to open the
> file, but you should delete the .LNK and .LCK files (using a terminal
> window or your file manager). Once
> those files are deleted, you will not get the warning message again
> unless GnuCash crashes.
>
>
> So, I think GnuCash believes Finance::Quote is another user, maybe,
> because I installed GnuCash manually (couldn't succeed any other way),
> and they aren't properly linked
>
> how do i get Finance::Quote integrated with my GnuCash install, so i can
> use it (i.e., doesn't crash)?
>
>
> Thanks!
>
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> 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

Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[Frank H. Ellenberger]

Hi Mitch,

please always answer to all or the list. I am no Windows user, so others
might have better ideas.

BTW the full quotes of websites are hard read.

A few places with additional infos:
https://wiki.gnucash.org/wiki/Online_Quotes
https://www.gnucash.org/docs/v3/C/gnucash-help/tips.html

Am 12.03.20 um 21:48 schrieb Mitchell Hausman:
> Danke
> 
> this page: https://wiki.gnucash.org/wiki/FAQ states:
> 
>    *Windows Users:* Note that recent versions of Finance::Quote
>    require more recent versions of perl on Windows. If you
>    encounter trouble with the installation, remove whichever perl
>    you have, both with Control Panel and Windows Explorer, then run
>    Install Online Price Retrieval, which will install a recent
>    version of Strawberry Perl  for you.
> 
>    /N.B.:/ You don't necessarily want to do that if you're
>    using perl for other purposes, but in that case you probably
>    already know how to upgrade perl.
> 
> i hadn't noticed that reference before today
> 
> i don't know/remember if i had perl installed before gnucash install
> (probably not), but i did run gnucash's " install online price
> retrieval," in windows and it didn't install successfully
> 
> (i thought F-Q  had been separated from GnuCash, and you had to do the
> install online price retrieval per the instruction above - i _assumed_
> if it was a menu option, that gnucash did not come with f-q already
> installed)
> 
> i also thought that meant install f-q, not install recent perl
> 
> i went thru many iterations of installing and uninstalling perl (both 64
> and 32 bit), installing f-q with cpan, installing and uninstalling
> GnuCash, but i don't recall if i uninstalled perl, then used gnucash to
> install f-q
> 
> i think i always did the cpan f-q install after (strawberry) perl install
> 
> only the 64 bit strawberry perl successfully installed f-q
> 
> 
> i finally successfully ran Install Online Price Retrieval, after
> successful cpan install of f-q
> 
> i thought GnuCash had to "think" it had installed f-q successfully
> 
> probably a bad idea, but it worked
> 
> 
> before that, i learned enough perl to run perl scripts that got quotes
> successfully, so i knew f-q was working
> 
> 
> get quote in gnucash worked last night (hooray), but it stopped working
> after i almost replied saying i got it working a few moments ago!
> 
> so yes, i muddled everything with so many uninstalls and installs!
> 
> 
> i guess the correct steps are to uninstall perl and gnucash (they always
> leave stuff in the registry, so it's not a complete uninstall, so i may
> not be able to "unmuddle"))
> 
> install gnucash -*done*
> 
> see if GnuCash "get quotes" works (doesn't crash GnuCash and gets price
> data) - *doesn't work *- get quotes greyed out) see attached screenshot
> 
> if not, run Install Online Price Retrieval - *done, and failed (see
> attached txt file)*
> 
> *
> *
> 
> ... at end of install:
> 
> Stopping: 'install' failed for 'JSON::Parse'.
> 
> * Check environment variable ALPHAVANTAGE_API_KEY
> 
>   ***
>   *** You need an API key (from https://www.alphavantage.co)
>   ***   to run the Perl module Finance::Quote.
>   ***
>   *** Make it available to GnuCash by
>   ***    - setting the environment variable ALPHAVANTAGE_API_KEY (done)
> or //key already entered in both places
>   ***    - starting GnuCash and adding the Alpha Vantage api key in
>   ***    Edit->Preferences->Online Quotes
>   ***
> 
> * Run gnc-fq-check
> 
> 
> You need to install the following Perl modules: //this is today's result
> of gnc-fq-check
>   Finance::Quote
> 
> Use your system's package manager to install them,
> or run 'gnc-fq-update' as root.
> //this failed as well
> missing-lib
> 
> An error occurred, see above.
> 
> Press any key to continue . . .
> 
> 
> 
> _I've come full circle and have to use cpan in perl to install
> finance::quote_
> 
> _but, _cpan install failed as well:
> 
> 
> collect2.exe: error: ld returned 1 exit status
> gmake: *** [Makefile:495: blib\arch\auto\JSON\Parse\Parse.xs.dll] Error 1
>   BKB/JSON-Parse-0.56.tar.gz
>   C:\STRAWB~1\c\bin\gmake.exe -- NOT OK
> Stopping: 'install' failed for 'JSON::Parse'.
> 
> 
> I give up
> 
> Thanks, though
> 
> 
> i ran these yesterday:
> 
> C:\Program Files (x86)\gnucash\bin>perl *gnc-fq-check*
> ("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" "m

Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[Frank H. Ellenberger]

Hello Mitchell,

Am 09.03.20 um 19:35 schrieb Mitchell Hausman via gnucash-user:
> 
> C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump

while gnc-fq-dump is written in perl, it is not provided  by cpan, but
already installed as part of gnucash.

So cpan is right here:
>>(error): Skipping gnc-fq-dump because I couldn't find a matching namespace.

Did you muddle cpan (installer) with perl (processor)?

What is the output of:
perl gnc-fq-check

HTH
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

[Mitchell Hausman via gnucash-user]

Hello,

I'm testing GnuCash software on windows 10 64bit, to see if it is useful 
for me (as opposed to buying Quicken!)



I wasn't able to install Finance::Quote successfully using this procedure:

Microsoft Windows:
??? Close GnuCash.
??? Run Install Online Price Retrieval which can be found in the GnuCash 
???Start??? menu entry.


===


So, i downloaded and installed Strawberry Perl 5.30.q.q-*64 bit* 
(successfully), then used cpan to install Finance::Quote, which also 
installed successfully


my windows environment has the correct Alpha Vantage?? key, as does 
GnuCash in edit/preferences/online quotes


i don't know if it is working properly, though, and, i couldn't figure 
out how to run gnu-fq-dump (unless i have to do it in the session in 
which i installed Finance::Quote)



i tried in the CMD window:


C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump
Loading internal logger. Log::Log4perl recommended for better logging
CPAN: CPAN::SQLite loaded ok (v0.217)
CPAN: LWP::UserAgent loaded ok (v6.42)
Fetching with LWP:
http://cpan.strawberryperl.com/authors/01mailrc.txt.gz
CPAN: YAML::XS loaded ok (v0.80)
Fetching with LWP:
http://cpan.strawberryperl.com/modules/02packages.details.txt.gz
Fetching with LWP:
http://cpan.strawberryperl.com/modules/03modlist.data.gz
Database was generated on Sat, 07 Mar 2020 16:00:43 GMT
Updating database file ... Done!
>(error): Could not expand [gnc-fq-dump]. Check the module name.
>(info): I can suggest names if you install one of 
Text::Levenshtein::XS, Text::Levenshtein::Damerau::XS, 
Text::Levenshtein, and Text::Levenshtein::Damerau::PP

>(info): and you provide the -x option on invocation.
>(error): Skipping gnc-fq-dump because I couldn't find a matching 
namespace.


===

i added a fund to security editor (it isn't in my investments accounts 
as a sub account--- is that a problem???), and checked get quotes



when i?? execute get quotes function (in price database, not price 
"editor", with or without funds added), GnuCash closes/crashes and i 
have a .LCK file


from the GnuCash guide:

You may occasionally see .LNK and .LCK files appear. These do not store 
any data, but they are created
to prevent more than one user from opening the same file at the same 
time. These files are automatically
created when you open the file, to lock it so no one else can access it. 
When you close your GnuCash
session or open another file, GnuCash unlocks the first data file by 
deleting the .LCK and .LNK files.


If GnuCash crashes while you have a data file open, the .LCK and .LNK 
files are not deleted. The next
time you try to open GnuCash, you will get a warning message that the 
file is locked. The warning message
appears because the .LNK and .LCK files are still in your directory. It 
is safe to choose Yes to open the
file, but you should delete the .LNK and .LCK files (using a terminal 
window or your file manager). Once
those files are deleted, you will not get the warning message again 
unless GnuCash crashes.



So, I think GnuCash believes Finance::Quote is another user, maybe, 
because I installed GnuCash manually (couldn't succeed any other way), 
and they aren't properly linked


how do i get Finance::Quote integrated with my GnuCash install, so i can 
use it (i.e., doesn't crash)?



Thanks!



--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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.