import problems

Roderick Averill rod.averill.pa at gmail.com
Wed Jul 5 13:07:05 EDT 2017


Thanks for the prompt response.
The name of the file is: FirstbankDownload1498612569999.qif
I was never given a choice to map the file.
There was not a new top level account.

I figured out that the QIF file would import if I changed the !Type from "!Type:Cash in Bank - 1st Bank 5343" to "!Type:Bank". Then it load and allow me to match it up with an existing account.

The csv import crashing occurs on this version of Gnucash:



> On Jul 5, 2017, at 10:53 AM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> Hi,
> 
> On Wed, July 5, 2017 12:35 pm, Roderick Averill wrote:
>> I'm trying to import data from my bank. I've tried both QIF format and csv
>> format.
>> 
>> The QIF file is !Type:Bank and it appears to process fine, but I cannot
>> find the data in my journal.
> 
> Okay, a few questions:
> 
> 0) I'm assuming you went through the full import and it gave you a bunch
> of questions along the way which you answered, and then finished the
> import?
> 1) What's the file name of the qif file (e.g. Foo.qif)?
> 2) During the QIF import, to what GnuCash account do you map the QIF
> Account "Foo" (where "Foo" is the name from #1)?
> 3) Assuming you did not map "Foo", do you see a top-level account named
> "Foo" in your chart of accounts?
> 
>> I then tried a csv file, but after adding column names, and importing,
>> gnucash crashes!!!!
> 
> What version of GnuCash?  It shouldn't crash, so any crasher is a bug.
> 
>> I'm running on a macbook.
>> 
>> I'm a new user, so I needs some help in debugging this import problem I'm
>> having..
>> 
>> Thanks
>> 
>> Snippet of qif file:
>> !Type:Cash in Bank - 1st Bank 5343
>> D05/01/2017
>> T88.5-
>> NVISA
>> PVISA KING SOOPERS 6000 S. HOLL GREENWOOD VIL CO ON 04-30 5102
>> ^
> 
> Is this actually the QIF?  I don't think the " in Bank - 1st Bank 5343" is
> allowed, so the importer might not like that.  But I could be wrong.
> 
>> First row of csv file:
>> 5/1/17	VISA KING SOOPERS 6000 S. HOLL GREENWOOD VIL CO ON 04-30
>> 5102	VISA	-88.5
> 
>> 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