gnucash-user Digest, Vol 135, Issue 41
Richard Lindgren
rlindgren74 at gmail.com
Mon Jun 30 04:33:14 EDT 2014
Dave,
Okay, maybe we have hit on something. Yes to your questions. I installed
Activeperl on top of Strawberry. Should I be un-installing Activeperl and
try and have GnuCash 2.63 install what I need? Need some more direction
here as I apparrently have introduced some wrong installations.
Richard
On Mon, Jun 30, 2014 at 4:15 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. Re: Downloading Stock Prices - Finance::Quote Problems (Dave H)
> 2. Re: gnucash-user Digest, Vol 135, Issue 40 (Richard Lindgren)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 30 Jun 2014 18:08:44 +1000
> From: Dave H <hellvee at gmail.com>
> To: Richard Lindgren <richard_lindgren at outlook.com>
> Cc: Fred.Bone at dial.pipex.com, Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: Downloading Stock Prices - Finance::Quote Problems
> Message-ID:
> <
> CA+5xQdqg+RWRa9dkZQL9FY+m1mn+7z4cn0s8fuYbTEAhCSAM8w at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Richard,
>
> I understood that strawberry Perl was installed by default if perl wasn't
> found when installing gnucash. It's interesting that you say you installed
> active perl and it installed in your strawberry Perl directory. Are you
> installing active state Perl over the top of strawberry Perl and screwing
> up both in the process ?
>
> Also I generally find I need to reboot after installing perl on Windows for
> it to work for me.
>
> Cheers Dave H
> On Jun 30, 2014 5:42 PM, "Richard Lindgren" <richard_lindgren at outlook.com
> >
> wrote:
>
> > 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"""
> > >
> > >
> > >
> >
> > _______________________________________________
> > 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: 2
> Date: Mon, 30 Jun 2014 04:15:40 -0400
> From: Richard Lindgren <rlindgren74 at gmail.com>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
> Subject: Re: gnucash-user Digest, Vol 135, Issue 40
> Message-ID:
> <CAD8ROJarwcq8zEu-_K79PAWsctH2kzYR8Yj=
> nseamJiW_o9HKg at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> 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.png
> >
>
> ------------------------------
>
> 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 41
> *********************************************
>
More information about the gnucash-user
mailing list