gnucash-user Digest, Vol 135, Issue 40

Richard Lindgren rlindgren74 at gmail.com
Mon Jun 30 04:15:40 EDT 2014


Fred,
Per your request, I have attached a copy of one of my stock Security
Information Forms that I use.

Richard


On Mon, Jun 30, 2014 at 3:56 AM, <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. Export of scheduled transactions (Dave's Mail)
>    2. VAT (Theo Richel)
>    3. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (Wm)
>    4. Re: VAT (David Carlson)
>    5. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (John Ralls)
>    6. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (John Ralls)
>    7. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (Wm)
>    8. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (Lance Alligood)
>    9. Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>       to read/save file (John Ralls)
>   10. Re: Show generation date on report (Mark)
>   11. Re: Downloading Stock Prices - Finance::Quote Problems
>       (Richard Lindgren)
>   12. Re: Downloading Stock Prices - Finance::Quote Problems (Fred Bone)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 29 Jun 2014 17:48:35 +0100
> From: "Dave's Mail" <dave.m at ntlworld.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Export of scheduled transactions
> Message-ID: <4E6C0BCF-390A-4D57-B028-365964F8E321 at ntlworld.com>
> Content-Type: text/plain;       charset=us-ascii
>
> Hi
> I wish to start a new set of accounts for the new year. Exporting to a new
> named account works great giving me a blank set of account ready to set the
> starting point as I wish.
> Unfortunately the scheduled transactions ( subscription standing orders)
> aren't transferred so I have had to recreate them in the new account year.
> Is there a way of exporting the scheduled transactions
> Dave Morris
>
> Sent from my iPad
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 29 Jun 2014 20:13:16 +0200
> From: "Theo Richel" <theo at richel.org>
> To: <gnucash-user at gnucash.org>
> Subject: VAT
> Message-ID:
>         <684D45F504C7B645995837575EEC3DCC3E7803 at superserver6.richel2.local
> >
> Content-Type: text/plain;       charset="us-ascii"
>
> As the archives online of this list are inaccessible, I would like to
> ask if there is any info available regarding the way one should
> configure the different VAT accounts in GNUcash.
>
>
>
> Many thanks
>
>
>
> Theo Richel
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 29 Jun 2014 20:15:50 +0100
> From: Wm <wm+gnc at tarrcity.demon.co.uk>
> To: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID: <aW6lE0GmXGsTFwVE at tarrcity.demon.co.uk>
> Content-Type: text/plain;charset=us-ascii;format=flowed
>
> Sun, 29 Jun 2014 08:37:18
> <6BD749E4-9734-44CE-95A5-2B84120C1969 at ceridwen.us> John Ralls
> <jralls at ceridwen.us>
>
> >
> >On Jun 28, 2014, at 3:46 PM, Lance Alligood <lalligood at gmail.com> wrote:
>
> [snip]
>
> Hi, L, you've provided some details I didn't have to work with before
> <fx: wry grin>.  You're certainly in good hands now.
>
> >I looked over the conversation on the Portable Apps site, and I see
> >that you already tested without compression and with the SQL backend.
> >The compression overhead seems high to me, but I haven't ever profiled
> >it so I don't know whether that's typical or not.
>
> My feeling at the moment is that it may be a symptom or artefact.
>
> >That block of several thousand repetitions of "attempt to write
> >disabled transaction log" messages looks like the meat of the problem.
> >since it appears to start 8 seconds after program start and the next
> >segment that you indicate is 18 minutes later.
>
> Agreed, see below.
>
> > Since you say it takes only 2-3 minutes to load your file, it doesn't
> >seem likely to me that those are going on for all 18 minutes. Is that
> >correct? If so, what is the actual duration?
>
> More to the point why the time difference between the *nix and Win
> systems with the same file?
>
> > Can you compare the log information of a windows and a linux run of
> >GC? Is there really nothing else being logged in that segment of the
> >log file?
>
> That seems important now.
>
> L, now we're on equal ground a simple test might be:
>
> run gnc with  --debug --extra on both platforms and grep for
> ===
> <gnc.translog>
> ===
>
> My guess is that will be found to top and tail the delay.
>
> a quick wc -l on the two log files will tell us (and you) if the same
> stuff (more or less) was being logged
>
> then you can look at the time stamp at the top and bottom of each sample
> and let us know what the difference is.
>
> If
>
> * the file was the same at the start of both tests
> * the gnc versions were same major (2.6 seems sensible)
>
> then there is something else we need to look at.
>
> Aside:
>
> How many log lines do you, the reader, have for each
> * hh:mm:ss  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
> transaction log
>
> here it varies between 10 and 6 with an eyeball check ... but I haven't
> been careful, it may be 11 and 5.
>
> --
> Wm...
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 29 Jun 2014 14:17:25 -0500
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: Re: VAT
> Message-ID: <53B06645.7060206 at gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On 6/29/2014 1:13 PM, Theo Richel wrote:
> > As the archives online of this list are inaccessible, I would like to
> > ask if there is any info available regarding the way one should
> > configure the different VAT accounts in GNUcash.
> >
> >
> >
> > Many thanks
> >
> >
> >
> > Theo Richel
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
> >
> Try again.  https://lists.gnucash.org/pipermail/gnucash-user/ was
> accessible a few seconds ago.
>
> David C
>
>
> ------------------------------
>
> Message: 5
> Date: Sun, 29 Jun 2014 21:53:28 +0200
> From: John Ralls <jralls at ceridwen.us>
> To: Wm <wm+gnc at tarrcity.demon.co.uk>
> Cc: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID: <0A7CDEB3-D982-49BF-903C-F7DA0974C057 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
> On Jun 29, 2014, at 9:15 PM, Wm <wm+gnc at tarrcity.demon.co.uk> wrote:
>
> > Sun, 29 Jun 2014 08:37:18 <
> 6BD749E4-9734-44CE-95A5-2B84120C1969 at ceridwen.us> John Ralls <
> jralls at ceridwen.us>
> >
> >>
> >> On Jun 28, 2014, at 3:46 PM, Lance Alligood <lalligood at gmail.com>
> wrote:
> >
> > [snip]
> >
> > Hi, L, you've provided some details I didn't have to work with before
> <fx: wry grin>.  You're certainly in good hands now.
> >
> >> I looked over the conversation on the Portable Apps site, and I see
> that you already tested without compression and with the SQL backend. The
> compression overhead seems high to me, but I haven't ever profiled it so I
> don't know whether that's typical or not.
> >
> > My feeling at the moment is that it may be a symptom or artefact.
> >
> >> That block of several thousand repetitions of "attempt to write
> disabled transaction log" messages looks like the meat of the problem.
> since it appears to start 8 seconds after program start and the next
> segment that you indicate is 18 minutes later.
> >
> > Agreed, see below.
> >
> >> Since you say it takes only 2-3 minutes to load your file, it doesn't
> seem likely to me that those are going on for all 18 minutes. Is that
> correct? If so, what is the actual duration?
> >
> > More to the point why the time difference between the *nix and Win
> systems with the same file?
> >
> >> Can you compare the log information of a windows and a linux run of GC?
> Is there really nothing else being logged in that segment of the log file?
> >
> > That seems important now.
> >
> > L, now we're on equal ground a simple test might be:
> >
> > run gnc with  --debug --extra on both platforms and grep for
> > ===
> > <gnc.translog>
> > ===
> >
> > My guess is that will be found to top and tail the delay.
> >
> > a quick wc -l on the two log files will tell us (and you) if the same
> stuff (more or less) was being logged
> >
> > then you can look at the time stamp at the top and bottom of each sample
> and let us know what the difference is.
>
> You can do it yourself, since he posted the two comparable logfiles on
> Dropbox.
> The linux one has 21912 instances of 'xaccTransWriteLog' and the time
> difference between the first and last it 7 seconds. The Windows one has
> 21800 instances and the time difference is 17 minutes 1 second.
>
> >
> > If
> >
> > * the file was the same at the start of both tests
> > * the gnc versions were same major (2.6 seems sensible)
> >
> > then there is something else we need to look at.
> >
> > Aside:
> >
> > How many log lines do you, the reader, have for each
> > * hh:mm:ss  INFO <gnc.translog> [xaccOpenLog] Attempt to open disabled
> transaction log
> >
> > here it varies between 10 and 6 with an eyeball check ... but I haven't
> been careful, it may be 11 and 5.
>
> It alternates between 3 and 5, with the extra two lines being variations on
> * 12:20:03 INFO [xaccTransSetDateInternal] addr=07D98158 set date to
> 1322103081.000000000 Wed Nov 23 21:51:21 2011
>
> He'd already shown you this in your discussion on the Portable Apps forum.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Sun, 29 Jun 2014 21:59:28 +0200
> From: John Ralls <jralls at ceridwen.us>
> To: Lance Alligood <lalligood at gmail.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID: <07C8D2EC-C874-4B1A-9605-6BE1A4023194 at ceridwen.us>
> Content-Type: text/plain;       charset=us-ascii
>
>
> On Jun 29, 2014, at 4:10 PM, Lance Alligood <lalligood at gmail.com> wrote:
>
> > John,
> >
> > Thank you for your response. When it took ~18 minutes to load my same
> data file, that was with me running 'gnucash.exe --debug --extra', instead
> of the 2-3 minutes for just 'gnucash.exe'.
>
>
> OK, that's interesting. The fact that extra logging increases the
> execution time by such a large value suggests that writing the log might be
> part of the problem. Please try launching GnuCash with --logto=NUL ; I
> *think* that NUL is the Windows equivalent of /dev/null, but since we're
> dealing with a unix emulation layer, it might require --logto=/dev/null to
> suppress the logging.
>
> >
> > I certainly can compare--and now have compared--the logs from my Windows
> vs Ubuntu sessions! Lengthwise & structure-wise, the files are nearly
> identical. The most significant difference is that it only took 8-10
> SECONDS for the application to load my datafile when running 'gnucash
> --debug --extra' in Ubuntu (vs the nearly 20 minutes in Windows). I've
> taken both trace files & made them available through the links below.
> > Ubuntu =>
> https://www.dropbox.com/sh/fy8msaw785xhmie/AADpnvhcXeVIwfpI_CCeoEVVa/gnucash.trace
> > Windows =>
> https://www.dropbox.com/sh/fy8msaw785xhmie/AACjl-ogzq4Nnp6v2lC352Nua/gnucash.trace.TQ75HX.log
> >
>
> Indeed. Unfortunately the timestamps are of too low a resolution to help
> understand where the problem is, and I haven't yet been able to find a way
> to get usable profiling data on Windows.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 29 Jun 2014 21:26:35 +0100
> From: Wm <wm+gnc at tarrcity.demon.co.uk>
> To: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID: <5ENNwBI7ZHsTFwBW at tarrcity.demon.co.uk>
> Content-Type: text/plain;charset=us-ascii;format=flowed
>
> Sun, 29 Jun 2014 21:53:28
> <0A7CDEB3-D982-49BF-903C-F7DA0974C057 at ceridwen.us>  John Ralls
> <jralls at ceridwen.us>
>
> Man quotes badly!
>
> >You can do it yourself, since he posted the two comparable logfiles on
> Dropbox.
> >The linux one has 21912 instances of 'xaccTransWriteLog' and the time
> >difference between the first and last it 7 seconds. The Windows one has
> >21800 instances and the time difference is 17 minutes 1 second.
>
> >It alternates between 3 and 5, with the extra two lines being variations
> on
> >* 12:20:03 INFO [xaccTransSetDateInternal] addr=07D98158 set date to
> >1322103081.000000000 Wed Nov 23 21:51:21 2011
> >
> >He'd already shown you this in your discussion on the Portable Apps forum.
> >
> >Regards,
> >John Ralls
>
> Please shit on the right person in future!
>
> I hold you in high esteem for now.
>
> Plain fact?  You read and replied in the wrong order!
>
> --
> Wm...
>
>
> ------------------------------
>
> Message: 8
> Date: Sun, 29 Jun 2014 10:10:50 -0400
> From: Lance Alligood <lalligood at gmail.com>
> To: John Ralls <jralls at ceridwen.us>
> Cc: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID:
>         <
> CAK0kNKHth79Bh82+qjanHa6LUEpb3hRNBU6csKAxrGEuDEo_vw at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> John,
>
> Thank you for your response. When it took ~18 minutes to load my same data
> file, that was with me running 'gnucash.exe --debug --extra', instead of
> the 2-3 minutes for just 'gnucash.exe'.
>
> I certainly can compare--and now have compared--the logs from my Windows vs
> Ubuntu sessions! Lengthwise & structure-wise, the files are nearly
> identical. The most significant difference is that it only took 8-10
> SECONDS for the application to load my datafile when running 'gnucash
> --debug --extra' in Ubuntu (vs the nearly 20 minutes in Windows). I've
> taken both trace files & made them available through the links below.
> Ubuntu =>
>
> https://www.dropbox.com/sh/fy8msaw785xhmie/AADpnvhcXeVIwfpI_CCeoEVVa/gnucash.trace
> Windows =>
>
> https://www.dropbox.com/sh/fy8msaw785xhmie/AACjl-ogzq4Nnp6v2lC352Nua/gnucash.trace.TQ75HX.log
>
> HTH,
>
> --Lance
>
>
>
> On Sun, Jun 29, 2014 at 2:37 AM, John Ralls <jralls at ceridwen.us> wrote:
>
> >
> > On Jun 28, 2014, at 3:46 PM, Lance Alligood <lalligood at gmail.com> wrote:
> >
> > > Hello. I've already sought help with the portable Windows version of
> > > GnuCash over at portable apps.com. (Feel free to look at the
> discussion
> > > thread here: http://portableapps.com/node/41588.) However, the problem
> > is
> > > that I am still experiencing long times (2+ minutes) in reading in and
> > > saving my GnuCash data file. While I do not recall the precise date or
> > > version that this problem started, but I am pretty sure it started
> > > somewhere between v2.4.5 and v2.6.1. It has persisted continually since
> > > then.
> > >
> > > Here is my setup:
> > > * I am currently running GnuCash v2.6.3 for Windows portable. There
> are a
> > > few different Windows PCs that I use. They are mostly Windows 7 64-bit
> > but
> > > there's the occasional Windows XP SP3 I use.
> > > * I also run on my laptop GnuCash v2.6.1 for Ubuntu Linux, which is the
> > > current release in the Ubuntu 14.04 standard apt repository.
> > > * The flash drive where I store my data file--& normally run the
> GnuCash
> > > for Windows portable executable--is a Transcend 64GB USB 3.0 drive. For
> > > every other use, application, and/or operating system that I use this
> > drive
> > > with, (aside from GnuCash for Windows) it reads & writes with
> exceptional
> > > speed.
> > > * My GnuCash data file is XML-based, ~600KB when compression is enabled
> > or
> > > ~8.0MB when saved without compression. I use GnuCash purely for
> > balancing a
> > > checking account & savings account. No online activity, no stocks, no
> > > reports, etc.
> > >
> > > When using GnuCash for Ubuntu, my data file consistently loads and
> saves
> > in
> > > well under 3 seconds, whether GnuCash is compressing the file or not.
> The
> > > laptop has USB 3.0 ports.
> > >
> > > When using GnuCash for Windows portable, my same data file loads and
> > saves
> > > in well OVER 2 MINUTES. Although my data file resides on the flash
> drive
> > > described above, I have taken great length to rule out the drive, the
> PC
> > > hardware, and even the operating system itself!
> > > * If I copy the datafile to the PC hard drive, it still takes 2+
> minutes
> > to
> > > load/save. (Probably can't be the flash drive.)
> > > * If I install & run GnuCash executable from the hard drive, it still
> > takes
> > > 2+ minutes to load/save my data file. (Can't be an issue with the USB
> > port.)
> > > * If I run a Crunchbang Linux virtual machine (using Virtualbox) on the
> > > same Windows PC & run GnuCash v2.4.5--that's the current release in
> > > Debian/Crunchbang repository--AND mount my flash drive in the VM, the
> > > read/write time of my data file drops back to the expected less than 5
> > > seconds! The Windows PC where I ran the VM only has USB 2.0 ports, so I
> > > expected it to be slightly slower than my Ubuntu laptop. (As the VM has
> > to
> > > work with host Windows OS for the VM, it probably cannot be the Windows
> > OS!)
> > >
> > > So that leaves me with the conclusion that there must be something with
> > the
> > > GnuCash Windows executable as it seems to struggle with reading
> in/saving
> > > to the same data file that GnuCash for Linux can read/write to much,
> much
> > > faster.
> > >
> > > I would be willing to provide additional information, trace files, &
> even
> > > an obfuscated version of my data file (although I got a "Can't call
> > method
> > > "getData" on an undefined value at ./gnucash-obfuscate.pl line 48."
> > error
> > > when I tried it earlier), if that would assist in resolving this issue.
> > >
> > > Thank you very much for your time & assistance with this.
> >
> > I looked over the conversation on the Portable Apps site, and I see that
> > you already tested without compression and with the SQL backend. The
> > compression overhead seems high to me, but I haven't ever profiled it so
> I
> > don't know whether that's typical or not.
> >
> > That block of several thousand repetitions of "attempt to write disabled
> > transaction log" messages looks like the meat of the problem. since it
> > appears to start 8 seconds after program start and the next segment that
> > you indicate is 18 minutes later. Since you say it takes only 2-3 minutes
> > to load your file, it doesn't seem likely to me that those are going on
> for
> > all 18 minutes. Is that correct? If so, what is the actual duration? Can
> > you compare the log information of a windows and a linux run of GC? Is
> > there really nothing else being logged in that segment of the log file?
> >
> > Regards,
> > John Ralls
> >
> >
>
>
> ------------------------------
>
> Message: 9
> Date: Sun, 29 Jun 2014 22:52:45 +0200
> From: John Ralls <jralls at ceridwen.us>
> To: Wm <wm+gnc at tarrcity.demon.co.uk>
> Cc: gnucash-user at gnucash.org
> Subject: Re: GnuCash 2.6.3 (portable) for Windows taking a LONG time
>         to read/save file
> Message-ID: <7BCF3C29-C565-483A-B125-070215707626 at ceridwen.us>
> Content-Type: text/plain; charset=us-ascii
>
>
> On Jun 29, 2014, at 10:26 PM, Wm <wm+gnc at tarrcity.demon.co.uk> wrote:
>
> > Sun, 29 Jun 2014 21:53:28 <
> 0A7CDEB3-D982-49BF-903C-F7DA0974C057 at ceridwen.us>  John Ralls <
> jralls at ceridwen.us>
> >
> > Man quotes badly!
> >
> >> You can do it yourself, since he posted the two comparable logfiles on
> Dropbox.
> >> The linux one has 21912 instances of 'xaccTransWriteLog' and the time
> difference between the first and last it 7 seconds. The Windows one has
> 21800 instances and the time difference is 17 minutes 1 second.
> >
> >> It alternates between 3 and 5, with the extra two lines being
> variations on
> >> * 12:20:03 INFO [xaccTransSetDateInternal] addr=07D98158 set date to
> 1322103081.000000000 Wed Nov 23 21:51:21 2011
> >>
> >> He'd already shown you this in your discussion on the Portable Apps
> forum.
> >>
> >> Regards,
> >> John Ralls
> >
> > Please shit on the right person in future!
>
> Please be civil on the mailing lists.
>
> >
> > I hold you in high esteem for now.
> >
> > Plain fact?  You read and replied in the wrong order!
> >
>
> No, the plain fact is that Lance's post with the Dropbox links hit the
> list 4 hours before your response. That you either failed to read
> everything before replying or chose to ignore what had already been posted
> is your problem, as is the fact that you addressed Lance while replying
> line-by-line to my post.
>
> Regards,
> John Ralls
>
>
>
>
> ------------------------------
>
> Message: 10
> Date: Sun, 29 Jun 2014 15:32:15 -0700
> From: Mark <msalists at gmx.net>
> To: Carsten Rinke <carsten.rinke at gmx.de>, gnucash-user at gnucash.org
> Subject: Re: Show generation date on report
> Message-ID: <53B093EF.8070809 at gmx.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Carsten,
>
> no, I have not.
> I found that here:
> Edit -> Style Sheets -> select "Easy" from the list, then click "Edit'
> -> "General" tab -> "Show preparer info".
>
> So that gives me at least the date, but no time (which would still be
> very helpfull as well).
>
> Thank you,
>
> Mark
>
> On 2014-06-29 00:59, Carsten Rinke wrote:
> > Hi Mark,
> >
> > just do double-check:
> > Did you activate the fields via Preferences -> Style Sheets -> Edit Easy?
> > I think that needs to be done before selecting Easy in the report
> > options.
> >
> > Carsten
> >
> > On 06/28/2014 08:44 PM, David Carlson wrote:
> >> On 6/28/2014 12:46 PM, Mark Arnold wrote:
> >>> That's exactly the report I am running in 2.4.15.
> >>> However, there is no second and third header line as you describe. If
> >>> there was, I guess it sounds like what I need.
> >>> I have the title, then a gap that might actually be two blank lines,
> >>> then the actual balance sheet table starts.
> >>> I do not have the words "Prepared By" or "Prepared For" anywhere in
> >>> the report...
> >>>   The three stylesheets "Easy", "Technicolor" and "Footer" look
> >>> identical to me, I can't see a difference between the three.
> >>>   Mark
> >>>
> >>> If you run the Assets and Liabilities report called the "Balance Sheet"
> >>> in release 2.4.13 using the "Easy" stylesheet, the date prepared
> >>> appears
> >>> in the third line of the title just under "Prepared By" and "Prepared
> >>> For".
> >>> When you get to specifics, sometimes there is an answer. I think the
> >>> "Easy" stylesheet does that in several reports. I wish this were
> >>> documented better in the help.
> >>>
> >>> David C
> >>> _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> 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.
> >>> .
> >> I think that there was a change in the report generation engine after
> >> 2.4.13, although I thought that it took effect in the 2.6 series, which
> >> I am not using.  This is another reason that I am not trying to document
> >> an un-supported release.
> >>
> >> In release 2.4.13 the three stylesheets are very different from each
> >> other in the Assets and Liabilities report called the "Balance Sheet".
> >> There is another report called "Balance Sheet using eguile-gnc" which I
> >> do not use, and it is probably different.
> >>
> >> David C
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> 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.
> >>
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
> >
>
>
>
> ------------------------------
>
> Message: 11
> Date: Mon, 30 Jun 2014 03:42:02 -0400
> From: Richard Lindgren <richard_lindgren at outlook.com>
> To: Fred.Bone at dial.pipex.com
> Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: Downloading Stock Prices - Finance::Quote Problems
> Message-ID:
>         <CAD8ROJZvFj96BH91=
> ycye9rjUR_UwXm+jFCoctZBtCM8D1iaVA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Fred,
> In my frustrations in trying to make this work, I re-installed Windows 7
> (again) to make sure I didn't mess anything up.
> - I then downloaded and installed GnuCash 2.63
> - I then Installed Activeperl 5.16.3.1603. This was installed in my
> Strawberry folder.
> - I then went into the Perl Package Manager and it went through a database
> sync operation.
> - I then opened up the command prompt and entered "perl -V". That worked
> ok.
> - I then entered: perl -MFinance::Quote -e"print
> ""$Finance::Quote::VERSION\n""". That worked ok.
> - I then went in as the Administrator to start the utility to Retrieve
> Online Price Retrieval. That worked ok.
> - I then opened up up GnuCash and went to the Advanced Portfolio to get my
> download of the prices. STILL, no luck. It comes back and says unable to
> retrieve qoutes for these items.
>
> I don't know what's happening hear but I am not a programmer and I keep
> asking myself, why is this become such a chore and why isn't the updated
> program setup with the correct codes to get these prices. I'm sure there
> must be a good reason, not being a programmer, if I can't get this working
> soon, I will either have to enter these prices manually or use some other
> program or technique. I have attached my last command prompt activity for
> your review. According to that, it is all installed and okay. Do I need to
> make another change? I need help here. Thanks.
>
> Richard
>
>
>
>
> On Fri, Jun 27, 2014 at 12:32 PM, Fred Bone <Fred.Bone at dial.pipex.com>
> wrote:
>
> > On 27 June 2014 at 12:19, Richard Lindgren said:
> >
> > > Here is a copy of my last script that I entered. Not sure if this will
> > > tell what Finance-Quote you need to know or not?
> >
> > Try
> >  perl -MFinance::Quote -e"print ""$Finance::Quote::VERSION\n"""
> >
> >
> >
> -------------- next part --------------
>
> * Check Perl
>
>
> * Check Perl version
>
>
> * Determine which Perl flavour we have found
>
> Access is denied.
> * Install DateManip
>
> Downloading ActiveState Package Repository packlist...done
> Updating ActiveState Package Repository database...done
> Syncing site PPM database with .packlists...done
> Downloading Date-Manip-6.44...done
> Unpacking Date-Manip-6.44...done
> Generating HTML for Date-Manip-6.44...done
> Updating files in site area...done
> 1039 files installed
>
> * Install Crypt-SSLeay
>
> Downloading Crypt-SSLeay-0.60...done
> Unpacking Crypt-SSLeay-0.60...done
> Generating HTML for Crypt-SSLeay-0.60...done
> Updating files in site area...done
>   13 files installed
>
> * Install Finance-Quote
>
> Downloading Finance-Quote-1.18...done
> Downloading HTML-TableExtract-2.11...done
> Unpacking Finance-Quote-1.18...done
> Unpacking HTML-TableExtract-2.11...done
> Generating HTML for Finance-Quote-1.18...done
> Generating HTML for HTML-TableExtract-2.11...done
> Updating files in site area...done
>   98 files installed
>
> * Run gnc-fq-check
>
> ("1.18" "vwd" "yahoo_nz" "australia" "amfiindia" "usfedbonds" "canada"
> "yahoo" "
> adig" "bux" "aiahk" "bsero" "yahoo_australia" "unionfunds" "lerevenu"
> "asia" "ts
> x" "sixfunds" "indiamutual" "bse" "hungary" "known_currencies"
> "fidelity_direct"
>  "goldmoney" "tdwaterhouse" "trustnet" "ftportfolios_direct" "cominvest"
> "mornin
> gstar" "ftportfolios" "tdefunds" "hu" "za" "fundlibrary"
> "stockhousecanada_fund"
>  "yahoo_europe" "platinum" "maninv" "tsp" "financecanada" "usa" "france"
> "trowep
> rice" "nasdaq" "bmonesbittburns" "yahoo_asia" "tiaacref"
> "troweprice_direct" "se
> b_funds" "yahoo_brasil" "greece" "fidelity" "fetch_live_currencies"
> "romania" "d
> wsfunds" "finland" "hex" "brasil" "asegr" "deka" "nyse" "canadamutual"
> "asx" "fi
> nanzpartner" "fool" "dutch" "uk_unit_trusts" "sixshares" "nzx" "aex" "nz"
> "vangu
> ard" "europe" "bourso")
>
> * Run gnc-fq-helper
>
> Use of uninitialized value within %info in string eq at
> C:/strawberry/site/lib/F
> inance/Quote/Yahoo/Base.pm line 222, <> line 1.
> Use of uninitialized value $info{"Missing Symbols List.\34p_change"} in
> substitu
> tion (s///) at C:/strawberry/site/lib/Finance/Quote/Yahoo/Base.pm line
> 238, <> l
> ine 1.
> Use of uninitialized value within %info in pattern match (m//) at
> C:/strawberry/
> site/lib/Finance/Quote/Yahoo/Base.pm line 243, <> line 1.
> (#f)
>
> * Installation succeeded
>
> Press any key to continue . . .
>
> Microsoft Windows [Version 6.1.7600]
> Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
>
> C:\Users\RR Lindgren>perl -V
> Summary of my perl5 (revision 5 version 16 subversion 3) configuration:
>
>   Platform:
>     osname=MSWin32, osvers=5.2, archname=MSWin32-x86-multi-thread
>     uname=''
>     config_args='undef'
>     hint=recommended, useposix=true, d_sigaction=undef
>     useithreads=define, usemultiplicity=define
>     useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
>     use64bitint=undef, use64bitall=undef, uselongdouble=undef
>     usemymalloc=n, bincompat5005=undef
>   Compiler:
>     cc='cl', ccflags ='-nologo -GF -W3 -MD -Zi -DNDEBUG -O1 -DWIN32
> -D_CONSOLE -
> DNO_STRICT -DPERL_TEXTMODE_SCRIPTS -DUSE_SITECUSTOMIZE
> -DPERL_IMPLICIT_CONTEXT -
> DPERL_IMPLICIT_SYS -DUSE_PERLIO -D_USE_32BIT_TIME_T',
>     optimize='-MD -Zi -DNDEBUG -O1',
>     cppflags='-DWIN32'
>     ccversion='12.00.8168', gccversion='', gccosandvers=''
>     intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
>     d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=8
>     ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='__int64',
> lseeksi
> ze=8
>     alignbytes=8, prototype=define
>   Linker and Libraries:
>     ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf
>  -libpath:"C:
> \strawberry\lib\CORE"  -machine:x86'
>     libpth=\lib
>     libs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
>  comdlg32.l
> ib advapi32.lib shell32.lib ole32.lib oleaut32.lib  netapi32.lib uuid.lib
> ws2_32
> .lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib comctl32.lib
> msvcrt.
> lib
>     perllibs=oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
>  comdlg
> 32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib  netapi32.lib
> uuid.lib ws
> 2_32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib
> comctl32.lib msv
> crt.lib
>     libc=msvcrt.lib, so=dll, useshrplib=true, libperl=perl516.lib
>     gnulibc_version=''
>   Dynamic Linking:
>     dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
>     cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug
> -opt:ref,icf  -
> libpath:"C:\strawberry\lib\CORE"  -machine:x86'
>
>
> Characteristics of this binary (from libperl):
>   Compile-time options: HAS_TIMES HAVE_INTERP_INTERN MULTIPLICITY
>                         PERLIO_LAYERS PERL_DONT_CREATE_GVSV
>                         PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS
>                         PERL_MALLOC_WRAP PERL_PRESERVE_IVUV
> PL_OP_SLAB_ALLOC
>                         USE_ITHREADS USE_LARGE_FILES USE_LOCALE
>                         USE_LOCALE_COLLATE USE_LOCALE_CTYPE
>                         USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
>                         USE_SITECUSTOMIZE
>   Locally applied patches:
>         ActivePerl Build 1603 [296746]
>   Built under MSWin32
>   Compiled at Mar 13 2013 11:29:21
>   @INC:
>     C:/strawberry/site/lib
>     C:/strawberry/lib
>     .
>
> C:\Users\RR Lindgren>perl -MFinance::Quote -e"print
> ""$Finance::Quote::VERSION\n
> """
> 1.18
>
> C:\Users\RR Lindgren>
>
> ------------------------------
>
> Message: 12
> Date: Mon, 30 Jun 2014 08:55:09 +0100
> From: "Fred Bone" <Fred.Bone at dial.pipex.com>
> To: "Richard Lindgren" <richard_lindgren at outlook.com>
> Cc: gnucash-user at gnucash.org
> Subject: Re: Downloading Stock Prices - Finance::Quote Problems
> Message-ID: <53B117DD.16972.228FD1BF at Fred.Bone.dial.pipex.com>
> Content-Type: text/plain; charset=US-ASCII
>
> On 30 June 2014 at 3:42, Richard Lindgren said:
>
> > Fred,
> > In my frustrations in trying to make this work, I re-installed Windows 7
> > (again) to make sure I didn't mess anything up. - I then downloaded and
> > installed GnuCash 2.63 - I then Installed Activeperl 5.16.3.1603. This
> was
> > installed in my Strawberry folder. - I then went into the Perl Package
> > Manager and it went through a database sync operation. - I then opened up
> > the command prompt and entered "perl -V". That worked ok. - I then
> > entered: perl -MFinance::Quote -e"print ""$Finance::Quote::VERSION\n""".
> > That worked ok. - I then went in as the Administrator to start the
> utility
> > to Retrieve Online Price Retrieval. That worked ok. - I then opened up up
> > GnuCash and went to the Advanced Portfolio to get my download of the
> > prices. STILL, no luck. It comes back and says unable to retrieve qoutes
> > for these items.
>
> We now know that you have Finance-Quote 1.18, which was the point of the
> ::VERSION stuff.
>
> For one selected quote that fails, please report exactly what you have in
> the "Edit Security" dialog box ("Edit" from the Security Editor). Maybe
> someone can spot what you have wrong.
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> ------------------------------
>
> End of gnucash-user Digest, Vol 135, Issue 40
> *********************************************
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GnuCashLindgren2.PNG
Type: image/png
Size: 47655 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20140630/9172dc53/attachment-0001.png>


More information about the gnucash-user mailing list