[GNC] Fw: Import qif does not remember account allocation.

[DIW]

Begin forwarded message:

Date: Sat, 29 Dec 2018 10:48:25 +1100
From: DIW <wasserland44 at gmail.com>
To: Derek Atkins <warlord at MIT.EDU>
Cc: John Ralls <jralls at ceridwen.fremont.ca.us>, gnucash-user at gnucash.org
Subject: Re: [GNC] Import qif does not remember account allocation.


On Mon, 03 Dec 2018 19:13:53 -0500
Derek Atkins <warlord at MIT.EDU> wrote:

> Hi,
> 
> John Ralls <jralls at ceridwen.fremont.ca.us> writes:
>   
> >> On Dec 3, 2018, at 6:06 AM, David wasserman
> >> <wasserland44 at gmail.com> wrote:
> >> 
> >> Running Ubuntu 18.04.  GNC version 2.6.19.
> >> 
> >> Whereas GNC remembers previous account allocation on my Mastercard.
> >> Importing from my recently new AMEX credit card, the system doesn't
> >> remember the account allocation even for exactly the same
> >> transaction multiple times previously booked.
> >> 
> >> How to fix, please?    
> >
> > Keep importing. It takes several runs of the importer to build up
> > enough matching data to generate matches, and it’s runs of the
> > matcher that matter, not the number of transactions in an
> > import.    
> 
> Keep in mind that the QIF importer matches on FULL LINES.  If there is
> even a single character different in the Payee or Memo then the QIF
> importer will consider it different.
>   
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.    
> 
> -derek  


Ongoing . . . . . 

I have now been through 8 monthly iterations of my newer Amex qif
importations.  Still no auto account allocation generation as
suggested will eventually occur. (Yet my long-term Mastercard
account .qif downloads continue to import and allocate correctly.)

In my frenetic searching, I find this file: /.gnucash/qif-accounts-map.
It seems to be the memory source of previous transaction.  It's a long
file that obviously has followed me over the years.  In it I recognise
that, typically, the Mastercard allocations Line Description has
the correct account allocation recorded.  

So I searched a recent Amex transaction that has twice previously been
manually corrected from "Unspecified" to it's correct Expense account
yet this is what is recorded inter alia:
("ROMEO S FOODHALL SUTHER SUTHERLAND" "ROMEO S FOODHALL SUTHER
SUTHERLAND" (9 8 0 3 4 2 11 12 5 6) #f "Unspecified" #f #t).

Sorry about the long preamble. ):

*1. Once designated "Unspecified" how/when, and by what means, does the
correct allocation be recorded?
*2. Is there a difference between manual correction while in QIF
Download mode and after Import has been completed?
*3. What do the numerals and #'s mean?
*4. Shall I upload the said qif-accounts-map file for you?

Dave W