[GNC] Import qif does not remember account allocation.

DIW wasserland44 at gmail.com
Fri Dec 28 18:51:30 EST 2018


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



More information about the gnucash-user mailing list