All transactions from QIF import listed as unspecified ... me too

[Charles Day]

On Mon, Aug 18, 2008 at 10:14 PM, susie <goddens at gmail.com> wrote:

> I am new to Gnucash and have installed 2.2.5. I am experiencing the
> same problem as Austin.  Here is an example of the QIF file I've
> downloaded
>
> !Type:Bank
> D28/06/08
> T-35.00
> PRETAIL PURCHASE AMNESTY INTERNATI1,CHIPPENDALE 2606 AUD000000003500
> ^
> D26/06/08
> T-2713.30
> PRETAIL PURCHASE PRINTZ PLUMBING, MAINE 1906 AUD000000271330
> ^
> D25/06/08
> T-105.25
> PRETAIL PURCHASE COLES, LIS 2406 AUD000000010525
> ^
>
> I am not sure how the matching process works .. in some of the files I
> tested I deleted the 'RETAIL PURCHASE' before importing, would that
> making a difference or would it be able to pick up the Payees name with
> our without the standard retail purchase bit?
>

Unfortunately the QIF importer doesn't look for anything but exact matches
to what you've mapped before. If the problem is due to your bank/credit card
company making the payee unique every time, then you could just edit the
field down to the non-unique part. For example, change "PRETAIL PURCHASE
COLES, LIS 2406 AUD000000010525" to simply "PCOLES". Or, at a minimum, get
rid for the last word (AUD000...).

If the pattern is pretty regular, you could automate the edit with a script
or sed command. For example:

$ sed -e 's/^P[^ ]* [^ ]* /P/ ; s/ AUD[0-9]*$//' test.qif
!Type:Bank
D28/06/08
T-35.00
PAMNESTY INTERNATI1,CHIPPENDALE 2606
^
D26/06/08
T-2713.30
PPRINTZ PLUMBING, MAINE 1906
^
D25/06/08
T-105.25
PCOLES, LIS 2406
^


> Hope I am making sense, and I look forward to hearing more
> susie
>

-Charles