GnuCash - Loading Pre-downloaded Transactions

[Derek Atkins]

Well, are you sure there are any QIF accounts in the QIF file?

-derek

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

> Derek
>
> Thanks for the feedback but ?.
>
>
> Yes I do that & I have had been able to Import the Sav file, plus two 
> other such files!! So come next day & I want to import another QIF 
> file into another account & it is just not possible.
>
> Now I find it very hard to trace what I did right for the SAV file & 
> it appears that this Import function is very temperamental for some 
> reason or other.
>
> So, once I am in the popup or druid 'Select a QIF to Load':
> 1.	I click Select and get the next druid
> 2.	'Select a QIF File' and here either I double click on the QIF file 
> which takes me to next druid or I single click & then click 'Import' 
> makes no difference to the outcome. Refer attachment GnuCash-Import-3.
> 3.
> 4.	I then get next druid 'QIF Files You have loaded' and click 
> forward.  I get a informational druid, click forward & then I get:
> 5.	Next druid 'Match QIF Accounts with GnuCash Accounts' which is 
> blank,  refer attachment GnuCash-Import-4.
> 6.
>
> This is where I am basically struggling to get the sequence right & 
> absolutely not sure why it worked fine the previous day with one lot 
> of files but not today??
>
> I will try a bit more & see what happens.  Hopefully one of you can 
> nail it down as what is wrong in my process to Import QIF!
>
> Regards
>
> John Singh
>
>
> -----Original Message-----
> From: Derek Atkins [mailto:warlord at MIT.EDU]
> Sent: Tuesday, 11 September 2007 10:11 PM
> To: J S
> Cc: 'Josh Sled'; 'Singh, John'; gnucash-user at lists.gnucash.org
> Subject: RE: GnuCash - Loading Pre-downloaded Transactions
>
> When you browse to the directory where the two .QIF files are located,
> do you actually select the Sav-Aug07.qif file??  All you say that you
> do is:
>
>> 2.  I then go to directory where Sav-Aug07 is stored & click Import
>
> But that's not sufficient; you also need to "select Sav-Aug07" and THEN
> click Import..  Are you doing that?  Your other option, I BELIEVE, is
> that you could double-click on the Sav-Aug07 file.
>
> -derek
>
> Quoting J S <singhj at iprimus.com.au>:
>
>> Hello
>>
>>
>>
>> Thanks for responding & here are more details, first 3 lines are repeated,
>> then I am sowing the step by step popup screens I get.
>>
>>
>>
>> I have used File -> Import -> to prime the Savings & Credit Accounts with
>> July 07 data.
>>
>>
>>
>> I now want to import August 07 data for same accounts downloaded from the
>> Bank in QIF format.
>>
>>
>>
>> The July 07 file in my C:\ directory is called Sav-Jul07.qif and August data
>> file is stored as Sav-aug07.qif.
>>
>>
>>
>> So I want to import this Sav-aug07.qif into my GnuCash Savings Account.
>>
>>
>>
>> So it is File -> Import -> Import QIF:
>>
>> 1.  I get this QIF Info Panel and I click Forward
>>
>> 2.  I then go to directory where Sav-Aug07 is stored & click Import
>>
>> 3.  I get another popup "QIF Files I have Loaded" & click Forward
>>
>> 4.  I get another popup 'Account & stock holdings', I click forward
>>
>> 5.  I then get a 'Match QIF accounts with GnuCash Accounts' ++++ basically a
>> blank popup with Headings, refer attach GnuCash-Import-1 & I click Forward
>>
>> 6.  Then I get 'Income & Expense categories' & I click Forward
>>
>> 7.  Then I get same as in Step 5 above, I click Forward
>>
>> 8.  Then I get 'Payees and Memos' popup & I click Forward
>>
>> 9.  Then I get 'Match payees/memos to GnuCash accounts' === basically a
>> blank with headings & I click Forward
>>
>> 10.Then I get 'Match duplicated transactions' & I click Forward
>>
>> 11.Then I get 'Select possible duplicates' popup ++++ basically showing me
>> the July 07 transactions already loaded +++ Refer attached GnuCash-Import-2.
>>
>>
>>
>> Finally, the Sav-Aug07 QIF file, the first record is '!Type:Bank' and then
>> on new line followed by D31/08/07 (a DD/MM/YY) formatted date field, etc.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> -----Original Message-----
>> From: Josh Sled [mailto:jsled at asynchronous.org]
>> Sent: Monday, 10 September 2007 11:46 PM
>> To: Singh, John
>> Cc: gnucash-user at lists.gnucash.org; singhj at iprimus.com.au
>> Subject: Re: GnuCash - Loading Pre-downloaded Transactions
>>
>>
>>
>> "Singh, John" <John.Singh at anz.com> writes:
>>
>>> I have just installed the GNUCASH on Windows XP & I have been able to
>>
>>> set/create my Chart of Accounts.
>>
>>
>>
>> It's just GnuCash.  There's no need for all caps.
>>
>>
>>
>>
>>
>>> I can 'import' a QIF format file into my accounts & this is only for
>>
>>> one time event (this was for July 07 transactions)..
>>
>>>
>>
>>> I now find that I cannot load my new transactions into GNUCASH
>>
>>> downloaded from my Bank accounts for the month of Aug 07.
>>
>>
>>
>> Details, please ... what happens when you attempt to load the Aug QIF file?
>>
>> If you create a clean/new file and load (only) the same Aug QIF file, does
>> that work?
>>
>>
>>
>> --
>>
>> ...jsled
>>
>> http://asynchronous.org/ - a=jsled; b=asynchronous.org; echo ${a}@${b}
>>
>>
>
>
>
> --
>       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