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