Re: Auto-Complete Search Method

2011-11-05 Thread Keith Bellairs
In my chart of accounts, the leaf nodes are not necessarily unique names. I need the parent accounts to uniquely ID an account. That said, I like the way mint.com (shudder) searches. It does a substring search on all the "accounts" and presents a gradually shrinking set of matches. That would work

sale of stock - transaction posts incorrectly

2013-04-08 Thread Keith Bellairs
Any thoughts? Hope this is a known bug. Keith Bellairs Guelph ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: sale of stock - transaction posts incorrectly

2013-04-08 Thread Keith Bellairs
I was obviously concerned about "lots" too. So I just hacked my xml file to delete the following slot from the account in question: lot-mgmt Getting rid of that flag seems to be all that is needed to resolve my problem. Don't remember how I got it set in the first place, but it is evil. KB Th

Re: sale of stock - transaction posts incorrectly

2013-04-08 Thread Keith Bellairs
s first. Keith On Mon, Apr 8, 2013 at 6:52 PM, David Carlson wrote: > On 4/8/2013 5:32 PM, Keith Bellairs wrote: > > I was obviously concerned about "lots" too. So I just hacked my xml file > to delete the following slot from the account in question: > > lot-mgmt &

Re: sale of stock - transaction posts incorrectly

2013-04-09 Thread Keith Bellairs
Parent accounts are 1 Asset (top-level asset-type CAD) 1.4 Investments (child account asset-type CAD) 1.4.4 (child account stock-type mutual-fund security, no currency but it is a USD priced commodity) For fun I changed the currency of "Investments" to USD, but continues to be broken

Fwd: sale of stock - transaction posts incorrectly

2013-04-10 Thread Keith Bellairs
oops. forgot to reply all. sorry for the noise. -- Forwarded message -- From: Keith Bellairs Date: Wed, Apr 10, 2013 at 11:52 AM Subject: Re: sale of stock - transaction posts incorrectly To: Derek Atkins Thanks, Derek. Yes, that was the problem. On Wed, Apr 10, 2013 at 11

Re: [GNC-dev] [GNC] USAA FSB requires newer QWIN support

2021-02-15 Thread Keith Bellairs
My USAA checking and credit card seem to be working. My users/0.conf is using this client UID: I got it from quicken's OFXlog.txt file. char clientUid="39E0E763-4E1E-4918-9528-D6EBAC94EF5D" Notably when the online action in GNC challenges for the account password the required response is

System error getting price quotes

2009-09-07 Thread Keith Bellairs
Fedora 10, gnucash 2.2.9 fc10-i386 distribution I was not able to get USD conversions so I casually ran gnc-fq-update to see if it had been patched. Now I get no price quotes at all. gnc-fq-update shows the following-- LWP is up to date (5.831). Date::Manip is up to date (5.54). HTML::Parser is u

Re: Save As MySQL is crashing gnucash

2010-11-26 Thread Keith Bellairs
Just did a save as into mysql with 2.3.17 on f14. that worked fine until I closed gnc and then tried to open it again. it now crashes every time with a seg fault i try to start gnc . It did tell me it could not get the lock and i told it to start anyway. crash comes before gui opens. downloading th

Re: Save As MySQL is crashing gnucash

2010-11-26 Thread Keith Bellairs
Here's the backtrace on my crashing gnc file. On Fri, Nov 26, 2010 at 8:23 AM, Keith Bellairs wrote: > Just did a save as into mysql with 2.3.17 on f14. that worked fine until I > closed gnc and then tried to open it again. it now crashes every time with a > seg fault i try to

Re: Save As MySQL is crashing gnucash

2010-11-26 Thread Keith Bellairs
ktrace shows it blew up in load_all_accounts. It did the select OK. kvp_frame_replace_slot_nc tries to do a hash table lookup, which then tries an illegal memory access. On Fri, Nov 26, 2010 at 10:23 AM, John Ralls wrote: > > On Nov 26, 2010, at 5:33 AM, Keith Bellairs wrote: >

2.4 postgres database issues

2010-12-21 Thread Keith Bellairs
using a new gnucash db created with r19971 in postgres a few odd things happen. 1. On reopening the db the following notices appear in the output in the command prompt window. Are these tables being receated every time? NOTICE: CREATE TABLE will create implicit sequence "recurrences_id_seq1" fo

Re: 2.4 postgres database issues

2010-12-21 Thread Keith Bellairs
Dec 21, 2010, at 9:59 AM, Keith Bellairs wrote: > > > Since these are not replicated, I'll start with a make clean before I do > anything else. > > > > On Tue, Dec 21, 2010 at 11:58 AM, John Ralls wrote: > > > > On Dec 21, 2010, at 7:23 AM, Keith Bellairs

Re: GDA save missing records

2008-02-18 Thread Keith Bellairs
Speaking as a user and not someone busting his butt on this, I hate the idea of "unlimited" everything when we go to a DB. Most of our databases have a mechanism (BLOB/CLOB) to store really big things, usually at the cost of indexing or searching (other than with special hacks -- Oracle Text, for e

Re: GDA: string lengths (was Re: GDA save missing records)

2008-02-18 Thread Keith Bellairs
I think that depends on the DB. Using VARCHAR at least gives the engine a chance to optimize storage. CHAR is good for truly fixed length strings. On Feb 18, 2008 3:56 PM, Graham Leggett <[EMAIL PROTECTED]> wrote: > Phil Longstaff wrote: > > > Well, as I originally said, I can use a TEXT type whi

import QSF?

2008-03-02 Thread Keith Bellairs
I did an export COA to QSF, then noticed that the import is not there. (Using a recent SVN build of trunk.) A quick search suggests that the import was turned off at the time of the 2.0 release. Is it dead? Should there be an export without an import? Or did I just happen into the middle of a work

Edit exchange rate regression

2008-03-26 Thread Keith Bellairs
In 2.2.4 I can no longer use the Edit Exchange Rate tool. GNC simply blows up and dies (seg fault in other words). It worked in 2.2.0 and 2.2.2. In the new version an attempt to use the tool in the simple ledger returns a prompt telling me: "You need to expand the transaction in order to modify it