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