gnucash-user Digest, Vol 89, Issue 33

Thu Aug 26 13:50:35 EDT 2010

Re: Install Online Price Retrieval

The latest ActivePerl version 5.10 does work and allows "Install Online
Price Retrieval" to work.  The gnuCash procedure to continue & complete
setting up the automatic stock price retrieval is more complex than I want
to deal with.  Will continue manual inputs.

Thanks for all your help.

Glenn

On Thu, Aug 26, 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. stocks & shares dealing accounts (Tarlika Elisabeth Schmitz)
>   2. Re: gnucash-user Digest, Vol 89, Issue 31 (Divakar Ramachandran)
>   3. RE: gnucash-user Digest, Vol 89, Issue 31 (David Halverson)
>   4. Re: CSV Import (Paul Schwartz)
>   5. Re: CSV Import (Martin Preuss)
>   6. RE: CSV Import (David Halverson)
>   7. Operation date vs booking date in home accounting? (Pawe? Zaj?c)
>   8. Re: Start gnucash (Geert Janssens)
>   9. online quote problem (Paul Minter)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 25 Aug 2010 19:00:24 +0100
> From: Tarlika Elisabeth Schmitz <gnucash2 at numerixtechnology.de>
> Subject: stocks & shares dealing accounts
> To: gnucash-user at gnucash.org
> Message-ID: <20100825190024.5bd9898e at dick.coachhouse>
> Content-Type: text/plain; charset=US-ASCII
>
> I used to have a share dealing account, which I closed. I had my shares
> transferred out and I now have paper certificates (of worthless bank
> shares).
>
>
> This is how I structured my GnuCash accounts:
>
> + Assets
> + + Dealing Account Name (placeholder)
> + + + Deposit Account
> + + + Stocks
> + + + + HBOS
>
>
>
> Considering that one might change dealing account my set-up isn't
> really appropriate. You might even have multiple dealing accounts who
> you hold different stocks with.
>
> Any suggestions how to organize the GnuCash accounts?
>
> --
>
> Best Regards,
> Tarlika Elisabeth Schmitz
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 26 Aug 2010 00:23:02 +0530
> From: Divakar Ramachandran <divakar07 at dataone.in>
> Subject: Re: gnucash-user Digest, Vol 89, Issue 31
> To: gnucash-user at gnucash.org
> Message-ID: <4C75668E.5040702 at dataone.in>
> Content-Type: text/plain; charset=ISO-8859-1
>
>  On 25/08/2010 22:51, glenn bergmann wrote:
> > 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.
>
> I am on Win7-64bit here as well. The Perl version I am using is
> "ActivePerl 5.10.1 Build 1007 (64-bit)" and I don't remember seeing the
> DateManip problem - maybe it was a temporary server issue with your ISP?
> - just guessing, no idea really. However, the 5.8 specification for
> GnuCash 2.2.9 is a minimum requirement - it was the latest version when
> 2.2.9 was released. AFAIK, online price retrieval works fine with later
> versions as well. 5.10 was the latest available when I setup this new
> desktop a few months ago. What I mean is, no need to wait, go ahead and
> install the latest version.
>
> HTH,
> Div.
>
> > Thanks again for the inputs.
> >
> > Glenn
> >
> >
> > On Wed, Aug 25, 2010 at 11:00 AM, <gnucash-user-request at gnucash.org>
> wrote:
> >
>
> --
> *Divakar Ramachandran* Anupuram, TN 603127, _INDIA_
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 26 Aug 2010 05:32:17 +1000
> From: "David Halverson" <hellvee at gmail.com>
> Subject: RE: gnucash-user Digest, Vol 89, Issue 31
> To: "'glenn bergmann'" <gnebergie at gmail.com>,
>        <gnucash-user at gnucash.org>
> Message-ID: <000d01cb448c$3d465200$b7d2f600$@gmail.com>
> Content-Type: text/plain;       charset="us-ascii"
>
> Glenn,
>
> Sorry I had forgotten that I also got this error when I attempted to
> install
> Activeperl 5.8 so I downloaded and installed 5.10 which installed without
> the date errors.
>
> Regards Dave.
>
> -----Original Message-----
> From: gnucash-user-bounces at gnucash.org
> [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of glenn bergmann
> Sent: Thursday, 26 August 2010 3:22 AM
> To: gnucash-user at gnucash.org
> Subject: Re: gnucash-user Digest, Vol 89, Issue 31
>
> 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
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 25 Aug 2010 13:20:02 -0700 (PDT)
> From: Paul Schwartz <pmjs1115 at yahoo.com>
> Subject: Re: CSV Import
> To: mxqute <riskz at yahoo.com>, gnucash-user at gnucash.org
> Message-ID: <872270.95623.qm at web55503.mail.re4.yahoo.com>
> Content-Type: text/plain; charset=us-ascii
>
> Go find the calc2qif [or similar] macro. Install it in your spreadsheet
> program
> [OpenOffice?]. Then it will allow you to produce a qif file from your
> spreadsheet whatever the order of columns.
>
> HTH
>
> Paul
>
>
>
> ----- Original Message ----
> > From: mxqute <riskz at yahoo.com>
> > To: gnucash-user at gnucash.org
> > Sent: Wed, August 25, 2010 9:27:26 AM
> > Subject: CSV Import
> >
> >
> > 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
> > -----
> > Please  remember to CC this list on all your replies.
> > You can do this by using  Reply-To-List or Reply-All.
> >
>
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 25 Aug 2010 22:33:04 +0200
> From: Martin Preuss <martin at aqbanking.de>
> Subject: Re: CSV Import
> To: gnucash-user at gnucash.org
> Message-ID: <201008252233.04410.martin at aqbanking.de>
> Content-Type: Text/Plain;  charset="iso-8859-1"
>
> Hi,
>
> just a note to the developers: As soon as the adaptation of GnuCash to
> AqBanking5 is finished users can use AqBanking5's new generic file importer
> which contains a profile editor for CSV files. This makes it possible to
> import
> bank statements from nearly any CSV file.
>
> This dialog is also based on GWEN's platform independent dialog framework,
> so
> it runs natively inside GnuCash.
>
>
> Regards
> Martin
>
>
> On Mittwoch 25 August 2010, Paul Schwartz wrote:
> > Go find the calc2qif [or similar] macro. Install it in your spreadsheet
> >  program [OpenOffice?]. Then it will allow you to produce a qif file from
> >  your spreadsheet whatever the order of columns.
> >
> > HTH
> >
> > Paul
> >
> >
> >
> > ----- Original Message ----
> >
> > > From: mxqute <riskz at yahoo.com>
> > > To: gnucash-user at gnucash.org
> > > Sent: Wed, August 25, 2010 9:27:26 AM
> > > Subject: CSV Import
> > >
> > >
> > > 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
> > >
> > >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
> > > -----
> > > 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.
> >
>
>
> --
> "Things are only impossible until they're not"
>
> Martin Preuss - http://www2.aquamaniac.de/
> AqBanking - http://www.aqbanking.de/
> LibChipcard - http://www.libchipcard.de/
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 26 Aug 2010 06:41:25 +1000
> From: "David Halverson" <hellvee at gmail.com>
> Subject: RE: CSV Import
> To: "'mxqute'" <riskz at yahoo.com>, <gnucash-user at gnucash.org>
> Message-ID: <000f01cb4495$e615b7f0$b24127d0$@gmail.com>
> Content-Type: text/plain;       charset="us-ascii"
>
> Hi Marx,
>
> I'm using the latest 2.3.15 unstable version on Win 7 as I'm not worried if
> I lose any data and I'm familiarising myself with the product - have been
> for a few months now :-)
>
> When you import a csv file into 2.3.15 you have the following columns
> available to select from :-
>
> Date (various formats you select from)
> Description
> Balance
> Deposit
> Withdrawal
>
> It doesn't seem to like any headers in the csv file so delete them if they
> are in your file.  One of my banks includes available balance lines with a
> zero transaction amount which I also delete but they are happily imported -
> they are highlighted in a different colour when importing but seem
> harmless.
>
> You can also get away with a single amount column - if you specify it as
> "Deposit" on the import any negative amounts are imported as withdrawals.
>
> As far as I'm aware you can only import to a single account so if you want
> to import to more than one account you might have to split your csv file
> and
> do more than one import.
>
> Cheers Dave H.
>
> -----Original Message-----
> From: gnucash-user-bounces at gnucash.org
> [mailto:gnucash-user-bounces at gnucash.org] On Behalf Of mxqute
> Sent: Thursday, 26 August 2010 1:27 AM
> To: gnucash-user at gnucash.org
> Subject: CSV Import
>
>
> 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
> -----
> 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 22:43:53 +0200
> From: Pawe? Zaj?c <pavzaj at gmail.com>
> Subject: Operation date vs booking date in home accounting?
> To: gnucash-user at gnucash.org
> Message-ID:
>        <AANLkTi=RmU5R2pwp2v2PqbdeRqgUzmaCNAUG_M=rzRw8 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello.
> In my bank account statements there are two dates assigned to each
> transaction:
> Operation date - date, when the transaction took place, eg. paying with
> debit card
> Booking date - date when the transaction has been recorded and added to
> account balance
>
> These dates are sometimes different.
>
> When I create ofx files from these statements (using some kind of parsing
> script) i choose Operation date to be used as transaction date in ofx. I do
> this, because Operation date is the same as date on receipts which I use to
> reconcile and analyse my expenses. The problem is that my bank use Booking
> date to calculate balances, so sometimes my gnucash transaction record is
> different than my bank statement. All in all the total balance on the end
> of
> the period is the same, but particular transactions may differ in balance.
> I'm totally new to accounting. What should I do? Is it a problem at all? It
> doesn't (usually)  affect reports etc. What do you think?
>
>
> ------------------------------
>
> Message: 8
> Date: Thu, 26 Aug 2010 10:10:09 +0200
> From: Geert Janssens <janssens-geert at telenet.be>
> Subject: Re: Start gnucash
> To: apianoman at optusnet.com.au
> Cc: gnucash-user at gnucash.org
> Message-ID: <201008261010.09396.janssens-geert at telenet.be>
> Content-Type: Text/Plain;  charset="iso-8859-15"
>
> On Thursday 26 August 2010, Richard Henry Peddie wrote:
> > Hi Geert,
> >
> > When I run new file, the input for start amount is not there.
> >
> > Is there a way to uninstall & start again?
> >
> > Richard H. Peddie.
> >
> I'm not sure what you are missing. Do you want to set opening balances for
> your new accounts ? You can do this in the step right after the step where
> you
> select the accounts you want in your book.
>
> On the other hand, the opening balance is just a transaction like any
> other,
> where the other account is Equity->Opening Balance. So if you forgot to set
> opening balances during the assistent, you can easily set opening balances
> manually later, by creating such transactions.
>
> There should be no need to uninstall & start again.
>
> Geert
>
>
> P.S. Please send all replies to the list. Thank you.
>
>
> ------------------------------
>
> Message: 9
> Date: Thu, 26 Aug 2010 08:58:09 +1000
> From: Paul Minter <p.minter at sil.org.pg>
> Subject: online quote problem
> To: gnucash-user at gnucash.org
> Message-ID: <4C75A001.8070408 at sil.org.pg>
> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
>
>  I have installed gnucash 2.2.9 on Windows Vista Home Premium running
> behind a corporate proxy. I have installed the Finance::Quote module but
> I think I'm hung up with the proxy. The "gnc-fq-dump" script returns "No
> results". How can I get the perl script to prompt for my proxy login or
> otherwise get through it? Thanks.
>
>
> ------------------------------
>
> _______________________________________________
> 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 33
> ********************************************
>