Quickbooks to MySQL for a PHP/MySQL based site

[behindspace]

is this possible, or does my client need to enter information in the DB
manually (which I will end up doing for them)

any ideas or links would be great,

thanks in advance!

[Michael Vilain]

Re: Quickbooks to MySQL for a PHP/MySQL based site

In article
<51f95f5a9dfe8a 9f6e9a5dfdd476f 8c7@localhost.t alkaboutprogram ming.com>,
"behindspac e" <mark.guy@[google's mail service]> wrote:
[color=blue]
> is this possible, or does my client need to enter information in the DB
> manually (which I will end up doing for them)
>
> any ideas or links would be great,
>
> thanks in advance![/color]

Yes it is possible. You'll have to write a parser for the .INF files,
but the format for most of the transactions is reverse-engineerable. I
recommend perl for this rather than php. It's better at dealing with
..INF files.

If you want to import a QB database into MySQL, you're probably out of
luck there.

I wrote stuff to go the other way--from MySQL to QB .INF files.

If you want to do this on the same machine or if your MySQL system
allows remote access, there's

http://www.qodbc.com/default.htm

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[NC]

Re: Quickbooks to MySQL for a PHP/MySQL based site

behindspace wrote:[color=blue]
>
> is this possible,[/color]

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

[behindspace]

Re: Quickbooks to MySQL for a PHP/MySQL based site

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)

[Michael Vilain]

Re: Quickbooks to MySQL for a PHP/MySQL based site

In article
<193a7b06a5e12c f4c50d0ce796602 2ad@localhost.t alkaboutprogram ming.com>,
"behindspac e" <mark.guy@[google's mail service]> wrote:
[color=blue]
> 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)[/color]

Well, how are you going to run Quickbooks on Fedora? Via WINE? Unless
you write something that can read the Quickbooks data file or .inf
files, you aren't going to get very far with this project. And this
design will require periodic updating rather than sharing information
between Quickbooks and MySQL. Is that what you want?

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[NC]

Re: Quickbooks to MySQL for a PHP/MySQL based site

behindspace wrote:[color=blue]
>[/color]
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...[color=blue]
>
> I wouldn't be using IIS,[/color]

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