gmane.comp.gnome.apps.gnucash.user

Re: Finance::Quote does not install

Deane Yamane — 2012-05-24T07:29:15

Great 'write-up'. … Works for me. 

Mahalo, Mr. 'Dizzy' Deane Yamane

On May 13, 2012, at 12:09 PM, John Ralls wrote:



_______________________________________________
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.

Re: account e transaction

David Carlson — 2012-05-24T05:19:51

There is a future scheduled transactions summary report.  It shows the
net changes to accounts during the selected interval rather than actual
transactions, but that may be what you want to see.

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.

Re: question on transaction download/import

David T. — 2012-05-24T02:24:11

Chuck--

Welcome, and congratulations on the migration!

With regard to your specific question, the imported description cannot be changed on import, but must be manually edited after the fact. Depending on how your bank creates these descriptions, you may find that Gnucash's quickfill feature will make many of these changes quick to do. 


If, for example, your Bank's transaction is something like: 


89762346--SAFEWAY AND SONS--JKH92JH98 SD976

it is very easy, using Quickfill, to change it to:

Safeway & Sons

Quickfill will probably get your previous entry after just a few characters.


If, however, your Bank's transaction is something like: 


SAFEWAY & SONS--JKH92JH98 SD976

You're stuck re-keying the entire description all over again, and then adding and removing a spurious character at the end of what you want it to say. This is a Known Behavior of Gnucash's quickfill implementation.

David


If, however, your bank's 



________________________________
 From: Chuck Cox <chuck< at >chezcox.net>
To: gnucash-user< at >gnucash.org 
Sent: Wednesday, May 23, 2012 2:18 PM
Subject: question on transaction download/import
 
Hi, new Gnucash user here in the process of converting over from
Quicken. I have successfully setup my accounts and imported about 12
years of old Quicken data via QIF files. Believe it or not, this all
went pretty smoothly. The few issues I ran into were caused by stupid
things that Quicken did...

I have also successfully configured Online Banking to fetch
transactions for my checking and savings accounts from my bank's OFX
server.  This is where my question comes in:

After the OFX file is downloaded from the bank's server, the list of
transactions comes up in the "Generic import transaction matcher". I
feel I understand pretty well what this window is showing me and have
figured out how to check what it has matched or to manually match
things if it has failed to find a match. No problems with adding new
transactions or just assigning an account to a transaction.

The problem is that I do not see a way to edit the "Description" of
each transaction in this window. The importing process seems to be
taking the <NAME> and <MEMO> fields from the OFX data, joining them
together, and then sticking them into the description field. After I
am done matching things up and click OK, all the transaction inserted
into the register show this big long string of stuff as the
description which does usually contain the payee in it somewhere, but
with a bunch of other junk I don't need there.

So is there a way to fix the Descriptions from within the matcher, or
do I simply have to go through them all in the register each time and
correct them? I have searched the mailing list archives and found
several past discussions about this sort of thing, but no solutions. I
did see several mentions that the Bayesian capability in the matcher
is supposed to learn and improve over time. Will this address the
issue? I have only downloaded transactions a couple of times so far,
so obviously it hasn't had much of a chance to learn anything yet. :-)


Thanks,
Chuck
_______________________________________________
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.

Re: account e transaction

David T. — 2012-05-24T02:00:32

I think you're asking whether Gnucash can give you an account balance that includes scheduled transactions. 

The answer to that question is "No." Gnucash can only give account balances on actual transactions that exist in the file; the Scheduled Transaction doesn't exist, so Gnucash can't calculate it in.

One alternative is to create transactions ahead of time, although this is fraught with a number of pitfalls: what if the transaction changes substantially in date or time--or even amount? What if it doesn't actually go through? And, how representative will your balances be if you don't pre-enter all the REST of your transactions?

HTH,
David



________________________________
 From: auleia <vincenzomary< at >libero.it>
To: gnucash-user< at >gnucash.org 
Sent: Wednesday, May 23, 2012 9:56 AM
Subject: account e transaction
 
I come here with this question. you can have a current account balance also
calculate the scheduled transactions on a certain date? Thank you.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/account-e-transaction-tp4651828.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.

question on transaction download/import

Chuck Cox — 2012-05-23T21:18:03

Hi, new Gnucash user here in the process of converting over from
Quicken. I have successfully setup my accounts and imported about 12
years of old Quicken data via QIF files. Believe it or not, this all
went pretty smoothly. The few issues I ran into were caused by stupid
things that Quicken did...

I have also successfully configured Online Banking to fetch
transactions for my checking and savings accounts from my bank's OFX
server.  This is where my question comes in:

After the OFX file is downloaded from the bank's server, the list of
transactions comes up in the "Generic import transaction matcher". I
feel I understand pretty well what this window is showing me and have
figured out how to check what it has matched or to manually match
things if it has failed to find a match. No problems with adding new
transactions or just assigning an account to a transaction.

The problem is that I do not see a way to edit the "Description" of
each transaction in this window. The importing process seems to be
taking the <NAME> and <MEMO> fields from the OFX data, joining them
together, and then sticking them into the description field. After I
am done matching things up and click OK, all the transaction inserted
into the register show this big long string of stuff as the
description which does usually contain the payee in it somewhere, but
with a bunch of other junk I don't need there.

So is there a way to fix the Descriptions from within the matcher, or
do I simply have to go through them all in the register each time and
correct them? I have searched the mailing list archives and found
several past discussions about this sort of thing, but no solutions. I
did see several mentions that the Bayesian capability in the matcher
is supposed to learn and improve over time. Will this address the
issue? I have only downloaded transactions a couple of times so far,
so obviously it hasn't had much of a chance to learn anything yet. :-)


Thanks,
Chuck
_______________________________________________
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.

Re: F::Q

Les — 2012-05-23T20:01:33

Thanks Divakar!

Is this quoted by Yahoo or ..?

Regards,
Les


_______________________________________________
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.

Re: F::Q

Divakar Ramachandran — 2012-05-23T19:53:38

Yes, there is - select commodity XAU and XAG for Au and Ag respectively,
under currency.

HTH,
Divakar

F::Q

Les — 2012-05-23T17:39:53

Is there a listing for precious metals (gold, silver) prices (per oz or..)?

Thanks,
Les
_______________________________________________
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.

account e transaction

auleia — 2012-05-23T16:56:24

I come here with this question. you can have a current account balance also
calculate the scheduled transactions on a certain date? Thank you.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/account-e-transaction-tp4651828.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.

Re: Enabling scheduled transaction crashes GnuCash

Gour — 2012-05-23T06:13:23

On Tue, 22 May 2012 21:07:16 -0500
David Carlson <carlson.dl< at >sbcglobal.net> wrote:


My experience is that scheduled transactions are very buggy in GC.

I did report about one problem - postponing them after which they
become totally messed up (here is the repo with the simple test case: 

 https://bitbucket.org/gour/sxtest

and now I have to use reminder instead.

However, I also experienced crashes with 'em.


Sincerely,
Gour

Re: Enabling scheduled transaction crashes GnuCash

David Carlson — 2012-05-23T02:07:16

David,

Do you start from a register transaction or work from scratch? I
normally start from a register transaction.

 I have fifty or more scheduled transactions working fine in release
2.4.10.  I cannot recall having a crash either in Windows environment or
in Ubuntu 11.10.  I edit about a third of them each time they come up,
usually changing some text, but occasionally I change the start date of
some that should be every month on the third Thursday, which is not an
available choice.  These do not trigger a crash for me.

Good luck.

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.

Re: GIFI Tax TXF Categories for Canada

George Lobay — 2012-05-22T23:45:35

The complete listing of GIFI codes are at the Canada Revenue Agency web 
site here:
http://www.cra-arc.gc.ca/E/pub/tg/rc4088/rc4088-e.html

On 21/05/2012 8:26 PM, bunk3m wrote:

Re: QIF import creates duplicate account

Derek Atkins — 2012-05-22T14:43:40


Hmm.  If account type *and* currency of all accounts in the tree is the
same then I see no reason that it would create a duplicate account.  The
only time I've seen that happen is when the types or currencies had a
mismatch.   *ponders*

-derek

Re: QIF import creates duplicate account

Chris Bainbridge — 2012-05-22T14:40:26

The account type for both the original and duplicate account is Bank.
The account type for the parent "Assets" account is Asset.

_______________________________________________
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.

Re: Enabling scheduled transaction crashes GnuCash

John Ralls — 2012-05-22T14:35:44

On May 22, 2012, at 12:39 AM, DavidS wrote:


Crashing is a bug, so please follow the debugging instructions in the FAQ and file a bug report:
http://wiki.gnucash.org/wiki/FAQ#Q:_Something_bad_happened.3B_how_can_I_help_debug.3F
http://wiki.gnucash.org/wiki/FAQ#Q:_I_think_I_found_a_bug._How_do_I_report_it.3F

Regards,
John Ralls



_______________________________________________
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.

Re: QIF import creates duplicate account

Derek Atkins — 2012-05-22T14:23:44

Chris,

Chris Bainbridge <chris.bainbridge< at >gmail.com> writes:


Okay, so it is not currency.  Weird.   Next thing to check:  account
types!  What are the original account types, and what are the
newly-created account types?

-derek

Enabling scheduled transaction crashes GnuCash

DavidS — 2012-05-22T07:39:13

I've been using GnuCash for a couple of years now.  For several months until
today I have been using Ubuntu 11.10 (Oneiric) with GnuCash 2.4.7.  Because
of the problem I have been getting I have now upgraded to 2.4.10, but it
hasn't helped.

I have a couple of dozen scheduled transactions which all work as they
should.  I have been trying to add another one, but every time I try to
enable it by setting the frequency and then click on OK, GnuCash crashes.

I've compared the options I've ticked and the layout of items on the three
tabs in the Scheduled Transaction Editor with other scheduled transactions
which work, and I can't see anything different, abnormal or inconsistent
about the new transaction.

I deleted another scheduled transaction in case there was a maximum number
allowed by GnuCash, but that didn't help either.

Has anyone else come across anything like this?  What could possibly be
causing the problem?

David



--
View this message in context: http://gnucash.1415818.n4.nabble.com/Enabling-scheduled-transaction-crashes-GnuCash-tp4649523.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.

Re: Finance::Quote IndiaMutual - source changes

Matej Cepl — 2012-05-22T04:34:28

And I am sorry, yes, John is right ... we are very glad you have let us 
know what's wrong. And thank you for those tickets in CPAN issue tracker.

Matěj

_______________________________________________
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.

Re: GIFI Tax TXF Categories for Canada

bunk3m — 2012-05-22T00:26:51

   Cool!  Thanks, Phil.
   I'll get working on the GIFI extract.  I haven't quite figured out the
   fields that are needed.  If you have a field listing that would help me
   a lot.
   BTW, is there a format that makes it easiest to implement?  I thought
   pipe delimited text file??
   Cheers!
   B.
   On 21.05.2012 12:38 , Phil Longstaff wrote:

   If you can provide the list of GIFI codes, I can implement them.
   Phil
     __________________________________________________________________

   From: bunk3m [1]<bunk3m< at >gmail.com>
   To: Derek Atkins [2]<warlord< at >MIT.EDU>
   Cc: [3]gnucash-user< at >gnucash.org
   Sent: Monday, May 21, 2012 12:28:18 PM
   Subject: Re: GIFI Tax TXF Categories for Canada
   Hmmm.
   I thought this might just need someone to do the manual data entry to
   create/duplicate and then change an existing file to add these other
   tax
   codes.  :-(
   I haven't programming for 25+ years.  I don't think I'll be able to
   learn Guile and then C to make whatever changes anytime soon.
   If someone knows these and can help, I can create the files that
   outline
   the GIFI codes & descriptions.
   I'll continue to putter around looking at this in my spare time.  If
   there is someone out there who can do the Guile & C programming, I'm
   ready and willing to help.
   Thanks for the help and descriptions.
   B
   On 21.05.2012 10:18 , Derek Atkins wrote:
   > John Ralls <[4]jralls< at >ceridwen.us> writes:
   >
   >> On May 19, 2012, at 11:51 AM, bunk3m wrote:
   >>
   >>> Thank you, John.
   >>>
   >>> I had a look at the file.  What type of file is an scm?
   >>>
   >>> Is there a description somewhere that can help me to understand the
   >>> structure and how the file is organized?
   >> .scm is for Scheme. Gnucash uses a variant called Guile-1.8 [1]
   >>
   >> Any documentation is in the file in the form of comments. Some
   comments are interpreted by Doxygen and produce the slightly more
   readable developer documentation [2]. There's a subdirectory
   (tax/us/de_DE) with the implementation for German taxes; that might be
   helpful as well.
   > ...and if you were to work on an en_CA version you would need to
   > effectively duplicate the way the de_DE code was implemented,
   including
   > some changes to the C code.
   >
   >> Regards,
   >> John Ralls
   >>
   >> [1]
   [5]http://www.gnu.org/software/guile/docs/docs-1.8/guile-ref/index.html
   >> [2] svn.gnucash.org/docs/head/index.html
   >> Please remember to CC this list on all your replies.
   >> You can do this by using Reply-To-List or Reply-All.
   > -derek
   >
   _______________________________________________
   gnucash-user mailing list
   [6]gnucash-user< at >gnucash.org
   [7]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.

References

   1. mailto:bunk3m< at >gmail.com
   2. mailto:warlord< at >MIT.EDU
   3. mailto:gnucash-user< at >gnucash.org
   4. mailto:jralls< at >ceridwen.us
   5. http://www.gnu.org/software/guile/docs/docs-1.8/guile-ref/index.html
   6. mailto:gnucash-user< at >gnucash.org
   7. https://lists.gnucash.org/mailman/listinfo/gnucash-user
_______________________________________________
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.

Re: Finance::Quote IndiaMutual - source changes

Matej Cepl — 2012-05-21T22:55:45

That's unfortunately our feeling as well. Which is the reason why she
tries to collect all patches floating on the Web (and in the Linux
distros' repos).


Oh believe me, she knows ... being one of the main Red Hat maintainers 
for perl* packages she has some experience.


Which was my original question ... it seemed to me that the author of 
this patch suggested it to GnuCash email list, so I was checking whether 
it goes somewhere upstream as well. Of course, I know about the Github 
repo ... but even that seems to be not perfect (e.g., number of unpulled 
pull requests).

Matěj

_______________________________________________
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.

Re: QIF import creates duplicate account

Chris Bainbridge — 2012-05-21T22:21:40

GBP (Pound Sterling). My locale is LANG=en_GB.UTF-8 LANGUAGE=en_GB:en


GBP (Pound Sterling)


There is one parent "Assets" with currency GBP (Pound Sterling)


The duplicate account has currency GBP (Pound Sterling). The only
parent is again "Assets", as already noted it has currency GBP (Pound
Sterling).
_______________________________________________
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.