tags:

views:

332

answers:

2

I have a client using quickbooks on a Mac platform. I have a PHP5-based web application that needs to export customer/sales records. I would love to try the quickbooks web connect soap framework that Keith developed but that system is not supported on Mac.

I've read that IIF is not the best way to handle it, but at this point it seems to be my only choice. Recommendations?

Whatever the file type, is there any existing php classes for generating those files?

A: 

Unfortunately IIF looks like it is it (and it is not a good choice for many reasons). I'm not aware of any PHP classes that do this, but IIF is a very simple format to generate (deceptively simple, really because its interaction with Quickbooks is very low-level and can really do inconvenient things).

Just be aware of the development cost you are getting into. Although making the IIF file is pretty straight forward, the testing is going to be a real cost. Just go into it with your eyes open.

Yishai
I've heard/read similar things - but at this point I'm grasping for straws because the only thing that seems solid/stable enough is Web Connect, which I'd rather do, but the client is on Mac OS X, and there seems to be no easy answer. IIF seems to be my only choice besides making them switch to windows for that specific task, or abandon the whole idea.
BotskoNet
Another option might be for them to move to QuickBooks Online Edition, which you can integrate with via HTTPS POSTs. I'm not sure if you can import QuickBooks Mac data into Online Edition though... you'd have to test it out and see. BootCamp or VMWare might be another option... it stinks that Intuit won't develop something akin to the Web Connector for Mac editions of QuickBooks.
Keith Palmer
+1  A: 

There is some documentation on the IIF file format available online: here, here, and here.

There is also this open-source project for dealing with IIF files: PHP QB IIF Viewer

If you end up writing your own IIF parser... get in touch with me keith [AT] consolibyte [DOT] com, as if I can find the time and you'd be willing to make it open-source I'd like to contribute so that I can add it to the other open-source QuickBooks work I've done.

Keith Palmer