Importing CSV files

Derek Atkins derek at ihtfp.com
Fri Jul 13 17:16:01 EDT 2012


Hi,

On Fri, July 13, 2012 4:34 pm, Richard Thomas wrote:
>>> My bank gives the option of CSV or QIF file formats.
>>>
>>> I had tried the QIF file format and the GNUCash GUI had lots of
>>> clicks and selections to do the importing I need.
>>
>>However, it remembers those settings, so you import all the stuff
>>slowly once and then speedily afterwards.
>
> Hi,
>
> I gave the QIF format import a go and had a few hickups.
>
>
> The imported transactions appeard in GNUCash as "n" and not "c"
>
> Is there a way to make GNUCash import the transactions as cleared?

Is the QIF Txn marked as cleared in the QIF?  "C"

>
> Also, my bank does not populate the  Transaction Type field, which I want
> to appear in GNUCash as "num"
>
> Does the QIF format support a field that GNUCash would import into the
> "num" field.

Yes, of course it does.  "N"

>
>
> Thanks,
>
> Richard.

> 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