qif import: no duplicates matched

Derek Atkins warlord at MIT.EDU
Mon Jun 16 11:01:02 CDT 2003


Hi,

I just tried this and it works just fine for me.  I created three
qif files, Checking.qif, Savings.qif, and Citibank.qif, and filled
in the three snippets below.  I then ran the importer three times,
once for each file.

- I loaded in Checking.qif.
- I then matches the two "Payee/Memo" strings with appropriate
  GnuCash Accounts:
  * T'FER FROM 1111S1           ->    Savings
  * CITIBANK-AUTOPAY/PAYMENT/   ->    Citibank
- I then went back and modified the new account types, because it created
  and income and expense account instead of a credit-card and bank account.
- I then loaded the Savings.qif file
- I matched the one Payee/Memo string with the appropriate account:
  * T'FER TO 1111S5             ->    Checking
- It then gave me a list of potential duplicate transactions (all one
  of them).

I just tested it again, and even WITHOUT fixing the account types
it works just fine for me..  I get a "Select possible duplicates"
page, and it asks me to select them.

I've tested this with both CVS HEAD and CVS-1.8 (I don't have a
released 1.8.4 around, but CVS-1.8 should be close enough in this
respect -- nothing has changed in the importer).

So, I don't know what to tell you..  I cannot reproduce your problem.

-derek

bri <bhh_mail at mail.com> writes:

> I imported at seperate times a qif from my bank for my checking
> account, savings account, and credit cards. There are several
> transactions in each that are transfers back and forth. Yet the
> imported didn't flag any as duplicates, so I ended up with a good
> number of them.
> 
> What are my options? I guess my only option now is to go thru and
> delete the dups by hand, right? What about in the future? Is there
> anyway that I can make it recognize the dup's better? Should/can I
> edit the .qif's somehow before importing them so that it recognizes
> them better? Or would dups get detected better if I imported the
> .qif's at the same time? or..? (I haven't tried it, but would gnucash
> like it better if the bank qif's had "transfer" instead of "t'fer"?)
> Should I rename my accounts so that they have the same name (ie,
> 1111S1) as in the .qif?
> 
> Using 1.8.4 on RH8.0. Here are some bits from the .qif's that are dups
> that didn't get recognized as dups:
> 
> Checking.qif: (1111S5 account)
> D02/26/2003
> PT'FER FROM 1111S1
> N
> T52.00
> L
> ^
> D02/26/2003
> PCITIBANK-AUTOPAY/PAYMENT/
> N
> T-1851.58
> L
> ^
> 
> Savings.qif (1111S1 account)
> D02/26/2003
> PT'FER TO 1111S5
> N
> T-52.00
> L
> ^
> 
> Citibank Credit Card.qif:
> D02/26/2003
> T1851.58
> PAUTOPAY 000000000004571RAUTOPAY AUTO-PMT
> M
> ^
> 
> 
> thx!!!
> 
> .bri.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at lists.gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list