GnuCash - Loading Pre-downloaded Transactions

[Derek Atkins]

Quoting J S <singhj at iprimus.com.au>:

> Derek
>
> Thanks .. I will maintain my sense of humor here.  I know I maybe a pain but
> facts are facts.  I have had a read of the QIF format but will revisit it
> again, but let me state my position again.

Good... Humor is a good thing to keep, and makes conversations
much less threatening, and hopefully a little more fun.  I'm sure
it can be very frustrating when it appears that something isn't working
and you spend hours and days trying to get it to work.  Trust me, I
know!  :-D

> The QIF files I have are NOT direct unloads from Quicken application.  As I
> said, they are unloaded from my Bank which gives an option for QIF & other
> formats, like CSV or Microsoft Money.  All the files I have unloaded from
> the Bank has !Type:Bank, even for Credit Card.  The Bank does not know if I
> use Quicken or GnuCash or some other accounting application, it only gives
> me an option to unload my transactions in various formats.

Yes, I understand that.  You're downloading files from a bank, which
implies that you're NOT going to have any !Account entries in your
QIF file.  So unless your QIF contains any L[Acct] entries you wont
have ANY QIF Account fields in your downloaded QIF.  This is normal.

> Now to your last paragraph, I have NOT been a deer, I have been to the end
> of QIF import session, many times, but just did not 'apply' BECAUSE GnuCash
> did not indicate into which account it will apply the transactions. Well in
> fact I just did 'apply' & guess what ... I do not know where GnuCash has
> applied those transactions ....  I have checked each account & there is no
> trace of them!  Explain that to me!!

Well, you certainly didn't say that.  Your messages always ended with
the empty Qif Account window.  This is why I tend to ask for step by
step instructions; they are more precise and less verbose.

The importer assumes that the name of the file is the "account" into
which you want to record your data.  So if the file is named "foo.qif"
then it will assume you're loading into account "foo".  The importer
SHOULD give you the option to map "foo" to some gnucash account.

> As I stated before I have had no issues loading the same QIF files that were
> unloaded from my BANK with July 07 transactions, why GnuCash cannot import
> transactions for August 07? Why the rule is different for August
> transactions??

I dont know?  Send me the two QIF files and I'll take a look?

> The 70% failure to import QIF files for August transactions is perhaps 90%,
> I have not tried the Visa QIF file as yet, all the rest disappears into some
> void when 'apply' is clicked.

90% of what?  What does "70% failure" or "90% failure" mean?  Those
numbers mean nothing to me!  Do you mean that out of 10 transaction in
the file the importer only sees 3 of them?  Or it only gets three of them
correct?  Or...???

> I will send you a screenshot of each of the steps I take, if that helps, but
> as I said I will read the QIF format BUT I hampered as I have no control
> over that format .. al I can do is discuss with my Bank that the QIF format
> is potentially wrong BUT I need evidence as I can happily load same QIF
> format files into another accounting application with no issues!!

I dont care about screenshots.  I know what the screen looks like.  I
dont need to see it again.  I need to see the data you're attempting to
feed it.

-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