Errors Importing QIF and CSV Files

Bob B. imthefunone at gmail.com
Fri Jul 10 14:49:05 EDT 2015


Thanks for the help, I did manage to get a stack trace. I had to dig around
the help menus a bit and add a "target exec" command, but I did get the
crash and a trace.

I'm working on submitting a bug report now.

Bob

On Fri, Jul 10, 2015 at 3:14 AM, Thomas Baumgart <thb at kmymoney.org> wrote:

> Hi,
>
> On Thursday 09 July 2015 21:22:28 Bob B. wrote:
>
> > Ok, I'm most of the way to the stack trace, but I need some help using
> GDB.
> >
> > I followed the instructions at the Stack_Trace Wiki and installed MingW
> and
> > GDB with apparent success. GDB runs as I think it should in the command
> > window.
> >
> > The instructions on the Stack_Trace Wiki say I should do three things:
> >
> >    1. In the cmd window type: set PATH=C:\Program Files\gdb\bin;%PATH%
> >    2. In the cmd window type: gdb "C:\Program Files\gnucash\bin\gnucash"
> >       1. I actually use "Program Files (x86) because that is where GNU
> cash
> >       sits
> >       2. I'm also on a 64 bit machine running gnucash from a x86
> directory.
> >       Does that matter?
> >    3. See below
> >
> > I do those things and get a gdb prompt. (I don't see gnu cash start. gdb
> > says it's reading symbols from gnucash, then says "done" and gives me
> back
> > the gdb prompt.)
>
> At this point type the "run" command in the gdb window to start the
> application. Once you hit the crash type the "bt" command here as well.
>
> > Then I do the third thing which is to run GnuCash and invoke the crash.
> > This might be where I go wrong because I do that from my  Windows desktop
> > icon and the gdb environment within the command window doesn't seem to
> > notice. I type the "bt" command in the gdb window after the cnucash crash
> > and just get "no stack" as the result.
>
> That won't work as you run things in a second process environment that does
> not know about the gdb you started in the first.
>
> > What am I doing wrong? I'm 99% there, I just can't figure out this last
> bit.
>
> See above. Hope that helps.
>
>
>
> > On Thu, Jul 9, 2015 at 9:35 AM, Derek Atkins <warlord at mit.edu> wrote:
> > > "Bob B." <imthefunone at gmail.com> writes:
> > > > Derek,
> > > >
> > > > I'm happy to help, but I don't know how to collect the crash dump or
> > >
> > > stack
> > >
> > > > trace. If you give me instructions and I'll work it out.
> > >
> > > See http://wiki.gnucash.org/wiki/Stack_Trace
> > >
> > > > I did download QIFs from a different credit card company and that one
> > >
> > > does
> > >
> > > > have "!Type:CCard" as it's first line. GnuCash imports that file just
> > >
> > > fine.
> > >
> > > Right.  The lack of the !Type is the issue for the failed import.
> > > Although not necessarily for the crash.
> > >
> > > > Bob
> > >
> > > -derek
> > >
> > > > On Wed, Jul 8, 2015 at 10:06 AM, Derek Atkins <warlord at mit.edu>
> wrote:
> > > >     Hi,
> > > >
> > > >     "Bob B." <imthefunone at gmail.com> writes:
> > > >     > Sure. The first thing in the file is two blank lines then the
> line
> > >
> > > with
> > >
> > > >     "C*"
> > > >
> > > >     > occurs.The last line is "^".
> > > >
> > > >     This is not a valid QIF.  Try pre-pending a line that says:
> > > !Type:Bank
> > >
> > > >     as the first line of the file.
> > > >
> > > >     > When I try to open this file, I arrive at a page with a Start
> > >
> > > button. I
> > >
> > > >     press
> > > >
> > > >     > it and get an error message saying "Line 3: File does not
> appear
> > >
> > > to be
> > >
> > > >     in QIF
> > > >
> > > >     > format: C* Read aborted.". Then GnuCash crashes.
> > > >     >
> > > >     > I'm using version 2.6.7 "built from git rev 757a50c+ on
> > > >     > 2015-06-29"
> > > >
> > > >     Hmm..  It definitely shouldn't crash.  Can you acquire a crash
> dump
> > > >     /
> > > >     stack trace and file a bug report?
> > > >
> > > >     The error message, however, is correct.  The file is not
> > >
> > > appropriately
> > >
> > > >     QIF enough for the importer because of the missing !Type line.
> > > >
> > > >     > Here is my file, line 3 is the C*:
> > > >     >
> > > >     > C*
> > > >     > D05/04/2015
> > > >     > NN/A
> > > >     > PWWW.CAREMARK.COM
> > > >     > T-105.00
> > > >     > ^
> > > >     > C*
> > > >     > D06/05/2015
> > > >     > NN/A
> > > >     > PPayment Thank You Image C
> > > >     > T1625.58
> > > >     > ^
> > > >     > C*
> > > >     > D05/19/2015
> > > >     > NN/A
> > > >     > PGOOGLE *Music
> > > >     > T-1.29
> > > >     > ^
> > > >
> > > >     -derek
> > > >
> > > >     > On Tue, Jul 7, 2015 at 2:41 PM, Derek Atkins <warlord at mit.edu>
> > >
> > > wrote:
> > > >     >     Hi,
> > > >     >
> > > >     >     Technically you ushould be asking this on gnucash-user, not
> > > >     >     gnucash-devel....
> > > >     >
> > > >     >     "Bob B." <imthefunone at gmail.com> writes:
> > > >     >     > If this is the wrong email list for asking this question,
> > >
> > > please
> > >
> > > >     direct
> > > >
> > > >     >     me
> > > >     >
> > > >     >     > to the right place.
> > > >     >     >
> > > >     >     > I'm trying to import credit card transactions I
> downloaded
> > >
> > > from my
> > >
> > > >     >     credit
> > > >     >
> > > >     >     > card's web site. I've tried both QIF and CSV formats and
> > >
> > > GnuCash
> > >
> > > >     tells
> > > >
> > > >     >     me
> > > >     >
> > > >     >     > there is an error in the file and then crashes.
> > > >     >     >
> > > >     >     > I've looked at the files in Notepad and they seem to be
> > >
> > > perfectly
> > >
> > > >     fine.
> > > >
> > > >     >     > They also seem to be structured the same way as QIF
> files I
> > > >
> > > >     successfully
> > > >
> > > >     >     > imported about 6 months ago.
> > > >     >     >
> > > >     >     > Can you tell me if this is a known bug or tell me what I
> > >
> > > need to
> > >
> > > >     do to
> > > >
> > > >     >     be
> > > >     >
> > > >     >     > able to import QIF or CSV files?
> > > >     >
> > > >     >     I'm surprised that GnuCash crashes.  It definitely
> shouldn't
> > > >     >     do
> > > >
> > > >     that;
> > > >
> > > >     >     that's definitely a bug.  As for the QIF file, can you post
> > > >     >     the
> > > >
> > > >     first
> > > >
> > > >     >     couple of lines of the file here?  The first line should
> begin
> > >
> > > with
> > >
> > > >     a !,
> > > >
> > > >     >     like !Type:Bank.
> > > >     >
> > > >     >     > OS: Win 7
> > > >     >     > GnuCash Version: 2.6.7
> > > >     >     >
> > > >     >     > Thank you,
> > > >     >     > Bob
> > > >     >     >
> > > >     >     > gnucash-devel at gnucash.org
> > > >     >
> > > >     >     -derek
> > > >     >     --
> > > >     >
> > > >     >            Derek Atkins, SB '93 MIT EE, SM '95 MIT Media
> > > >     >            Laboratory
> > > >     >            Member, MIT Student Information Processing Board
> > > >     >            (SIPB)
> > > >     >            URL: http://web.mit.edu/warlord/    PP-ASEL-IA
> > >
> > >  N1NWH
> > >
> > > >     >            warlord at MIT.EDU                        PGP key
> > >
> > > available
> > >
> > > >     --
> > > >
> > > >            Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> > > >            Member, MIT Student Information Processing Board  (SIPB)
> > > >            URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> > > >            warlord at MIT.EDU                        PGP key available
> > >
> > > --
> > >
> > >        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> > >        Member, MIT Student Information Processing Board  (SIPB)
> > >        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> > >        warlord at MIT.EDU                        PGP key available
> >
> > _______________________________________________
> > gnucash-devel mailing list
> > gnucash-devel at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> --
>
> Regards
>
> Thomas Baumgart
>
> GPG-FP: E55E D592 F45F 116B 8429   4F99 9C59 DB40 B75D D3BA
> -------------------------------------------------------------
> GDB has a 'break' feature; why doesn't it have 'fix' too?
> -------------------------------------------------------------
>


More information about the gnucash-devel mailing list