Similarities between CSV and QIF importers?

[Albert Lash]

Hi Benny,

I just happen to have examined the code for Finance::IIF, and I'm surprised
at how similar the IIF format is to TSV (tab separated values).  If what I
think is correct, IIF is TSV. I realize you are talking about QIF, but since
you also mentioned CSV, it might be an easy addition to include IIF files as
well.

There are two perl modules which might be of use to you:
Finance::IIF (already mentioned)
Finance::QIF

They are available on Sourceforge and CPAN and are recently updated. I don't
think that Quickbooks can export everything to IIF format (ie transactions),
but the fact that it can export the chart of accounts makes it a valuable
conduit. Also worth considering,  I believe Intuit is dropping IIF in lieu
of qbXML in the latest version.

For what its worth, I've done some digging on the subject and came up with
these useful URLs:

http://www.mail-archive.com/gnucash-devel@gnucash.org/msg09127.html

http://lists.pdxlinux.org/pipermail/plug/2004-March/029973.html

Good luck!

Albert
http://www.pbooks.org/




On 5/29/07, Benjamin Sperisen <lasindi at gmail.com> wrote:
>
> Hi Chintan,
>
> I am the summer of code student working on the CSV importer. My mentor
> (Josh Sled) suggested that I try seeing if there are any similarities
> between the QIF and CSV importers that we could work on, and that
> seems like a good idea to me (why reinvent wheels?). I have code at
> the moment that can read in a CSV file and create a two-dimensional
> GPtrArray containing the cells as strings. Is this at all similar to
> the data structure you parse QIF files into (or plan to use as you
> rewrite the importer in C)?
>
> Benny
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>