This is a discussion on Quickbooks to MySQL for a PHP/MySQL based site within the PHP Language forums, part of the PHP Programming Forums category; is this possible, or does my client need to enter information in the DB manually (which I will end up ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
behindspace wrote:
> > is this possible, Yes. You need to export QuickBooks data into an IIF file (this is QuickBooks' standard export-import format; essentially, this is flat text with some twists, such as multiple lines per transaction). Then you can twist the IIS around to transform it into something importable into MySQL. Last time I dealt with IIS was a couple of years ago, so I don't remember all the details, but I do remember that somewhere between QuickBooks help files and QuickBooks Web site I found a pretty intelligible description of the IIF format... Cheers, NC |
|
|||
|
I wouldn't be using IIS, I have a Linux server running Fedora Core 2, so
I'll be using Apache and MySQL on it's native platform. I can't deal with IIS, it's to insecure, and prefer not to use M$FT at all (except for gaming) |
|
|||
|
behindspace wrote:
> NC> Last time I dealt with IIS was a couple of years ago, so I NC> don't remember all the details, but I do remember that somewhere NC> between QuickBooks help files and QuickBooks Web site I found NC> a pretty intelligible description of the IIF format... > > I wouldn't be using IIS, My apologies. The quote above should read: "Last time I dealt with IIF". The choice of HTTP server has no bearing on data imports. In fact, you can do data imports without any HTTP server, by using command-line scripting... Cheers, NC |
![]() |
| Thread Tools | |
| Display Modes | |
|
|