Assigning to the registered perl-Finance-Quote maintainer

Btw, why do we have perl-Finance-Quote-1.380.0-3.mga6 instead of perl-Finance-Quote-1.38.0-3.mga6? Is that because of 

  Version:    %perl_convert_version %{upstream_version}

If so, why does it need to be converted like that?

Source RPM: (none) => perl-Finance-Quote-1.380.0-3.mga6
CC: (none) => marja11
Assignee: bugsquad => shlomif

(In reply to Marja van Waes from comment #1)
> Assigning to the registered perl-Finance-Quote maintainer
> 

thanks! I submitted 1.470 to 6/updates_testing.

> Btw, why do we have perl-Finance-Quote-1.380.0-3.mga6 instead of
> perl-Finance-Quote-1.38.0-3.mga6? Is that because of 
> 
>   Version:    %perl_convert_version %{upstream_version}
> 

yes.

> If so, why does it need to be converted like that?

this is because 1.38 is considered 1.380.0 in perl land.

Assigning to QA for testing.

Status: NEW => ASSIGNED
Assignee: shlomif => qa-bugs

MGA6-32 on Dell Latitude D600 MATE
No installation issues.
Test before update: I have my accounts in gnucash in Euro, added another dummy in AUD, and run the test as described above. I get this error. 
Closed gnucash, installed the update and do the test again. I get the same error.
I noticed that on this test laptop I have gnucash 2.6.19( seen as stable from MCC), while on my MGA6-64 desktop I have 2.6.18, and the newer version not seen in MCC.
This desktop is fully updated (not test repo's enabled).

CC: (none) => herman.viaene

Can the new 1.470 package also be put into "Core Updates Testing"?  I can only see it in "Core 32bit Updates Testing", hence I assume that is why I cannot test it.  Cheers!

Sorry, the 32bit package works.  I followed the instructions at:

    https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

The quote fetching works after obtaining a free key according to the above, and then running:

"""
$ export ALPHAVANTAGE_API_KEY=XXXXXXXXXXXXXX
$ gnc-fq-dump alphavantage CSCO
Finance::Quote fields Gnucash uses:
    symbol: CSCO                 <=== required
      date: 04/17/2018           <=== recommended
  currency: USD                  <=== required
      last: 44.5900              <=\       
       nav:                      <=== one of these
     price:                      <=/        
  timezone:                      <=== optional
"""

Now I need to work out why it doesn't work within Gnucash 2.6.18.  The instructions to go to "Tools->Security Editor" and changing the "Quote Source Information" to "unknown: alphavantage" does nothing.  It seems like this setting cannot be saved (editing the currency a second time shows that the setting is not saved).

More testing shows that the following command works when gnucash is not running and allows (at least some) of the quotes to be updated:

$ gnucash --add-price-quotes /path/to/file.gnucash

After this, I also updated to gnucash 2.6.19 as found in "Core Updates Testing".  This made no difference to the "gnucash --add-price-quotes" fetching or the inability to change the currency source to alphavantage in the Security Editor.

I've built the gnucash 2.6.21a tag from the git repository and the behaviour is the same as 2.6.19.  Fetching quotes via the GUI barely ever works, and the "--add-price-quotes" command line option only updates some of the quotes some of the time (though quite rarely).

I also built the "maint" branch which includes fixes on top of the 3.0 release (I couldn't build the 3.0 tag as it refused to find the GMOCK_ROOT installation path).  However "--add-price-quotes" results in a backtrace.  Fetching quotes from the GUI also has the same problem, 

I need to investigate further, but my guess is that the "Get Quotes" function is looping over the currencies, and terminating the loop if a quote fetching error occurs.  I have the feeling that certain currencies at the end of a long list can never be reached.  I might have to shift the conversation upstream.

In the light of previous comments, I am feedbacking this until the situation is clearer. It would be nice to see the bug package named somewhere; one can deduce:
 perl-Finance-Quote-1.470.0-3.mga6
Also, it looks as as if Gnucash itself might need to be part of this update. If so, should it not be explicitly included & cited?

Keywords: (none) => feedback

From my testing, the new perl-Finance-Quote-1.470.0-3.mga6 package works reasonably well.  The Alphavantage quotes using their "key" works most of the time (as advertised, a heavy load on their server sometimes results in no quote being retrieved).  I used a Gnucash tool for the testing:

$ gnc-fq-dump currency USD XAU
1 USD = 0.00075451 XAU
$ gnc-fq-dump currency USD XAU
1 USD = 0.00075451 XAU
$ gnc-fq-dump currency USD XAU
Illegal division by zero at /usr/lib/perl5/vendor_perl/5.22.3/Finance/Quote.pm line 289.
$ gnc-fq-dump currency USD CNY
1 USD = <unknown> CNY
$ gnc-fq-dump currency USD CNY
1 USD = <unknown> CNY
$ gnc-fq-dump currency USD CNY
1 USD = <unknown> CNY
$ gnc-fq-dump currency CNY
$ gnc-fq-dump currency CNY EUR
1 CNY = 0.12991535 EUR
$ gnc-fq-dump currency CNY USD
1 CNY = 0.15822534 USD
$ gnc-fq-dump currency USD CNY
1 USD = 6.3201 CNY
$ 

Gnucash on the other hand is not doing so well.  My guess is that a single retrieval failure results in the rest of the current list not being updated.  I will report this separate issue upsteam.

Here is the GnuCash bug report:  https://bugzilla.gnome.org/show_bug.cgi?id=795564

I have also reported the issue upstream to Finance::Quote:  https://rt.cpan.org/Public/Bug/Display.html?id=125310

After following https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
and getting an api key for alphavantage, gnucash is working ok, at least for
Canadian/U.S conversion, with the update.

While there may be problems in gnucash working when the online service is not
responding, that's not a reason to hold this update.

I'm validating both this update and the gnucash update in bug 23036.

Keywords: feedback => advisory, validated_update
Whiteboard: (none) => MGA6-64-OK
Blocks: (none) => 23036
CC: (none) => davidwhodgins, sysadmin-bugs

An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGAA-2018-0109.html

Resolution: (none) => FIXED
Status: ASSIGNED => RESOLVED