Errors Importing QIF and CSV Files
Bob B.
imthefunone at gmail.com
Fri Jul 10 16:01:59 EDT 2015
I submitted bug report *Bug 752249
<https://bugzilla.gnome.org/show_bug.cgi?id=752249>*
Bob
On Fri, Jul 10, 2015 at 2:49 PM, Bob B. <imthefunone at gmail.com> wrote:
> 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