OFX Bayesian import not working for me

[John Ralls]

On Aug 18, 2014, at 9:21 PM, Eliot Rosenbloom <eliot at prosocialleadership.net> wrote:

> HEY --  Possible success!   I just updated gnucash to 2.6.3, and -- in an infrequently used set of books -- 1 out of 1 xns WERE successfully assigned!  :-) 
> 
> Transactions done using v 2.4.13  (for June and July) did NOT produce assignment for August xns I just imported.  But I am hoping those August xns just assigned manually  (using 2.6.3) will produce assignment henceforth.  I'm inclined not to post to the whole list until more info/data is in (unless you'd prefer otherwise), but I wanted to let you know.
> 
> Also: Here is the link to the earlier part of this thread.  I can post it to the whole list, if that would be helpful.  Sorry about the posts getting separated.
> 
> http://gnucash.1415818.n4.nabble.com/OFX-Bayesian-import-not-working-for-me-td4664949.html#none
> 

Eliot,

We generally prefer otherwise, so please go back to the list once Derek gets his router replaced (today, we hope).

I t seems unlikely to me that upgrading to 2.6 would change anything about Bayesian matching, and 1 transaction isn't really a useful sample. I don't think that the screenshots would be helpful, but examining the account file might be. If you can send me that plus the backups from before you did each of the June and July imports I can compare the data stored in the Bayesian matching tree and perhaps find a clue about what's going wrong. Don't send *that* to the list.

Regards,
John Ralls


On 8/18/14, 4:22 PM, Eliot Rosenbloom wrote:
>> Hey -  I have just completed 2 more month-ends: June and July.  I did them separately, to allow learning to happen.  Only about 3 transactions were properly assigned prior to hitting import; ie, I had to assign almost all by hand.  Ie, they were almost all orange, in spite of many similar transactions between months.
>> 
>> I looked for the files, you mentioned, John, both currently and in Time Machine backups from April, when I'm pretty sure it was working.  Results:
>> 
>> No  ~/.aqbanking  file in either case.  (I did enable Show invisible files).
>> No plist file in either case.
>> AppSpt/GnuCash folder -- It WAS found among my current files (8/16) & on a 5/26 backup.   Looking quickly, they both seemed to have the same contents.
>>     It was NOT found in the 4/21 Backup.  I had RECREATED my Home folder (a new account per Apple's instructions on 4/18; and 4/21 may have been before I opened gnucash for the first time thereafter.  I imagine GC may recreate the folder it it doesn't find it.)  
>> 
>> I took some screen shots of the Import windows before and after manual assignment in June and July.  Given that they have somewhat personal data I'd prefer, to send them to a couple of people rather than to the whole list / internet, assuming they might be helpful.
>> 
>> Obviously, if I could get the Baysian matching to work again, that would be a huge time savings!  Really appreciate any suggestions you might have.
>> 
>> Eliot
>> 
>> FWIW: I remain pretty foggy about the Preference thresholds -- eg, are they thresholds for matching for assignment purposes, or for non-duplication of transactions already entered into the register.  I'm also foggy about the colored bars and the A, U+R, whatever, columns in the Import Window.
>> 
>> It just occurred to that, although my new account does not have permissions (and could not get them via the "GetInfo" window) to view my TM backups prior to 4/21, I think I may still be able to use my old account to view the older backups.  I will try to look for the files and folder you mentioned (in backups pre 4/21) if you think that might be of value.  [Ed:  I just tried. Probably would be quite hard, since many files were MOVED to the new account, I think, not copied.  I couldn't even log in.  It hung.]
>> 
>> 
>> =========
>> On 7/24/14, 2:40 AM, John Ralls wrote:
>>> On Jul 24, 2014, at 5:02 AM, Eliot Rosenbloom <eliot at prosocialleadership.net> wrote:
>>> 
>>>> Thanks, John.  Not that I'm aware of.  I futzed around a little with MAMP in the last few months, but not in connection with GC.  And I use Filemaker a lot (installed v 13 in April).  But that's as close as I get to SQL.
>>>> 
>>>> In April, because of a problem with Mac's Calendar app that Apple couldn't fix, they had me create completely anew my daily (non-admin) account, and then transfer from the old account as little as possible (so as not to bring the problem with me).  I spent 2 or 3 days recreating settings and the like.  Might some GC file (perhaps in one of the libraries) not have been copied to the new account and be causing my problem?
>>>> 
>>>> I thumbed thru all the GC Preferences, and nothing jumped out at me (tho I don't understand them all).  (I didn't see anything re: choosing XML or SQL).
>>>> 
>>>> I'm not sure, or have only a general sense of, what you are referring to re: "account associations or file backend."
>>>> 
>>>> (I'd have responded sooner, but my GnuCash Thunderbird folder got nested, and I didn't check my web posting and see your response untill just now.)
>>>> 
>>> Please remember to copy the list on all replies by using "reply all" (the double-arrow).
>>> 
>>> The backend is selected when you save the file the first time, at the top of the save dialog. Since you didn't know that, you're probably using the XML backend and have been right along.
>>> 
>>> All of GC itself is in GnuCash.app, but its preferences are in ~/Library/Preferences/org.gnucash.Gnucash.plist, other things it keeps track of are in ~/Library/Application Support/Gnucash, and if you're using online banking that's in ~/.aqbanking. I don't think that any of that would have any impact on Bayesian matching, which is all kept in the data file, though I suppose if you had to recreate aqbanking accounts you'd also have to re-associate them with GnuCash accounts and that might invalidate the old Bayesian keys.
>>> 
>>> Regards,
>>> John Ralls
>>>