Errors Importing QIF and CSV Files
Derek Atkins
warlord at MIT.EDU
Wed Jul 8 10:06:45 EDT 2015
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