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