[GNC] Update F::Q in flatpak GC?

Tue Aug 22 11:14:35 EDT 2023

Thanks again for your prompt and informative response!

As it turns out, six.pm didn't help me.  Most of the securities I 
wanted, weren't even found on the six-group website.  The one I did find 
on the website wasn't uniquely identified by its Valora (it's available 
in USD and also hedged to CHF), so that gave six.pm indigestion.  I 
wound up getting that one from bloomberg.pm (which only knows the 
unhedged version) and the rest from morningstarch.pm. I look forward to 
the fully dynamic management of the source list(s) in GC. I'm probably 
not the only one who finds all those greyed-out sources confusing ;-)

On 21.08.23 22:56, john wrote:
> The list of sources in the Security Edit dialog is hard coded and not 
> often updated. Entries are grayed out if the item isn't found in the 
> list of sources retrieved from F::Q at start up, which at preset is a 
> lot of them. Sources that are in the F::Q list but don't have a 
> hardcoded entry get added to the Unknown list at the bottom. I found 
> `six` in that list.
>
> 1626.png
> WIP: Incorporate new Finance::Quote get_features() to automatically 
> configure quote sources by vincentl · Pull Request #1626 · 
> Gnucash/gnucash <https://github.com/Gnucash/gnucash/pull/1626>
> github.com <https://github.com/Gnucash/gnucash/pull/1626>
>
> <https://github.com/Gnucash/gnucash/pull/1626>
>  seeks to replace the hard-coded lists, but there are still a few 
> details to work out and the contributor doesn't seem to have a lot of 
> time to work on it.
>
> Regards,
> John Ralls
>
>> On Aug 21, 2023, at 05:12, rsbrux via gnucash-user 
>> <gnucash-user at gnucash.org> wrote:
>>
>> Still one problem (perhaps better handled on the F::Q mailing list):
>> My main reason for wanting to update F::Q is that I saw that SIX.pm 
>> had been updated.
>>
>> However, in GC (flatpak) 5.3+ with the updates to the PM scripts 
>> mentioned below, the Securities Editor still shows the obsolete 
>> SIXfunds and SIXshares as sources and no SIX. Furthermore. both 
>> SIXfunds and SIXshares are greyed out.
>>
>> According to GitHub 
>> (https://github.com/finance-quote/finance-quote/commit/19962d29985549bfefef89891670dafb93e87f27) 
>> SIXfunds.pm and SIXshares.pm were merged into SIX.pm as of 19 Nov., 2020.
>>
>> What do I need to do to get rid of the obsolete entries and get 
>> access to SIX as a source of securities pricing?
>>
>> On 18.08.23 18:16, rsbrux wrote:
>>> Spot on! Deleted the two lines, now working as expected.
>>> Many thanks!
>>>
>>> -----Original Message-----
>>> From: John Ralls <jralls at ceridwen.us>
>>> Sent: Thursday, August 17, 2023 11:23 PM
>>> To: rsbrux <rsbrux at yahoo.com>
>>> Subject: Re: [GNC] Update F::Q in flatpak GC?
>>>
>>> I meant go back to the 1.56 version of IndiaMutual.pm, leaving 
>>> everything
>>> else in place.
>>>
>>> You don't need to delete it, just remove the two lines in Quote.pm that
>>> refer to it.
>>>
>>> Regards,
>>> John Ralls
>>>
>>>
>>>
>>>> On Aug 17, 2023, at 12:21 PM, rsbrux <rsbrux at yahoo.com> wrote:
>>>>
>>>> I don’t need IndiaMutual.pm, but I don’t want to go back to 1.56 
>>>> because I
>>>> would like to try out the updated version of six.pm.  Can I just delete
>>>> IndaiMutual.pm?
>>>>
>>>> Sent from my iPad
>>>>
>>>>> On 17 Aug 2023, at 19:30, john <jralls at ceridwen.us> wrote:
>>>>>
>>>>> IndiaMutual.pm has a new perl dependency IO::String
>>>>> (https://metacpan.org/pod/IO::String) as of F::Q 1.57. That 
>>>>> dependency is
>>>>> in the nightlies but not the release flatpak. It's pure perl and 
>>>>> has no
>>>>> dependencies so you have a couple of ways forward:
>>>>>
>>>>> * Get the source code (there are links in the sidebar on the left on
>>>>> the IO::String page) and install it in the flatpak's perl directory
>>>>> as IO/String.pm
>>>>> * Install a recent nightly build and apply the F::Q update to that
>>>>> * If you don't need the IndiaMutual module you can restore the 1.56
>>>>> version that doesn't need IO::String.
>>>>>
>>>>> Regards,
>>>>> John Ralls
>>>>>
>>>>>
>>>>>> On Aug 17, 2023, at 01:59, rsbrux <rsbrux at yahoo.com> wrote:
>>>>>>
>>>>>> Thanks for the further tips.  I was unable to find gnucash.trace in
>>>>>> either /tmp or /var/tmp (or their subdirectories.  Before trying 
>>>>>> to pipe
>>>>>> the logs to the console as described in
>>>>>> https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output, I tried
>>>>>> running the quote retrieval from the command line, as you suggested.
>>>>>> This resulted in the following error message:
>>>>>>
>>>>>> Price retrieval failed: Finance::Quote check returned error Can't
>>>>>> locate IO/String.pm in @INC (you may need to install the IO::String
>>>>>> module) (@INC contains: /app/lib/perl5/site_perl/5.32.0/x86_64-linux
>>>>>> /ap
>>>>>> p/lib/perl5/site_perl/5.32.0 /app/lib/perl5/5.32.0/x86_64-linux
>>>>>> /app/lib/perl5/5.32.0) at /app/lib/perl
>>>>>> 5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
>>>>>> BEGIN failed--compilation aborted at
>>>>>> /app/lib/perl5/site_perl/5.32.0/Finance/Quote/IndiaMutual.pm line 33.
>>>>>> Compilation failed in require at
>>>>>> /app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
>>>>>> Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains:
>>>>>> /app/lib/perl5/site_perl/5.32.0/x86_64-l
>>>>>> inux /app/lib/perl5/site_perl/5.32.0
>>>>>> /app/lib/perl5/5.32.0/x86_64-linux /app/lib/perl5/5.32.0) at /app/
>>>>>> lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
>>>>>> at /app/bin/finance-quote-wrapper line 113.
>>>>>> Attempt to reload Finance/Quote/IndiaMutual.pm aborted.
>>>>>> Compilation failed in require at
>>>>>> /app/lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
>>>>>> Can't locate Finance/Quote/IndiaMutual in @INC (@INC contains:
>>>>>> /app/lib/perl5/site_perl/5.32.0/x86_64-l
>>>>>> inux /app/lib/perl5/site_perl/5.32.0
>>>>>> /app/lib/perl5/5.32.0/x86_64-linux /app/lib/perl5/5.32.0) at /app/
>>>>>> lib/perl5/site_perl/5.32.0/Module/Load.pm line 78.
>>>>>> at /app/bin/finance-quote-wrapper line 114.
>>>>>>
>>>>>> <<
>>>>>>
>>>>>> This suggests to me that the changes in the pm scripts depend on 
>>>>>> changes
>>>>>> in the actual program code.
>>>>>>
>>>>>> Can I just copy the entire tarball extract into
>>>>>> /var/lib/flatpak/app/org.gnucash.GnuCash/current/active/, or do I 
>>>>>> need
>>>>>> to limit what I copy or keep any residual files in that directory 
>>>>>> tree?
>>>>>>
>>>>>> Thanks for your support!
>>>>>>
>>>>>> On 15.08.23 19:19, john wrote:
>>>>>>> Look in the tracefile (https://wiki.gnucash.org/wiki/Tracefile) 
>>>>>>> or run
>>>>>>> `gnucash-cli -Q info` (see
>>>>>>> https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools 
>>>>>>> for how
>>>>>>> to run that from a flatpak) to see what the errors are.
>>>>>>>
>>>>>>> Regards,
>>>>>>> John Ralls
>>>>>>>
>>>>>>>
>>>>>>>> On Aug 15, 2023, at 08:26, rsbrux <rsbrux at yahoo.com> wrote:
>>>>>>>>
>>>>>>>> Now that I copied over the Quote directory and the Quote.pm 
>>>>>>>> script in
>>>>>>>> /var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5/site_perl/5.32.0/Finance/
>>>>>>>> with the files from the 1.58 release package, the "Get Quotes" 
>>>>>>>> button
>>>>>>>> in the Price Database tool is disabled. I already gave universal
>>>>>>>> execute privileges to  all of the newly copied files (and 
>>>>>>>> directory).
>>>>>>>> What else might be the cause?
>>>>>>>>
>>>>>>>> On 15.08.23 14:51, rsbrux wrote:
>>>>>>>>> Sorry, dumb question.  I found the tarball here:
>>>>>>>>> https://sourceforge.net/projects/finance-quote/
>>>>>>>>>
>>>>>>>>> On 15.08.23 14:48, rsbrux wrote:
>>>>>>>>>> Thanks for the tip, but I'm not sure I'm getting the right 
>>>>>>>>>> source.
>>>>>>>>>>
>>>>>>>>>> https://github.com/finance-quote/finance-quote offers a zip 
>>>>>>>>>> download
>>>>>>>>>> of the code from master.  Is this the 1.58 release code or the
>>>>>>>>>> current development version?  If the latter, where should I be
>>>>>>>>>> looking for the release?
>>>>>>>>>>
>>>>>>>>>> On 14.08.23 18:58, john wrote:
>>>>>>>>>>>> On Aug 14, 2023, at 04:33, rsbrux via gnucash-user
>>>>>>>>>>>> <gnucash-user at gnucash.org> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> I am running GC 5.3+ as a flatpak under Ubuntu  Studio 
>>>>>>>>>>>> 22.04 LTS.
>>>>>>>>>>>>
>>>>>>>>>>>> The included F::Q version is 1..56, which I have modified 
>>>>>>>>>>>> with the
>>>>>>>>>>>> Yahoo as JSON patch already published to this mailing list.
>>>>>>>>>>>>
>>>>>>>>>>>> However, it looks as though the current F::Q release, 1.58,
>>>>>>>>>>>> includes quite a few fixes for various sources.
>>>>>>>>>>>>
>>>>>>>>>>>> The last I heard,  it wasn't possible to update F::Q within a
>>>>>>>>>>>> flatpak installation of GC.  Is that still the case?
>>>>>>>>>>>>
>>>>>>>>>>>> If so, when can a flatpak update of GC containing F::Q 1.58 be
>>>>>>>>>>>> expected?
>>>>>>>>>>>>
>>>>>>>>>>>> If not, how can I update F::Q within my flatpak installation?
>>>>>>>>>>> The update will be available when someone (probably I) have 
>>>>>>>>>>> time to
>>>>>>>>>>> update the F::Q module in gnucash-on-flatpak. That update 
>>>>>>>>>>> will be
>>>>>>>>>>> immediately available in nightly builds; it won't be 
>>>>>>>>>>> available on
>>>>>>>>>>> Flathub until the regular release at the end of September.
>>>>>>>>>>>
>>>>>>>>>>> It's not possible to use CPAN, and consequently 
>>>>>>>>>>> gnc-fq-update, in
>>>>>>>>>>> the flatpak, but you can do it manually similarly to the way you
>>>>>>>>>>> applied the yahoo_json patch: Download and untar the release
>>>>>>>>>>> tarball or clone the repo then copy Quote.pm and the contents of
>>>>>>>>>>> Quote/ into the right places in your flatpak.
>>>>>>>>>>>
>>>>>>>>>>> Regards,
>>>>>>>>>>> John Ralls
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>