[GNC] gnucash-user Digest, Vol 185, Issue 91
Bill Swanson
wcswanson at gmail.com
Thu Aug 23 16:22:39 EDT 2018
Use:
Security Editor to edit secuiry
Use Single: Yahoo as JSON
Thanks Brad!
On Wed, Aug 22, 2018 at 5:46 PM <gnucash-user-request at gnucash.org> wrote:
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: Balsheet-eg.scm problem (Stephen M. Butler)
> 2. Re: Price tool -- get price works for 3 mutual funds but not
> the rest. (Bill Swanson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 22 Aug 2018 14:17:21 -0700
> From: "Stephen M. Butler" <kg7je at arrl.net>
> To: Derek Atkins <warlord at MIT.EDU>
> Cc: GnuCash users group <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Balsheet-eg.scm problem
> Message-ID: <7360a9b9-82ad-56de-5412-02f723cb7850 at gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> On 08/22/2018 08:01 AM, Derek Atkins wrote:
> > Hi,
> >
> > There should be a
> /usr/local/share/gnucash/scm/gnucash/report/business-reports*
> > in your installation.
> I see a business-reports.scm file there.? The other files are:
> steve at stevelaptop:/usr/local/share/gnucash/scm/gnucash/report$ ls -l
> total 916
> -rw-r--r-- 1 root root? 30346 Aug? 8 12:34 aging.scm
> -rw-r--r-- 1 root root?? 1240 Aug? 8 12:34 balsheet-eg.css
> -rw-r--r-- 1 root root? 11728 Aug? 8 12:34 balsheet-eg.eguile.scm
> -rw-r--r-- 1 root root? 33739 Aug 21 19:21 balsheet-eg.old
> -rw-r--r-- 1 root root? 33386 Aug 21 20:51 balsheet-eg.scm
> -rw-r--r-- 1 root root? 11556 Aug 21 21:27 balsheet-fmtd.eguile.scm
> -rw-r--r-- 1 root root? 34010 Aug 21 19:22 balsheet-fmtd.scm
> -rw-r--r-- 1 root root?? 5383 Aug? 8 12:34 business-reports.scm
> -rw-r--r-- 1 root root? 38987 Aug? 8 12:34 customer-summary.scm
> -rw-r--r-- 1 root root? 27079 Aug? 8 12:34 easy-invoice.scm
> -rw-r--r-- 1 root root? 10148 Aug? 8 12:34 eguile-gnc.scm
> -rw-r--r-- 1 root root?? 5523 Aug? 8 12:34 eguile-html-utilities.scm
> -rw-r--r-- 1 root root?? 4142 Aug? 8 12:34 eguile-utilities.scm
> -rw-r--r-- 1 root root? 32028 Aug? 8 12:34 fancy-invoice.scm
> -rw-r--r-- 1 root root? 21430 Aug? 8 12:34 hello-world.scm
> -rw-r--r-- 1 root root? 11639 Aug 21 19:22 income-statement2.scm
> -rw-r--r-- 1 root root? 24147 Aug? 8 12:34 invoice.scm
> -rw-r--r-- 1 root root? 21536 Aug? 8 12:34 job-report.scm
> drwxr-xr-x 2 root root?? 4096 Aug? 8 19:13 locale-specific
> -rw-r--r-- 1 root root? 32733 Aug? 8 12:34 owner-report.scm
> -rw-r--r-- 1 root root?? 4115 Aug? 8 12:34 payables.scm
> -rw-r--r-- 1 root root?? 2521 Aug? 8 12:34 receipt.css
> -rw-r--r-- 1 root root? 13049 Aug? 8 12:34 receipt.eguile.scm
> -rw-r--r-- 1 root root? 12901 Aug? 8 12:34 receipt.scm
> -rw-r--r-- 1 root root?? 4635 Aug? 8 12:34 receivables.scm
> -rw-r--r-- 1 root root?? 5486 Aug? 8 12:34 report-gnome.scm
> drwxr-xr-x 3 root root?? 4096 Aug? 8 19:13 report-system
> -rw-r--r-- 1 root root? 28028 Aug? 8 12:34 report-system.scm
> drwxr-xr-x 3 root root?? 4096 Aug? 8 19:13 standard-reports
> -rw-r--r-- 1 root root?? 5648 Aug? 8 12:34 standard-reports.scm
> -rw-r--r-- 1 root root? 12994 Aug? 8 12:34 stylesheet-easy.scm
> -rw-r--r-- 1 root root? 12910 Aug? 8 12:34 stylesheet-fancy.scm
> -rw-r--r-- 1 root root? 13592 Aug? 8 12:34 stylesheet-footer.scm
> -rw-r--r-- 1 root root? 20856 Aug? 8 12:34 stylesheet-head-or-tail.scm
> -rw-r--r-- 1 root root?? 7547 Aug? 8 12:34 stylesheet-plain.scm
> -rw-r--r-- 1 root root?? 1240 Aug 21 19:22 stylesheet-reports.css
> -rw-r--r-- 1 root root?? 1518 Aug? 8 12:34 stylesheets.scm
> -rw-r--r-- 1 root root?? 1855 Aug? 8 12:34 taxinvoice.css
> -rw-r--r-- 1 root root? 19239 Aug? 8 12:34 taxinvoice.eguile.scm
> -rw-r--r-- 1 root root? 19041 Aug? 8 12:34 taxinvoice.scm
> -rw-r--r-- 1 root root? 39142 Aug? 8 12:34 taxtxf-de_DE.scm
> -rw-r--r-- 1 root root 192419 Aug? 8 12:34 taxtxf.scm
> -rw-r--r-- 1 root root??? 847 Aug? 8 12:34
> test-load-report-stylesheets-module.scm
> -rw-r--r-- 1 root root?? 1497 Aug? 8 12:34 utility-reports.scm
> -rw-r--r-- 1 root root?? 8988 Aug? 8 12:34 view-column.scm
> -rw-r--r-- 1 root root?? 4431 Aug? 8 12:34 welcome-to-gnucash.scm
>
>
>
> > What version of GnuCash is this? Considering it's /usr/local I'm
> > guessing you built it yourself. Did you possibly upgrade a 2.6.x to 3.y
> > version and overwrite the older version?
>
> I've been running v3.2 for awhile (compiled locally) and recently pulled
> down from github to fix some bugs so now have v3.2-100.
>
> I had made changes to the eguile balance sheet program pre-3.x but
> hadn't moved it in thinking the new multi-column balance sheet report
> would make it obsolete.? That turns out to not be the case and the new
> one is headed in a different direction.
>
> So, I pulled out the old code and attempted to install
> (balsheet-fmtd.scm and balsheet-fmtd.eguile.scm) but GNC ignored them.?
> I remembered that I had to load them under the original name
> balsheet-eg.scm previously before GNC saw them and added them in (after
> that I could have both sitting there and working).? So, I renamed
> balscheet-eg.scm to *.old andw copied balsheet-fmt.scm to have the
> balsheet-eg.scm name.? That led me to discover several changes that were
> needed (apparently due to changes from 2.6 to 3.x).?
>
> I am down to this error and not understanding what it has to do with the
> changes I made.? I've attached my versions of the old eguile balance
> sheet just in case the stdout has a clue to what line in this is causing
> the problem.? Remember that balsheet-fmtd.scm is currently named
> balsheet-eg.scm in the above folder.
> > -derek
>
> --Steve
> PS? Sorry for the delayed response.? Was out raising the south wall on
> my new greenhouse (10x20).? Too hot outside now even though the air
> quality is better than the last few days.
> > "Stephen M. Butler" <kg7je at arrl.net> writes:
> >
> >> When I load gnucash the below messages come out.? However, I can't find
> >> references to "business-reports" in the code.? I also don't see it in
> >> evel-string.scm (in the ice-9 folder).? Ideas?
> >>
> >>
> >> sudo find / -name eval-string.scm
> >> [sudo] password for steve:
> >> /usr/share/guile/2.0/ice-9/eval-string.scm
> >> find: ?/run/user/1000/gvfs?: Permission denied
> >>
> >> gnucash --logto=stdout
> >>
> >> (gnucash:11506): Gtk-WARNING **: 22:02:10.785: Theme parsing error:
> >> gtk.css:1278:13: The 'icon-shadow' property has been renamed to
> >> '-gtk-icon-shadow'
> >>
> >> (gnucash:11506): Gtk-WARNING **: 22:02:10.785: Theme parsing error:
> >> gtk.css:1281:15: The 'icon-shadow' property has been renamed to
> >> '-gtk-icon-shadow'
> >>
> >>
> >> <<the above two warnings pop out immediately.? Then a delay while
> >> reports are loaded.>>
> >>
> >> ;;; note: source file
> >> /usr/local/share/gnucash/scm/gnucash/report/balsheet-eg.scm
> >> ;;;?????? newer than compiled
> >> /usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/balsheet-eg.go
> >> ;;; found fresh local cache at
> >>
> /home/steve/.cache/guile/ccache/2.0-LE-8-2.0/usr/local/share/gnucash/scm/gnucash/report/balsheet-eg.scm.go
> >> Backtrace:
> >> In ice-9/eval-string.scm:
> >> ? 37: 19 [lp (use-modules (gnucash report business-reports))]
> >> In ice-9/eval.scm:
> >> ?505: 18 [#<procedure 55a8a3699340 at ice-9/eval.scm:499:4 (exp)>
> >> (use-modules #)]
> >> In ice-9/psyntax.scm:
> >> 1106: 17 [expand-top-sequence ((use-modules #)) () ((top)) ...]
> >> ?989: 16 [scan ((use-modules (gnucash report business-reports))) () ...]
> >> ?279: 15 [scan ((# #) #(syntax-object *unspecified* # #)) () (()) ...]
> >> In ice-9/boot-9.scm:
> >> 3589: 14 [process-use-modules (((gnucash report business-reports)))]
> >> ?705: 13 [map #<procedure 55a8a3761d40 at ice-9/boot-9.scm:3589:25
> >> (mif-args)> ((#))]
> >> 3590: 12 [#<procedure 55a8a3761d40 at ice-9/boot-9.scm:3589:25
> >> (mif-args)> (#)]
> >> 2867: 11 [resolve-interface (gnucash report business-reports) #:select
> ...]
> >> 2792: 10 [#<procedure 55a8a3754620 at ice-9/boot-9.scm:2780:4 (name
> >> #:optional autoload version #:key ensure)> # ...]
> >> 3068: 9 [try-module-autoload (gnucash report business-reports) #f]
> >> 2404: 8 [save-module-excursion #<procedure 55a8a488cc90 at
> >> ice-9/boot-9.scm:3069:17 ()>]
> >> 3088: 7 [#<procedure 55a8a488cc90 at ice-9/boot-9.scm:3069:17 ()>]
> >> In unknown file:
> >> ?? ?: 6 [primitive-load-path "gnucash/report/business-reports" ...]
> >> In business-reports.scm:
> >> ?123: 5 [#<procedure 55a8a470a7c0 ()>]
> >> In ice-9/boot-9.scm:
> >> 3589: 4 [process-use-modules (((gnucash report balsheet-eg)))]
> >> ?705: 3 [map #<procedure 55a8a3761d40 at ice-9/boot-9.scm:3589:25
> >> (mif-args)> ((#))]
> >> 3590: 2 [#<procedure 55a8a3761d40 at ice-9/boot-9.scm:3589:25
> >> (mif-args)> (#)]
> >> 2870: 1 [resolve-interface (gnucash report balsheet-eg) #:select ...]
> >> In unknown file:
> >> ?? ?: 0 [scm-error misc-error #f ...]
> >>
> >> ERROR: In procedure scm-error:
> >> ERROR: no code for module (gnucash report balsheet-eg)
>
>
> --
> Stephen M Butler, PMP, PSM
> Stephen.M.Butler51 at gmail.com
> kg7je at arrl.net
> 253-350-0166
> -------------------------------------------
> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: balsheet-fmtd.eguile.scm
> Type: text/x-scheme
> Size: 11556 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180822/d07028ff/attachment-0002.bin
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: balsheet-fmtd.scm
> Type: text/x-scheme
> Size: 34010 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180822/d07028ff/attachment-0003.bin
> >
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: stylesheet-reports.css
> Type: text/css
> Size: 1240 bytes
> Desc: not available
> URL: <
> http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180822/d07028ff/attachment-0001.css
> >
>
> ------------------------------
>
> Message: 2
> Date: Wed, 22 Aug 2018 17:41:10 -0400
> From: Bill Swanson <wcswanson at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Price tool -- get price works for 3 mutual funds
> but not the rest.
> Message-ID:
> <
> CABh-xaNCrwt+aaRjucxJx8NOzHN4J5RCDzyMnYraL0u_4ntpQQ at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> ISSUE SUMMARY:
> GnuCash 2.6.12 (Using Sqlite for data)
> Unable to retrieve quotes for these items:
> NASDAQ:ABSYX
> NASDAQ:JVMIX
> NASDAQ:IPAS
> NASDAQ:WSTL
> NASDAQ:LMSC
> ...
>
> But good quotes are received for :
> ABCYX
> JAENX
> PTTPX
>
> Running on Linux Mint (Mate) 18.3 Sylvia
> Environment varibles:
> [Variables]
> # PATH is used to find the finance::quote utility functions
> PATH={GNC_BIN};{PATH}
> ALPHAVANTAGE_API_KEY=###################
>
> >sudo cpan -D Finance::Quote
> CPAN::SQLite not installed, trying to work without
> Reading '/home/bill/.cpan/Metadata'
> Database was generated on Sat, 18 Aug 2018 13:17:03 GMT
> Finance::Quote
> -------------------------------------------------------------------------
> (no description)
> E/EC/ECOCODE/Finance-Quote-1.47.tar.gz
> /usr/local/share/perl/5.22.1/Finance/Quote.pm
> Installed: 1.47
> CPAN: 1.47 up to date
> Erik Colson (ECOCODE)
> eco at ecocode.net
>
> gnc-fq-dump -v alphavantage ipas works when the code in
> gnc-fq-dump is changed from:
> # my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
> my $ALPHAVANTAGE_API_KEY = '###########';
>
> and it now works!
> bill at bill-mint64 ~/Downloads/Gnucash/gnucash-2.6.12/src/quotes $ sudo
> perl
> gnc-fq-dump -v alphavantage ipas
> Finance::Quote fields Gnucash uses:
> symbol: ipas <=== required
> date: 08/22/2018 <=== required
> currency: USD <=== required
> last: 0.2201 <=\
> nav: <=== one of these
> price: <=/
> timezone: <=== optional
>
> All fields returned by Finance::Quote for stock ipas
>
> stock field value
> ----- ----- -----
> ipas close: 0.2201
> ipas currency: USD
> ipas currency_set_by_fq: 1
> ipas date: 08/22/2018
> ipas high: 0.2400
> ipas isodate: 2018-08-22
> ipas last: 0.2201
> ipas low: 0.1813
> ipas method: alphavantage
> ipas open: 0.1999
> ipas success: 1
> ipas symbol: ipas
> ipas volume: 1739863
>
> But from GnuCash I only get 3 updates for the entire list.
>
> Suggestions?
> --
> Bill Swanson
> 207-2443946
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
>
> 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
> 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.
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 185, Issue 91
> *********************************************
>
--
Bill Swanson
207-2443946
More information about the gnucash-user
mailing list