Errors Importing QIF and CSV Files
Thomas Baumgart
thb at kmymoney.org
Fri Jul 10 03:14:46 EDT 2015
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?
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 225 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20150710/899010a0/attachment.sig>
More information about the gnucash-devel
mailing list