IIF import

Derek Atkins warlord at MIT.EDU
Thu Mar 20 09:07:21 EDT 2008


There was one person I was taking to who supposedly wrote something
in PERL or Python (sorry, I don't remember which) that was able
to parse IIF..  I don't recall if it was on -user or -devel.
I encouraged him to write one in C so we could use it..

-derek

"David T." <sunfish62 at yahoo.com> writes:

> A quick search online failed to find any conversion programs from IIF to QIF,
> but I did find a link that suggests that Excel will open IIF files, and if this
> is indeed the case, you can then use some of the tools available for importing
> or converting Excel files. I found (but have not tested)
> http://xl2qif.chez-alice.fr/xl2qif_en.php which is an Excel add-in and perhaps
> you could find other tools.
>
> HTH,
> David
>
> --- Derek Atkins <warlord at MIT.EDU> wrote:
>
>> Hi,
>> 
>> Quoting Rommel Martinez <ebzzry at gmail.com>:
>> 
>> > We have >10 years worth of Quickbooks accounting data, and
>> > the version we use now is Quickbooks 2003. Unfortunately
>> > Quickbooks 2003 can only export in IIF format.
>> >
>> > Is there a way to import the information contained in our files
>> > to Gnucash without loss of data? If Gnucash is not able to
>> > read/import IIF files, must an intermediate application exist
>> > to convert IIF to a format that Gnucash can read?
>> >
>> > Yes, I've searched the MLs first regarding that matter.
>> 
>> No, gnucash does not have an IIF Importer.  So if you want to
>> import your data you'll need some intermediary to convert it to
>> QIF.  Note that there is no way to import your customer/vendor
>> database or Invoice/Bill lists.
>> 
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> 
>> -derek
>> 
>> -- 
>>        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-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.
>> 
>
>
>
>       ____________________________________________________________________________________
> Be a better friend, newshound, and 
> know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
>

-- 
       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


More information about the gnucash-user mailing list