QIF import does not work - SOLVED

[Henry De la Mano M.]

On 02/22/2014 04:30 PM, Art wrote:
> 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
>     ^
> _____
Thank you Art for your help, I used your sample as reference.

Finally, I solved it by removing whitespace at the beginning of each line.