QIF Record and field layouts

[Tom Bullock]

Hi Rick,

Since you wrote your thoughts below, I have been reading the references 
you and others gave me.  Coming back at you with thoughts interspersed 
into your message below.

Rick Rogers wrote:
> Tom: These are Excel and Calc macros that you add on. They appear to be
> written by the same person. I can only relate my satisfaction with the
> OO Calc one. I have used it several times (including a few minutes ago)
> with no problems using Vista.
>
> The data I converted with the macro was almost two years of checking
> account history downloaded from my bank that  I brought into Calc. I
> used Calc to assign each transaction to various category and
> sub-categories for the lowest levels of my chart of accounts. The author
> has a short but adequate help file showing a sample column layout. 
It sounds like you are describing a lot of hand tweaking transaction by 
transaction once the bank data was placed in the Calc spreadsheet.  Is 
that correct?  I expect that the data you received from your bank was 
close in field formatting and sequencing one to the other so that you 
were fairly close to the QIF arrangement.  Correct?
> I
> have not attempted to import splits, however it appears able to do this.
>
> I tested it first with a small segment of the data I wanted to import. I
> set GnuCash to not automatically save the file periodically, (I always
> do this before importing) so I can just close it if I have created
> problems and restart to where I was before the import. You can convert
> and import as many segments as you want. It doesn't have to be all at once.
>   
Importing in batches seems reasonable.  Would a batch consist of all of 
one type of transaction from the input side?  Or is a batch governed by 
what QIF needs for its information?

TIA for your thoughts.

Tom
> Hope this helps, Rick
>
>
> Tax Assistance Program - ( taptax ) wrote:
>   
>> Rick,
>>
>> Are you saying that XL2QIF should work using Excel because a different program worked using Open Office Calc?  Do I have your meaning?
>>
>> Tom
>>
>> -----Original Message-----
>> From: Rick Rogers [mailto:rrogers at rcn.com]
>> Sent: Monday, April 20, 2009 1:50 PM
>> To: sunfish62 at yahoo.com
>> Cc: gnucash-user at gnucash.org; Tax Assistance Program - ( taptax )
>> Subject: Re: QIF Record and field layouts
>>
>> Regarding XL2QIF, I had complete success with their counterpart for Open
>> Office Calc. They also have some links to QIF file format references.
>>
>>     
>>