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