QIF Record and field layouts

[Tax Assistance Program - ( taptax )]

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.

David T. wrote:
> Removing devel list, as this isn't a developer question.
>
> This has been tackled by others, so before you put in a great deal of effort, you might search out some of the CSV (or XLS) to QIF converters that address this. One that's been mentioned here before is XL2QIF (http://xl2qif.chez-alice.fr/xl2qif_en.php). I can't vouch for the success, but there you are.
>
> HTH,
> David
>
> --- On Mon, 4/20/09, Tax Assistance Program - ( taptax ) <taptax at nd.edu> wrote:
>
>
>> From: Tax Assistance Program - ( taptax ) <taptax at nd.edu>
>> Subject: QIF Record and field layouts
>> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>, "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org>
>> Date: Monday, April 20, 2009, 8:31 AM
>> Hi everyone,
>>
>> Still trying to get started.  I am moving my data from
>> QuickBooks (much different than Quicken) to Gnucash.  I can
>> easily export from QB to a tab or csv delimited file.  But
>> moving that data into the QIF format will by my challenge.
>>
>> So I am studying what is involved and find that the
>> information re QIF format I found using google is pretty
>> general.  I have some sense of what it will look like but
>> nothing specific.
>>
>> Here are my questions:
>> a)    How many record types does QIF support?
>> b)    Where do I find the field-by-field layouts for each
>> supported QIF record type?
>> c)    What techniques did prior QB users invoke to make the
>> data conversion to QIF?
>>
>> Once I have those answers I am assuming I should be able to
>> transfer my data from QB format to QIF.
>>
>> Has anyone ever converted QB records to Gnucash?
>>
>> Interested in all replies!  :)
>>
>> Thanks.
>>
>> Tom Bullock
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>