Errors Importing QIF and CSV Files

Bob B. imthefunone at gmail.com
Wed Jul 8 18:13:35 EDT 2015


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.

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.

Bob

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
>


More information about the gnucash-devel mailing list