Importing QIF files

Derek Atkins derek at ihtfp.com
Thu Feb 5 13:10:48 EST 2015


HI,

On Thu, February 5, 2015 12:35 pm, Mark Wigmore wrote:
> Here's a screenshot of the last few entries from the first pass of the
> importer.
>
> Nearly everything above that is of the first type, unrecognised
> reconciliation status.

That means you have empty C lines.  It defaults to unreconciled.  The
unrecognized action field is the empty N lines.

> Yes, seems to be specifying the type of account:
>
> !Account
> NBarnsley
> DBarnsley Building Society
> TBank
> ^
>
> Let me know if you need anything else.

Yeah, this is a reasonable account definition.

> Mark

-derek

> On 5 February 2015 at 17:16, Derek Atkins <warlord at mit.edu> wrote:
>
>> Hi,
>>
>> Mark Wigmore <mawigmore at gmail.com> writes:
>>
>> > On 4 February 2015 at 14:29, Derek Atkins <warlord at mit.edu> wrote:
>> >
>> >     I understand you're unwilling to do that, but honestly, it's not
>> that
>> >     hard to do something like:
>> >
>> >     grep '^N$' file.qif
>> >
>> >
>> > I get 2369 matches! The first in investments is this on line 21301:
>> >
>> > !Type:Invst
>> > D01/01/1970
>> > T3612.25CX
>> > N
>> > POpening Balance
>> > M
>> > L[Start Balance]
>> > ^
>>
>> Aha!!  The "CX" is wrong in the T line, and is probably what's causing
>> the issue here.  I guess my regex didn't look for non-numerics at the
>> end of the string, which would have brought this up.
>>
>> Is CX supposed to be a currency?  Or a stock?  I'm not sure.  Either
>> way, this is why the number format cannot be parsed by the importer.
>>
>> >     egrep '^T[^-0-9]' file.qif
>> >
>> > 101 matches, but they all have T followed by text, TBank, TInvst, etc.
>> I'm
>> > afraid I'm not familiar enough with these searches to look further.
>>
>> For these I'd have to see the context around these items to understand
>> what it is.  My guess is that it's within the Account List, specifying
>> the Account Type.  I don't see any invalid types here, so that's not an
>> issue.
>>
>> Assuming you haven't completely given up yet, could you remind me the
>> actual QIF import error(s) you were getting?
>>
>> > Mark
>> [snip]
>>
>> -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                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list