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