QIF import does not work

Art pinaart at yahoo.com
Sat Feb 22 16:00:35 EST 2014


I've successfully imported QIF in previous versions of GC. The last one I did was in GC v2.6.0 built on 2013-12-29. My QIF file was formatted as follows, with some of the data at the end redacted with ellipses,

   !Type:CCard
  D01/26/2014
  N      760...
  T-44.26
  PPURCHASE
  MAPRO #49                 MEN...
  ^
  D02/07/2014
  N      F62...
  T555.0
  PAUTOMATIC PAYMENT - THANK YOU
  MAUTOMATIC PAYMENT - THANK YOU

The QIF file was in Unix format. I'm on Windows 7 Professional 64-bit, Region and Language (Locale) format: English (United States) with Short date: M/d/yyyy.
I found an older QIF file in DOS format and just imported that one too. It asked for locale information and bank matching and took the data - unfortunately all of the transactions were already in my database, so I wound up with duplicates which I was prepared to deal with. This one was formated,
  !Type:Bank
  D04/08/2013
  T-445.99
  NE-PMT
  PSAM'S ...
  APO BOX 960013
  AORLANDO
  AFL
  A328...
  ^
I am running MySQL for the back-end, but this should not matter as I've run XML in the past and never noticed any import/export issues related to the back-end (intuitively, they're independent).
- Art


On Saturday, February 22, 2014 10:14 AM, Henry De la Mano M. <henrydelamano at yahoo.es> wrote:
 
The import function doesn't work with .QIF files, probably It has a Bug, 
because nothing happend after imported.

Gnucash version 2.4.10
Sample QIF file:
!Type:Bank
     D2014/02/03
     MND- CONSUMO TARJETA LLAVE MERCANTIL MAESTRO NAC.
     N98200938464
     T-170.00
     ^
D2014/02/05
     MND- CONSUMO TARJETA DE PAGO ABRA 24
     N75002073431
     T-93.48
     ^
D2014/02/06
     MND- CONSUMO TARJETA DE PAGO ABRA 24
     N75002335993
     T-386.00
     ^
D2014/02/06
     MND- RETIRO CAJERO AUTOMATICO ABRA-24
     N63009632371
     T-500.00
     ^
D2014/02/20
     MNC- PAGO A TERCEROS VIA INTERNET
     N25577553110
     T600.00
     ^
D2014/02/21
     MND- CONSUMO TARJETA LLAVE MERCANTIL MAESTRO NAC.
     N98200938464
     T-244.39
     ^
D2014/02/21
     MNC- PAGO A TERCEROS VIA INTERNET
     N25568794260
     T360.00
     ^
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list