Exporting transaction data from QuickBooks to GnuCash

Graeme Nichols gnichols at tpg.com.au
Tue Mar 9 19:29:18 CST 2004


On Fri, 2004-02-27 at 06:45, Benoit Grégoire wrote:
> On Thursday 26 February 2004 14:06, Brian V Bonini wrote:
> > What sort of documentation do you need? It is just a .csv file. You can
> > open it in any plain text editor and see exactly what is going on with
> > it.
> 
> Yes, but what are the allowable values of the TRNSTYPE field?  Is the format 
> of DATE standardized?  What is the CLASS fields used for.  IIF files don't 
> have the same fields defined at the top of the file.  There are several 
> variants of the IIF format with different columns depending on the type of 
> data represented, which column can we expect to always be present? Is it 
> possible that several formats could be sent in a single file (accounts and 
> transactions for example?  If so, do we expect a new copy of the headers to 
> parse, or are they all non-overlaping?
> 
> People seem to be under the impression that because they can download a so 
> called "IIF file" from their bank, all IIF files are the same and represent 
> the same kind of data.  Obviously they are not.
> 
> Yes, we can probably reverse engineer it from the exambles in your previous 
> message, but it will be time consuming and error prone at best, especially 
> without a copy of quickbooks to verify.
> 
> -- 
> Benoit Grégoire, http://step.polymtl.ca/~bock/

Benoit, I have a copy of QuickBooks V7. What is it you need and I will
see if I can obtain it for you? Someone said it was in the online
documentation of QuickBooks so I should be able to find it.

-- 

Kind regards,

Graeme Nichols

----------------------------------------------------------------------
+#if defined(__alpha__) && defined(CONFIG_PCI)
+       /*
+        * The meaning of life, the universe, and everything. Plus
+        * this makes the year come out right.
+        */
+       year -= 42;
+#endif
(From the patch for 1.3.2: (kernel/time.c), submitted by Marcus
Meissner)

----------------------------------------------------------------------
- IMPORTANT.                                                         -
- The contents of this email and any attachments, which may be con-  -  
- fidential, are sent for the personal attention of the addressee/s  -
- only. If you receive this email and are not the intended addressee -
- please inform the sender and delete this email immediately. Use,   -
- copying, disclosure or forwarding of the contents of this email    -
- and/or any attachment/s is not authourised.                        -
----------------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20040310/420f9ed8/attachment.pgp


More information about the gnucash-user mailing list