GnuCash - Loading Pre-downloaded Transactions

J S singhj at iprimus.com.au
Fri Sep 14 01:12:42 EDT 2007


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GnuCash-Import-3.GIF
Type: image/gif
Size: 36070 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20070914/ce502040/attachment-0002.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GnuCash-Import-4.GIF
Type: image/gif
Size: 29941 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20070914/ce502040/attachment-0003.gif 


More information about the gnucash-user mailing list