Errors Importing QIF and CSV Files

Bob B. imthefunone at gmail.com
Thu Jul 9 21:22:28 EDT 2015


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.)

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.

What am I doing wrong? I'm 99% there, I just can't figure out this last bit.

Bob


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
>


More information about the gnucash-devel mailing list