gnucash-user Digest, Vol 89, Issue 31

glenn bergmann gnebergie at gmail.com
Wed Aug 25 13:21:42 EDT 2010


Re: Install Online Price Retrieval

I down loaded ActivePerl 5.8.9.827 and using install.bat, installed the
software.  I use gnuCash 2.2.9 and the "Install Online Price Retrieval" does
state that ActivePerl 5.8 is required.

After ActivePerl installation, a computer restart and choosing "Install
Online Price Retrieval" I got the attached screen.  I am using a Windows 7,
a 64 bit computer and I installed the 64 bit version of ActivePerl
5.8.9.827.

The procedure to accomplish this feature will intimidate a large number of
gnuCash users.  The install procedure takes the user to the command screen
on the computer and the gui is not clear on the inputs required to proceed.
And it didn't work.

Hopefully, the next version of gnuCash will utilize ApplePerl 5.12 which has
a familiar install procedure.  gnuCash 2.2.9 doesn't like this version of
ApplePerl.

This for info purposes.  No more help required.  I am going to wait until
this feature is easier to implement.

Thanks again for the inputs.

Glenn


On Wed, Aug 25, 2010 at 11:00 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. GnuCash to be presented at the Utah Open Source Conference
>      (Joseph Brower)
>   2. Re: Help to install Finance::quote (Divakar Ramachandran)
>   3. Re: Phantom bill (Derek Atkins)
>   4. Re: gnucash-user Digest, Vol 89, Issue 27 (Derek Atkins)
>   5. Re: gnucash-user Digest, Vol 89, Issue 27 (glenn bergmann)
>   6. RE: gnucash-user Digest, Vol 89, Issue 27 (David Halverson)
>   7. Start gnucash (Richard)
>   8. Re: Start gnucash (Derek Atkins)
>   9. Re: Start gnucash (Geert Janssens)
>  10. Re: gnucash-user Digest, Vol 89, Issue 27 (glenn bergmann)
>  11. CSV Import (mxqute)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 24 Aug 2010 11:32:43 -0600
> From: Joseph Brower <jbrower at nexusprofessionals.com>
> Subject: GnuCash to be presented at the Utah Open Source Conference
> To: gnucash-user at gnucash.org
> Cc: gnucash-devel at gnucash.org
> Message-ID: <1282671163.13870.4.camel at joseph-desktop>
> Content-Type: text/plain; charset="UTF-8"
>
> I will be giving a presentation at the Utah Open Source Conference on
> Gnucash.  The conference is from October 7-9.  You can see conference
> schedule at http://utosc.com/presentation/schedule/ and presentation
> details at http://utosc.com/presentation/198/ .
>
> This will be my 4th year attending.  It has always been an excellent
> experience and I would strongly suggest going.
>
> Thanks,
>
> Joseph Brower
>
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 25 Aug 2010 00:59:27 +0530
> From: Divakar Ramachandran <divakar07 at dataone.in>
> Subject: Re: Help to install Finance::quote
> To: gnucash-user at gnucash.org
> Message-ID: <4C741D97.8050101 at dataone.in>
> Content-Type: text/plain; charset=ISO-8859-1
>
>  On 21/08/2010 04:05, Johan Vinck wrote:
> > Hello,
> >
> >
> >
> > I'm an MS Money user for years. I'm now looking for a new financial
> program since they stopped the production and the on line services by the
> end of January 2011.
> >
> > I've been through ? lot of financial programs and the best so far is
> GNUcash ! Because I'm a accountant, so the structure and the double entry is
> great for me. (Balance, cash flow...)
> >
> >
> >
> > Only...I'm not that good in computer languages.
> >
> >
> >
> > Could someone please give some help on installing Finance::quote. I tried
> really hard to install it but...without success.
> >
> Some info on this is available in the wiki at
> http://wiki.gnucash.org/wiki/Windows#Finance::Quote. Have you seen it
> and still have a problem?
>
> Div.
>
> --
> *Divakar Ramachandran* Anupuram, TN 603127, _INDIA_
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 24 Aug 2010 18:36:44 -0400
> From: Derek Atkins <warlord at MIT.EDU>
> Subject: Re: Phantom bill
> To: Wouter van Marle <wouter at squirrel-systems.com>
> Cc: maillist Gnucash <gnucash-user at gnucash.org>
> Message-ID: <sjmhbijy6wz.fsf at pgpdev.ihtfp.org>
> Content-Type: text/plain; charset=us-ascii
>
> Wouter van Marle <wouter at squirrel-systems.com> writes:
>
> >> One thing you might try is deleting it from the *other* account?  I.e.,
> >> don't delete it from A/R or A/P, but from the Income or Expense
> >> account.  However, this still might not work.
> >
> > Both the liability and the payables accounts give the message:
> > "Cannot modify or delete this transaction.
> >
> > this transaction is marked read-only with the
> > comment: 'Generated from an invoice. Try unposting
> > the invoice.'"
> >
> > This was the first I tried (except trying from the other side; expecting
> > no difference) to get rid of the offending transaction. The problem here
> > is that it is the bill transaction itself, not the payment for that bill
> > (which indeed can be deleted/changed manually). Invoices work indeed the
> > same in that respect.
>
> Yeah, not surprising.
>
> >> > So I'm looking for a way to introduce balancing transactions to
> >> > compensate for this. Like a negative invoice, which is an issue in
> >> > itself of course for GnuCash - but no idea how that could be solved.
> >>
> >> Negative Invoice == Process Payment.  But then your lots will be all
> >> screwed up.
> >
> > Well insofar a "negative invoice" would also decrease my COGS account,
> > which a payment doesn't do (or can one safely post a payment to a COGS
> > account?).
>
> Sure.  Process the payment as you normally would and then go and change
> the account from e.g. Checking to e.g. COGS.
>
> > It seems the best solution here is to take another invoice (with larger
> > amount), and deduct the exact same amount from that invoice. Then I just
> > have to try and set some comments here and there as a reminder on why
> > this is done that way... just in case some accountant wants to have a
> > look.
>
> That's certainly another option...
>
> > Wouter.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 24 Aug 2010 18:38:21 -0400
> From: Derek Atkins <warlord at MIT.EDU>
> Subject: Re: gnucash-user Digest, Vol 89, Issue 27
> To: glenn bergmann <gnebergie at gmail.com>
> Cc: gnucash-user at gnucash.org
> Message-ID: <sjmd3t7y6ua.fsf at pgpdev.ihtfp.org>
> Content-Type: text/plain; charset=us-ascii
>
> glenn bergmann <gnebergie at gmail.com> writes:
>
> > Ref Message 201008211741.19649.janssens-geert at telenet.be>
> >
> > I am also interested in obtaining stock quotes from the internet for use
> by
> > gnuCash.  The link instructions on how to do so are not clear to me.
>  Could
> > someone outline the step by step procedures to follow after downloading
> and
> > installing the recommended version of ActivePerl.  What steps are then
> > necessary for gnuCash to use the downloaded program to obtain and utilize
> > stock quotes from the internet?
>
> Start -> All Programs -> GnuCash -> Install Online Price Retrieval
>
> [snip]
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> PS: Please trim your replies.
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 24 Aug 2010 18:57:12 -0500
> From: glenn bergmann <gnebergie at gmail.com>
> Subject: Re: gnucash-user Digest, Vol 89, Issue 27
> To: Derek Atkins <warlord at mit.edu>
> Cc: gnucash-user at gnucash.org
> Message-ID:
>        <AANLkTi=LyqcP6iGCvg-a66=Y=H03opk5s1MyLNoUmkyO at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi, I didn't make myself clear enough on the inquiry.  The problem I have
> is
> related to installing the ActivePerl software.  Do you just run the
> ActivePerl download program,
>
> ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi<file:///G:/Program%20Downloads/ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi>,
> and then follow the procedure Start -> All Programs -> GnuCash -> Install
> Online Price Retrieval?
>
> Sorry my message wasn't stated more clearly.
>
> Glenn
>
>
> On Tue, Aug 24, 2010 at 5:38 PM, Derek Atkins <warlord at mit.edu> wrote:
>
> > glenn bergmann <gnebergie at gmail.com> writes:
> >
> > > Ref Message 201008211741.19649.janssens-geert at telenet.be>
> > >
> > > I am also interested in obtaining stock quotes from the internet for
> use
> > by
> > > gnuCash.  The link instructions on how to do so are not clear to me.
> >  Could
> > > someone outline the step by step procedures to follow after downloading
> > and
> > > installing the recommended version of ActivePerl.  What steps are then
> > > necessary for gnuCash to use the downloaded program to obtain and
> utilize
> > > stock quotes from the internet?
> >
> > Start -> All Programs -> GnuCash -> Install Online Price Retrieval
> >
> > [snip]
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > PS: Please trim your replies.
> >
> > --
> >       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >       Member, MIT Student Information Processing Board  (SIPB)
> >       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >       warlord at MIT.EDU                        PGP key available
> >
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 25 Aug 2010 11:32:28 +1000
> From: "David Halverson" <hellvee at gmail.com>
> Subject: RE: gnucash-user Digest, Vol 89, Issue 27
> To: "'glenn bergmann'" <gnebergie at gmail.com>
> Cc: gnucash-user at gnucash.org
> Message-ID: <000801cb43f5$63835130$2a89f390$@gmail.com>
> Content-Type: text/plain;       charset="us-ascii"
>
> Glenn,
>
> I'm running GnuCash 2.3.15 and it will only run on Windows with ActivePerl
> 5.8 or 5.10 - I installed 5.10.1.  Yes download it and double click on the
> windows installer (.msi) file to install activeperl.
>
> I'd also advise you to restart after installing activeperl before you run
> the Start -> All Programs -> GnuCash -> Install Online Price Retrieval as I
> think from memory I had issues with detecting activeperl until I restarted.
>
> If you run Start -> All Programs -> GnuCash -> Install Online Price
> Retrieval prior to installing activeperl I think it tells you that it's not
> installed and also what version is required.
>
> Cheers Dave H.
>
> -----Original Message-----
> From: gnucash-user-bounces at gnucash.org
> [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of glenn bergmann
> Sent: Wednesday, 25 August 2010 9:57 AM
> To: Derek Atkins
> Cc: gnucash-user at gnucash.org
> Subject: Re: gnucash-user Digest, Vol 89, Issue 27
>
> Hi, I didn't make myself clear enough on the inquiry.  The problem I have
> is
> related to installing the ActivePerl software.  Do you just run the
> ActivePerl download program,
>
> ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi<file:///G:/Program%20Downloads
> /ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi>,
> and then follow the procedure Start -> All Programs -> GnuCash -> Install
> Online Price Retrieval?
>
> Sorry my message wasn't stated more clearly.
>
> Glenn
>
>
> On Tue, Aug 24, 2010 at 5:38 PM, Derek Atkins <warlord at mit.edu> wrote:
>
> > glenn bergmann <gnebergie at gmail.com> writes:
> >
> > > Ref Message 201008211741.19649.janssens-geert at telenet.be>
> > >
> > > I am also interested in obtaining stock quotes from the internet for
> > > use
> > by
> > > gnuCash.  The link instructions on how to do so are not clear to me.
> >  Could
> > > someone outline the step by step procedures to follow after
> > > downloading
> > and
> > > installing the recommended version of ActivePerl.  What steps are
> > > then necessary for gnuCash to use the downloaded program to obtain
> > > and utilize stock quotes from the internet?
> >
> > Start -> All Programs -> GnuCash -> Install Online Price Retrieval
> >
> > [snip]
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > PS: Please trim your replies.
> >
> > --
> >       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >       Member, MIT Student Information Processing Board  (SIPB)
> >       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >       warlord at MIT.EDU                        PGP key available
> >
> _______________________________________________
> 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: 7
> Date: Wed, 25 Aug 2010 11:03:28 +1000
> From: Richard <apianoman at optusnet.com.au>
> Subject: Start gnucash
> To: gnucash-user at gnucash.org
> Message-ID: <4C746BE0.1000405 at optusnet.com.au>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
>
> Just loaded Gnucash but missed setup first time. Is there a way to get
> back the setup Account?
>
> Help is not available from within Gnucash. Is there a way to get help
> insie Gnucash?
>
> Richard H. Peddie.
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 25 Aug 2010 09:51:57 -0400
> From: Derek Atkins <warlord at MIT.EDU>
> Subject: Re: Start gnucash
> To: Richard <apianoman at optusnet.com.au>
> Cc: gnucash-user at gnucash.org
> Message-ID: <sjmvd6yx0jm.fsf at pgpdev.ihtfp.org>
> Content-Type: text/plain; charset=us-ascii
>
> Hi,
>
> Richard <apianoman at optusnet.com.au> writes:
>
> > Hi,
> >
> > Just loaded Gnucash but missed setup first time. Is there a way to get
> > back the setup Account?
>
> File -> New -> New File
>
> > Help is not available from within Gnucash. Is there a way to get help
> > insie Gnucash?
>
> You don't say what OS/Distro you're running.  On Linux you need to
> install the gnucash-docs package.
>
> > Richard H. Peddie.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available
>
>
> ------------------------------
>
> Message: 9
> Date: Wed, 25 Aug 2010 16:04:54 +0200
> From: Geert Janssens <janssens-geert at telenet.be>
> Subject: Re: Start gnucash
> To: gnucash-user at gnucash.org
> Cc: Richard <apianoman at optusnet.com.au>
> Message-ID: <201008251604.54352.janssens-geert at telenet.be>
> Content-Type: Text/Plain;  charset="iso-8859-1"
>
> On Wednesday 25 August 2010, Richard wrote:
> > Hi,
> >
> > Just loaded Gnucash but missed setup first time. Is there a way to get
> > back the setup Account?
> >
> > Help is not available from within Gnucash. Is there a way to get help
> > insie Gnucash?
> >
> > Richard H. Peddie.
> >
> The account setup assistant is run each time you create a new file. If you
> missed it, you can select File->New->New File to start a new file with the
> setup assistant.
>
> Geert
>
>
> ------------------------------
>
> Message: 10
> Date: Wed, 25 Aug 2010 09:14:34 -0500
> From: glenn bergmann <gnebergie at gmail.com>
> Subject: Re: gnucash-user Digest, Vol 89, Issue 27
> To: David Halverson <hellvee at gmail.com>
> Cc: gnucash-user at gnucash.org
> Message-ID:
>        <AANLkTimicK=icxD2PhVnCU2i=DtkcE0WZ8n7f12s4vm0 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Thanks for the rapid response.  Your explanation is excellent.  I am leery
> about installing programs from the internet so.  Needed some support for
> doing this.
>
> gnuCash support is far better than I have received from any commercial
> software company.  I have been involved in PC type computers since 1975.
> You should be very proud of what you do.
>
> Glenn
>
>
> On Tue, Aug 24, 2010 at 8:32 PM, David Halverson <hellvee at gmail.com>
> wrote:
>
> > Glenn,
> >
> > I'm running GnuCash 2.3.15 and it will only run on Windows with
> ActivePerl
> > 5.8 or 5.10 - I installed 5.10.1.  Yes download it and double click on
> the
> > windows installer (.msi) file to install activeperl.
> >
> > I'd also advise you to restart after installing activeperl before you run
> > the Start -> All Programs -> GnuCash -> Install Online Price Retrieval as
> I
> > think from memory I had issues with detecting activeperl until I
> restarted.
> >
> > If you run Start -> All Programs -> GnuCash -> Install Online Price
> > Retrieval prior to installing activeperl I think it tells you that it's
> not
> > installed and also what version is required.
> >
> > Cheers Dave H.
> >
> > -----Original Message-----
> > From: gnucash-user-bounces at gnucash.org
> > [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of glenn bergmann
> > Sent: Wednesday, 25 August 2010 9:57 AM
> > To: Derek Atkins
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: gnucash-user Digest, Vol 89, Issue 27
> >
> > Hi, I didn't make myself clear enough on the inquiry.  The problem I have
> > is
> > related to installing the ActivePerl software.  Do you just run the
> > ActivePerl download program,
> >
> >
> ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi<file:///G:/Program%20Downloads
> > /ActivePerl-5.12.1.1201-MSWin32-x64-292674.msi>,
> > and then follow the procedure Start -> All Programs -> GnuCash -> Install
> > Online Price Retrieval?
> >
> > Sorry my message wasn't stated more clearly.
> >
> > Glenn
> >
> >
> > On Tue, Aug 24, 2010 at 5:38 PM, Derek Atkins <warlord at mit.edu> wrote:
> >
> > > glenn bergmann <gnebergie at gmail.com> writes:
> > >
> > > > Ref Message 201008211741.19649.janssens-geert at telenet.be>
> > > >
> > > > I am also interested in obtaining stock quotes from the internet for
> > > > use
> > > by
> > > > gnuCash.  The link instructions on how to do so are not clear to me.
> > >  Could
> > > > someone outline the step by step procedures to follow after
> > > > downloading
> > > and
> > > > installing the recommended version of ActivePerl.  What steps are
> > > > then necessary for gnuCash to use the downloaded program to obtain
> > > > and utilize stock quotes from the internet?
> > >
> > > Start -> All Programs -> GnuCash -> Install Online Price Retrieval
> > >
> > > [snip]
> > > > Please remember to CC this list on all your replies.
> > > > You can do this by using Reply-To-List or Reply-All.
> > >
> > > -derek
> > >
> > > PS: Please trim your replies.
> > >
> > > --
> > >       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> > >       Member, MIT Student Information Processing Board  (SIPB)
> > >       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> > >       warlord at MIT.EDU                        PGP key available
> > >
> > _______________________________________________
> > 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: Wed, 25 Aug 2010 08:27:26 -0700 (PDT)
> From: mxqute <riskz at yahoo.com>
> Subject: CSV Import
> To: gnucash-user at gnucash.org
> Message-ID: <1282750046873-2338423.post at n4.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
>
> I would like to import my transaction activities that I keep in a
> spreadsheet
> (csv format) into GNU cash, what is the best way to format my spreadsheet?
> Currently I have -> Date, Transaction Description, Amount, Account (cash or
> credit) and Category.  Any suggestions or tips would be appreciated.
>
> Thanks,
> Marx
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/CSV-Import-tp2338423p2338423.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>
> End of gnucash-user Digest, Vol 89, Issue 31
> ********************************************
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ActivePerl 5.8.9.827.JPG
Type: image/jpeg
Size: 41372 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100825/976869a6/attachment-0001.jpe>


More information about the gnucash-user mailing list