Trouble Importing QIF to Gnucash 2.4.8

Bruce Perryman bperryman_us at yahoo.com
Wed Jan 11 19:32:47 EST 2012


<Quote>
Well, it depends what account the transactions are for.  The !Type
description tells the QIF parser how to interpret the transactions. 
Options include !Type:Bank, !Type:CCard, and many others.

Most likely it should be !Type:Bank, but really it does depend on what
kind of transactions you are importing.
</Quote>

I'm not sure that I am getting the same functionality that I desire. The Financial management software that I've been using captures may sources of income and categorizes and sub-categorizes them for import into a quicken file via .qifs. For example, the following .qif:
D01/01/2012
T10.00
NDEP
PCat1
LCat1
MCat1
^^
D01/01/2012
T1628.00
NDEP
PCat2
LCat2
MCat2
^^
D01/01/2012
T17.00
NDEP
PCat3
LCat3
MCat3
Imports the data into the account that I have opened in the Payee, Category, and Memo fields respectively. When I first tried to import, because of the missing type statement, it displayed an error. When I place a !Type statement, it doesn't display an error, but it doesn't import any data into any accounts. When the screen comes up to match the fields, all fields are blank and there is nothing to match. Something is not connecting.

I need to understand the process a little better. Thanks again.


________________________________
 From: Derek Atkins <derek at ihtfp.com>
To: bper <bperryman_us at yahoo.com> 
Cc: gnucash-user at gnucash.org 
Sent: Wednesday, January 11, 2012 7:09 PM
Subject: Re: Trouble Importing QIF to Gnucash 2.4.8
 
Hi,

On Wed, January 11, 2012 4:39 pm, bper wrote:
> Wow! Thanks for the quick response!

You're welcome..

> Derek Atkins-3 wrote
>>
>> The first line of a QIF file is supposed to be a "!Type" line, such as
>> !Type:Bank or !Type:Account or something else.  If the first line is a
>> Date Line (D01/01/2012) then yes, the file is technically malformed.
>> Just
>> add a !Type:Bank as the first line of the file (assuming it's a set
>> transactions from of bank account).
>>
>
> This file was not generated from a bank, but it was generated from
> transactions from the financial package that I mentioned. Is there a
> specific "!Type' specification that I should use? I guess I will have to
> manually add these lines all the time with this version of the financial
> package before importing into gnucash?

Well, it depends what account the transactions are for.  The !Type
description tells the QIF parser how to interpret the transactions. 
Options include !Type:Bank, !Type:CCard, and many others.

Most likely it should be !Type:Bank, but really it does depend on what
kind of transactions you are importing.

> Thanks in advance for your help.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
      derek at ihtfp.com            www.ihtfp.com
       Computer and Internet Security Consultant


More information about the gnucash-user mailing list