Similarities between CSV and QIF importers?

[Derek Atkins]

Yes, the date-format and number-format ambiguities exist in
CSV import as well.  Or at least I would assume they do.

-derek

Quoting Chintan Agarwal <chintan.agarwal at gmail.com>:

> I guess the complications in QIF import is due to the ambiguities
> involved in the data of QIF files(like date formats etc.). Are such
> issues present in CSV too. In that case, apart from the parsing part,
> much of the code could be similar!
> As for the QIF import, I think the existing scheme code gives a good
> indication about the issues that would have to be handled.
> -Chintan
>
> On 5/30/07, Derek Atkins <warlord at mit.edu> wrote:
>> My personal feeling:
>>
>> Feel free to use these modules as guidance, but I think we want
>> the parsers written in C, not PERL.
>>
>> -derek
>>
>> "Albert Lash" <albert.lash at gmail.com> writes:
>>
>> > 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/
>> >
>>
>> --
>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>        Member, MIT Student Information Processing Board  (SIPB)
>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>        warlord at MIT.EDU                        PGP key available
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>



-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available