Errors Importing QIF and CSV Files
Derek Atkins
warlord at MIT.EDU
Thu Jul 9 09:35:41 EDT 2015
"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