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